package csmyzsweb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;

public class ctrlservlet extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";
   DBbean b1=null;
  //Initialize global variables
  public void init() throws ServletException {
  try{
   // Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    b1=new DBbean();
    }catch(Exception ee){throw new ServletException(ee);}
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doPost(request,response);
   }


  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
     request.setCharacterEncoding("gb2312");
     response.setContentType(CONTENT_TYPE);
     PrintWriter out = response.getWriter();
     String ctrl=(String)request.getParameter("ctrl");
     if (ctrl!=null){
        if(ctrl.equals("1")){//處理注冊
        String ExaminationCode=(String)request.getParameter("txtExaminationCode");
        String Password=(String)request.getParameter("txtPassword");
        String sltQuestion=(String)request.getParameter("sltQuestion");
        String txtAnswer=(String)request.getParameter("txtAnswer");
         String ok=null;
        String DisplyMsg=null;
        try{ ok=b1.insertdata(ExaminationCode,Password, sltQuestion,txtAnswer);
          if(ok != null){
             request.setAttribute("DisplyType","registererror");
             DisplyMsg=" <font  size=\"5\"  color=\"red\">注冊成功，你的網報號是："+ok+"<br>請用網報號登錄<br></font><br>注：網報號是你登錄報名系統的通行證，也是你領取準考證的唯一依據！";
             request.setAttribute("DisplyMsg",DisplyMsg);
             getServletConfig().getServletContext().getRequestDispatcher("/Logon.jsp").forward(request,response);
            }
           else {  request.setAttribute("register","notok");
                  getServletConfig().getServletContext().getRequestDispatcher("/Register.jsp").forward(request,response);
                 }

         }catch(Exception ee){
           String msg=ee.toString();
          if(msg.indexOf("PRIMARY")>1){
           DisplyMsg="該考生號已經注冊，請直接選擇登錄功能<br>";
          }
           else {DisplyMsg="系統數據庫異常，操作失敗，請稍后再登錄。<br>如有問題請與招生辦聯系<br>";}
           request.setAttribute("DisplyType","registererror");
           request.setAttribute("DisplyMsg",DisplyMsg);
           this.getServletConfig().getServletContext().getRequestDispatcher("/Msgdisply.jsp").forward(request,response);
        }
            }

      if(ctrl.equals("2")){//處理登錄
        out.print("正在登錄...<br>");
        String NetworkCode =(String)request.getParameter("txtNetworkCode");
        String password=(String)request.getParameter("txtPassword");
        String  ok=null;//考生號
        String  DisplyMsg=null;
        try{
           ok=b1.logincheck(NetworkCode, password) ;
           }catch(SQLException ee){

             request.setAttribute("DisplyType","logon");
             DisplyMsg="系統數據庫異常，操作失敗，請稍后再登錄。<br>如有問題請與招生辦聯系<br>";
             request.setAttribute("DisplyMsg",DisplyMsg);
             getServletConfig().getServletContext().getRequestDispatcher("/Msgdisply.jsp").forward(request,response);;
         }
         if(ok!=null){
             HttpSession session=request.getSession();
             session.setAttribute("ExaminationCode",ok);
             session.setAttribute("NetworkCode",NetworkCode);
            // request.setAttribute("DisplyType","logon");
            // DisplyMsg="考生號為"+ok+"的用戶:<br>你已登錄成功，請選擇其它功能";
            // request.setAttribute("DisplyMsg",DisplyMsg);
           // getServletConfig().getServletContext().getRequestDispatcher("/Msgdisply.jsp").forward(request,response);
            ctrl="9";
         }
         else{
           //
           request.setAttribute("logon","notlogon");
           getServletConfig().getServletContext().getRequestDispatcher("/Logon.jsp").forward(request,response);
         }

      }

     if(ctrl.equals("3")){//處理數據修改

       String City=( String)request.getParameter("sltCity");
       String County= ( String)request.getParameter("sltCityCounty");
       String MiddleSchool=( String)request.getParameter("txtMiddleSchool");
       String SpecialtyType=( String)request.getParameter("sltSpecialtyType");

       HttpSession session=request.getSession();
       String NetworkCode=( String)session.getAttribute("NetworkCode");
       String ExaminationCode=( String)session.getAttribute("ExaminationCode");

       String StudentName=( String)request.getParameter("txtName");
       String Sex=( String)request.getParameter("sltSex");
       String Nationality=( String)request.getParameter("sltNationality");
// ---------出生日期---
       String BirthYear=(String) request.getParameter("sltYear");
       String BirthMonth=(String) request.getParameter("sltMonth");
       String BirthDay=(String) request.getParameter("sltDay");

       String Birth = BirthYear+"-"+BirthMonth+"-"+BirthDay;
//---------------------
       String PoliticsVisage = (String) request.getParameter("sltPoliticsVisage");

       String IdentityCardID = (String) request.getParameter("txtIdentityCardID");
       String ExamineeType = (String) request.getParameter("sltExamineeType");

       String ResidenceCity = (String) request.getParameter("sltResidenceCity");
       String ResidenceRounty = (String) request.getParameter("sltResidenceCounty");
       String ResidenceVillages = (String) request.getParameter("txtResidenceVillage");


        String CountryTelephone = (String) request.getParameter("sltCountry");
        String Tel =(String) request.getParameter("txtPhone");
        String Telephone = CountryTelephone+"-"+Tel;


       String MobileTelephone = (String) request.getParameter("txtMobilePhone");
       String PostCode = (String) request.getParameter("txtPostCode");

       String Address = (String)request.getParameter("txtAddress");
       String Addressee = (String) request.getParameter("txtAddressee");
       String EnterSpecialityOne = (String)request.getParameter("sltSpecialityOne");
       String EnterSpecialityTwo = (String)request.getParameter("sltSpecialityTwo");
       String Adjust = (String) request.getParameter("sltAdjust");
//----------------高中-----------
       String StartTime1=(String) request.getParameter("sltStartTime1");
       String EndTime1=(String)request.getParameter("sltEndTime1");
       String Student1=(String)request.getParameter("txtStudent1");
       String  Post1=(String)request.getParameter("txtPost1");
       String  Person1=(String)request.getParameter("txtPerson1");
     //-----------初中----------------------------------------------
      String StartTime2=(String) request.getParameter("sltStarTime2");
      String EndTime2=(String)request.getParameter("sltEndTime2");
      String Student2=(String)request.getParameter("txtStudent2");
      String  Post2=(String)request.getParameter("txtPost2");
      String  Person2=(String)request.getParameter("txtPerson2");
    //-----------小學--------------------------------------------------
      String StartTime3=(String) request.getParameter("sltStartTime3");
      String EndTime3=(String)request.getParameter("sltEndTime3");
      String Student3=(String)request.getParameter("txtStudent3");
      String  Post3=(String)request.getParameter("txtPost3");
      String  Person3=(String)request.getParameter("txtPerson3");


       String Resume = StartTime1+"%"+EndTime1+"%"+Student1+"%"+ Post1+"%"+ Person1;
        Resume = Resume+"/" +StartTime2+"%"+EndTime2+"%"+Student2+"%"+ Post2+"%"+ Person2;
       Resume = Resume+ "/"+StartTime3+"%"+EndTime3+"%"+Student3+"%"+ Post3+"%"+ Person3;
 //-------------------------------------------------------------
       String StrongSuit = (String) request.getParameter("txtStrongSuit");
       String EncouragementAndPunishment = (String) request.getParameter("txtEncouragementAndPublishment");

       String  DisplyMsg=null;
       boolean ok=false;
      try{
        ok=b1.updatedata(City, County, MiddleSchool, SpecialtyType,
                              StudentName, Sex, Nationality,
                        Birth, PoliticsVisage, IdentityCardID,
                        ExamineeType, ResidenceCity, ResidenceRounty,
                                     ResidenceVillages, Telephone, MobileTelephone,
                                     PostCode,
                                    Address, Addressee, EnterSpecialityOne,
                                    EnterSpecialityTwo, Adjust, Resume, StrongSuit,
                                    EncouragementAndPunishment, ExaminationCode);


                 }catch(SQLException ee){System.out.print(ee.toString());
                      DisplyMsg="系統數據庫異常，操作失敗，請稍后再登錄。<br>如有問題請與招生辦聯系<br>";
                      request.setAttribute("DisplyType","updatedata");