在线java课程培训,java 在线教程

一、前言

项目介绍

采用跳趾春蝠实现的在线学习系统，一共2个身份。

　　管理员登录系统后可以管理所有用户信息，管理角色信息，添加修改管理课件信息，学生学习培训批次管理，成绩导入管理

　　学生登录系统后可以查询自己的个人信息，查询课件列表学习，查询我的培训记录，查询自己的成绩

　　采用跳羚框架实现前台模板用的百里香叶数据库层采用框架框架注解模式

　　上传文件夹放入D盘根目录！

项目运行

登录地址：http://本地主机：8080/th/登录

　　管理员账号和密码：管理管理

　　学生登录账号： 1314 密码： 123456

二、效果图展示

三、核心代码

用户管理控制层

@控制器@请求映射(/用户)公共类用户控制器{ @ Autowiredprivate UserService UserService；@ Autowiredprivate power service电力服务；@ Autowiredprivate RoleService RoleService；@ autowired私信通知服务；@ request mapping(/Main )public String RES(http servlet请求request){ String time=date util。getstring today()；request.getSession().setAttribute(time ，time)；通知通知=新通知();列表通知列表=通知服务。查询全部(通知)；通知=列表。get(0)；用户用户=用户服务。selectbyprimarykey(注意。get userid())；注意。设置userid(用户。getname())；request.getSession().setAttribute(notice ，通知);返回“主”；} @RequestMapping(/changePa )公共字符串res1(){ return change pass ；} @请求映射(/log in )公共模型和查看登录(http servlet请求，字符串id，字符串密码)抛出异常{ modeland view MAV=new modeland view()；用户用户1=用户服务。selectbyprimarykey(id)；if(user1==null ！密码。等于(用户1。get password()){ MAV。设置viewname(“index”)；request.getSession().设置属性(" info "、" error ")；回归MAV } else { Role Role=new Role()；角色。设置roleid(用户1。getroleid())；ListRole list=roleService .查询所有(角色);角色=列表。get(0)；request.getSession().setAttribute(roleName ，role。get roleName())；电力电力=电力服务。selectbyprimarykey(角色。getpowerid())；如果(!线

　　Util.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<User> 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<User> list = userService.QueryAllTeacher(user);JSONObject json = new JSONObject(); return json.toJSONString(list);} @RequestMapping("/student")public String QueryAllStudent(HttpServletRequest request,User user){ List<User> 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<User> 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("/Role")public class RoleController { @Autowiredprivate RoleService depotService; @Autowiredprivate 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<Role> 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<Role> 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<Role> 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<Role> list = depotService.QueryAll(role); String jsonq = json.toJSONString(list); System.out.println(jsonq);return jsonq;} }

课程管理控制层

@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<Coursecomment> 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<Curelation> curelationList = curelationService.queryAll(course); List<Course> dataList = new ArrayList<>(); for (int i = 0; i < curelationList.size(); i++) { Course curelation = courseService.selectByPrimaryKey(curelationList.get(i).getCourseid()); dataList.add(curelation); } JSONObject json = new JSONObject(); return json.toJSONString(dataList); } @RequestMapping("suggeetion") public String suggeetion(HttpServletRequest request, Coursecomment coursecomment){ List<Coursecomment> 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<Map<String,String>> 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<Course> 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<Map> list = new ArrayList<>(); Map<Integer, String> map = new HashMap<Integer, String>(); for (int i = 1; i < rowsNum; i++) {//我的excel第一行是标题,所以 i从1开始 cell = sheet.getCell(0,i); cell1 = sheet.getCell(5,i); Curelation curelation = new Curelation(); curelation.setId(cell.getContents()); curelation.setScore(cell1.getContents()); curelationService.updateByPrimaryKey(curelation); } } catch (IOException e) { e.printStackTrace(); } catch (BiffException e) { e.printStackTrace(); } return "redirect:/Course/queryCourse"; } @RequestMapping("/queryCourse") public String queryScore(HttpServletRequest request,Curelation curelation){ curelation.setType("1"); List<Curelation> list = curelationService.queryAll(curelation); request.setAttribute("list",list ); return "ScoreList"; } @RequestMapping("/teacher") public String teacher(HttpServletRequest request){ User user = (User) request.getSession().getAttribute("user"); Course course = new Course(); course.setCourseteacher(user.getName()); List<Course> courseList = courseService.queryAll(course); request.setAttribute("list",courseList); return "teacherDeal"; } @RequestMapping("/student") public String student(HttpServletRequest request){ Course course = new Course(); course.setStatus("1"); List<Course> courseList = courseService.queryAll(course); request.setAttribute("list",courseList); return "studentChoose"; } @RequestMapping("/upload") public String upload(){ return "uploadScore"; } @RequestMapping("/Export") public void Export(HttpServletResponse response, User user){ response.setContentType("application/binary;charset=UTF-8"); try { ServletOutputStream out = response.getOutputStream(); String fileName1 = "学生信息"; String fileName2 = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date()); String fileName = fileName1+fileName2; response.setHeader("Content-disposition", "attachment; filename=" +new String(fileName.getBytes("gbk"),"iso8859-1") + ".xls"); String[] titles = { "成绩编号","学生编号", "学生姓名", "课程编号", "课程名称", "成绩" }; courseService.export(titles, out,user); } catch (Exception e) { e.printStackTrace(); } } @RequestMapping("delete") public String delete(String ID){ courseService.deleteByPrimaryKey(ID); return "redirect:/Course/queryAll"; } @RequestMapping("update") public String update(Course course){ courseService.updateByPrimaryKey(course); return "redirect:/Course/queryAll"; } @Transactional @RequestMapping("update1") public String update1(HttpServletRequest request,Course course){ course.setStatus("1"); courseService.updateByPrimaryKey(course); User user = (User) request.getSession().getAttribute("user"); Curelation curelation1 = new Curelation(); curelation1.setCourseid(course.getId()); curelation1.setUserid(user.getId()); List<Curelation> curelationList = curelationService.queryAll(curelation1); if(curelationList.size()==0){ Curelation curelation = new Curelation(); curelation.setUserid(user.getId()); curelation.setCourseid(course.getId()); curelation.setId(String.valueOf(Math.random()).substring(2, 10)); curelation.setType("2"); curelationService.insert(curelation); } return "redirect:/Course/teacher"; } @RequestMapping("update2") public String update2(HttpServletRequest request,Course course){ User user = (User) request.getSession().getAttribute("user"); Curelation curelation = new Curelation(); curelation.setUserid(user.getId()); 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{ Curelation curelation1 = 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") public String queryOne(String ID){ Course course = new Course(); course.setId(ID); List<Course> list = courseService.queryAll(course); course = list.get(0); JSONObject json = new JSONObject(); return json.toJSONString(course); } @RequestMapping("add") public String addCourse(Course course){ course.setId(String.valueOf(Math.random()).substring(2, 10)); System.out.println(course.toString()); courseService.insert(course); return "redirect:/Course/queryAll"; } }

以上就是Java实战之课程在线学习系统的实现的详细内容，更多关于Java课程在线学习系统的资料请关注盛行IT其它相关文章！

郑重声明：本文由网友发布，不代表盛行IT的观点，版权归原作者所有，仅为传播更多信息之目的，如有侵权请联系，我们将第一时间修改或删除，多谢。

目录