package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Enumeration;
import java.sql.Date;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import com.suntek.eap.jdbc.QueryHelper;
import com.suntek.eap.jdbc.RowModel;
import com.suntek.eap.core.app.*;
import myLogger.MideaLogger;


public class LoginServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public LoginServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
this.doPost(request, response);

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

		response.setContentType("text/html");
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		PrintWriter out = response.getWriter();
		
		//獲取form信息
		String yhm = request.getParameter("yhm");
		String mm = request.getParameter("mm");

		
		//QueryHelper queryer = QueryHelper.getDefault(AppHandle.getHandle("ResumeManagement").getDatasourceName());
		QueryHelper queryer = QueryHelper.getDefault("orc10g");
		String querysql = "select * from USERINFO where VC_ID = '"+yhm+"'";
		RowModel row = null;
		try{
		row = queryer.getFirstRow(querysql);
		}
		catch(Exception ex)
		{
			MideaLogger.logger.error(ex.getMessage());
			response.sendRedirect("../error.jsp?type=1");//用戶名錯(cuò)誤
		}
		try{
		if (mm.equals(row.getColumnValue("VC_MM")))
		{
//			設(shè)置用戶名為會(huì)話對(duì)象
			HttpSession httpsession = request.getSession();
			httpsession.setAttribute("yhm", yhm);
			if (row.getColumnValue("I_YHLB").equals("0")){
//				轉(zhuǎn)向顯示頁面
				response.sendRedirect("../user.jsp");
			}
			if (row.getColumnValue("I_YHLB").equals("1")){
//				轉(zhuǎn)向顯示頁面
				response.sendRedirect("../admin.jsp");
			}
		}
		}
		catch(Exception ex)
		{
			MideaLogger.logger.error(ex.getMessage());
			response.sendRedirect("../error.jsp?type=2");//用戶名錯(cuò)誤
		}
	}

	public void init() throws ServletException {
		// Put your code here
	}

}