javaee(j2ee)简单注册登录系统(附详细源码)【DOC精选】Word下载.doc
《javaee(j2ee)简单注册登录系统(附详细源码)【DOC精选】Word下载.doc》由会员分享,可在线阅读,更多相关《javaee(j2ee)简单注册登录系统(附详细源码)【DOC精选】Word下载.doc(18页珍藏版)》请在冰豆网上搜索。
);
3.DBAccess.java
packagecom.demo.javabean;
importjava.sql.DriverManager;
importjava.sql.SQLException;
importcom.mysql.jdbc.Connection;
importcom.mysql.jdbc.ResultSet;
importcom.mysql.jdbc.Statement;
publicclassDBAccess{
privateStringdrv="
com.mysql.jdbc.Driver"
;
privateStringurl="
jdbc:
mysql:
//localhost:
3306/demo"
privateStringusr="
root"
privateStringpwd="
"
privateConnectionconn=null;
privateStatementstm=null;
privateResultSetrs=null;
publicStringgetDrv(){
returndrv;
}
publicvoidsetDrv(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(){
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()
{
booleanb=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(Stringsql)
stm=(Statement)conn.createStatement();
stm.execute(sql);
}catch(Exceptione){
//查询sql函数
publicvoidquery(Stringsql)
rs=(ResultSet)stm.executeQuery(sql);
}catch(Exceptione)
{
publicbooleannext()
if(rs.next())b=true;
catch(Exceptione)
publicStringgetValue(Stringfield)
Stringvalue=null;
try{
if(rs!
=null)value=rs.getString(field);
}catch(Exceptione)
returnvalue;
publicvoidcloseRs()
if(rs!
=null)
rs.close();
catch(SQLExceptione)
{
}
publicvoidcloseStm()
stm.close();
publicvoidcloseConn()
conn.close();
}
4.UserBean.java
publicclassUserBean
{
//登录验证函数
publicbooleanvalid(Stringusername,Stringpassword)
booleanisValid=false;
DBAccessdb=newDBAccess();
if(db.createConn())
Stringsql="
select*fromuserwhereusername='
+username+"
andpassword='
+password+"
db.query(sql);
if(db.next())
isValid=true;
db.closeRs();
db.closeStm();
db.closeConn();
returnisValid;
//检查用户名是否存在
publicbooleanisExist(Stringusername)
booleanisExist=false;
if(db.createConn())
Stringsql="
db.query(sql);
if(db.next())
isExist=true;
db.closeRs();
db.closeStm();
db.closeConn();
returnisExist;
publicvoidadd(Stringusername,Stringpassword,Stringemail){
insertintouser(username,password,email)values('
'
+email+"
)"
db.update(sql);
5.login_action.jsp
<
%@pagelanguage="
java"
import="
java.util.*"
pageEncoding="
ISO-8859-1"
%>
%@pageimport="
com.demo.javabean.UserBean"
%>
%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+"
:
//"
+request.getServerName()+"
+request.getServerPort()
+path+"
/"
html>
<
head>
basehref="
%=basePath%>
>
<
title>
MyJSP'
login_action.jsp'
startingpage<
/title>
/head>
body>
Stringusername=request.getParameter("
userna