package com.logistic.servlet;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.Statement;
import com.logistic.business.LoginManager;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.logistic.data.DataConnect;

public class LoginInfoUpdate extends HttpServlet {

	private static final long serialVersionUID = -2305260907601477327L;
	HttpSession 	session=null;
	DataConnect 	dc=new DataConnect();
	Statement 		stat=null;
	ResultSet 		rs=null;
	String  		loginid=null;
	String  		loginname=null;
	String  		password=null;
	String  		repassword=null;
	String  		loginpower=null;
	String  		employeeid=null;
	int      		flag=0;
	RequestDispatcher requestdispatcher;


	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
//		根據員工編號取得員工姓名
		   try{
			     employeeid=(String)request.getParameter("employeename");
			     String strsql="select * from employeeinfotable where EmployeeId="+employeeid;
			     stat=dc.getStmtread();
			     rs  =stat.executeQuery(strsql);
			     while(rs.next()){
			    	 loginname=rs.getString("EmployeeName");
			     }		   
		   }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		    
//	從頁面獲取參數進行添加操作
		    loginid=(String)request.getParameter("lid");
		    loginpower=(String)request.getParameter("power");
		    password=(String)request.getParameter("password").trim();
		    repassword=(String)request.getParameter("repassword").trim();
		    
//	檢測數據合法性
		 if(loginid==null||employeeid==null||loginpower==null){	
	         session.setAttribute("errors","*標識項必須填寫!");
	 		 requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
	 		 requestdispatcher.forward(request, response);	    		   
		     }else{	    	 
			    if(password.equals(repassword)==false){	
			    	session.setAttribute("errors","密碼不等，請重新確認密碼!");
			 		requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			 		requestdispatcher.forward(request, response);
			    }else{		    	
		    	     try{
		    		     LoginManager lm=new LoginManager();
		    		     flag=lm.ModifyLogin(loginid, loginname, password, loginpower, employeeid);
		    		     if(flag>0){
		    		    	 session.setAttribute("success","登陸信息修改成功!");
		    		    	 requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/adminlogininfo.jsp");
		    		    	 requestdispatcher.forward(request, response);
		    		     }else{
		    		    	 session.setAttribute("errors", " 登陸信息修改失敗!");
		    		    	 requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		    		    	 requestdispatcher.forward(request, response);
		    		     }
		    		
		    	     	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		         }
		    }	    
		
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {

		doPost(request,response);
    }

}