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

《javaee(j2ee)简单注册登录系统(附详细源码)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、1，布局如下2,所用数据库:mysql版.Droptableifexists`user`;CREATETABLE`user`(`id`int(10)unsignedNOTNULLauto_increment,`username`varchar(50)NOTNULLdefault'',`password`varchar(10)defaultNULL,`email`varchar(50)defaultNULL,PRIMARYKEY(`id`),UNIQUEKEY`ID`(`id`),KEY`ID_2`(`id`))ENGINE=InnoDBDEF

2、AULTCHARSET=utf8AUTO_INCREMENT=78;Insertintouservalues(10,"shi","123","456");3.DBAccess.javapackagecom.demo.javabean;importjava.sql.DriverManager;importjava.sql.SQLException;importcom.mysql.jdbc.Connection;importcom.mysql.jdbc.ResultSet;importcom.mysql.jdbc.Statement;public

3、classDBAccess{privateStringdrv="com.mysql.jdbc.Driver";privateStringurl="jdbc:mysql://localhost:3306/demo";privateStringusr="root";privateStringpwd="";privateConnectionconn=null;privateStatementstm=null;privateResultSetrs=null;publicStringgetDrv(){returndrv;}publicvoidsetDr

4、v(Stringdrv){this.drv=drv;}publicStringgetUrl(){returnurl;}publicvoidsetUrl(Stringurl){this.url=url;}publicStringgetUsr(){returnusr;}publicvoidsetUsr(Stringusr){this.usr=usr;}publicStringgetPwd(){returnpwd;}publicvoidsetPwd(Stringpwd){this.pwd=pwd;}publicConnectiongetConn()

5、{returnconn;}publicvoidsetConn(Connectionconn){this.conn=conn;}publicjava.sql.StatementgetStm(){returnstm;}publicvoidsetStm(Statementstm){this.stm=stm;}publicjava.sql.ResultSetgetRs(){returnrs;}publicvoidsetRs(ResultSetrs){this.rs=rs;}//创建数据库连接函数publicbooleancreateConn(){bo

6、oleanb=false;try{Class.forName(drv).newInstance();conn=(Connection)DriverManager.getConnection(url,usr,pwd);b=true;}catch(SQLExceptione){}catch(ClassNotFoundExceptione){}catch(InstantiationExceptione){}catch(IllegalAccessExceptione){}returnb;}//更新sql函数publicbooleanupdate(St

7、ringsql){booleanb=false;try{stm=(Statement)conn.createStatement();stm.execute(sql);b=true;}catch(Exceptione){}returnb;}//查询sql函数publicvoidquery(Stringsql){try{stm=(Statement)conn.createStatement();rs=(ResultSet)stm.executeQuery(sql);}catch(Exceptione){}}publicbooleannext(){

8、booleanb=false;try{if(rs.next())b=true;}catch(Exceptione){}returnb;}publicStringge