1、Good is good, but better carries it.精益求精，善益求善。Jsp學(xué)生信息管理系統(tǒng)登錄驗(yàn)證全代碼jsp登錄界面Login.jsp用戶登錄界面學(xué)生信息信息管理系統(tǒng)123456b2bStr=newArray();b2bStr0=太陽島公園一角;b2bStr1=太陽島公園湖光山色;b2bStr2=哈爾濱雪雕;b2bStr3=鏡泊湖;b2bStr4=太陽島公園瀑布;b2bStr5=鏡泊湖夜色;varpage=0;varspeed=3000;functionshowPage(id)page=id;setTransition();b2bContent.innerHTML=b

2、2bStrid;b2bContent.filters.revealTrans.play();functionturnPage()showPage(page);theTimer=setTimeout(turnPage(),speed);checkBt();page+;if(page=6)page=0;functioncheckBt()for(vari=0;i6;i+)btObj=eval(bt+i);if(page=i)btObj.style.color=#FFFFFF;btObj.style.backgroundColor=#FF781C;elsebtObj.style.color=#0000

3、00;btObj.style.backgroundColor=#F7F7F7;functionsetTransition()b2bContent.filters.revealTrans.Transition=Math.round(Math.random()*23);b2bContent.filters.revealTrans.apply();turnPage();用戶名:密碼:2.java代碼User.Java定義的屬性和數(shù)據(jù)庫中的字段相對應(yīng)packagecom.softeem.dt;publicclassUserprivateintid;privateStringusername;priva

4、teStringpassword;privateStringxh;privateStringcollege;publicintgetId()returnid;publicvoidsetId(intid)this.id=id;publicStringgetUsername()returnusername;publicvoidsetUsername(Stringusername)this.username=username;publicStringgetPassword()returnpassword;publicvoidsetPassword(Stringpassword)this.passwo

5、rd=password;publicStringgetXh()returnxh;publicvoidsetXh(Stringxh)this.xh=xh;publicStringgetCollege()returncollege;publicvoidsetCollege(Stringcollege)this.college=college;UserDAO.java操作數(shù)據(jù)庫tb_user,驗(yàn)證用戶登錄packagecom.softeem.dao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.Re

6、sultSet;importjava.sql.SQLException;importcom.softeem.db.DBManager;importcom.softeem.dt.User;publicclassUserDAO/*驗(yàn)證用戶登錄*return*/publicbooleancheckDenglu(Useruser)booleanflag=false;/獲得數(shù)據(jù)庫連接Connectionconn=DBManager.getConnection();/用select*from查詢數(shù)據(jù)庫中的所有字段Stringsql=selectcount(*)fromtb_userwhereusernam

7、e=?andpassword=?;tryPreparedStatementpst=conn.prepareStatement(sql);pst.setString(1,user.getUsername();pst.setString(2,user.getPassword();/執(zhí)行查詢語句,拿到結(jié)果集ResultSetrs=pst.executeQuery();while(rs.next()intcount=rs.getInt(1);/用count和0比較,若大于0表示該用戶存在,否則不存在if(count0)flag=true;catch(SQLExceptione)e.printStack

8、Trace();returnflag;3.LoginServlet,點(diǎn)擊登錄跳轉(zhuǎn)到服務(wù)器端packagecom.softeem.servlet;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.softeem.dao.UserDAO;importcom

9、.softeem.dto.User;/*ServletimplementationclassLoginServlet*/publicclassLoginServletextendsHttpServletprivatestaticfinallongserialVersionUID=1L;/*seeHttpServlet#HttpServlet()*/publicLoginServlet()super();/*seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)*/protectedvoiddoGet

10、(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOExceptionsuper.doGet(request,response);/*seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)*/protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOEx

11、ception/獲取表單數(shù)據(jù)/處理亂碼request.setCharacterEncoding(utf-8);Stringusername=request.getParameter(username);Stringpassword=request.getParameter(password);/封裝到user對象中Useruser=newUser();user.setUsername(username);user.setPassword(password);/調(diào)用dao的checkLogin方法UserDAOdao=newUserDAO();booleanflag=dao.checkLogin(user);Stringmessage=null;Stringpath=null;if(flag)message=登錄成功;path=success.jsp;request.getSession().setAttribute(user,user);elsemessage=對不起密碼錯誤,請重新輸入!;path=f