大家帮我看看是什么错误，就是存不进数据库去！

sy_binbin 2005-05-02 03:57:18

JAVABEAN:
package rencai;

import java.io.Serializable;
public class RegisterBean implements Serializable{
private String userName;
private String userPass;
private java.sql.Date regDate;
private String userType;

public void setUserName(String userName) {
this.userName = userName;
}

public void setUserPass(String userPass) {
this.userPass = userPass;
}
public void setRegDate(java.sql.Date regDate) {
this.regDate = regDate;
}

public void setUserType(String userType) {
this.userType = userType;
}

public String getUserName() {
return userName;
}

public String getUserPass() {
return userPass;
}
public java.sql.Date getRegDate() {
return regDate;
}

public String getUserType() {
return userType;
}

}

数据库处理代码：

package rencai;
import java.sql.*;

public class RegisterSql
{
private Connection conn;

public RegisterSql()
{
try
{
this.conn = DateBaseConnection.getSqlConnection();
}
catch(Exception e)
{
e.printStackTrace();
}
}

/////添加数据
public void add(RegisterBean bean) throws Exception
{

try
{

PreparedStatement add = conn.prepareStatement("insert into user values(?,?,?,?)");
add.setString(1,bean.getUserName());
add.setString(2,bean.getUserPass());
add.setDate(3,new java.sql.Date(new java.util.Date().getTime()));
add.setString(4,bean.getUserType());

add.executeUpdate();

conn.close();
}
catch(Exception e)
{
System.out.println(e);
}

}
}

数据库连接代码

package rencai;
import java.sql.*;

public class DateBaseConnection
{
public static Connection getSqlConnection()
{
Connection conn = null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rencai","sa","");
}
catch(Exception e)
{
System.out.println("数据库连接的异常："+e);
}
return conn;
}

}

提交处理页面：

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="rencai.*" %>
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<jsp:useBean id="bean" class="rencai.RegisterBean" scope="page"/>
<jsp:setProperty name="bean" property="*"/>
<jsp:useBean id="sql" class="rencai.RegisterSql" scope="page"/>
<%
sql.add(bean);
%>
</body>
</html>

...全文

72 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

sy_binbin 2005-05-02

打赏
举报

要是有异常我就不贴出来了！都通过了，就是数据库里没数据！

liuquanyi 2005-05-02

打赏
举报

告诉我异常，我喜欢看异常，不喜欢看代码！

sy_binbin 2005-05-02

打赏
举报

up!up!up!

sy_binbin 2005-05-02

打赏
举报

我是实在找不出来是什么错误了！脑袋都大了！呵呵！

sy_binbin 2005-05-02

打赏
举报

表单的那个页面我没贴上去！因为上面就一些ＨＴＭＬ代码，还有些ＪＳ代码！

下面的代码就是表单的代码

<%@ page contentType="text/html; charset=gb2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>

</head>
<body>
<script language="javascript">

function RgTest()
{
var userName = document.form1.userName.value;
if(form1.userName.value=="")
{
window.alert("请输入用户名！");
document.form1.userName.focus();
return false;
}
var userPass = document.form1.userPass.value;
if(form1.userPass.value=="")
{
window.alert("请输入用户密码！");
document.form1.userPass.focus();
return false;
}
var userPassAgain = document.form1.userPassAgain.value;
if(form1.userPass.value!=form1.userPassAgain.value)
{
window.alert("两次输入的密码不一样！");
document.form1.userPass.value="";
document.form1.userPassAgain.value="";
document.form1.userPassAgain.focus();
return false;
}
var userType = document.form1.userType.value;
if(form1.userType.value=="")
{
window.alert("请选择用户类别！");
document.form1.userType.focus();
return false;
}
return true;
}

</script>

<%
String userName = request.getParameter("userName");
if(userName==null)
{
userName="";
}
String userPass = request.getParameter("userPass");
if(userPass==null)
{
userPass="";
}
String userPassAgain = request.getParameter("userPassAgain");
if(userPassAgain==null)
{
userPassAgain="";
}
%>
<form name="form1" method="post" action="registerOk.jsp" onSubmit="return RgTest();">
<table width="500" border="0" align="center">
<tr>
<td width="155" height="30"><div align="right">用户名：</div></td>
<td width="335"><input name="userName" type="text" id="userName" value="<%=userName%>"></td>
</tr>
<tr>
<td height="30"><div align="right">用户密码：</div></td>
<td><input name="userPass" type="text" id="userPass" value="<%=userPass%>"></td>
</tr>
<tr>
<td height="30"><div align="right">密码验证：</div></td>
<td><input name="userPassAgain" type="text" id="userPassAgain" value="<%=userPassAgain%>"></td>
</tr>
<tr>
<td height="30"><div align="right">用户类型：</div></td>
<td><select name="userType" id="userType">
<option>请选择用户类型</option>
<option value="个人用户 ">个人用户 </option>
<option value="企业用户">企业用户</option>
</select></td>
</tr>
<tr>
<td height="30"><div align="right"></div></td>
<td><input type="submit" name="Submit" value="提交数据"></td>
</tr>
<tr>
<td height="30"><div align="right"></div></td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>

rui0263 2005-05-02