大学生毕业设计管理系统

package com.web.controller.servlet; import java.io.IOException; import java.sql.SQLException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.web.controller.dao.impl.UserDaoImpl; import com.web.controller.dao.UserDao; import com.web.controller.entity.Page; import com.web.controller.entity.Project; import com.web.controller.entity.Student; import com.web.controller.entity.User; public class UserServlet extends HttpServlet { private static UserDaoImpl uDao = null; static { uDao = new UserDaoImpl(); } /** * request:用户的请求信息 response:响应用户的请求 */ @Override public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { super.service(request, response); } @Override public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } @Override public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); // flag标示，从页面接收flag对应的值下面用来比对进行什么样的操作 String flag = request.getParameter("flag"); /** * 添加数据操作 */ if ("add".equals(flag)) { User user = new User(); user.setUserName(request.getParameter("userName")); user.setPassWord(request.getParameter("passWord")); user.setStu_name(request.getParameter("stu_name")); user.setStu_sex (request.getParameter("stu_sex")); user.setStu_college(request.getParameter("stu_college")); System.out.println(request.getParameter("userName")); System.out.println(request.getParameter("passWord")); try { int num = uDao.addUser(user); if (num == 1) { System.out.print("插入成功"); response.sendRedirect("userServlet?flag=list"); } else { System.out.print("插入失败" ); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /* * 查询所有的数据项 */ if ("list".equals(flag)) { Page page = new Page(); try { List<User> list = uDao.findAll(); int listSize = list.size(); // System.out.println(listSize); if (listSize == 0) { System.out.println("查询无结果"); } else { if (listSize < 12) { page.setPageSize(listSize); } else { page.setPageSize(12); } page.setTotalRecord(list.size()); page.setTotalPage(list.size(), page.getPageSize()); int currentRecorde = 0; // 计算并设置分页的参数 if (request.getParameter("currentRecord") != null) { currentRecorde = Integer.parseInt(request .getParameter("currentRecord")); page.setCurrentRecord(currentRecorde); page.setCurrentPage(currentRecorde, page.getPageSize()); } // 从结果集中取出当前页面要显示的子集 List<User> subResult = null; if (currentRecorde == 0) { subResult = list.subList(0, page.getPageSize()); } if (page.getCurrentRecord() + page.getPageSize() < list .size()) subResult = list.subList(page.getCurrentRecord(), page.getCurrentRecord() + page.getPageSize()); else { subResult = list.subList(page.getCurrentRecord(), list.size()); } request.setAttribute("subResult", subResult); request.setAttribute("page", page); request.getRequestDispatcher( "pages/files/showAllStudent.jsp").forward(request, response); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } /* * 查询所有的数据项 */ if ("listAll".equals(flag)) { Page page = new Page(); try { List<User> list = uDao.getListAll(); int listSize = list.size(); // System.out.println(listSize); if (listSize == 0) { System.out.println("查询无结果"); } else { if (listSize < 12) { page.setPageSize(listSize); } else { page.setPageSize(12); } page.setTotalRecord(list.size()); page.setTotalPage(list.size(), page.getPageSize()); int currentRecorde = 0; // 计算并设置分页的参数 if (request.getParameter("currentRecord") != null) { currentRecorde = Integer.parseInt(request .getParameter("currentRecord")); page.setCurrentRecord(currentRecorde); page.setCurrentPage(currentRecorde, page.getPageSize()); } // 从结果集中取出当前页面要显示的子集 List<User> subResult = null; if (currentRecorde == 0) { subResult = list.subList(0, page.getPageSize()); } if (page.getCurrentRecord() + page.getPageSize() < list .size()) subResult = list.subList(page.getCurrentRecord(), page.getCurrentRecord() + page.getPageSize()); else { subResult = list.subList(page.getCurrentRecord(), list.size()); } request.setAttribute("subResult", subResult); request.setAttribute("page", page); request.getRequestDispatcher( "pages/files/main.jsp").forward(request, response); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } /* * 更新操作 */ if ("update".equals(flag)) { User user = new User(); user.setUserName(request.getParameter("userName")); user.setPassWord(request.getParameter("passWord")); System.out.println("更改密码"); try { int num = uDao.update(user); System.out.println(num); if (num > 0) { response.sendRedirect("userServlet?flag=list"); System.out.println("更新"); } } catch (SQLException e) { // TODO Auto-generated catch block System.out.print("修改出错"); e.printStackTrace(); } } /* * 更新操作 */ if ("updateuser".equals(flag)) { User user = new User(); user.setUserName(request.getParameter("userName")); user.setStu_name(request.getParameter("stu_name")); user.setStu_sex(request.getParameter("stu_sex")); user.setStu_college(request.getParameter("stu_college")); System.out.println(request.getParameter("stu_name")); try { int num = uDao.updateuser(user); System.out.println(num); if (num > 0) { response.sendRedirect("userServlet?flag=list"); System.out.println("更新"); } } catch (SQLException e) { // TODO Auto-generated catch block System.out.print("修改出错"); e.printStackTrace(); } } /* * 通过id查询详情 */ if ("listbyusername".equals(flag)) { User user = null; String num = request.getParameter("userName"); System.out.println("根据ID修改"); try { user = uDao.getUserByUsername(num); request.setAttribute("user", user); request.getRequestDispatcher("pages/files/setPassword.jsp") .forward(request, response); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } /* * 通过id查询详情 */ if ("listbynum".equals(flag)) { User user = null; String num =request.getParameter("userName"); System.out.println(" listbynum 根据ID修改"); try { user = uDao.getUserByUsername(num); request.setAttribute("user", user); request.getRequestDispatcher("pages/files/setStudent.jsp") .forward(request, response); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } /* * 通过用户名来查询用