基于javaweb和mysql的ssm公开课记录管理系统(java+ssm+html+javascript+jsp+mysql)
基于javaweb和mysql的ssm公开课记录管理系统(java+ssm+html+javascript+jsp+mysql)
私信源码获取及调试交流
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SSM公开课记录管理系统(java+ssm+html+javascript+jsp+mysql)
项目介绍
管理员: 登录,修改个人资料,用户管理,公告管理,教室管理,科目管理,听课记录管理等功能。
用户角色包含以下功能: 用户登录,修改个人资料,查看公告,查看听课记录等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,http://localhost:8080/shop/index
List<Coursecomment>list=coursecommentService.queryAll(course);course=list.get(0);JSONObjectjson=newJSONObject();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);List<Role>list=depotService.QueryAll(depot);Rolerole1=list.get(0);Powerpower1=powerService.selectByPrimaryKey(role1.getPowerid());Stringname=role1.getRolename();role1.setPowerid(power1.getPower());Stringdata=json.toJSONString(role1);returndata;@ResponseBody@RequestMapping("/getAll")publicStringgetAll(Rolerole){JSONObjectjson=newJSONObject();curelation.setCourseid(course.getId());List<Curelation>curelationList=curelationService.queryAll(curelation);if(curelationList.size()==0){curelation.setId(String.valueOf(Math.random()).substring(2,10));curelation.setType("1");curelationService.insert(curelation);}else{Curelationcurelation1=curelationList.get(0);curelation1.setUserid(user.getId());curelation1.setCourseid(course.getId());System.out.println(curelation1.toString());curelationService.updateByPrimaryKey(curelation1);@AutowiredprivateNoticeServicenoticeService;@RequestMapping("/Main")publicStringres(HttpServletRequestrequest){Stringtime=DateUtil.getStringToday();request.getSession().setAttribute("time",time);Noticenotice=newNotice();List<Notice>list=noticeService.queryAll(notice);notice=list.get(0);Useruser=userService.selectByPrimaryKey(notice.getUserid());notice.setUserid(user.getName());List<Role>list=depotService.QueryAll(depot);Rolerole1=list.get(0);Powerpower1=powerService.selectByPrimaryKey(role1.getPowerid());Stringname=role1.getRolename();role1.setPowerid(power1.getPower());Stringdata=json.toJSONString(role1);returndata;@ResponseBody@RequestMapping("/getAll")publicStringgetAll(Rolerole){JSONObjectjson=newJSONObject();List<Role>list=depotService.QueryAll(role);Stringtime=DateUtil.getStringToday();request.getSession().setAttribute("time",time);request.getSession().setAttribute("user",user1);mav.setViewName("redirect:/User/Main");returnmav;@RequestMapping("/updateStudent")publicStringupdate(Useruser){userService.updateByPrimaryKey(user);return"redirect:/User/student";@RequestMapping("/updateTeacher")publicStringupdatet(Useruser){e.printStackTrace();return"redirect:/Course/queryCourse";@RequestMapping("/queryCourse")publicStringqueryScore(HttpServletRequestrequest,Curelationcurelation){curelation.setType("1");List<Curelation>list=curelationService.queryAll(curelation);request.setAttribute("list",list);return"ScoreList";@RequestMapping("/teacher")publicStringteacher(HttpServletRequestrequest){Useruser=(User)request.getSession().getAttribute("user");Coursecourse=newCourse();course.setCourseteacher(user.getName());List<Course>courseList=courseService.queryAll(course);publicclassUserController{@AutowiredprivateUserServiceuserService;@AutowiredprivatePowerServicepowerService;@AutowiredprivateRoleServiceroleService;@AutowiredprivateNoticeServicenoticeService;@RequestMapping("/Main")publicStringres(HttpServletRequestrequest){Stringtime=DateUtil.getStringToday();request.getSession().setAttribute("time",time);}else{Curelationcurelation1=curelationList.get(0);curelation1.setUserid(user.getId());curelation1.setCourseid(course.getId());System.out.println(curelation1.toString());curelationService.updateByPrimaryKey(curelation1);return"redirect:/Course/student";@ResponseBody@RequestMapping("/queryOne")publicStringqueryOne(StringID){Coursecourse=newCourse();course.setId(ID);publicStringaddStudent(Useruser){StringpassWord="123456";user.setPassword(passWord);user.setType(Constans.STUDENT);userService.insert(user);return"redirect:/User/student";@ResponseBody@RequestMapping("/queryOne")publicStringqueryOne(StringID){Useruser=newUser();user.setId(ID);List<User>list=userService.QueryAll(user);user=list.get(0);if(null!=role.getRolename()){request.setAttribute("rolename",role.getRolename());return"Role";@RequestMapping("/add")publicStringadd(Stringroleid,Stringrolename,StringpowerContent){Powerpower1=newPower();Rolerole=newRole();Stringpowerid=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);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());request.getSession().setAttribute("power",power.getPower());Stringtime=DateUtil.getStringToday();request.getSession().setAttribute("time",time);request.getSession().setAttribute("user",user1);mav.setViewName("redirect:/User/Main");returnmav;@RequestMapping("/updateStudent")publicStringupdate(Useruser){userService.updateByPrimaryKey(user);return"redirect:/User/student";@RequestMapping("/updateTeacher")publicStringupdatet(Useruser){userService.updateByPrimaryKey(user);curelation.setCourseid(course.getId());List<Curelation>curelationList=curelationService.queryAll(curelation);if(curelationList.size()==0){curelation.setId(String.valueOf(Math.random()).substring(2,10));curelation.setType("1");curelationService.insert(curelation);}else{Curelationcurelation1=curelationList.get(0);curelation1.setUserid(user.getId());curelation1.setCourseid(course.getId());System.out.println(curelation1.toString());course.setStatus("1");List<Course>courseList=courseService.queryAll(course);request.setAttribute("list",courseList);return"studentChoose";@RequestMapping("/upload")publicStringupload(){return"uploadScore";@RequestMapping("/Export")publicvoidExport(HttpServletResponseresponse,Useruser){response.setContentType("application/binary;charset=UTF-8");try{publicStringreceive(HttpServletRequestrequest,HttpServletResponseresponse,MultipartFilefile){try{//也可以用request获取上传文件//MultipartFile fileFile = request.getFile("file"); //这里是页面的name属性//转换成输入流InputStreamis=file.getInputStream();//得到excelWorkbookworkbook=Workbook.getWorkbook(is);//得到sheetSheetsheet=workbook.getSheet(0);//得到列数intcolsNum=sheet.getColumns();//得到行数Powerpower=powerService.selectByPrimaryKey(role.getPowerid());if(!StringUtil.isNullOrEmpty(power.getPower())){request.getSession().setAttribute("power",power.getPower());Stringtime=DateUtil.getStringToday();request.getSession().setAttribute("time",time);request.getSession().setAttribute("user",user1);mav.setViewName("redirect:/User/Main");returnmav;@RequestMapping("/updateStudent")publicStringupdate(Useruser){userService.updateByPrimaryKey(user);