adminlogin.java

基于JSP编程的网上书店系统,功能挺强的！可供课程设计或毕业设计的同学使用

/**
 * 该Servlet接受来自index.jsp管理员入口链接的请求
 * 用于完成管理员登陆任务
 */
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import bean.UserInf;
import bean.DBClass;
import bean.StrClass;

public class AdminLogin extends HttpServlet{
	public void doGet(HttpServletRequest request, HttpServletResponse response) 
	throws ServletException, IOException {
		HttpSession session=request.getSession();
		String toJsp="";
		String id=request.getParameter("id");
		String pwd=request.getParameter("password");
		String query="SELECT * FROM admin WHERE id="+"\'"+ id + "\'"
						+"AND password="+"\'"+ pwd + "\'";
		DBClass db=new DBClass();
		db.connect();
		ResultSet resultset=db.executeQuery(query);
		try{
			if(resultset.next()){
				session.setAttribute("adminId", id);
				toJsp="/adminLoginSuccess.jsp";
			} else {
				toJsp="/adminLogin.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);
	}
}