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?javax.servlet.http.HttpSession;

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（）;
		HttpSession?session?=?request.getSession（）;
		HashMap?user?=?（HashMap）session.getAttribute（“admin“）;
		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（“mlogin“））
		{??
			String?username?=?request.getParameter（“uname“）;
			String?password?=?request.getParameter（“upass“）;?
				List?list?=?dao
						.select（“select?*?from?sysuser?where?uname=‘“
								+?username?+?“‘“）;
				if?（list.size（）?==?1）?{
					HashMap?map?=?list.get（0）;
					List?ulist?=?dao
							.select（“select?*?from?sysuser?where?uname=‘“
									+?username?+?“‘???and?upass=‘“?+?password