基于javaweb和mysql的ssm公开课记录管理系统(javassmhtmljavascriptjspmysql)私信源码获取及调试交流私信源码获取及调试交流运行环境Java≥8、MySQL≥5.7、Tomcat≥8开发工具eclipse/idea/myeclipse/sts等均可配置运行适用课程设计大作业毕业设计项目练习学习演示等功能说明基于javaweb的SSM公开课记录管理系统(javassmhtmljavascriptjspmysql)项目介绍管理员 登录,修改个人资料,用户管理,公告管理,教室管理,科目管理,听课记录管理等功能。用户角色包含以下功能 用户登录,修改个人资料,查看公告,查看听课记录等功能。环境需要1.运行环境最好是java jdk 1.8我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境IDEAEclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境Tomcat 7.x,8.x,9.x版本均可 4.硬件环境windows 7/8/10 1G内存以上或者 Mac OS 5.数据库MySql 5.7版本技术栈后端SpringSpringMVCMybatis 2. 前端HTMLCSSJavaScriptjsp使用说明使用Navicat或者其它工具在mysql中创建对应名称的数据库并导入项目的sql文件 2. 使用IDEA/Eclipse/MyEclipse导入项目Eclipse/MyEclipse导入时若为maven项目请选择maven;若为maven项目导入成功后请执行maven clean;maven install命令然后运行 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目http://localhost:8080/shop/indexListCoursecommentlistcoursecommentService.queryAll(course);courselist.get(0);JSONObjectjsonnewJSONObject();returnjson.toJSONString(course);RequestMapping(addComment)publicStringaddComment(HttpServletRequestrequest,Coursecommentcoursecomment){Useruser(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);depot.setRoleid(ID);ListRolelistdepotService.QueryAll(depot);Rolerole1list.get(0);Powerpower1powerService.selectByPrimaryKey(role1.getPowerid());Stringnamerole1.getRolename();role1.setPowerid(power1.getPower());Stringdatajson.toJSONString(role1);returndata;ResponseBodyRequestMapping(/getAll)publicStringgetAll(Rolerole){JSONObjectjsonnewJSONObject();curelation.setCourseid(course.getId());ListCurelationcurelationListcurelationService.queryAll(curelation);if(curelationList.size()0){curelation.setId(String.valueOf(Math.random()).substring(2,10));curelation.setType(1);curelationService.insert(curelation);}else{Curelationcurelation1curelationList.get(0);curelation1.setUserid(user.getId());curelation1.setCourseid(course.getId());System.out.println(curelation1.toString());curelationService.updateByPrimaryKey(curelation1);AutowiredprivateNoticeServicenoticeService;RequestMapping(/Main)publicStringres(HttpServletRequestrequest){StringtimeDateUtil.getStringToday();request.getSession().setAttribute(time,time);NoticenoticenewNotice();ListNoticelistnoticeService.queryAll(notice);noticelist.get(0);UseruseruserService.selectByPrimaryKey(notice.getUserid());notice.setUserid(user.getName());ListRolelistdepotService.QueryAll(depot);Rolerole1list.get(0);Powerpower1powerService.selectByPrimaryKey(role1.getPowerid());Stringnamerole1.getRolename();role1.setPowerid(power1.getPower());Stringdatajson.toJSONString(role1);returndata;ResponseBodyRequestMapping(/getAll)publicStringgetAll(Rolerole){JSONObjectjsonnewJSONObject();ListRolelistdepotService.QueryAll(role);StringtimeDateUtil.getStringToday();request.getSession().setAttribute(time,time);request.getSession().setAttribute(user,user1);mav.setViewName(redirect:/User/Main);returnmav;RequestMapping(/updateStudent)publicStringupdate(Useruser){userService.updateByPrimaryKey(user);returnredirect:/User/student;RequestMapping(/updateTeacher)publicStringupdatet(Useruser){e.printStackTrace();returnredirect:/Course/queryCourse;RequestMapping(/queryCourse)publicStringqueryScore(HttpServletRequestrequest,Curelationcurelation){curelation.setType(1);ListCurelationlistcurelationService.queryAll(curelation);request.setAttribute(list,list);returnScoreList;RequestMapping(/teacher)publicStringteacher(HttpServletRequestrequest){Useruser(User)request.getSession().getAttribute(user);CoursecoursenewCourse();course.setCourseteacher(user.getName());ListCoursecourseListcourseService.queryAll(course);publicclassUserController{AutowiredprivateUserServiceuserService;AutowiredprivatePowerServicepowerService;AutowiredprivateRoleServiceroleService;AutowiredprivateNoticeServicenoticeService;RequestMapping(/Main)publicStringres(HttpServletRequestrequest){StringtimeDateUtil.getStringToday();request.getSession().setAttribute(time,time);}else{Curelationcurelation1curelationList.get(0);curelation1.setUserid(user.getId());curelation1.setCourseid(course.getId());System.out.println(curelation1.toString());curelationService.updateByPrimaryKey(curelation1);returnredirect:/Course/student;ResponseBodyRequestMapping(/queryOne)publicStringqueryOne(StringID){CoursecoursenewCourse();course.setId(ID);publicStringaddStudent(Useruser){StringpassWord123456;user.setPassword(passWord);user.setType(Constans.STUDENT);userService.insert(user);returnredirect:/User/student;ResponseBodyRequestMapping(/queryOne)publicStringqueryOne(StringID){UserusernewUser();user.setId(ID);ListUserlistuserService.QueryAll(user);userlist.get(0);if(null!role.getRolename()){request.setAttribute(rolename,role.getRolename());returnRole;RequestMapping(/add)publicStringadd(Stringroleid,Stringrolename,StringpowerContent){Powerpower1newPower();RolerolenewRole();StringpoweridString.valueOf(Math.random()).substring(2,8);role.setRoleid(String.valueOf(Math.random()).substring(2,6));role.setPowerid(powerid);role.setRolename(rolename);power1.setPower(powerContent);if(powerContent.indexOf(120)!-1){powerContentpowerContent,1200;if(powerContent.indexOf(130)!-1){powerContentpowerContent,1300;if(powerContent.indexOf(140)!-1){powerContentpowerContent,1400;if(powerContent.indexOf(150)!-1){powerContentpowerContent,1500;power.setPower(powerContent);power.setRoleid(role1.getPowerid());request.getSession().setAttribute(power,power.getPower());StringtimeDateUtil.getStringToday();request.getSession().setAttribute(time,time);request.getSession().setAttribute(user,user1);mav.setViewName(redirect:/User/Main);returnmav;RequestMapping(/updateStudent)publicStringupdate(Useruser){userService.updateByPrimaryKey(user);returnredirect:/User/student;RequestMapping(/updateTeacher)publicStringupdatet(Useruser){userService.updateByPrimaryKey(user);curelation.setCourseid(course.getId());ListCurelationcurelationListcurelationService.queryAll(curelation);if(curelationList.size()0){curelation.setId(String.valueOf(Math.random()).substring(2,10));curelation.setType(1);curelationService.insert(curelation);}else{Curelationcurelation1curelationList.get(0);curelation1.setUserid(user.getId());curelation1.setCourseid(course.getId());System.out.println(curelation1.toString());course.setStatus(1);ListCoursecourseListcourseService.queryAll(course);request.setAttribute(list,courseList);returnstudentChoose;RequestMapping(/upload)publicStringupload(){returnuploadScore;RequestMapping(/Export)publicvoidExport(HttpServletResponseresponse,Useruser){response.setContentType(application/binary;charsetUTF-8);try{publicStringreceive(HttpServletRequestrequest,HttpServletResponseresponse,MultipartFilefile){try{//也可以用request获取上传文件//MultipartFile fileFile request.getFile(file); //这里是页面的name属性//转换成输入流InputStreamisfile.getInputStream();//得到excelWorkbookworkbookWorkbook.getWorkbook(is);//得到sheetSheetsheetworkbook.getSheet(0);//得到列数intcolsNumsheet.getColumns();//得到行数PowerpowerpowerService.selectByPrimaryKey(role.getPowerid());if(!StringUtil.isNullOrEmpty(power.getPower())){request.getSession().setAttribute(power,power.getPower());StringtimeDateUtil.getStringToday();request.getSession().setAttribute(time,time);request.getSession().setAttribute(user,user1);mav.setViewName(redirect:/User/Main);returnmav;RequestMapping(/updateStudent)publicStringupdate(Useruser){userService.updateByPrimaryKey(user);