jsp用户登录连接数据库.doc

《jsp用户登录连接数据库.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、数据库里的字段#MySQL-Front3.2(Build7.19)/*!40101SET@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;/*!40101SET@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS*/;/*!40101SET@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION*/;/*!40101SETNAMES'gbk'*/;#Host:127.0.

2、0.1Database:qy#------------------------------------------------------#Serverversion5.0.18-nt##Tablestructurefortableqyuser#DROPTABLEIFEXISTS`qyuser`;CREATETABLE`qyuser`(`Id`int(11)NOTNULLauto_increment,`uanme`varchar(50)defaultNULL,`upwd`varchar(50)defaultN

3、ULL,`tswt`varchar(50)defaultNULL,`wtda`varchar(50)defaultNULL,PRIMARYKEY(`Id`))ENGINE=InnoDBDEFAULTCHARSET=gbk;##Dumpingdatafortableqyuser#INSERTINTO`qyuser`VALUES(1,'admin','admin','admin','admin');INSERTINTO`qyuser`VALUES(2,'admin99,'admin99','admin99','a

4、dmin99');/*!40101SETCHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT*/;/*!40101SETCHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS*/;/*!40101SETCOLLATION_CONNECTION=@OLD_COLLATION_CONNECTION*/;//bean目录packagecom.qy.Bean;publicclassUserBean{//用户idprivateintId;

5、publicintgetId(){returnId;}publicvoidsetId(intid){Id=id;}publicStringgetUname(){returnuname;}publicvoidsetUname(Stringuname){this.uname=uname;}publicStringgetUpwd(){returnupwd;}publicvoidsetUpwd(Stringupwd){this.upwd=upwd;}publicStringgetTswt(){returntswt;}

6、publicvoidsetTswt(Stringtswt){this.tswt=tswt;}publicStringgetWtda(){returnwtda;}publicvoidsetWtda(Stringwtda){this.wtda=wtda;}//用户姓名privateStringuname;//用户密码privateStringupwd;//提示问题privateStringtswt;//问题答案privateStringwtda;}////javadaopackagecom.qy.Dao;publ

7、icinterfaceUserDao{//用户登录接口publicbooleanislogin(Stringuanme,Stringupwd)throwsException;}//javaimplpackagecom.qy.Dao;publicinterfaceUserDao{//用户登录接口publicbooleanislogin(Stringuanme,Stringupwd)throwsException;}//javaDatabasepackagecom.qy.DataBase;importjava.s

8、ql.Connection;importjava.sql.DriverManager;publicclassUserDataBase{//用户名publicStringuname="root";//用户密码publicStringupwd="admin";//驱动程序publicStringDRIVER="com.mysql.jdbc.Driver";//连接地址publicStringURL="j