BYR Achieve · 镜像论坛

JSP求教

2011/7/10镜像同步12 回复

本人在做JSP网站，登陆页面运行的时候，无论信息是对还是错，都是rs.next()这行报错，就是不能页面跳转，求大牛指教. ublic class LoginServlet extends HttpServlet implements Servlet { public LoginServlet() { // TODO Auto-generated constructor stub } /* * (non-Javadoc) * * @see * javax.servlet.http.HttpServlet#doGet(javax.servlet.http.HttpServletRequest * , javax.servlet.http.HttpServletResponse) */ @Override protected void doGet(HttpServletRequest arg0, HttpServletResponse arg1) throws ServletException, IOException { } /* * (non-Javadoc) * * @see * javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest * , javax.servlet.http.HttpServletResponse) */ @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); String result = ""; // 获取用户名 String sUserName = request.getParameter("username"); // 获取密码 String sPasswd = request.getParameter("password"); // 登记JDBC驱动程序 try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } catch (InstantiationException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("InstantiationException"); } catch (IllegalAccessException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("IllegalAccessException"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("ClassNotFoundException"); } // 连接参数与Access不同 String url = "jdbc:mysql://localhost:3306/javaweb"; // 建立连接 java.sql.Connection connection = null; Statement stmt = null; ResultSet rs = null; try { connection = DriverManager.getConnection(url, "root", "123456"); stmt = connection.createStatement(); // SQL语句 String sql = "SELECT * FROM user where username='" + sUserName + "' and password = '" + sPasswd + "'"; rs = stmt.executeQuery(sql);// 返回查询结果 } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if (rs.next())// 如果记录集非空，表明有匹配的用户名和密码，登陆成功 { // 登录成功后将sUserName设置为session变量的UserName // 这样在后面就可以通过 session.getAttribute("UserName") 来获取用户名， // 同时这样还可以作为用户登录与否的判断依据 request.getSession().setAttribute("UserName", sUserName); // 权限登陆,flag变量在某些权限管理功能的时候用以判断。 request.getSession().setAttribute("flag", "rs.getString(4)"); response.sendRedirect("LoginSuccess.jsp"); } else { // 否则登录失败 response.sendRedirect("LoginFailure.jsp"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if (null != rs) { rs.close(); } if (null != stmt) { stmt.close(); } if (null != connection) { connection.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }

订阅后，新回复会通过你的通知中心匿名送达。