Jsp學(xué)生信息管理系統(tǒng)登錄驗(yàn)證全代碼

1、imer);theTimer=setTimeout(turnPage(),speed);checkimer);theTimer=setTimeout(turnPage(),speed);check1.jsp登錄界面Login.jspvtitle用戶登錄界面/titlevformaction=LoginServletmethod=postvbodybgcolor=bluevmarqueedirection=rightonmouseover=stop()onmouseout=start()style=font-family:楷體_GB2312vpvfontsize=10pxcolor=red學(xué)生信

2、息信息管理系統(tǒng)v/fontv/pv/marqueevtablealign=centerwidth=237vtrvtdvtablewidth=100%vtrimer);theTimer=setTimeout(turnPage(),speed);checkimer);theTimer=setTimeout(turnPage(),speed);checkv/divv/trvtrvtdalign=centerSTYLE=cursor:handvfontsize=2vdivclass=b2bbuttonid=bt0onclick=javascript:showPage(0);clearTimeout(t

3、heTimer);theTimer=setTimeout(turnPage(),speed);checkBt();1v/divv/fontv/tdvtdalign=centerSTYLE=cursor:handvfontsize=2vdivclass=b2bbuttonid=bt1onclick=javascript:showPage(1);clearTimeout(theTBt();23v/divvtdalign=centerSTYLE=cursor:handvfontsize=2vdivclass=b2bbuttonid=bt3onclick=javascript:showPage(3);

4、clearTimeout(theTimer);theTimer=setTimeout(turnPage(),speed);checkBt();4v/divv/fontv/tdvtdalign=centerSTYLE=cursor:handvfontsize=2vdivclass=b2bbuttonid=bt4onclick=javascript:showPage(4);clearTimeout(theTonclick=javascript:showPage(4);clearTimeout(theTonclick=javascript:showPage(4);clearTimeout(theTo

5、nclick=javascript:showPage(4);clearTimeout(theTimer);theTimer=setTimeout(turnPage(),speed);checkBt();5v/divvtdalign=centerSTYLE=cursor:handvfontsize=2vdivclass=b2bbuttonid=bt5onclick=javascript:showPage(5);clearTimeout(theTimer);theTimer=setTimeout(turnPage(),speed);checkBt();6v/divv/fontv/tdv/trv/t

6、ablevscriptlanguage=javascriptb2bStr=newArray();b2bStr0=vdivstyle=float:left;width:100%;overflow:hidden;vahref=1giftarget=_blankvimgsrc=1gifwidth=214pxheight=145pxborder=0v/avbrvatarget=_blanktitle=太陽島公園一角href=1gif太陽島公園一角v/av/div;b2bStr1=太陽島公園湖光山色;b2bStr2=哈爾濱雪雕v/div;b2bStr3=vahref=4.giftarget=_blank

7、vimgsrc=4.gifwidth=214pxheight=145pxborder=0v/avbrvatarget=_blanktitle=鏡泊湖href=4.gif鏡泊湖v/av/div;b2bStr4=vdivstyle=float:left;width:100%;overflow:hidden;vahref=5.giftarget=_blankvimgsrc=5.gifwidth=214pxheight=145pxborder=0v/avbrvatarget=_blanktitle=太陽島公園瀑布href=5.gif太陽島公園瀑布v/av/div;b2bStr5=鏡泊湖夜色v/div;

8、varpage=0;varspeed=3000;functionshowPage(id)page=id;setTransition();b2bContentinnerHTML=b2bStrid;b2bContentfiltersrevealTransplay();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)btO

9、bj.stylecolor=#FFFFFF;btObj.style.backgroundColor=#FF781C;elsebtObj.style.color=#000000;btObj.style.backgroundColor=#F7F7F7;functionsetTransition()b2bContent.filters.revealTrans.Transition=Math.round(Math.random()*23);b2bContent.filters.revealTrans.apply();turnPage();用戶名:密碼:vinputtype=resetvalue=取消v

10、/trv/tablev/formv/bodyv/html2.java代碼(1)User.Java定義的屬性和數(shù)據(jù)庫中的字段相對應(yīng)packagecom.softeem.dt;publicclassUserprivateintid;privateStringusername;privateStringpassword;privateStringxh;privateStringcollege;publicintgetId()returnid;publicvoidsetId(intid)this.id=id;publicStringgetUsername()returnusername;publicv

11、oidsetUsername(Stringusername)this.username=username;publicStringgetPassword()returnpassword;publicvoidsetPassword(Stringpassword)this.password=password;publicStringgetXh()returnxh;publicvoidsetXh(Stringxh)this.xh=xh;publicStringgetCollege()returncollege;publicvoidsetCollege(Stringcollege)this.colle

12、ge=college;(2)UserDA0java操作數(shù)據(jù)庫tb_user,驗(yàn)證用戶登錄packagecom.softeem.dao;importjavasqlConnection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importcom.softeem.db.DBManager;importcom.softeem.dt.User;publicclassUserDAO/*驗(yàn)證用戶登錄*return*/publicbooleancheckDenglu(Userus

13、er)booleanflag=false;/獲得數(shù)據(jù)庫連接Connectionconn=DBManager.getConnection();/用select*from查詢數(shù)據(jù)庫中的所有字段Stringsql=selectcount(*)fromtb_userwhereusername=?andpassword=?;tryPreparedStatementpst=conn.prepareStatement(sql);pst.setString(1,user.getUsername();pst.setString(2,user.getPassword();/執(zhí)行查詢語句,拿到結(jié)果集ResultSe

14、trs=pst.executeQuery();while(rs.next()intcount=rs.getInt(1);用count和0比較,若大于0表示該用戶存在，否則不存在if(count0)flag=true;catch(SQLExceptione)e.printStackTrace();returnflag;3.LoginServlet,點(diǎn)擊登錄跳轉(zhuǎn)到服務(wù)器端packagecom.softeem.servlet;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet. HYPE

15、RLINK http:/http.HttpServlethttp.HttpServlet;importjavax.servlet. HYPERLINK http:/http.HttpServletRequesthttp.HttpServletRequest;importjavax.servlet. HYPERLINK http:/http.HttpServletResponsehttp.HttpServletResponse;importcom.softeem.dao.UserDAO;importcom.softeem.dto.User;/*Servletimplementationclass

16、LoginServlet*/publicclassLoginServletextendsHttpServletprivatestaticfinallongserialVersionUID=1L;/*seeHttpServlet#HttpServlet()*/publicLoginServlet()super();/*seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponsere

17、sponse)throwsServletException,IOExceptionsuper.doGet(request,response);/*seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)*/protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException/獲取表單數(shù)據(jù)/處理亂碼request.setCharacterEncoding(

18、utf-8);Stringusernamerequest.getParameter(username);Stringpasswordrequest.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)messag