Jsp_Servlet实现动态登录

package mypakage; import java.io.IOException; import java.io.PrintWriter; import mybean.*; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class CheckAccount extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; public static Connection getConnection(){ Connection con=null; try{ Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "123456"); }catch(Exception e){ e.printStackTrace(); } return con; } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { HttpSession session = request.getSession(); AccountBean account = new AccountBean(); String username = new String(request.getParameter("username").getBytes("ISO8859_1")); String pwd = request.getParameter("pwd"); account.setUsername(username); account.setPassword(pwd); Connection con=getConnection(); Statement st; String u; String p; try { st=con.createStatement(); ResultSet rs=st.executeQuery("select * from checkout"); while(rs.next()){ u=rs.getString("user"); p=rs.getString("password"); if( (username != null) && ( username.trim().equals(u)) ) { if( (pwd != null) && ( pwd.trim().equals(p)) ) { System.out.println("success"); session.setAttribute("account",account); String logon_suc= "success.jsp"; response.sendRedirect(logon_suc); return; } } } String logon_fail = "fail.jsp"; response.sendRedirect(logon_fail); return; } catch(Exception e){ e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request,response); } }