/*
 *該servlet接受來自登錄界面的管理員入口連接的請求
 *用于完成管理員登錄任務
 */
 package 
 import java.io.*;
 import java.sql.*;
 import javax.servlet.*;
 import javax.servler.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 SBClass();
 		db.connect();
 		ResultSet resultset=db.executeQuery(query);
 		try{
 			if(resultset.next()){
 				session.setAttribute("adminId",id);
 				toJsp='/adminLogin.jsp";		
 			}else{
 				toJsp="/adminLogin.jsp";
 				request.setAttribute("errInf","*密碼與帳號不匹配");
 			}
 		}catch(SQLException sele){
 			System.err.println("Erro with connection:"+sqle);
 		}
 		db.closeConnection();
 		RequestDispatcher dispatcher=request.getRequestDispatcher(toJSP);
 		dispatcher.forward(request,response);
 	}pubinc void dopost(HttpServletRequest request,HttpServletResponse,response)throws ServletExcepton,IOEception{
 		doGet(request,response);
 	}
 }