Java实战之课程信息管理系统的实现

@Controller @RequestMapping("/User") public class UserController { @Autowired private UserService userService; @Autowired private PowerService powerService; @Autowired private RoleService roleService; @Autowired private NoticeService noticeService; @RequestMapping("/Main") public String res(HttpServletRequest request){ String time = DateUtil.getStringToday(); request.getSession().setAttribute("time", time); Notice notice = new Notice(); List list = noticeService.queryAll(notice); notice = list.get(0); User user = userService.selectByPrimaryKey(notice.getUserid()); notice.setUserid(user.getName()); request.getSession().setAttribute("notice", notice); return "Main"; } @RequestMapping("/changePa") public String res1(){ return "changePass"; } @RequestMapping("/Login") public ModelAndView login(HttpServletRequest request,String id,String password) throws Exception{ ModelAndView mav = new ModelAndView(); User user1 = userService.selectByPrimaryKey(id); if(user1 == null || !password.equals(user1.getPassword())){ mav.setViewName("index"); request.getSession().setAttribute("info", "error"); return mav; }else{ Role role = new Role(); role.setRoleid(user1.getRoleid()); List list =roleService.QueryAll(role); role =list.get(0); request.getSession().setAttribute("roleName", role.getRolename()); Power power = powerService.selectByPrimaryKey(role.getPowerid()); if(!StringUtil.isNullOrEmpty(power.getPower())){ request.getSession().setAttribute("power", power.getPower()); } String time = DateUtil.getStringToday(); request.getSession().setAttribute("time", time); request.getSession().setAttribute("user", user1); mav.setViewName("redirect:/User/Main"); } return mav; } @RequestMapping("/updateStudent") public String update(User user){ userService.updateByPrimaryKey(user); return "redirect:/User/student"; } @RequestMapping("/updateTeacher") public String updatet(User user){ userService.updateByPrimaryKey(user); return "redirect:/User/teacher"; } @RequestMapping("/updatePa") public String updatePa(String userID,String password){ User user = new User(); System.out.println(userID); User user1 = userService.selectByPrimaryKey(userID); user1.setPassword(password); userService.updateByPrimaryKey(user1); return "Main"; } @RequestMapping("/delete") public String delete(String ID){ userService.deleteByPrimaryKey(ID); return "redirect:/User/queryAll"; } @RequestMapping("/teacher") public String QueryAllTeacher(HttpServletRequest request,User user){ List list = userService.QueryAllTeacher(user); request.setAttribute("list", list); if(null != user.getName()){ request.setAttribute("name", user.getName()); } if(null != user.getMobile()){ request.setAttribute("mobile", user.getMobile()); } return "teacher"; } @ResponseBody @RequestMapping("/jsonteacher") public String QueryAllTeacherjson(HttpServletRequest request,User user){ List list = userService.QueryAllTeacher(user); JSONObject json = new JSONObject(); return json.toJSONString(list); } @RequestMapping("/student") public String QueryAllStudent(HttpServletRequest request,User user){ List list = userService.QueryAllStudent(user); request.setAttribute("list", list); if(null != user.getName()){ request.setAttribute("name", user.getName()); } if(null != user.getMobile()){ request.setAttribute("mobile", user.getMobile()); } return "student"; } @RequestMapping("/addteacher") public String  addUser(User user){ String passWord = "123456"; user.setPassword(passWord); user.setType(Constans.TEACHER); userService.insert(user); return "redirect:/User/teacher"; } @RequestMapping("/addstudent") public String  addStudent(User user){ String passWord = "123456"; user.setPassword(passWord); user.setType(Constans.STUDENT); userService.insert(user); return "redirect:/User/student"; } @ResponseBody @RequestMapping("/queryOne") public String queryOne(String ID){ User user = new User(); user.setId(ID); List list = userService.QueryAll(user); user = list.get(0); JSONObject json = new JSONObject(); String data = json.toJSONString(user); return data; } @RequestMapping("/quit") public ModelAndView quit(HttpServletRequest request) throws Exception{ ModelAndView mav = new ModelAndView(); HttpSession session1 = request.getSession(); session1.invalidate(); request.getSession().setAttribute("info", "quit"); mav.setViewName("index"); return mav; } }

@Controller @RequestMapping("/Course") public class CourseController { @Autowired private CourseService courseService; @Autowired private CurelationService curelationService; @Autowired private CoursecommentService coursecommentService; @ResponseBody @RequestMapping("/queryOneCom") public String queryOneCom(String ID){ Coursecomment course = new Coursecomment(); course.setId(ID); System.out.println("===================================="+ID); List list = coursecommentService.queryAll(course); course = list.get(0); JSONObject json = new JSONObject(); return json.toJSONString(course); } @RequestMapping("addComment") public String addComment(HttpServletRequest request, Coursecomment coursecomment){ User user = (User) request.getSession().getAttribute("user"); coursecomment.setCreatetime(DateUtil.getStringToday()); coursecomment.setUserid(user.getName()); coursecomment.setId(String.valueOf(Math.random()).substring(2,10)); coursecommentService.insert(coursecomment); return "redirect:/Course/suggeetion"; } @ResponseBody @RequestMapping("jsoncourse") public String jsoncourse(HttpServletRequest request, Curelation course){ User user = (User) request.getSession().getAttribute("user"); /*String type = "1"; if ("1".equals(user.getType())){ type="2"; } course.setType(type); course.setUserid(user.getId());*/ List curelationList = curelationService.queryAll(course); List dataList = new ArrayList<>(); for (int i = 0; i  coursecomments = coursecommentService.queryAll(coursecomment); request.setAttribute("list",coursecomments); return "suggeetion"; } @RequestMapping("view") public String view(HttpServletRequest request){ User user = (User) request.getSession().getAttribute("user"); String type = "1"; if ("1".equals(user.getType())){ type="2"; } List> list=curelationService.courseview(type,user.getId()); request.setAttribute("list",list); return "courseview"; } @RequestMapping("deletecomment") public String deletecomment(String ID){ coursecommentService.deleteByPrimaryKey(ID); return "redirect:/Course/suggeetion"; } @RequestMapping("queryAll") public String queryAll(HttpServletRequest request, Course course){ List list = courseService.queryAll(course); request.setAttribute("list",list); return "course"; } @RequestMapping("/receive") public String receive(HttpServletRequest request, HttpServletResponse response, MultipartFile file){ try { //也可以用request获取上传文件 //MultipartFile  fileFile = request.getFile("file"); //这里是页面的name属性 //转换成输入流 InputStream is = file.getInputStream(); //得到excel Workbook workbook = Workbook.getWorkbook(is); //得到sheet Sheet sheet = workbook.getSheet(0); //得到列数 int colsNum = sheet.getColumns(); //得到行数 int rowsNum = sheet.getRows(); //单元格 Cell cell; Cell cell1; List

@Controller @RequestMapping("/Notice") public class NoticeController { @Autowired private NoticeService noticeService; @RequestMapping("/add") public String toAdd(){ return "NoticeAdd"; } @RequestMapping("/modify") public String modify(HttpServletRequest request,Notice notice){ List noticeList = noticeService.queryAll(notice); request.setAttribute("list",noticeList); return "noticeModfiy"; } @RequestMapping("/update") public String update(HttpServletRequest request,Notice notice){ User user = (User) request.getSession().getAttribute("user"); notice.setUserid(user.getId()); notice.setCreatdate(DateUtil.getStringToday()); noticeService.update(notice); return "redirect:/Notice/modify"; } @RequestMapping("/delete") public String delete(HttpServletRequest request,Notice notice){ List noticeList = noticeService.queryAll(notice); request.setAttribute("list",noticeList); return "noticeDelete"; } @RequestMapping("/delete1") public String delete1(String ID){ noticeService.delete(ID); return "redirect:/Notice/delete"; } @ResponseBody @RequestMapping("/queryOne") public String queryOne(String id){ System.out.println("=================="+id); Notice notice = new Notice(); notice.setId(id); List noticeList = noticeService.queryAll(notice); JSONObject json = new JSONObject(); return json.toJSONString(noticeList.get(0)); } @RequestMapping("/add1") public String  add(HttpServletRequest request,String Content,String biaoti) throws Exception{ User user = (User) request.getSession().getAttribute("user"); Notice notice = new Notice(); notice.setContent(Content); notice.setTitle(biaoti); notice.setCreatdate(DateUtil.Date2String(new Date())); notice.setId(String.valueOf(Math.random()).substring(2, 8)); notice.setUserid(user.getId()); noticeService.add(notice); return "redirect:/User/Main"; } }

@Controller @RequestMapping("/Role") public class RoleController { @Autowired private RoleService depotService; @Autowired private PowerService powerService; @RequestMapping("/update") public String update(String id,String rolename,String powerContent){ Role role = new Role(); role.setRoleid(id); role.setRolename(rolename); depotService.update(role); List list = depotService.QueryAll(role); Role role1 = list.get(0); Power power = new Power(); if(powerContent.indexOf("110") != -1){ powerContent = powerContent + ",1100"; } if(powerContent.indexOf("120") != -1){ powerContent = powerContent + ",1200"; } if(powerContent.indexOf("130") != -1){ powerContent = powerContent + ",1300"; } if(powerContent.indexOf("140") != -1){ powerContent = powerContent + ",1400"; } if(powerContent.indexOf("150") != -1){ powerContent = powerContent + ",1500"; } power.setPower(powerContent); power.setRoleid(role1.getPowerid()); powerService.update(power); return "redirect:/Role/queryAll"; } @RequestMapping("/delete") public String delete(String ID){ depotService.deleteByPrimaryKey(ID); return "redirect:/Role/queryAll"; } @RequestMapping("/queryAll") public String queryAll(HttpServletRequest request,Role role){ List list = depotService.QueryAll(role); request.setAttribute("list", list); if(null != role.getRolename()){ request.setAttribute("rolename", role.getRolename()); } return "Role"; } @RequestMapping("/add") public String  add(String roleid,String rolename,String powerContent){ Power power1 = new Power(); Role role = new Role(); String powerid = String.valueOf(Math.random()).substring(2, 8); role.setRoleid(String.valueOf(Math.random()).substring(2, 6)); role.setPowerid(powerid); role.setRolename(rolename); power1.setPower(powerContent); power1.setRoleid(powerid); power1.setId(String.valueOf(Math.random()).substring(2, 8)); powerService.insert(power1); depotService.insert(role); return "redirect:/Role/queryAll"; } @ResponseBody @RequestMapping("/queryOne") public String queryOne(String ID){ JSONObject json = new JSONObject(); Role depot = new Role(); Power power = new Power(); power.setId(ID); System.out.println(ID); depot.setRoleid(ID); List list = depotService.QueryAll(depot); Role role1 = list.get(0); Power power1 = powerService.selectByPrimaryKey(role1.getPowerid()); String name = role1.getRolename(); role1.setPowerid(power1.getPower()); String data = json.toJSONString(role1); return data; } @ResponseBody @RequestMapping("/getAll") public String getAll(Role role){ JSONObject json = new JSONObject(); List list = depotService.QueryAll(role); String jsonq = json.toJSONString(list); System.out.println(jsonq); return jsonq; } }