userlogin.java

书店实现用struts实现的一个系统 采用mysql数据库

/**
 * 该Servlet处理来自userLogin.jsp及快速登陆表单的请求
 * 用于对用户帐号与密码是否匹配进行检查
 * 如果帐号密码匹配则登陆成功，否则转回userLogin.jsp
 */
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import bean.UserInf;
import bean.StrClass;
import bean.conn;

public class UserLogin extends HttpServlet{
	public void doGet(HttpServletRequest request, HttpServletResponse response) 
	throws ServletException, IOException {
		HttpSession session=request.getSession();
		String toJsp="/hasLogin.jsp";
		if(session.getAttribute("userId")==null){
			String id=request.getParameter("id");
			String pwd=request.getParameter("password");
			String query="SELECT * FROM UserInf WHERE id="+"\'"+ id + "\'"
						+"AND password="+"\'"+ pwd + "\'";
			conn db=new conn();		
			ResultSet resultset=db.executeQuery(query);
			try{
				if(resultset.next()){
					session.setAttribute("userId", id);
					toJsp="/loginSuccess.jsp";
				} else {
					toJsp="/userLogin.jsp";
					request.setAttribute("errInf","*密码与帐号不匹配");
				}
			}catch(SQLException sqle){
			    System.err.println("Erro with connection:"+sqle);
			}
			db.closeConnection();
		} 
		RequestDispatcher dispatcher = 
		                  request.getRequestDispatcher(toJsp);		            
		dispatcher.forward(request, response);	
	}
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		doGet(request,response);
	}
}