《Jsp学生信息管理系统登录验证全代码.doc》由会员分享,可在线阅读,更多相关《Jsp学生信息管理系统登录验证全代码.doc(15页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、【精品文档】如有侵权,请联系网站删除,仅供学习与交流1.2.3.4. Jsp学生信息管理系统登录验证全代码.精品文档.5. jsp登录界面 Login.jsp用户登录界面学生信息信息管理系统123456b2bStr = new Array();b2bStr0= 太阳岛公园一角;b2bStr1 = 太阳岛公园湖光山色;b2bStr2 = 哈尔滨雪雕;b2bStr3 = 镜泊湖;b2bStr4 = 太阳岛公园瀑布;b2bStr5 = 镜泊湖夜色;var page=0;var speed=3000;function showPage(id)page=id;setTransition();b2bCon
2、tent.innerHTML=b2bStrid;b2bContent.filters.revealTrans.play();function turnPage()showPage(page);theTimer=setTimeout(turnPage(), speed);checkBt();page+;if(page=6) page=0;function checkBt()for(var i=0;i6;i+)btObj=eval(bt+i);if(page=i)btObj.style.color=#FFFFFF;btObj.style.backgroundColor=#FF781C;elsebt
3、Obj.style.color=#000000;btObj.style.backgroundColor=#F7F7F7;function setTransition()b2bContent.filters.revealTrans.Transition=Math.round(Math.random()*23);b2bContent.filters.revealTrans.apply();turnPage();用户名:密 码: 2.java代码(1) User.Java 定义的属性和数据库中的字段相对应pa
4、ckage com.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.id = id;public String getUsername() return username;public void setUsername(String username) this.u
5、sername = 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.xh = xh;public String getCollege() return college;public void setCollege(String college) this.college = c
6、ollege;(2) UserDAO.java 操作数据库tb_user,验证用户登录package com.softeem.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import com.softeem.db.DBManager;import com.softeem.dt.User;public class UserDAO * 验证用户登录 * returnpublic boolean check
7、Denglu(User user) boolean flag = false;/ 获得数据库连接Connection conn = DBManager.getConnection();/ 用select * from查询数据库中的所有字段String sql = select count(*) from tb_user where username=? and password=?;try PreparedStatement pst = conn.prepareStatement(sql);pst.setString(1, user.getUsername();pst.setString(2,
8、 user.getPassword();/ 执行查询语句,拿到结果集ResultSet rs = pst.executeQuery();while (rs.next() int count = rs.getInt(1);/用count和0比较,若大于0表示该用户存在,否则不存在if(count 0)flag = true; catch (SQLException e) e.printStackTrace();return flag;3.LoginServlet,点击登录跳转到服务器端package com.softeem.servlet;import java.io.IOException;i
9、mport javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.softeem.dao.UserDAO;import com.softeem.dto.User; * Servlet implementation class LoginServletpublic class LoginServlet exten
10、ds HttpServlet private static final long serialVersionUID = 1L; * see HttpServlet#HttpServlet() public LoginServlet() super(); * see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)protected void doGet(HttpServletRequest request, HttpServletResponse response) throws Servle
11、tException, IOException super.doGet(request, response); * see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException /获取表单数据/处理乱码request.setCharacterEncoding(utf-
12、8);String username = request.getParameter(username);String password = request.getParameter(password);/封装到user对象中User user = new User();user.setUsername(username);user.setPassword(password);/调用dao的checkLogin方法UserDAO dao = new UserDAO();boolean flag = dao.checkLogin(user);String message = null;String
13、 path = null;if(flag)message = 登录成功;path=success.jsp;request.getSession().setAttribute(user, user);elsemessage =对不起密码错误,请重新输入!;path=fail.jsp;/response返回messageresponse.setCharacterEncoding(utf-8);response.getWriter().write(message);*/属于服务器跳转,浏览器地址栏没有发生改变request.getRequestDispatcher(path).forward(request,response);