Eclipse实现学生信息管理系统，优秀Java毕业设计，小白必看！

package com.ischoolbar.programmer.servlet; import java.io.IOException; import java.io.InputStream; import java.io.UnsupportedEncodingException; import java.net.URLEncoder; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.fileupload.FileUploadException; 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 net.sf.json.JSONArray; import net.sf.json.JSONObject; import com.ischoolbar.programmer.dao.CourseDao; import com.ischoolbar.programmer.dao.ScoreDao; import com.ischoolbar.programmer.dao.SelectedCourseDao; import com.ischoolbar.programmer.dao.StudentDao; import com.ischoolbar.programmer.dao.TeacherDao; import com.ischoolbar.programmer.model.Course; import com.ischoolbar.programmer.model.Page; import com.ischoolbar.programmer.model.Score; import com.ischoolbar.programmer.model.SelectedCourse; import com.ischoolbar.programmer.model.Student; import com.ischoolbar.programmer.model.Teacher; import com.lizhou.exception.FileFormatException; import com.lizhou.exception.NullFileException; import com.lizhou.exception.ProtocolException; import com.lizhou.exception.SizeException; import com.lizhou.fileload.FileUpload; public class ScoreServlet extends HttpServlet { /** * */ private static final long serialVersionUID = -153736421631912372L; public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{ doPost(request, response); } public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{ String method = request.getParameter("method"); if("toScoreListView".equals(method)){ try { request.getRequestDispatcher("view/scoreList.jsp").forward(request, response); } catch (ServletException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if("AddScore".equals(method)){ addScore(request,response); }else if("ScoreList".equals(method)){ getScoreList(request,response); }else if("EditScore".equals(method)){ editScore(request,response); }else if("DeleteScore".equals(method)){ deleteScore(request,response); }else if("ImportScore".equals(method)){ importScore(request,response); }else if("ExportScoreList".equals(method)){ exportScore(request,response); }else if("toScoreStatsView".equals(method)){ try { request.getRequestDispatcher("view/scoreStats.jsp").forward(request, response); } catch (ServletException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if("getStatsList".equals(method)){ getStatsList(request,response); } } private void getStatsList(HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString()); String searchType = request.getParameter("searchType"); response.setCharacterEncoding("UTF-8"); if(courseId == 0){ try { response.getWriter().write("error"); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } return; } ScoreDao scoreDao = new ScoreDao(); Score score = new Score(); score.setCourseId(courseId); if("avg".equals(searchType)){ Map<String, Object> avgStats = scoreDao.getAvgStats(score); List<Double> scoreList = new ArrayList<Double>(); scoreList.add(Double.parseDouble(avgStats.get("max_score").toString())); scoreList.add(Double.parseDouble(avgStats.get("min_score").toString())); scoreList.add(Double.parseDouble(avgStats.get("avg_score").toString())); List<String> avgStringList = new ArrayList<String>(); avgStringList.add("最高分"); avgStringList.add("最低分"); avgStringList.add("平均分"); Map<String, Object> retMap = new HashMap<String, Object>(); retMap.put("courseName", avgStats.get("courseName").toString()); retMap.put("scoreList", scoreList); retMap.put("avgList", avgStringList); retMap.put("type", "suceess"); try { response.getWriter().write(JSONObject.fromObject(retMap).toString()); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } return; } List<Map<String, Object>> scoreList = scoreDao.getScoreList(score); List<Integer> numberList = new ArrayList<Integer>(); numberList.add(0); numberList.add(0); numberList.add(0); numberList.add(0); numberList.add(0); List<String> rangeStringList = new ArrayList<String>(); rangeStringList.add("60分以下"); rangeStringList.add("60~70分"); rangeStringList.add("70~80分"); rangeStringList.add("80~90分"); rangeStringList.add("90~100分"); String courseName = ""; for(Map<String, Object> entry:scoreList){ courseName = entry.get("courseName").toString(); double scoreValue = Double.parseDouble(entry.get("score").toString()); if(scoreValue < 60){ numberList.set(0, numberList.get(0)+1); continue; } if(scoreValue <= 70 && scoreValue >= 60){ numberList.set(1, numberList.get(1)+1); continue; } if(scoreValue <= 80 && scoreValue > 70){ numberList.set(2, numberList.get(2)+1); continue; } if(scoreValue <= 90 && scoreValue > 80){ numberList.set(3, numberList.get(3)+1); continue; } if(scoreValue <= 100 && scoreValue > 90){ numberList.set(4, numberList.get(4)+1); continue; } } Map<String, Object> retMap = new HashMap<String, Object>(); retMap.put("courseName", courseName); retMap.put("numberList", numberList); retMap.put("rangeList", rangeStringList); retMap.put("type", "suceess"); try { response.getWriter().write(JSONObject.fromObject(retMap).toString()); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } private void exportScore(HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString()); int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString()); //获取当前登录用户类型 int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString()); if(userType == 2){ //如果是学生，只能查看自己的信息 Student currentUser = (Student)request.getSession().getAttribute("user"); studentId = currentUser.getId(); } Score score = new Score(); score.setStudentId(studentId); score.setCourseId(courseId); try { response.setHeader("Content-Disposition", "attachment;filename="+URLEncoder.encode("score_list_sid_"+studentId+"_cid_"+courseId+".xls", "UTF-8")); response.setHeader("Connection", "close"); response.setHeader("Content-Type", "application/octet-stream"); ServletOutputStream outputStream = response.getOutputStream(); ScoreDao scoreDao = new ScoreDao(); List<Map<String, Object>> scoreList = scoreDao.getScoreList(score); scoreDao.closeCon(); HSSFWorkbook hssfWorkbook = new HSSFWorkbook(); HSSFSheet createSheet = hssfWorkbook.createSheet("成绩列表"); HSSFRow createRow = createSheet.createRow(0); createRow.createCell(0).setCellValue("学生"); createRow.createCell(1).setCellValue("课程"); createRow.createCell(2).setCellValue("成绩"); createRow.createCell(3).setCellValue("备注"); //实现将数据装入到