帮我看下注册代码
封装类:package xiao;
import java.sql.Date;
import java.io.Serializable;
class UserRegisterBean 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 xiao;
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;
}
}
数据库操作:
package xiao;
import java.sql.*;
public class UserRegister
{
private Connection conn;
public UserRegister()
{
try
{
this.conn = DateBaseConnection.getSqlConnection();
}
catch(Exception e)
{
e.printStackTrace();
}
}
/////添加数据
public void add(UserRegisterBean bean) throws Exception
{
try
{
PreparedStatement addSql = conn.prepareStatement("insert into user values(?,?,?,?)");
addSql.setString(1,bean.getUserName());
addSql.setString(2,bean.getUserPass());
addSql.setDate(3,new java.sql.Date(new java.util.Date().getTime()));
addSql.setString(4,bean.getUserType());
addSql.executeUpdate();
}
catch(Exception e)
{
e.printStackTrace();
throw e;
}
}
}
处理数据的页面:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="xiao.*" %>
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<jsp:useBean id="bean" class="xiao.UserRegisterBean" scope="page"/>
<jsp:setProperty name="bean" property="*"/>
<jsp:useBean id="sql" class="xiao.UserRegister" scope="page"/>
<%
try
{
sql.add(bean);
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</body>
</html>