基于javaweb+mysql的springboot课程在线学习系统(java+springboot+thymeleaf+html+ssm+mysql)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的SpringBoot课程在线学习系统(java+springboot+thymeleaf+html+ssm+mysql)
项目介绍
采用SpringBoot+Spring+Mybatis+Thyeleaf实现的在线学习系统，一共2个身份。
管理员登录系统后可以管理所有用户信息，管理角色信息，添加修改管理课件信息，学生学习培训批次管理，成绩导入管理 学生登录系统后可以查询自己的个人信息，查询课件列表学习，查询我的培训记录，查询自己的成绩
采用SpringBoot框架实现 前台模板用的thymeleaf 数据库层采用mybatis框架 注解模式
upload文件夹放入D盘根目录！
项目运行
登录地址： http://localhost:8080/th/login 管理员账号和密码： admin admin
学生登录账号： 1314 密码： 123456
Courseinfo course1=courseservice.selecto(course);
map.addAttribute("courseinfo",course1);
return "thymeleaf/course/updatecourse";
}
//提交修改界面
@RequestMapping("/updatecourse1")
public String updatecourse1(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
courseservice.updatecourse(course);
map.addAttribute("courseinfo",course1);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class StudyrecordController {
@Autowired
private Studyrecordservice recordservice;
@Autowired
private Sysservice sysservice;
@Autowired
private Batchservice batchservice;
@Autowired
private Courseresoureservice recoureservice;
//记录列表
@RequestMapping("/listrecord")
public String listrecord(ModelMap map,Studyrecord record,Sysuser user,Studybatch studybatch,Courseresoure resoure) {
List<Studyrecord> selectrecord=recordservice.selectrecord(record);
List<Sysuser> user1=sysservice.selectUser(user);
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("sysuser", user1);
map.addAttribute("courseresoure", resoure1);
map.addAttribute("batch", selectbatch);
map.addAttribute("record", selectrecord);
return "thymeleaf/studyrecord/listrecord";
@RequestMapping("/listbatch")
public String listbatch(ModelMap map,Studybatch studybatch,Userbatch userbatch,Coureseresourebatch resoure) {
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
List<Userbatch> selectuser=batchservice.selectuser(userbatch);
List<Coureseresourebatch> selectresoure=batchservice.selectresoure(resoure);
map.addAttribute("batch", selectbatch);
map.addAttribute("user", selectuser);
map.addAttribute("resoure", selectresoure);
return "thymeleaf/batch/listbatch";
}
//删除批次
@RequestMapping("/deletebatch")
public String deletebatch(ModelMap map,Studybatch studybatch,Userbatch userbatch,Coureseresourebatch resoure) {
batchservice.deleteuser(userbatch);
batchservice.deleteresoure(resoure);
batchservice.deletebatch(studybatch);
return "thymeleaf/error/success";
}
//修改批次界面
@RequestMapping("/updatebatch")
public String updatebatch(ModelMap map,Studybatch studybatch,Courseresoure resoure,Sysuser user) {
Studybatch studybatch1=batchservice.batchone(studybatch);
map.addAttribute("batch", studybatch1);
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
List<Sysuser> user1=sysservice.selectUser(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/batch/updatebatch";
}
//提交批次界面
@RequestMapping("/updatebatch1")
public String updatebatch1(ModelMap map,Studybatch studybatch,Userbatch userbatch,Coureseresourebatch resoure) {
batchservice.updatebatch(studybatch);
batchservice.updateresoure(resoure);
batchservice.updateuser(userbatch);
return "thymeleaf/error/success";
};
}
package com.example.demo.controller;
Status=Status-1;
}
sysservice.updatez(Status, Id);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//添加用户页面
@RequestMapping("/adduser")
public String adduser(Sysuser user,ModelMap map) {
return "thymeleaf/user/adduser";
}
//提交用户页面
@RequestMapping("/addsysuser")
public String addsysuser(Sysuser user,ModelMap map) {
sysservice.addsysuser(user);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class CourseresoureController {
@Autowired
private Courseresoureservice recoureservice;
@Autowired
private Courseinfoservice courseservice;
//增加课件界面
@RequestMapping("/addcourseresoure")
public String addcourseresoure(ModelMap map,Courseinfo course) {
List<Courseinfo> course1=courseservice.selectcourse(course);
System.out.println(course1);
recoureservice.updateresoure(resoure);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class BatchController {
@Autowired
private Courseresoureservice recoureservice;
@Autowired
private Sysservice sysservice;
@Autowired
private Batchservice batchservice;
//添加批次页面
@RequestMapping("/addbatch")
public String addbatch(ModelMap map,Courseresoure resoure,Sysuser user,Studybatch studybatch) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
@Controller
@RequestMapping("th")
public class CourseresoureController {
@Autowired
private Courseresoureservice recoureservice;
@Autowired
private Courseinfoservice courseservice;
//增加课件界面
@RequestMapping("/addcourseresoure")
public String addcourseresoure(ModelMap map,Courseinfo course) {
List<Courseinfo> course1=courseservice.selectcourse(course);
System.out.println(course1);
map.addAttribute("courseinfo", course1);
return "thymeleaf/courseresour/addcourseresoure";
}
//提交课件页面
@RequestMapping("/addcourseresoure1")
public String addcourseresoure1(ModelMap map, MultipartFile file, MultipartFile image,
HttpServletRequest request,Courseresoure resoure) throws Exception {
String filename = file.getOriginalFilename();// 获取上传文件的原名
String coverpath =image.getOriginalFilename();//获取上传图片名
String path = "D://upload/"
+ filename;
String pathi ="D://upload/"
+ coverpath;
File f = new File(path);
file.transferTo(f);
File c=new File(pathi);
image.transferTo(c);
resoure.setFileName(filename);
resoure.setCoverPath(coverpath);
System.out.println(resoure);
recoureservice.addresoure(resoure);
return "thymeleaf/error/success";
}
//课件列表
@RequestMapping("/listresoure")
}
else if(user1.getStatus()==1) {
return "thymeleaf/error/error";
}
return null;
}
//删除用户
@RequestMapping("/delete")
public String delete(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
sysservice.deleteUser(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//修改用户界面
@RequestMapping("/updatem")
public String updatem(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/user/updatemessage";
}
//修改提交页面
@RequestMapping(value="/updatems")
public String updatems(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
sysservice.updatems(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//修改状态
@RequestMapping("/updatez")
public String updatez(ModelMap map,Sysuser user) {
Sysuser user1=sysservice.selectone(user);
int Status=user1.getStatus();
int Id=user1.getId();
System.out.println(user1.getStatus());
if(Status==0)
{
Status=Status+1;
}
else {
Status=Status-1;
}
sysservice.updatez(Status, Id);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
public String delete(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
sysservice.deleteUser(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//修改用户界面
@RequestMapping("/updatem")
public String updatem(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/user/updatemessage";
}
//修改提交页面
@RequestMapping(value="/updatems")
public String updatems(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
sysservice.updatems(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//修改状态
@RequestMapping("/updatez")
public String updatez(ModelMap map,Sysuser user) {
Sysuser user1=sysservice.selectone(user);
int Status=user1.getStatus();
int Id=user1.getId();
System.out.println(user1.getStatus());
if(Status==0)
{
Status=Status+1;
}
else {
Status=Status-1;
}
sysservice.updatez(Status, Id);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//添加用户页面
@RequestMapping("/adduser")
public String adduser(Sysuser user,ModelMap map) {
return "thymeleaf/user/adduser";
}
//提交用户页面
@RequestMapping("/addsysuser")
public String addsysuser(Sysuser user,ModelMap map) {
sysservice.addsysuser(user);
return "thymeleaf/error/success";
System.out.println(resoure);
recoureservice.addresoure(resoure);
return "thymeleaf/error/success";
}
//课件列表
@RequestMapping("/listresoure")
public String listresoure(ModelMap map,Courseresoure resoure) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/courseresour/listresoure";
}
//删除课件
@RequestMapping("/deleteresoure")
public String deleteresoure(ModelMap map,Courseresoure resoure) {
Courseresoure resoure1=recoureservice.resoure(resoure);
recoureservice.deleteresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/error/success";
}
//修改课件页面
@RequestMapping("/updateresoure")
public String updateresoure(ModelMap map,Courseresoure resoure,Courseinfo course) {
List<Courseinfo> course1=courseservice.selectcourse(course);
Courseresoure resoure1=recoureservice.resoure(resoure);
map.addAttribute("courseinfo", course1);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/courseresour/updateresoure";
}
//提交修改课件页面
@RequestMapping("/updateresoure1")
public String updateresoure1(ModelMap map, MultipartFile file, MultipartFile image,
HttpSession session,Courseresoure resoure) throws Exception {
String filename = file.getOriginalFilename();// 获取上传文件的原名
String coverpath =image.getOriginalFilename();//获取上传图片名
String path = "D://upload/"
+ filename;
String pathi = "D://upload/"
+ coverpath;
File f = new File(path);
file.transferTo(f);
File c=new File(pathi);
file.transferTo(c);
resoure.setFileName(filename);
}
//提交添加课程页面
@RequestMapping("/addcourse1")
public String addcourse1(Courseinfo course,ModelMap map) {
System.out.println(course);
courseservice.addcourse(course);
return "thymeleaf/error/success";
}
//删除
@RequestMapping("/deletecourse")
public String deletecourse(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
courseservice.deletecourse(course);
map.addAttribute("courseinfo", course1);
return "thymeleaf/error/success";
}
//修改界面
@RequestMapping("/updatecourse")
public String updatecourse(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
map.addAttribute("courseinfo",course1);
return "thymeleaf/course/updatecourse";
}
//提交修改界面
@RequestMapping("/updatecourse1")
public String updatecourse1(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
courseservice.updatecourse(course);
map.addAttribute("courseinfo",course1);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
String coverpath =image.getOriginalFilename();//获取上传图片名
String path = "D://upload/"
+ filename;
String pathi = "D://upload/"
+ coverpath;
File f = new File(path);
file.transferTo(f);
File c=new File(pathi);
file.transferTo(c);
resoure.setFileName(filename);
resoure.setCoverPath(coverpath);
System.out.println(resoure);
recoureservice.updateresoure(resoure);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class BatchController {
@Autowired
private Courseresoureservice recoureservice;
@Autowired
private Sysservice sysservice;
@Autowired
private Batchservice batchservice;
//添加批次页面
@RequestMapping("/addbatch")
public String addbatch(ModelMap map,Courseresoure resoure,Sysuser user,Studybatch studybatch) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
//课件列表
@RequestMapping("/studentresoure")
public String studentresoure(ModelMap map,Courseresoure resoure) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/student/studentresoure";
}
//学习课件
@RequestMapping("/study")
public String study(ModelMap map,Courseresoure resoure) {
Courseresoure resoure1=recoureservice.resoure(resoure);
resoure1.setFileName("http://localhost:8081/upload/"+resoure1.getFileName());
resoure1.setCoverPath("http://localhost:8081/upload/"+resoure1.getCoverPath());
map.addAttribute("resoure", resoure1);
return "thymeleaf/student/study";
}
//批次信息记录
@RequestMapping("/batchmessage")
public String batchmessage(ModelMap map,Studybatch studybatch,Sysuser user,Userbatch userbatch,Coureseresourebatch resoure) {
Sysuser user1=sysservice.selectone(user);
map.addAttribute("sysuser", user1);
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
map.addAttribute("batch", selectbatch);
Userbatch userbatch1=batchservice.userone(userbatch);
map.addAttribute("userbatch", userbatch1);
Coureseresourebatch resoure1=batchservice.resoureone(resoure);
map.addAttribute("resoure", resoure1);
return "thymeleaf/student/studybatch";
}
//进入学习
@RequestMapping("/studyview")
public String studyview(ModelMap map,Studybatch studybatch,Coureseresourebatch resoure1,Courseresoure resoure,Userbatch userbatch) {
Coureseresourebatch resoure2=batchservice.resoureone(resoure1);
map.addAttribute("batchresoure", resoure2);
if(studybatch.getId()==resoure2.getBatchId())
{
Courseresoure resoure3=recoureservice.studyresoure(resoure);
map.addAttribute("recourseview", resoure3);
Userbatch user1=batchservice.userone(userbatch);
map.addAttribute("user", user1);
if(resoure2.getCourseResoureId()==resoure3.getId()) {
resoure3.setFileName("http://localhost:8081/upload/"+resoure3.getFileName());
resoure3.setCoverPath("http://localhost:8081/upload/"+resoure3.getCoverPath());
map.addAttribute("studview", resoure3);
}
@Controller
@RequestMapping("th")
public class CourseresoureController {
@Autowired
private Courseresoureservice recoureservice;
@Autowired
private Courseinfoservice courseservice;
//增加课件界面
@RequestMapping("/addcourseresoure")
public String addcourseresoure(ModelMap map,Courseinfo course) {
List<Courseinfo> course1=courseservice.selectcourse(course);
System.out.println(course1);
map.addAttribute("courseinfo", course1);
return "thymeleaf/courseresour/addcourseresoure";
}
//提交课件页面
@RequestMapping("/addcourseresoure1")
public String addcourseresoure1(ModelMap map, MultipartFile file, MultipartFile image,
HttpServletRequest request,Courseresoure resoure) throws Exception {
String filename = file.getOriginalFilename();// 获取上传文件的原名
String coverpath =image.getOriginalFilename();//获取上传图片名
String path = "D://upload/"
+ filename;
String pathi ="D://upload/"
+ coverpath;
File f = new File(path);
file.transferTo(f);
File c=new File(pathi);
image.transferTo(c);
resoure.setFileName(filename);
resoure.setCoverPath(coverpath);
System.out.println(resoure);
recoureservice.addresoure(resoure);
return "thymeleaf/error/success";
}
//课件列表
@RequestMapping("/listresoure")
public String listresoure(ModelMap map,Courseresoure resoure) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/courseresour/listresoure";
}
public class RoleController {
@Autowired
private Sysroleservice roleservice;
//角色列表
@RequestMapping("/listrole")
public String selectRole(ModelMap map,Sysrole role) {
List<Sysrole> role1=roleservice.selectRole(role);
System.out.println(role1);
map.addAttribute("sysrole", role1);
return "thymeleaf/role/listrole";
}
//修改状态
@RequestMapping("/updaterolez")
public String updatez(ModelMap map,Sysrole role) {
Sysrole role1=roleservice.selectone(role);
int Status=role1.getStatus();
int Id=role1.getId();
System.out.println(role1.getStatus());
if(Status==0)
{
Status=Status+1;
}
else {
Status=Status-1;
}
roleservice.updatez(Status, Id);
map.addAttribute("sysrole", role1);
return "thymeleaf/error/success";
}
//修改角色界面
@RequestMapping("/updatej")
public String updatej(Sysrole role,ModelMap map) {
Sysrole role1=roleservice.selectone(role);
map.addAttribute("sysrole", role1);
return "thymeleaf/role/updaterole";
}
//修改提交页面
@RequestMapping(value="/updatemj")
public String updatemj(Sysrole role,ModelMap map) {
Sysrole role1=roleservice.selectone(role);
roleservice.update(role);
map.addAttribute("sysrole", role1);
return "thymeleaf/error/success";
}
//删除角色
@RequestMapping("/deleterole")
public String deleterole(Sysrole role,ModelMap map) {
Sysrole role1=roleservice.selectone(role);
}
//提交添加课程页面
@RequestMapping("/addcourse1")
public String addcourse1(Courseinfo course,ModelMap map) {
System.out.println(course);
courseservice.addcourse(course);
return "thymeleaf/error/success";
}
//删除
@RequestMapping("/deletecourse")
public String deletecourse(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
courseservice.deletecourse(course);
map.addAttribute("courseinfo", course1);
return "thymeleaf/error/success";
}
//修改界面
@RequestMapping("/updatecourse")
public String updatecourse(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
map.addAttribute("courseinfo",course1);
return "thymeleaf/course/updatecourse";
}
//提交修改界面
@RequestMapping("/updatecourse1")
public String updatecourse1(Courseinfo course,ModelMap map) {
Courseinfo course1=courseservice.selecto(course);
courseservice.updatecourse(course);
map.addAttribute("courseinfo",course1);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class ExamscoreController {
@Autowired
private Examscoreservice examxcore;
@Autowired
private Sysservice sysservice;
@Autowired
private Batchservice batchservice;
//批量上传
@RequestMapping("/muchscore")
public String muchscore(ModelMap map) {
return "thymeleaf/examscore/exclexam";
}
//提交上传成绩
@RequestMapping("/muchscore1")
public String muchscore1(MultipartFile file) throws IOException{
List<Map<String,String>> list=ExcelUtil.getList(file.getInputStream());
for(Map<String,String> score : list){
Examscore e=new Examscore();
e.setScore(Integer.parseInt(score.get("Score").toString()));
e.setSysUserId(Integer.parseInt(score.get("SysUserId").toString()));
e.setStudyBatchId(Integer.parseInt(score.get("StudyBatchId").toString()));
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//修改状态
@RequestMapping("/updatez")
public String updatez(ModelMap map,Sysuser user) {
Sysuser user1=sysservice.selectone(user);
int Status=user1.getStatus();
int Id=user1.getId();
System.out.println(user1.getStatus());
if(Status==0)
{
Status=Status+1;
}
else {
Status=Status-1;
}
sysservice.updatez(Status, Id);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//添加用户页面
@RequestMapping("/adduser")
public String adduser(Sysuser user,ModelMap map) {
return "thymeleaf/user/adduser";
}
//提交用户页面
@RequestMapping("/addsysuser")
public String addsysuser(Sysuser user,ModelMap map) {
sysservice.addsysuser(user);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@RequestMapping("/listscore")
public String listscore(ModelMap map,Sysuser user,Studybatch studybatch,Examscore score) {
List<Sysuser> user1=sysservice.selectUser(user);
map.addAttribute("sysuser", user1);
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
map.addAttribute("batch", selectbatch);
List<Examscore> score1=examxcore.selectscore(score);
map.addAttribute("score", score1);
return "thymeleaf/examscore/listscore";
}
//删除成绩
@RequestMapping("/deletescore")
public String deletescore(ModelMap map,Examscore score) {
examxcore.deletescore(score);
return "thymeleaf/error/success";
}
//修改分数页面
@RequestMapping("/updatescore")
public String updatescore(ModelMap map,Examscore score) {
Examscore score1=examxcore.scoreone(score);
map.addAttribute("score", score1);
return "thymeleaf/examscore/updatescore";
}
//提交修改分数页面
@RequestMapping("/updatescore1")
public String updatescore1(ModelMap map,Examscore score,int Score,int Id) {
Examscore score1=examxcore.scoreone(score);
examxcore.updatescore(Score, Id);
map.addAttribute("score", score1);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
}
//修改提交页面
@RequestMapping(value="/updatemj")
public String updatemj(Sysrole role,ModelMap map) {
Sysrole role1=roleservice.selectone(role);
roleservice.update(role);
map.addAttribute("sysrole", role1);
return "thymeleaf/error/success";
}
//删除角色
@RequestMapping("/deleterole")
public String deleterole(Sysrole role,ModelMap map) {
Sysrole role1=roleservice.selectone(role);
roleservice.deleterole(role);
map.addAttribute("sysrole", role1);
return "thymeleaf/error/success";
}
//添加角色界面
@RequestMapping("/addrole")
public String addrole(Sysrole role,ModelMap map) {
return "thymeleaf/role/addrole";
}
//提交增加页面
@RequestMapping("/addrolet")
public String addrolet(Sysrole role,ModelMap map) {
roleservice.addrole(role);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
resoure.setFileName(filename);
resoure.setCoverPath(coverpath);
System.out.println(resoure);
recoureservice.addresoure(resoure);
return "thymeleaf/error/success";
}
//课件列表
@RequestMapping("/listresoure")
public String listresoure(ModelMap map,Courseresoure resoure) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/courseresour/listresoure";
}
//删除课件
@RequestMapping("/deleteresoure")
public String deleteresoure(ModelMap map,Courseresoure resoure) {
Courseresoure resoure1=recoureservice.resoure(resoure);
recoureservice.deleteresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/error/success";
}
//修改课件页面
@RequestMapping("/updateresoure")
public String updateresoure(ModelMap map,Courseresoure resoure,Courseinfo course) {
List<Courseinfo> course1=courseservice.selectcourse(course);
Courseresoure resoure1=recoureservice.resoure(resoure);
map.addAttribute("courseinfo", course1);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/courseresour/updateresoure";
}
//提交修改课件页面
@RequestMapping("/updateresoure1")
public String updateresoure1(ModelMap map, MultipartFile file, MultipartFile image,
HttpSession session,Courseresoure resoure) throws Exception {
String filename = file.getOriginalFilename();// 获取上传文件的原名
String coverpath =image.getOriginalFilename();//获取上传图片名
String path = "D://upload/"
+ filename;
String pathi = "D://upload/"
+ coverpath;
File f = new File(path);
file.transferTo(f);
File c=new File(pathi);
file.transferTo(c);
resoure.setFileName(filename);
resoure.setCoverPath(coverpath);
System.out.println(resoure);
recoureservice.updateresoure(resoure);
return "thymeleaf/error/success";
}
public String muchscore1(MultipartFile file) throws IOException{
List<Map<String,String>> list=ExcelUtil.getList(file.getInputStream());
for(Map<String,String> score : list){
Examscore e=new Examscore();
e.setScore(Integer.parseInt(score.get("Score").toString()));
e.setSysUserId(Integer.parseInt(score.get("SysUserId").toString()));
e.setStudyBatchId(Integer.parseInt(score.get("StudyBatchId").toString()));
examxcore.insertscore(e);
}
return "thymeleaf/error/success";
}
//列表成绩
@RequestMapping("/listscore")
public String listscore(ModelMap map,Sysuser user,Studybatch studybatch,Examscore score) {
List<Sysuser> user1=sysservice.selectUser(user);
map.addAttribute("sysuser", user1);
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
map.addAttribute("batch", selectbatch);
List<Examscore> score1=examxcore.selectscore(score);
map.addAttribute("score", score1);
return "thymeleaf/examscore/listscore";
}
//删除成绩
@RequestMapping("/deletescore")
public String deletescore(ModelMap map,Examscore score) {
examxcore.deletescore(score);
return "thymeleaf/error/success";
}
//修改分数页面
@RequestMapping("/updatescore")
public String updatescore(ModelMap map,Examscore score) {
Examscore score1=examxcore.scoreone(score);
map.addAttribute("score", score1);
return "thymeleaf/examscore/updatescore";
}
//提交修改分数页面
@RequestMapping("/updatescore1")
public String updatescore1(ModelMap map,Examscore score,int Score,int Id) {
Examscore score1=examxcore.scoreone(score);
examxcore.updatescore(Score, Id);
map.addAttribute("score", score1);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
List<Sysuser> user1=sysservice.selectUser(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/batch/updatebatch";
}
//提交批次界面
@RequestMapping("/updatebatch1")
public String updatebatch1(ModelMap map,Studybatch studybatch,Userbatch userbatch,Coureseresourebatch resoure) {
batchservice.updatebatch(studybatch);
batchservice.updateresoure(resoure);
batchservice.updateuser(userbatch);
return "thymeleaf/error/success";
};
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class ExamscoreController {
@Autowired
private Examscoreservice examxcore;
@Autowired
private Sysservice sysservice;
@Autowired
private Batchservice batchservice;
//批量上传
@RequestMapping("/muchscore")
public String muchscore(ModelMap map) {
@Controller
@RequestMapping("th")
public class StudyrecordController {
@Autowired
private Studyrecordservice recordservice;
@Autowired
private Sysservice sysservice;
@Autowired
private Batchservice batchservice;
@Autowired
private Courseresoureservice recoureservice;
//记录列表
@RequestMapping("/listrecord")
public String listrecord(ModelMap map,Studyrecord record,Sysuser user,Studybatch studybatch,Courseresoure resoure) {
List<Studyrecord> selectrecord=recordservice.selectrecord(record);
List<Sysuser> user1=sysservice.selectUser(user);
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("sysuser", user1);
map.addAttribute("courseresoure", resoure1);
map.addAttribute("batch", selectbatch);
map.addAttribute("record", selectrecord);
return "thymeleaf/studyrecord/listrecord";
}
//删除成绩
@RequestMapping("/deleterecord")
public String deletebatch(ModelMap map,Studyrecord record) {
recordservice.deeterecord(record);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
public String selectone(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/user/updateps";
}
//提交修改密码界面
@RequestMapping(value ="/updateps1")
public String updateps(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
sysservice.updateps(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/error/success";
}
//用户列表
@RequestMapping("/listuser")
public String listuser(ModelMap map,Sysuser user) {
List<Sysuser> user1=sysservice.selectUser(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/user/listuser";
}
//提交登录界面
@RequestMapping(value = "/login1")
public String login(Sysuser user,ModelMap map,Studybatch studybatch){
Sysuser user1 = sysservice.login(user);
System.out.println(user1);
System.out.println(user1.getName());
System.out.println(user1.getId());
System.out.println(user1.getStatus());
if(user1.getStatus()==0 ) {
if(user1.getPermission()==1)
{
map.addAttribute("sysuser", user1);
return "thymeleaf/user/userindex";
}
else {
map.addAttribute("sysuser", user1);
return "thymeleaf/student/studentindex";
}
}
else if(user1.getStatus()==1) {
return "thymeleaf/error/error";
}
return null;
}
//删除用户
@RequestMapping("/delete")
public String delete(Sysuser user,ModelMap map) {
Sysuser user1=sysservice.selectone(user);
sysservice.deleteUser(user);
map.addAttribute("sysuser", user1);
}
//删除课件
@RequestMapping("/deleteresoure")
public String deleteresoure(ModelMap map,Courseresoure resoure) {
Courseresoure resoure1=recoureservice.resoure(resoure);
recoureservice.deleteresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/error/success";
}
//修改课件页面
@RequestMapping("/updateresoure")
public String updateresoure(ModelMap map,Courseresoure resoure,Courseinfo course) {
List<Courseinfo> course1=courseservice.selectcourse(course);
Courseresoure resoure1=recoureservice.resoure(resoure);
map.addAttribute("courseinfo", course1);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/courseresour/updateresoure";
}
//提交修改课件页面
@RequestMapping("/updateresoure1")
public String updateresoure1(ModelMap map, MultipartFile file, MultipartFile image,
HttpSession session,Courseresoure resoure) throws Exception {
String filename = file.getOriginalFilename();// 获取上传文件的原名
String coverpath =image.getOriginalFilename();//获取上传图片名
String path = "D://upload/"
+ filename;
String pathi = "D://upload/"
+ coverpath;
File f = new File(path);
file.transferTo(f);
File c=new File(pathi);
file.transferTo(c);
resoure.setFileName(filename);
resoure.setCoverPath(coverpath);
System.out.println(resoure);
recoureservice.updateresoure(resoure);
return "thymeleaf/error/success";
}
}
package com.example.demo.controller;
@Controller
@RequestMapping("th")
public class StudentController {
@Autowired
private Sysservice sysservice;
@Autowired
private Courseresoureservice recoureservice;
@Autowired
private Studyrecordservice recordservice;
@Autowired
private Batchservice batchservice;
@Autowired
private Examscoreservice examxcore;
//基本信息查询
@RequestMapping("/studentmessage")
public String studentmessage(ModelMap map,Sysuser user) {
Sysuser user1=sysservice.selectone(user);
map.addAttribute("sysuser", user1);
return "thymeleaf/student/studentmessage";
}
//课件列表
@RequestMapping("/studentresoure")
public String studentresoure(ModelMap map,Courseresoure resoure) {
List<Courseresoure> resoure1=recoureservice.selectresoure(resoure);
map.addAttribute("courseresoure", resoure1);
return "thymeleaf/student/studentresoure";
}
//学习课件
@RequestMapping("/study")
public String study(ModelMap map,Courseresoure resoure) {
Courseresoure resoure1=recoureservice.resoure(resoure);
resoure1.setFileName("http://localhost:8081/upload/"+resoure1.getFileName());
resoure1.setCoverPath("http://localhost:8081/upload/"+resoure1.getCoverPath());
map.addAttribute("resoure", resoure1);
return "thymeleaf/student/study";
}
//批次信息记录
@RequestMapping("/batchmessage")
public String batchmessage(ModelMap map,Studybatch studybatch,Sysuser user,Userbatch userbatch,Coureseresourebatch resoure) {
Sysuser user1=sysservice.selectone(user);
map.addAttribute("sysuser", user1);
List<Studybatch> selectbatch=batchservice.selectbatch(studybatch);
402
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
