在jsp中用bean和servlet联合实现用户注册、登录

《在jsp中用bean和servlet联合实现用户注册、登录》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、在jsp中用bean和servlet联合实现用户注册、登录在jsp中用bean和servlet联合实现用户注册、登录本例需要的软件和运行环境：1、windows2000server操作系统2、jdk1.43、jcreator2.5（java源码编辑调试器，吐血推荐！）4、macromediajrunmx5、macromediadreamweavermx（非必需）6、mysql数据库（最好安装mysqlcontrolcenter）一、数据库设计用mysqlcontrolcenter打开mysql数据库，新建数据库shopping，在其下

2、新建表tbl_user，其中各字段设置如下：二、编写连接数据库bean：dbconn.java//dbconn.java//includerequiredclassesimportjava.sql.*;//==========================================//defineclassdbconn//==========================================publicclassdbconn{publicstringsql_driver="org.gjt.mm.mysql.dri

3、ver";publicstringsql_url="jdbc:mysql://localhost:3306";publicstringsql_dbname="shopping";publicstringuser="sa";publicstringpwd="";connectionconn=null;statementstmt=null;resultsetrs=null;publicbooleansetdriver(stringdrv){this.sql_driver=drv;returntrue;}publicstringgetdri

4、ver(){returnthis.sql_driver;}publicbooleanseturl(stringurl){this.sql_url=url;returntrue;}publicbooleansetdbname(stringdbname){this.sql_dbname=dbname;returntrue;}publicstringgetdbname(){returnthis.sql_dbname;}publicbooleansetuser(stringuser){this.user=user;returntrue;}pu

5、blicstringgetuser(){returnthis.user;}publicbooleansetpwd(stringpwd){this.pwd=pwd;returntrue;}publicstringgetpwd(){returnthis.pwd;}publicdbconn(){try{class.forname(sql_driver);//加载数据库驱动程序this.conn=drivermanager.getconnection(sql_url+"/"+sql_dbname+"?user="+user+"&passwor

6、d="+pwd+"&useunicode=true&characterencoding=gb2312");this.stmt=this.conn.createstatement();}catch(exceptione){system.out.println(e.tostring());}}//执行查询操作publicresultsetexecutequery(stringstrsql){try{this.rs=stmt.executequery(strsql);returnthis.rs;}catch(sqlexceptione){s

7、ystem.out.println(e.tostring());returnnull;}catch(nullpointerexceptione){system.out.println(e.tostring());returnnull;}}//执行数据的插入、删除、修改操作publicbooleanexecute(stringstrsql){try{if(this.stmt.executeupdate(strsql)==0)returnfalse;elsereturntrue;}catch(sqlexceptione){system.o

8、ut.println(e.tostring());returnfalse;}catch(nullpointerexceptione){system.out.println(e.tostring());returnfals