package?control;

import?java.io.BufferedInputStream;
import?java.io.BufferedOutputStream;
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.IOException;
import?java.io.InputStream;
import?java.io.OutputStream;
import?java.io.PrintWriter;
import?java.io.UnsupportedEncodingException;
import?java.net.URLEncoder;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;

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

import?jxl.Cell;
import?jxl.Sheet;
import?jxl.Workbook;

import?org.apache.commons.fileupload.FileItem;
import?org.apache.commons.fileupload.FileUpload;
import?org.apache.commons.fileupload.RequestContext;
import?org.apache.commons.fileupload.disk.DiskFileItemFactory;
import?org.apache.commons.fileupload.servlet.ServletFileUpload;
import?org.apache.commons.fileupload.servlet.ServletRequestContext;


import?util.Info;

import?dao.CommDAO;

public?class?MainCtrl?extends?HttpServlet?{

	public?MainCtrl（）?{
		super（）;
	}

	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?go（String?urlHttpServletRequest?request?HttpServletResponse?response）
		{
		try?{
			request.getRequestDispatcher（url）.forward（request?response）;
		}?catch?（ServletException?e）?{
			e.printStackTrace（）;
		}?catch?（IOException?e）?{
			e.printStackTrace（）;
		}
		}
		
		public?void?gor（String?urlHttpServletRequest?request?HttpServletResponse?response）
		{
			try?{
				response.sendRedirect（url）;
			}?catch?（IOException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		
		}

	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
????????response.setContentType（“text/html“）;
		PrintWriter?out?=?response.getWriter（）;
		String?ac?=?request.getParameter（“ac“）;
		if（ac==null）ac=““;
		CommDAO?dao?=?new?CommDAO（）;
		String?date?=?Info.getDateStr（）;
		String?today?=?date.substring（010）;
		String?tomonth?=?date.substring（07）;
		
		?
		if（ac.equals（“l(fā)ogin“））
		{
			String?username?=?request.getParameter（“username“）;
			String?password?=?request.getParameter（“pwd1“）;
			String?utype?=?request.getParameter（“cx“）;
			String?pagerandom?=?request.getParameter（“pagerandom“）==null?““:request.getParameter（“pagerandom“）;
			String?random?=?（String）request.getSession（）.getAttribute（“random“）;
			if（!pagerandom.equals（random）&&request.getParameter（“a“）!=null）
			{
				request.setAttribute（“random“?““）;
				go（“/index.jsp“?request?response）;
			}
			else{
				String?sql1=““;
				if?（utype.equals（“管理員“））{sql1?=?“sele