javaeej2ee简单注册登录系统附详细源码.docx
《javaeej2ee简单注册登录系统附详细源码.docx》由会员分享,可在线阅读,更多相关《javaeej2ee简单注册登录系统附详细源码.docx(16页珍藏版)》请在冰豆网上搜索。
javaeej2ee简单注册登录系统附详细源码
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=InnoDBDEFAULTCHARSET=utf8AUTO_INCREMENT=78;
Insertintouservalues(10,"shi","123","456");
3.DBAccess.java
publicclassDBAccess{
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;
}
returnstm;
}
publicvoidsetStm(Statementstm){
this.stm=stm;
}
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)
{
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()
{
booleanb=false;
try{
if(rs.next())b=true;
}
catch(Exceptione)
{
}
returnb;
}
publicStringgetValue(Stringfield)
{
Stringvalue=null;
try{
if(rs!
=null)value=rs.getString(field);
}catch(Exceptione)
{
}
returnvalue;
}
publicvoidcloseRs()
{
try{
if(rs!
=null)
rs.close();
}
catch(SQLExceptione)
{
}
}
publicvoidcloseStm()
{
try{
if(rs!
=null)
stm.close();
}
catch(SQLExceptione)
{
}
}
publicvoidcloseConn()
{
try{
if(rs!
=null)
conn.close();
}
catch(SQLExceptione)
{
}
}
}
4.UserBean.java
package
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;
DBAccessdb=newDBAccess();
if(db.createConn())
{
Stringsql="select*fromuserwhereusername='"+username+"'";
db.query(sql);
if(db.next())
{
isExist=true;
}
db.closeRs();
db.closeStm();
db.closeConn();
}
returnisExist;
}
publicvoidadd(Stringusername,Stringpassword,Stringemail){
DBAccessdb=newDBAccess();
if(db.createConn())
{
Stringsql="insertintouser(username,password,email)values('"+username+"','"+password+"','"+email+"')";
db.update(sql);
db.closeStm();
db.closeConn();
}
}
}
5.login_action.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="ISO-8859-1"%>
<%@pageimport=%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"
+request.getServerName()+":
"+request.getServerPort()
+path+"/";
%>
">
MyJSP'login_action.jsp'startingpage<%
Stringusername=request.getParameter("username");
Stringpassword=request.getParameter("password");
if(username==null||password==null)
{
response.sendRedirect("login.jsp");
}
%>
<%
//验证登录
booleanisValid=false;
UserBeanuserBean=newUserBean();
isValid=userBean.valid(username,password);
if(isValid)
{
session.setAttribute("username",username);
response.sendRedirect("welcome.jsp");
}
else
{
response.sendRedirect("login.jsp");
}
%>
6.Login.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="utf-8"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTD