基于SSM框架开发的在线考试系统

package it.com.action; import java.io.IOException; import java.io.PrintWriter; import java.io.UnsupportedEncodingException; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Random; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import org.apache.poi.hssf.extractor.ExcelExtractor; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import it.com.bean.Knowledge; import it.com.bean.Questions; import it.com.bean.Subject; import it.com.bean.Users; import it.com.service.TeacherService; import it.com.service.UsersService; import it.com.service.impl.ImpTeacherService; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import net.sf.json.JSONArray; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; @Controller public class UsersAction { @Resource UsersService us; public UsersService getUs() { return us; } public void setUs(UsersService us) { this.us = us; } @Resource TeacherService ts; public TeacherService getTs() { return ts; } public void setTs(TeacherService ts) { this.ts = ts; } @RequestMapping("index.action") //跳转到学生、教师登陆页面 public ModelAndView index(){ return new ModelAndView("stu/login.jsp"); } @RequestMapping("welcome.action") //跳转到管理员欢迎页面 public ModelAndView welcome(){ return new ModelAndView("admin/welcome.jsp"); } @RequestMapping("forgetpwd.action") //跳转到管理员欢迎页面 public ModelAndView forgetpwd(HttpSession session){ int m=0; List<Users> list=us.findAdmin(); System.out.println(list); session.setAttribute("usernameA", list); session.setAttribute("m", m); return new ModelAndView ("admin/forgetpwd.jsp"); } @RequestMapping("tecwelcome.action") //跳转到教师欢迎页面 public ModelAndView tecwelcome(){ return new ModelAndView("teacher/welcome.jsp"); } @RequestMapping("nav.action") //跳转到管理员nav页面 public ModelAndView nav(){ return new ModelAndView("admin/nav.jsp"); } @RequestMapping("tecnav.action") //跳转到教师nav页面 public ModelAndView tecnav(){ return new ModelAndView("teacher/nav.jsp"); } @RequestMapping("table.action") //跳转到管理员table页面 public ModelAndView table(){ return new ModelAndView("admin/table.jsp"); } @RequestMapping("form.action") //跳转到管理员form页面 public ModelAndView form(){ return new ModelAndView("admin/form.jsp"); } @RequestMapping("tecform.action") //跳转到教师form页面 public ModelAndView tecform(){ return new ModelAndView("teacher/form.jsp"); } @RequestMapping("logintest.action") //管理员登陆验证 public ModelAndView logintest(HttpServletRequest request,HttpSession session){ String uri=""; String username=request.getParameter("username"); String userpwd=request.getParameter("userpwd"); String usertype=request.getParameter("usertype"); if(usertype.equals("administrator")){ int n=us.login(username, userpwd,0); if(n==1){ uri="admin/success.jsp"; }else{ uri="admin/login.jsp"; session.setAttribute("n", n); } Map map=new HashMap(); map.put("username", username); map.put("userpwd",userpwd); session.setAttribute("user", map); }else{ uri="admin/login.jsp"; } return new ModelAndView(uri); } //教师、学生登陆验证 @RequestMapping(value="login.action") public ModelAndView login(String username,String userpwd, int numyzm,HttpServletRequest res,HttpSession session){ String uri=""; String usertype=res.getParameter("usertype"); System.out.println("*--------"+usertype); System.out.println("*--------"+username); //System.out.println("---usertype---:"+usertype); if(usertype.equals("student")){ int nn=us.login(username, userpwd,2); //System.out.println("输出nn的值--------"+nn); int result=Integer.parseInt(session.getAttribute("result").toString()); //System.out.println(username+"===="+userpwd+"===="+numyzm); if(numyzm==result&&nn==1){ //System.out.println("我是学生--------"+nn); session.setAttribute("user", username); uri="stu/main.jsp"; }else{ uri="stu/login.jsp"; } }else if(usertype.equals("teacher")){ int nn=us.login(username, userpwd,1); //System.out.println("输出nn的值--------"+nn); int result=Integer.parseInt(session.getAttribute("result").toString()); //System.out.println(username+"===="+userpwd+"===="+numyzm); if(numyzm==result&&nn==1){ //System.out.println("我是老师--------"+nn); uri="tea.action"; }else{ uri="stu/login.jsp"; } }else{ uri="stu/login.jsp"; } return new ModelAndView(uri); } //通过页面获取的usertype查询学生或者教师的所有信息 @RequestMapping("selectUser.action") public ModelAndView selectUser(int usertype,HttpSession session){ List<Users> list=us.findUserByType(usertype); List <Subject>list1=ts.findSubject1(); int m1=list1.size(); session.setAttribute("m1", m1); session.setAttribute("listsub", list1); session.setAttribute("listusers", list); session.setAttribute("usertype", usertype); return new ModelAndView("admin/table.jsp");//跳转到查询的用户所有信息的界面 } //Users 操作 //插入学生或者教师的信息 @RequestMapping("insertUser.action") public ModelAndView insertUser(String username,String userpwd,int subjectid,int usertype,HttpSession session){ int n=us.insertUserByIdType(username, userpwd, subjectid, usertype); return new ModelAndView("admin/up.jsp");//跳转到插入后的用户界面 } //删除学生或者教师的信息 @RequestMapping("deleteUser.action") public ModelAndView deleteUser(int userid){ int n=us.deleUserById(userid); return new ModelAndView("admin/up.jsp");//更新用户信息后的界面 } //更新查询 @RequestMapping("UpdateSelectUsersById.action") public ModelAndView UpdateSelectUsersById(int userid,HttpSession session){ List<Users>list=us.UpdateSelectUsersById(userid); session.setAttribute("listuserbyid", list); return new ModelAndView("admin/update.jsp");//跳转到插入后的用户界面 } //更新 @RequestMapping("UpdateUserById.action") public ModelAndView UpdateUserById(String username,String userpwd,int subjectid,int usertype,int userid,HttpSession session){ int n=us.UpdateUserById(username, userpwd, subjectid, usertype, userid); session.setAttribute("usertype", usertype); return new ModelAndView("admin/up.jsp");//跳转到插入后的用户界面 } //课程操作 //查询所有课程 @RequestMapping("allsubject.action") public ModelAndView selectsubject(HttpSession session){ List <Subject> list=ts.findSubject1(); session.setAttribute("listless", list); return new ModelAndView("admin/less.jsp");//跳转到插入后的用户界面 } //插入 @RequestMapping("insertSub.action") public ModelAndView insertSub(String subjecttype){ int n=us.insSubjectById(subjecttype); return new ModelAndView("admin/su.jsp");//跳转到插入后的用户界面 } //删除 @RequestMapping("deleteSub.action") public ModelAndView deleteSub(HttpServletRequest request) throws UnsupportedEncodingException{ String subjecttype=new String(request.ge