当前位置:   article > 正文

Java项目:学习平台管理系统(java+SpringBoot+Vue+ElementUI+Layui+Mysql)_vue+elementui+java管理系统带数据库文件

vue+elementui+java管理系统带数据库文件

源码获取:俺的博客首页 "资源" 里下载!

项目介绍

基于SpringBoot和Vue的学习平台:

在平台首页可以查看首页,课程信息,作业信息,资料信息,校园论坛,试卷,公告信息,个人中心,后台管理等内容进行详细操作

角色:管理员、学生、教师

管理员:管理员登录系统后,可以对首页,个人中心,学生管理,教师管理,课程信息管理,类型管理,作业信息管理,资料信息管理,签到信息管理,成绩统计管理,学生作业管理,试卷管理,试题管理,校园论坛,系统管理等功能模块进行相应操作

学生:学习平台,在平台首页可以查看首页,课程信息,作业信息,资料信息,校园论坛,试卷,公告信息,个人中心,后台管理等内容进行详细操作

教师:教师登录进入学习平台,可以对首页,个人中心,课程信息管理,作业信息管理,资料信息管理,签到信息管理,成绩统计管理,学生作业管理等功能进行相应操作

环境需要

1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
4.数据库:MySql 5.7/8.0版本均可;
5.是否Maven项目:是;


技术栈

1.后端:SpringBoot+Mybaits
2.前端:Vue +ElementUI +Layui +HTML+CSS+JS


使用说明

项目运行:
1. 使用Navicat或者其它工具,在mysql中创建对应sql文件名称的数据库,并导入项目的sql文件;
2. 使用IDEA/Eclipse/MyEclipse导入项目,导入成功后请执行maven clean;maven install命令,然后运行;
3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;
4. 运行项目,在浏览器中输入项目地址:http://localhost:8080/springbootm55rv/front/index.html
注:项目所在路径不能存在中文、空格等特殊字符
管理员: abo/abo
用户: 学号1/123456
教师:工号1/123456


 

 

 

 

 

用户管理控制层:

  1. @Controller
  2. @RequestMapping("/User")
  3. public class UserController {
  4. @Autowired
  5. private UserService userService;
  6. @Autowired
  7. private PowerService powerService;
  8. @Autowired
  9. private RoleService roleService;
  10. @Autowired
  11. private NoticeService noticeService;
  12. @RequestMapping("/Main")
  13. public String res(HttpServletRequest request){
  14. String time = DateUtil.getStringToday();
  15. request.getSession().setAttribute("time", time);
  16. Notice notice = new Notice();
  17. List<Notice> list = noticeService.queryAll(notice);
  18. notice = list.get(0);
  19. User user = userService.selectByPrimaryKey(notice.getUserid());
  20. notice.setUserid(user.getName());
  21. request.getSession().setAttribute("notice", notice);
  22. return "Main";
  23. }
  24. @RequestMapping("/changePa")
  25. public String res1(){
  26. return "changePass";
  27. }
  28. @RequestMapping("/Login")
  29. public ModelAndView login(HttpServletRequest request,String id,String password) throws Exception{
  30. ModelAndView mav = new ModelAndView();
  31. User user1 = userService.selectByPrimaryKey(id);
  32. if(user1 == null || !password.equals(user1.getPassword())){
  33. mav.setViewName("index");
  34. request.getSession().setAttribute("info", "error");
  35. return mav;
  36. }else{
  37. Role role = new Role();
  38. role.setRoleid(user1.getRoleid());
  39. List<Role> list =roleService.QueryAll(role);
  40. role =list.get(0);
  41. request.getSession().setAttribute("roleName", role.getRolename());
  42. Power power = powerService.selectByPrimaryKey(role.getPowerid());
  43. if(!StringUtil.isNullOrEmpty(power.getPower())){
  44. request.getSession().setAttribute("power", power.getPower());
  45. }
  46. String time = DateUtil.getStringToday();
  47. request.getSession().setAttribute("time", time);
  48. request.getSession().setAttribute("user", user1);
  49. mav.setViewName("redirect:/User/Main");
  50. }
  51. return mav;
  52. }
  53. @RequestMapping("/updateStudent")
  54. public String update(User user){
  55. userService.updateByPrimaryKey(user);
  56. return "redirect:/User/student";
  57. }
  58. @RequestMapping("/updateTeacher")
  59. public String updatet(User user){
  60. userService.updateByPrimaryKey(user);
  61. return "redirect:/User/teacher";
  62. }
  63. @RequestMapping("/updatePa")
  64. public String updatePa(String userID,String password){
  65. User user = new User();
  66. System.out.println(userID);
  67. User user1 = userService.selectByPrimaryKey(userID);
  68. user1.setPassword(password);
  69. userService.updateByPrimaryKey(user1);
  70. return "Main";
  71. }
  72. @RequestMapping("/delete")
  73. public String delete(String ID){
  74. userService.deleteByPrimaryKey(ID);
  75. return "redirect:/User/queryAll";
  76. }
  77. @RequestMapping("/teacher")
  78. public String QueryAllTeacher(HttpServletRequest request,User user){
  79. List<User> list = userService.QueryAllTeacher(user);
  80. request.setAttribute("list", list);
  81. if(null != user.getName()){
  82. request.setAttribute("name", user.getName());
  83. }
  84. if(null != user.getMobile()){
  85. request.setAttribute("mobile", user.getMobile());
  86. }
  87. return "teacher";
  88. }
  89. @ResponseBody
  90. @RequestMapping("/jsonteacher")
  91. public String QueryAllTeacherjson(HttpServletRequest request,User user){
  92. List<User> list = userService.QueryAllTeacher(user);
  93. JSONObject json = new JSONObject();
  94. return json.toJSONString(list);
  95. }
  96. @RequestMapping("/student")
  97. public String QueryAllStudent(HttpServletRequest request,User user){
  98. List<User> list = userService.QueryAllStudent(user);
  99. request.setAttribute("list", list);
  100. if(null != user.getName()){
  101. request.setAttribute("name", user.getName());
  102. }
  103. if(null != user.getMobile()){
  104. request.setAttribute("mobile", user.getMobile());
  105. }
  106. return "student";
  107. }
  108. @RequestMapping("/addteacher")
  109. public String addUser(User user){
  110. String passWord = "123456";
  111. user.setPassword(passWord);
  112. user.setType(Constans.TEACHER);
  113. userService.insert(user);
  114. return "redirect:/User/teacher";
  115. }
  116. @RequestMapping("/addstudent")
  117. public String addStudent(User user){
  118. String passWord = "123456";
  119. user.setPassword(passWord);
  120. user.setType(Constans.STUDENT);
  121. userService.insert(user);
  122. return "redirect:/User/student";
  123. }
  124. @ResponseBody
  125. @RequestMapping("/queryOne")
  126. public String queryOne(String ID){
  127. User user = new User();
  128. user.setId(ID);
  129. List<User> list = userService.QueryAll(user);
  130. user = list.get(0);
  131. JSONObject json = new JSONObject();
  132. String data = json.toJSONString(user);
  133. return data;
  134. }
  135. @RequestMapping("/quit")
  136. public ModelAndView quit(HttpServletRequest request) throws Exception{
  137. ModelAndView mav = new ModelAndView();
  138. HttpSession session1 = request.getSession();
  139. session1.invalidate();
  140. request.getSession().setAttribute("info", "quit");
  141. mav.setViewName("index");
  142. return mav;
  143. }
  144. }

角色管理控制层:

  1. @Controller
  2. @RequestMapping("/Role")
  3. public class RoleController {
  4. @Autowired
  5. private RoleService depotService;
  6. @Autowired
  7. private PowerService powerService;
  8. @RequestMapping("/update")
  9. public String update(String id,String rolename,String powerContent){
  10. Role role = new Role();
  11. role.setRoleid(id);
  12. role.setRolename(rolename);
  13. depotService.update(role);
  14. List<Role> list = depotService.QueryAll(role);
  15. Role role1 = list.get(0);
  16. Power power = new Power();
  17. if(powerContent.indexOf("110") != -1){
  18. powerContent = powerContent + ",1100";
  19. }
  20. if(powerContent.indexOf("120") != -1){
  21. powerContent = powerContent + ",1200";
  22. }
  23. if(powerContent.indexOf("130") != -1){
  24. powerContent = powerContent + ",1300";
  25. }
  26. if(powerContent.indexOf("140") != -1){
  27. powerContent = powerContent + ",1400";
  28. }
  29. if(powerContent.indexOf("150") != -1){
  30. powerContent = powerContent + ",1500";
  31. }
  32. power.setPower(powerContent);
  33. power.setRoleid(role1.getPowerid());
  34. powerService.update(power);
  35. return "redirect:/Role/queryAll";
  36. }
  37. @RequestMapping("/delete")
  38. public String delete(String ID){
  39. depotService.deleteByPrimaryKey(ID);
  40. return "redirect:/Role/queryAll";
  41. }
  42. @RequestMapping("/queryAll")
  43. public String queryAll(HttpServletRequest request,Role role){
  44. List<Role> list = depotService.QueryAll(role);
  45. request.setAttribute("list", list);
  46. if(null != role.getRolename()){
  47. request.setAttribute("rolename", role.getRolename());
  48. }
  49. return "Role";
  50. }
  51. @RequestMapping("/add")
  52. public String add(String roleid,String rolename,String powerContent){
  53. Power power1 = new Power();
  54. Role role = new Role();
  55. String powerid = String.valueOf(Math.random()).substring(2, 8);
  56. role.setRoleid(String.valueOf(Math.random()).substring(2, 6));
  57. role.setPowerid(powerid);
  58. role.setRolename(rolename);
  59. power1.setPower(powerContent);
  60. power1.setRoleid(powerid);
  61. power1.setId(String.valueOf(Math.random()).substring(2, 8));
  62. powerService.insert(power1);
  63. depotService.insert(role);
  64. return "redirect:/Role/queryAll";
  65. }
  66. @ResponseBody
  67. @RequestMapping("/queryOne")
  68. public String queryOne(String ID){
  69. JSONObject json = new JSONObject();
  70. Role depot = new Role();
  71. Power power = new Power();
  72. power.setId(ID);
  73. System.out.println(ID);
  74. depot.setRoleid(ID);
  75. List<Role> list = depotService.QueryAll(depot);
  76. Role role1 = list.get(0);
  77. Power power1 = powerService.selectByPrimaryKey(role1.getPowerid());
  78. String name = role1.getRolename();
  79. role1.setPowerid(power1.getPower());
  80. String data = json.toJSONString(role1);
  81. return data;
  82. }
  83. @ResponseBody
  84. @RequestMapping("/getAll")
  85. public String getAll(Role role){
  86. JSONObject json = new JSONObject();
  87. List<Role> list = depotService.QueryAll(role);
  88. String jsonq = json.toJSONString(list);
  89. System.out.println(jsonq);
  90. return jsonq;
  91. }
  92. }

课程管理控制层:

  1. @Controller
  2. @RequestMapping("/Course")
  3. public class CourseController {
  4. @Autowired
  5. private CourseService courseService;
  6. @Autowired
  7. private CurelationService curelationService;
  8. @Autowired
  9. private CoursecommentService coursecommentService;
  10. @ResponseBody
  11. @RequestMapping("/queryOneCom")
  12. public String queryOneCom(String ID){
  13. Coursecomment course = new Coursecomment();
  14. course.setId(ID);
  15. System.out.println("===================================="+ID);
  16. List<Coursecomment> list = coursecommentService.queryAll(course);
  17. course = list.get(0);
  18. JSONObject json = new JSONObject();
  19. return json.toJSONString(course);
  20. }
  21. @RequestMapping("addComment")
  22. public String addComment(HttpServletRequest request, Coursecomment coursecomment){
  23. User user = (User) request.getSession().getAttribute("user");
  24. coursecomment.setCreatetime(DateUtil.getStringToday());
  25. coursecomment.setUserid(user.getName());
  26. coursecomment.setId(String.valueOf(Math.random()).substring(2,10));
  27. coursecommentService.insert(coursecomment);
  28. return "redirect:/Course/suggeetion";
  29. }
  30. @ResponseBody
  31. @RequestMapping("jsoncourse")
  32. public String jsoncourse(HttpServletRequest request, Curelation course){
  33. User user = (User) request.getSession().getAttribute("user");
  34. /*String type = "1";
  35. if ("1".equals(user.getType())){
  36. type="2";
  37. }
  38. course.setType(type);
  39. course.setUserid(user.getId());*/
  40. List<Curelation> curelationList = curelationService.queryAll(course);
  41. List<Course> dataList = new ArrayList<>();
  42. for (int i = 0; i < curelationList.size(); i++) {
  43. Course curelation = courseService.selectByPrimaryKey(curelationList.get(i).getCourseid());
  44. dataList.add(curelation);
  45. }
  46. JSONObject json = new JSONObject();
  47. return json.toJSONString(dataList);
  48. }
  49. @RequestMapping("suggeetion")
  50. public String suggeetion(HttpServletRequest request, Coursecomment coursecomment){
  51. List<Coursecomment> coursecomments = coursecommentService.queryAll(coursecomment);
  52. request.setAttribute("list",coursecomments);
  53. return "suggeetion";
  54. }
  55. @RequestMapping("view")
  56. public String view(HttpServletRequest request){
  57. User user = (User) request.getSession().getAttribute("user");
  58. String type = "1";
  59. if ("1".equals(user.getType())){
  60. type="2";
  61. }
  62. List<Map<String,String>> list=curelationService.courseview(type,user.getId());
  63. request.setAttribute("list",list);
  64. return "courseview";
  65. }
  66. @RequestMapping("deletecomment")
  67. public String deletecomment(String ID){
  68. coursecommentService.deleteByPrimaryKey(ID);
  69. return "redirect:/Course/suggeetion";
  70. }
  71. @RequestMapping("queryAll")
  72. public String queryAll(HttpServletRequest request, Course course){
  73. List<Course> list = courseService.queryAll(course);
  74. request.setAttribute("list",list);
  75. return "course";
  76. }
  77. @RequestMapping("/receive")
  78. public String receive(HttpServletRequest request, HttpServletResponse response, MultipartFile file){
  79. try {
  80. //也可以用request获取上传文件
  81. //MultipartFile fileFile = request.getFile("file"); //这里是页面的name属性
  82. //转换成输入流
  83. InputStream is = file.getInputStream();
  84. //得到excel
  85. Workbook workbook = Workbook.getWorkbook(is);
  86. //得到sheet
  87. Sheet sheet = workbook.getSheet(0);
  88. //得到列数
  89. int colsNum = sheet.getColumns();
  90. //得到行数
  91. int rowsNum = sheet.getRows();
  92. //单元格
  93. Cell cell;
  94. Cell cell1;
  95. List<Map> list = new ArrayList<>();
  96. Map<Integer, String> map = new HashMap<Integer, String>();
  97. for (int i = 1; i < rowsNum; i++) {//我的excel第一行是标题,所以 i从1开始
  98. cell = sheet.getCell(0,i);
  99. cell1 = sheet.getCell(5,i);
  100. Curelation curelation = new Curelation();
  101. curelation.setId(cell.getContents());
  102. curelation.setScore(cell1.getContents());
  103. curelationService.updateByPrimaryKey(curelation);
  104. }
  105. } catch (IOException e) {
  106. e.printStackTrace();
  107. } catch (BiffException e) {
  108. e.printStackTrace();
  109. }
  110. return "redirect:/Course/queryCourse";
  111. }
  112. @RequestMapping("/queryCourse")
  113. public String queryScore(HttpServletRequest request,Curelation curelation){
  114. curelation.setType("1");
  115. List<Curelation> list = curelationService.queryAll(curelation);
  116. request.setAttribute("list",list );
  117. return "ScoreList";
  118. }
  119. @RequestMapping("/teacher")
  120. public String teacher(HttpServletRequest request){
  121. User user = (User) request.getSession().getAttribute("user");
  122. Course course = new Course();
  123. course.setCourseteacher(user.getName());
  124. List<Course> courseList = courseService.queryAll(course);
  125. request.setAttribute("list",courseList);
  126. return "teacherDeal";
  127. }
  128. @RequestMapping("/student")
  129. public String student(HttpServletRequest request){
  130. Course course = new Course();
  131. course.setStatus("1");
  132. List<Course> courseList = courseService.queryAll(course);
  133. request.setAttribute("list",courseList);
  134. return "studentChoose";
  135. }
  136. @RequestMapping("/upload")
  137. public String upload(){
  138. return "uploadScore";
  139. }
  140. @RequestMapping("/Export")
  141. public void Export(HttpServletResponse response, User user){
  142. response.setContentType("application/binary;charset=UTF-8");
  143. try {
  144. ServletOutputStream out = response.getOutputStream();
  145. String fileName1 = "学生信息";
  146. String fileName2 = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date());
  147. String fileName = fileName1+fileName2;
  148. response.setHeader("Content-disposition", "attachment; filename=" +new String(fileName.getBytes("gbk"),"iso8859-1") + ".xls");
  149. String[] titles = { "成绩编号","学生编号", "学生姓名", "课程编号", "课程名称", "成绩" };
  150. courseService.export(titles, out,user);
  151. } catch (Exception e) {
  152. e.printStackTrace();
  153. }
  154. }
  155. @RequestMapping("delete")
  156. public String delete(String ID){
  157. courseService.deleteByPrimaryKey(ID);
  158. return "redirect:/Course/queryAll";
  159. }
  160. @RequestMapping("update")
  161. public String update(Course course){
  162. courseService.updateByPrimaryKey(course);
  163. return "redirect:/Course/queryAll";
  164. }
  165. @Transactional
  166. @RequestMapping("update1")
  167. public String update1(HttpServletRequest request,Course course){
  168. course.setStatus("1");
  169. courseService.updateByPrimaryKey(course);
  170. User user = (User) request.getSession().getAttribute("user");
  171. Curelation curelation1 = new Curelation();
  172. curelation1.setCourseid(course.getId());
  173. curelation1.setUserid(user.getId());
  174. List<Curelation> curelationList = curelationService.queryAll(curelation1);
  175. if(curelationList.size()==0){
  176. Curelation curelation = new Curelation();
  177. curelation.setUserid(user.getId());
  178. curelation.setCourseid(course.getId());
  179. curelation.setId(String.valueOf(Math.random()).substring(2, 10));
  180. curelation.setType("2");
  181. curelationService.insert(curelation);
  182. }
  183. return "redirect:/Course/teacher";
  184. }
  185. @RequestMapping("update2")
  186. public String update2(HttpServletRequest request,Course course){
  187. User user = (User) request.getSession().getAttribute("user");
  188. Curelation curelation = new Curelation();
  189. curelation.setUserid(user.getId());
  190. curelation.setCourseid(course.getId());
  191. List<Curelation> curelationList = curelationService.queryAll(curelation);
  192. if(curelationList.size() == 0){
  193. curelation.setId(String.valueOf(Math.random()).substring(2, 10));
  194. curelation.setType("1");
  195. curelationService.insert(curelation);
  196. }else{
  197. Curelation curelation1 = curelationList.get(0);
  198. curelation1.setUserid(user.getId());
  199. curelation1.setCourseid(course.getId());
  200. System.out.println(curelation1.toString());
  201. curelationService.updateByPrimaryKey(curelation1);
  202. }
  203. return "redirect:/Course/student";
  204. }
  205. @ResponseBody
  206. @RequestMapping("/queryOne")
  207. public String queryOne(String ID){
  208. Course course = new Course();
  209. course.setId(ID);
  210. List<Course> list = courseService.queryAll(course);
  211. course = list.get(0);
  212. JSONObject json = new JSONObject();
  213. return json.toJSONString(course);
  214. }
  215. @RequestMapping("add")
  216. public String addCourse(Course course){
  217. course.setId(String.valueOf(Math.random()).substring(2, 10));
  218. System.out.println(course.toString());
  219. courseService.insert(course);
  220. return "redirect:/Course/queryAll";
  221. }
  222. }

 源码获取:俺的博客首页 "资源" 里下载!

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/不正经/article/detail/369335
推荐阅读
相关标签
  

闽ICP备14008679号