机房上机安排管理系统.rar

该系统分为值班人员端，教师端和超级管理员端，系统导入时注意数据库的创建和连接。这可是我当初的毕设哟，虽然不咋滴。

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（“adminlogin“））
		{
			String username = request.getParameter（“username“）;
			String password = request.getParameter（“pwd“）;
			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（“/login.jsp“ request response）;
			}
			else{
				String sql1=““;
				if （utype.equals（“教师“））

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       1505  2019-05-19 20:08  jspmjfskapxthsg7002A9\.classpath

     文件        336  2019-05-19 19:16  jspmjfskapxthsg7002A9\.mymetadata

     文件         66  2019-05-19 19:16  jspmjfskapxthsg7002A9\.myumldata

     文件       1764  2019-05-19 19:16  jspmjfskapxthsg7002A9\.project

     文件        406  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\.jsdtscope

     文件        105  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\org.eclipse.core.resources.prefs

     文件        670  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\org.eclipse.jdt.core.prefs

     文件        498  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\org.eclipse.wst.common.component

     文件        252  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\org.eclipse.wst.common.project.facet.core.xml

     文件         49  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\org.eclipse.wst.jsdt.ui.superType.container

     文件          6  2019-05-19 19:16  jspmjfskapxthsg7002A9\.settings\org.eclipse.wst.jsdt.ui.superType.name

     文件         87  2019-05-19 20:08  jspmjfskapxthsg7002A9\.settings\org.eclipse.wst.ws.service.policy.prefs

     文件      36374  2019-05-19 19:16  jspmjfskapxthsg7002A9\database\jspmjfglxthsg5169A9.sql

     文件    3145728  2019-05-19 19:16  jspmjfskapxthsg7002A9\database\jspmjfskapxthsg7002A9.mdf

     文件    1048576  2019-05-19 19:16  jspmjfskapxthsg7002A9\database\jspmjfskapxthsg7002A9_log.ldf

     文件       8338  2019-05-19 19:16  jspmjfskapxthsg7002A9\src\control\MainCtrl.java

     文件      19232  2019-05-19 20:09  jspmjfskapxthsg7002A9\src\dao\CommDAO.java

     文件       2321  2019-05-20 11:44  jspmjfskapxthsg7002A9\src\page\jifangshenqing.java

     文件      27832  2019-05-19 19:16  jspmjfskapxthsg7002A9\src\util\Info.java

     文件       6974  2019-05-20 15:00  jspmjfskapxthsg7002A9\src\util\PageManager.java

     文件       1696  2019-05-19 19:16  jspmjfskapxthsg7002A9\src\util\SetChar.java

     文件       3459  2019-05-19 19:16  jspmjfskapxthsg7002A9\src\util\StrUtil.java

     文件         39  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebContent\meta-INF\MANIFEST.MF

     文件        234  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\css.css

     文件        853  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\databack.jsp

     文件       3020  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\factory\checkno.jsp

     文件       5500  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\factory\getsonops.jsp

     文件        881  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\factory\getyao.jsp

     文件       1475  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\frontfiles\css\css.css

     文件       3047  2019-05-19 19:16  jspmjfskapxthsg7002A9\WebRoot\frontfiles\js\collection.js

............此处省略225个文件信息