UsersManagerJsp1.0.zip_简单购物_购物网站

package dlnu.wangbo.controller; import java.io.IOException; import java.io.PrintWriter; import java.sql.*; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class LoginClServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String u = request.getParameter("username"); String p = request.getParameter("password"); Connection conn = null; ResultSet rs = null; PreparedStatement ps = null; try { // 1.加载驱动 Class.forName("com.mysql.jdbc.Driver"); // 2.建立连接 conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test", "root", "system"); // 创建PrepareStatement ps = conn .prepareStatement("select * from login where username =? and password=?"); // 给？赋值 ps.setObject(1, u); ps.setObject(2, p); // 执行操作 rs = ps.executeQuery(); // 根据结果判断 if (rs.next()) { request.getSession().setAttribute("username", u); request.getRequestDispatcher("/main.jsp").forward(request,response); } else { request.setAttribute("error", "1"); request.getRequestDispatcher("/login.jsp").forward(request,response); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { if (rs != null) { try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } rs = null; } if (conn != null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } conn = null; } if(ps != null){ try { ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } ps = null; } } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } }