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

1、I.jsp 登錄界面 Login.jsp用戶登錄界面vform action =LoginServlet method=post vmarquee directi on =rightonm ouseover=stop()onm ouseout=start() style =font-family:楷體 _GB2312vfont size =10px color =red 學(xué)生信息信息管理系統(tǒng) v/font vtable align =center width =237 vtd vtable width =100%vtr vtd colspan =6vfont size =212size =23

2、4div class =b2bbutton id =bt4on click =javascript:showPage(4);clearTimeout(theTime5v/font 6b2bStr = n ewArray();b2bStr0=v/avbr 太陽島公園一角 b2bStr1= 太陽島公園湖光山色 ;b2bStr2 = 雪雕 ;b2bStr3 = 鏡泊湖 ;b2bStr4divstyle=float:left; 太陽島公園瀑布 b2bStr5width:100%;overflow:hidden; 鏡泊湖夜色 ;var page=O;var speed=3000;fun cti on s

3、howPage(id)page=id;setTra nsiti on();b2bCo nte nt.i nn erHTML=b2bStrid; b2bC on te nt.filters.revealTra ns.play(); ,speed);fun cti on tur nPage() showPage(page); theTimer=setTimeout( turnPage() checkBt();page+;if (page=6) page=0;fun cti on checkBt()for (var i=0;i6;i+)btObj=eval( bt +i);#FFFFFF ;btOb

4、j.styleif (page=i)btObj.style.color=backgroundColor= #FF781C ;else btObj.style.color= #000000 ;btObj.style.backgro undColor= #F7F7F7 ;fun cti on setTra nsiti on()b2bC on te nt.filters.revealTra ns.Tra nsiti on=Math.ro und(Math.ra ndom()*23);b2bContent.filters.revealTrans.apply();turn Page(); 用戶 名: 密

5、      碼 :     2.java 代碼(1)User.Java 定義的屬性和數(shù)據(jù)庫中的字段相對應(yīng) package .softeem.dt;public class User private int id ; private String username;private String password;private String xh; private String college ;public int getId()return id;public void setId( int id) this .

6、id = id;public String getUsername() return username;public void setUsername(String username) this . username = username;public String getPassword() return password;public void setPassword(String password) this . password = password;public String getXh() return xh;public void setXh(String xh) this .x

7、h = xh;public String getCollege() return college ;public void setCollege(String college) this . college = college;(2)UserDAO.java 操作數(shù)據(jù)庫 tb_user, 驗(yàn)證用戶登錄 package .softeem.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import .sof

8、teem.db.DBManager;import .softeem.dt.User;public class UserDAO *驗(yàn)證用戶登錄* return*/public boolean checkDenglu(User user) boolean flag = false ;/獲得數(shù)據(jù)庫連接Connection conn = DBManager. getConnection ();where/用select * from查詢數(shù)據(jù)庫中的所有字段String sql = select count(*) from tb_user username=? and password=?;try Pre

9、paredStateme ntpstconn .prepareStateme nt(sql);pst.setStri ng(1, user.getUsername();pst.setStri ng(2, user.getPassword();/執(zhí)行查詢語句，拿到結(jié)果集ResultSet rs = pst.executeQuery();while (rs.next() int count = rs.getInt(1);/用cou nt和0比較，若大于0表示該用戶存在，否則不存在if (count 0)flag = true ; catch (SQLException e) e.printStac

10、kTrace();return flag;3.LoginServlet, 點(diǎn)擊登錄跳轉(zhuǎn)到服務(wù)器端 package .softeem.servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import .softeem.dao.UserDAO;impo

11、rt .softeem.dto.User;* Servlet implementation class LoginServlet*/public class LoginServlet extends HttpServlet private static final long serialVersionUID = 1L;* see HttpServlet#HttpServlet()*/public LoginServlet() super();* see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse respo

12、nse)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException super.doGet(request, response);* see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletRe

13、sponse response) throws ServletException, IOException / 獲取表單數(shù)據(jù)/ 處理亂碼 request.setCharacterEncoding(utf-8);Stringusernamerequest.getParameter(username);Stringpasswordrequest.getParameter(password);/ 封裝到 user 對象中User user = new User(); user.setUsername(username); user.setPassword(password);/ 調(diào)用 dao 的 checkLogin 方法UserDAO dao = new UserDAO();boolean flag = dao.checkLogin(user);String message = null;String path = null;if(flag)message = 登錄成功 ;path=success.jsp;request.getSession().setAttribute(user,user);elsemessage = 對不起密