欢迎来到天天文库
浏览记录
ID:51690617
大小:30.00 KB
页数:9页
时间:2020-03-15
《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
此文档下载收益归作者所有