作者主页:编程指南针
简介:Java领域优质创作者、CSDN博客专家 Java项目、简历模板、学习资料、面试题库、技术互助
文末获取源码
项目编号:BS-GX-004
本项目基于JSP/SERVLET技术开发实现,数据库使用MYSQL,开发工具采用IDEA/ECLIPSE。
大学生综合素质测评系统:包含用户管理,学生管理,院系管理,课程管理,各种测评成 管理等,数据可以导出EXECL,分用管理员用户和学生用户,管理员管理信息,用户查看自己的成绩信息。
系统管理员登陆: hsg / hsg
http://localhost/suzhicp/
系统部分功能展示如下:
编辑
管理员登陆后台主页面:
编辑
系统用户管理
编辑
学生信息管理
编辑
院系信息管理
编辑
班级信息管理
编辑
体育素质管理
编辑
课程信息管理
编辑
课程成绩管理
编辑
智能素质管理
编辑
政治思想素质管理
编辑
综合成绩管理
编辑
以上是本项目展示的部分功能,本项目功能完整,运行无误,采用JSP/SERVLET技术开发,适合做毕业设计使用 。
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 url, HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher(url).forward(request, response); } catch (ServletException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } public void gor(String url, HttpServletRequest 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(0, 10); String tomonth = date.substring(0, 7); if (ac.equals("login")) { 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 = "select * from yonghuzhuce where yonghuming='" + username + "' and mima='" + password + "' and issh='是'"; } else { sql1 = "select * from yuangongxinxi where gonghao='" + username + "' and mima='" + password + "'"; } List<HashMap> userlist1 = dao.select(sql1); if (userlist1.size() == 1) { if (utype.equals("注册用户")) { request.getSession().setAttribute("username", userlist1.get(0).get("yonghuming")); } else { request.getSession().setAttribute("username", userlist1.get(0).get("gonghao")); } request.getSession().setAttribute("cx", utype); gor("index.jsp", request, response); } else { request.setAttribute("error", ""); go("/index.jsp", request, response); } } } 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 ("学生".equals(utype)) { sql1 = "select * from xueshengxinxi where xuehao='" + username + "' and mima='" + password + "' "; } else { sql1 = "select * from allusers where username='" + username + "' and pwd='" + password + "'"; } // String sql1 = "select * from allusers where username='"+username+"' and pwd='"+password+"' "; List<HashMap> userlist1 = dao.select(sql1); if (userlist1.size() == 1) { if ("学生".equals(utype)) { request.getSession().setAttribute("username", userlist1.get(0).get("xuehao")); request.getSession().setAttribute("xm", userlist1.get(0).get("xingming")); request.getSession().setAttribute("yx", userlist1.get(0).get("yuanxi")); request.getSession().setAttribute("bj", userlist1.get(0).get("banji")); request.getSession().setAttribute("cx", utype); } else { request.getSession().setAttribute("username", userlist1.get(0).get("username")); request.getSession().setAttribute("cx", userlist1.get(0).get("cx")); } gor("main.jsp", request, response); } else { request.setAttribute("error", ""); go("/login.jsp", request, response); } } } //修改密码 if (ac.equals("uppass")) { String olduserpass = request.getParameter("ymm"); String userpass = request.getParameter("xmm1"); String copyuserpass = request.getParameter("xmm2"); HashMap m = dao.getmaps("yonghuming", (String) request.getSession().getAttribute("username"), "yonghuzhuce"); if (!(((String) m.get("mima")).equals(olduserpass))) { request.setAttribute("error", ""); go("mod2.jsp", request, response); } else { //String id = (String)user.get("id"); String sql = "update yonghuzhuce set mima='" + userpass + "' where yonghuming='" + (String) request.getSession().getAttribute("username") + "'"; dao.commOper(sql); request.setAttribute("suc", ""); go("mod2.jsp", request, response); } } //修改密码 if (ac.equals("adminuppass")) { String olduserpass = request.getParameter("ymm"); String userpass = request.getParameter("xmm1"); String copyuserpass = request.getParameter("xmm2"); //println(Info.getUser(request).get("id").toString()); HashMap m = dao.getmaps("username", (String) request.getSession().getAttribute("username"), "allusers"); if (!(((String) m.get("pwd")).equals(olduserpass))) { request.setAttribute("error", ""); go("mod.jsp", request, response); } else { //String id = (String)user.get("id"); String sql = "update allusers set pwd='" + userpass + "' where username='" + (String) request.getSession().getAttribute("username") + "'"; dao.commOper(sql); request.setAttribute("suc", ""); go("mod.jsp", request, response); } } if (ac.equals("uploaddoc")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploaddoc.jsp?docname=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploaddoc2")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploaddoc2.jsp?docname=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploaddoc3")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploaddoc3.jsp?docname=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } //导excel if (ac.equals("importexcel")) { String page = request.getParameter("page"); String whzdstr = request.getParameter("whzdstr"); String tablename = request.getParameter("tablename"); try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } if (filename.indexOf(".xls") > -1) { Workbook workbook; try { workbook = Workbook.getWorkbook(new File(request.getRealPath("/upfile/") + "/" + filename)); //通过Workbook的getSheet方法选择第一个工作簿(从0开始) Sheet sheet = workbook.getSheet(0); //通过Sheet方法的getCell方法选择位置为C2的单元格(两个参数都从0开始) //int empty = 0; for (int i = 1; i < 1000; i++) { Cell cell = null; try { String isql = "insert into " + tablename + "("; for (String str : whzdstr.split("-")) { isql += str + ","; } isql = isql.substring(0, isql.length() - 1); isql += ")values("; int j = 0; int empty = 1; for (String str : whzdstr.split("-")) { cell = sheet.getCell(j, i); isql += "'" + cell.getContents() + "',"; String content = cell.getContents() == null ? "" : cell.getContents(); if (!"".equals(content.trim())) { empty = 0; } j++; } if (empty == 1) continue; isql = isql.substring(0, isql.length() - 1); isql += ")"; dao.commOper(isql); } catch (Exception e) { continue; } } workbook.close(); } catch (Exception e) { e.printStackTrace(); } } } go("/admin/" + page + "?docname=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploadimg")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploadimg.jsp?filename=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploadimg2")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploadimg2.jsp?filename=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploadimg3")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploadimg3.jsp?filename=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploadimg4")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploadimg4.jsp?filename=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploadimg5")) { try { String filename = ""; request.setCharacterEncoding("gb2312"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } go("/js/uploadimg5.jsp?filename=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } dao.close(); out.flush(); out.close(); } public void init() throws ServletException { // Put your code here } }