javaee(j2ee)简单注册登录系统(附详细源码).doc

1，布局如下2,所用数据库:mysql版.Drop table if exists user;CREATE TABLE user ( id int(10) unsigned NOT NULL auto_increment, username varchar(50) NOT NULL default , password varchar(10) default NULL, email varchar(50) default NULL, PRIMARY KEY (id), UNIQUE KEY ID (id), KEY ID_2 (id) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;Insert into user values(10,shi,123,456);3. DBAccess.javapackage com.demo.javabean;import java.sql.DriverManager;import java.sql.SQLException;import com.mysql.jdbc.Connection;import com.mysql.jdbc.ResultSet;import com.mysql.jdbc.Statement;public class DBAccess private String drv=com.mysql.jdbc.Driver;private String url=jdbc:mysql:/localhost:3306/demo;private String usr=root;private String pwd=;private Connection conn=null;private Statement stm=null;private ResultSet rs=null;public String getDrv() return drv;public void setDrv(String drv) this.drv = drv;public String getUrl() return url;public void setUrl(String url) this.url = url;public String getUsr() return usr;public void setUsr(String usr) this.usr = usr;public String getPwd() return pwd;public void setPwd(String pwd) this.pwd = pwd;public Connection getConn() return conn;public void setConn(Connection conn) this.conn = conn;public java.sql.Statement getStm() return stm;public void setStm(Statement stm) this.stm = stm;public java.sql.ResultSet getRs() return rs;public void setRs(ResultSet rs) this.rs = rs;/创建数据库连接函数public boolean createConn()boolean b=false;tryClass.forName(drv).newInstance();conn=(Connection) DriverManager.getConnection(url,usr,pwd);b=true;catch(SQLException e)catch(ClassNotFoundException e)catch(InstantiationException e)catch(IllegalAccessException e)return b;/更新sql函数public boolean update (String sql)boolean b=false;trystm=(Statement) conn.createStatement();stm.execute(sql);b=true;catch(Exception e)return b;/查询sql函数 public void query (String sql)trystm=(Statement) conn.createStatement();rs=(ResultSet) stm.executeQuery(sql);catch(Exception e)public boolean next()boolean b=false;tryif(rs.next()b=true;catch(Exception e)return b;public String getValue(String field)String value=null;tryif(rs!=null)value=rs.getString(field);catch(Exception e)return value;public void closeRs()tryif(rs!=null)rs.close();catch(SQLException e)public void closeStm()tryif(rs!=null)stm.close();catch(SQLException e)public void closeConn()tryif(rs!=null)conn.close();catch(SQLException e)4. UserBean.javapackage com.demo.javabean;public class UserBean /登录验证函数 public boolean valid (String username, String password )boolean isValid=false;DBAccess db=new DBAccess();if(db.createConn()String sql=select * from user where username=+username+and password=+password+;db.query(sql);if(db.next()isValid=true;db.closeRs();db.closeStm();db.closeConn();return isValid;/检查用户名是否存在public boolean isExist(String username)boolean isExist=false;DBAccess db=new DBAccess();if(db.createConn()String sql=select * from user where username=+username+;db.query(sql);if(db.next()isExist=true;db.closeRs();db.closeStm();db.closeConn();return isExist;public void add(String username,String password,String email)DBAccess db=new DBAccess();if(db.createConn()String sql=insert into user(username,password,email) values(+username+,+password+,+email+);db.update(sql);db.closeStm();db.closeConn();5. login_action.jsp base href= My JSP login_action.jsp starting page 6. Login.jsp base href= My JSP index.jsp starting page This is my JSP page. 登录窗口 用户名 密码注册新用户 7. Logout.jsp base href= My JSP logout.jsp starting page !- This is my JSP page. 8. Register_action.jsp base href= My JSP register_action.jsp starting page This is my JSP page. 9. Register.jsp base href= My JSP register.jsp starting page This is my JSP pa