欢迎来到天天文库
浏览记录
ID:33663653
大小:186.50 KB
页数:18页
时间:2019-02-28
《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
此文档下载收益归作者所有