Jsp学生信息管理系统登录验证全代码.doc

精品文档1. jsp登录界面 Login.jsp用户登录界面学生信息信息管理系统123456b2bStr = new Array();b2bStr0= 太阳岛公园一角;b2bStr1 = 太阳岛公园湖光山色;b2bStr2 = 哈尔滨雪雕;b2bStr3 = 镜泊湖;b2bStr4 = 太阳岛公园瀑布;b2bStr5 = 镜泊湖夜色;var page=0;var speed=3000;function showPage(id)page=id;setTransition();b2bContent.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;elsebtObj.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 定义的属性和数据库中的字段相对应package 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.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.xh = xh;public String getCollege() return college;public void setCollege(String college) this.college = college;(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 /* * 验证用户登录 * return */public boolean checkDenglu(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, 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;import 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 LoginServlet */public class LoginServlet extends 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 ServletException, 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-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 path = null;if(flag)message = 登录成功;path=success.jsp;request.getSession().setAttribute(user, user);elsemessage =对不起密码错误,请重新输入!;path=fail.jsp;/response返回messageresponse.setChara