基于javaweb的教务信息查询系统(java+ssm+bootstrap+c3p0+mysql)

基于javaweb的教务信息查询系统(java+ssm+bootstrap+c3p0+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+SSM的教务信息查询系统(java+SSM+Bootstrap+C3P0+Maven+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.是否Maven项目: 是；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目  6.数据库：MySql 5.7版本；

使用技术

IOC容器：Spring Web框架：SpringMVC ORM框架：Mybatis 安全框架：Shiro 数据源：C3P0 日志：log4j 前端框架：Bootstrap

使用说明

1. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，下载所需jar包；

2. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 3. 将项目中mysql.properties配置文件中的数据库配置改为自己的配置 4. 配置tomcat，然后运行项目，输入localhost:8080/xxx 登录 5. 管理员账户:admin 密码:123 教师账号：1001 密码:123

学生账号：10001 密码:123

学生管理管理控制层：

@Authority(roles = {Role.STUDENT})

@Controller

@RequestMapping(“/student”)

public class StudentController {

private static final Logger LOGGER = LoggerFactory.getLogger(StudentController.class);

@Autowired

private StudentService studentService;

@Autowired

private HttpServletRequest request;

@Autowired

private LoginServiceImpl loginService;

@Autowired

IndexServiceImpl indexService;

@Autowired

AdminService adminService;

@Autowired

TopicsService topicsService;

//Session过期时间

private final Integer SAVE_TIME = 606024;

@GetMapping(“/login”)

public String login(){

return “student/login”;

@PostMapping(value = “/login”)

@ResponseBody

public String login(String name, String pwd, Model model, HttpServletResponse response) {

name = name.trim();

List student = studentService.selectByName(name);

if (student.size() >= 1) {

if (student.get(0).getPwd().equals(pwd)) {

request.getSession().setAttribute(“student”,student.get(0));

request.getSession().setMaxInactiveInterval(SAVE_TIME);

User user = new User();

//-1表示为超管

user.setId(1L);

user.setRole(“student”);

user.setUserName(name);

//生成Token 存到 Cookie

Cookie cookie = new Cookie(“token”, TokenUtil.createToken(

user

));

//该Cookie无法被js读取

cookie.setHttpOnly(true);

cookie.setPath(“/”);

response.addCookie(cookie);

model.addAttribute(“student”, student.get(0));

return “200”;

}else {

return “0”;

} else {

return “300”;

@RequestMapping(“/index”)

public String index(Model model, HttpSession httpSession) {

Student student = (Student) request.getSession().getAttribute(“student”);

Subject project = indexService.indexinfo(student.getId());

String str = null;

Long flag = null;

if (project == null) {

model.addAttribute(“projectName”, “未选课题”);

model.addAttribute(“flag”, “未选题”);

model.addAttribute(“teacher”, “无”);

httpSession.removeAttribute(“”);

} else {

httpSession.setAttribute(“XZproject”, project.getProjectname());

model.addAttribute(“XZproject”, project.getProjectname());

model.addAttribute(“projectName”, project.getProjectname());

flag = indexService.projectselectedstuflag(student.getId());

if (flag == 0L) {

str = “未选题”;

} else if (flag == 1L) {

str = “选题待审核”;

} else if (flag == 2L) {

str = “选题未通过”;

} else if (flag == 3L) {

str = “选题通过”;

model.addAttribute(“flag”, str);

model.addAttribute(“teacher”, project.getTeachernames());

request.getSession().setAttribute(“filePath”,project.getFilepath());

//用来判断当前页是否为首页

model.addAttribute(“path”,“1”);

//判断是否修改了个人信息

// request.getSession().setAttribute(“modifyFlag”,0);

return “student/index”;

/**

• 查看个人信息

*/

@RequestMapping(“/studentinfo”)

public String studentinfo(Model model) {

Student student = (Student) request.getSession().getAttribute(“student”);

MyClass idclass = indexService.studentinfo(student.getIdClass());

model.addAttribute(“tclass”, idclass);

return “student/studentinfo”;

/**

• 将查看的个人信息放到信息修改页面

*/

@RequestMapping(“/modifyinfo”)

public String modifyinfo(Model model) {

Student student = (Student) request.getSession().getAttribute(“student”);

MyClass idclass = indexService.studentinfo(student.getIdClass());

model.addAttribute(“tclass”, idclass);

return “student/modifyinfo”;

/**

• 修改个人信息

• 根据班级(className)修改

*/

/*@RequestMapping(value = “/modifyinfodao”, method = RequestMethod.PUT)

@ResponseBody

public String modifyinfodao(Student student, String className, Model model) {

Student Tstudent = (Student) request.getSession().getAttribute(“student”);

MyClass Tclass = indexService.selectByclassName(className);

int count = -1;

student.setIdClass(Tclass.getId());

System.out.println(“******”+Tstudent.toString());

System.out.println(“******”+student.toString());

if (student.getStunum().equals(Tstudent.getStunum())) {

student.setStunum(null);

if (student.getIdClass().equals(Tstudent.getIdClass())) {

student.setIdClass(null);

if (student.getName().equals(Tstudent.getName())) {

student.setName(null);

if (student.getGender().equals(Tstudent.getGender())) {

student.setGender(null);

if (student.getGender() == null && student.getName() == null && student.getIdClass() == null && student.getStunum() == null) {

} else {

student.setId(Tstudent.getId());

count = indexService.updateBymodifyinfo(student);

student = indexService.selectByid(Tstudent.getId());

model.addAttribute(“student”, student);

if (count > 0) {

request.getSession().setAttribute(“student”,student);

request.getSession().setAttribute(“modifyFlag”,1);

return “200”;

} else {

request.getSession().setAttribute(“modifyFlag”,0);

return “201”;

}*/

/**

• 跳转页面(修改密码)

*/

@RequestMapping(“/changepsw”)

public String changepsw() {

return “student/changepsw”;

/**

• 200修改成功

• 201对不起密码错误

• 202对不起输入框为空

• 203新密码不一致

• 204修改失败

*/

@RequestMapping(value = “/changepassword”, method = RequestMethod.PUT)

@ResponseBody

public String changepswdao(String oldpassword, String newpassword, String newpassword1) {

if(!verifypassword(newpassword)){

return “206”;

if(!verifypassword(newpassword1)){

return “206”;

Student student = (Student) request.getSession().getAttribute(“student”);

Student studentdao = loginService.selectByName(student.getUsername());

int result;

if (newpassword.equals(newpassword1) && !newpassword.equals(“”) && !newpassword1.equals(“”)) {

if (studentdao.getPwd().equals(oldpassword)) {

if(oldpassword.equals(newpassword)){

return “205”;

}else{

result = indexService.updatepassword(newpassword, student.getId());

if (result > 0) {

return “200”;

}else{

return “204”;

} else {

return “201”;

} else if (newpassword.equals(“”) && newpassword1.equals(“”)) {

return “202”;

return “203”;

//密码验证

public boolean verifypassword(String password){

if(password.length() < 6 || password.length() > 16){

return false;

for(int i = 0;i < password.length();i++){

if(!(password.charAt(i)>=‘A’ && password.charAt(i)<=‘Z’)){

if(!(password.charAt(i)>=‘a’ && password.charAt(i)<=‘z’)){

if(!(password.charAt(i)>=‘0’ && password.charAt(i)<=‘9’)){

return false;

return true;

//退出

//清除Session数据

@RequestMapping(“/exit”)

public String exit(HttpServletResponse response,HttpSession httpSession) {

// httpSession.setAttribute(“XZproject”, null);

// 清除Session

Enumeration em = request.getSession().getAttributeNames();

while(em.hasMoreElements()){

request.getSession().removeAttribute(em.nextElement().toString());

//将Cookie 中的token 置空

Cookie cookie = new Cookie(“token”, null);

cookie.setPath(“/”);

response.addCookie(cookie);

return “student/login”;

/**

• 查看班级选报信息

*/

@RequestMapping(“/classinfo”)

public String classinfo(Model model,HttpSession httpSession) {

Student student = (Student) request.getSession().getAttribute(“student”);

removeSession();

List list = adminService.select_student(null, null, student.getIdClass(), null, null);

System.out.println(list);

model.addAttribute(“list”, list);

return “student/classinfo”;

/**

• 查看课题

*/

@RequestMapping(“/topics”)

public String Topics(Model model,HttpSession httpSession) {

Student student = (Student) request.getSession().getAttribute(“student”);

removeSession();

List topicsinfolist = topicsService.topics(student.getIdClass());

System.out.println(topicsinfolist);

model.addAttribute(“topicsinfolist”, topicsinfolist);

return “student/topicsinfo”;

/**

• 课题具体信息

*/

@RequestMapping(“/topicsto”)

public String Topicsto(Long project_id,int selectFlag,String projectName, Model model, HttpSession httpSession) {

List topicstos = topicsService.topicsinfo(project_id);

Student student = (Student) request.getSession().getAttribute(“student”);

Long flag = topicsService.state(student);

Long flagto = topicsService.flag(project_id);

if (flagto != 0) {

flag = 3L;

model.addAttribute(“selectFlag”,selectFlag);

model.addAttribute(“flag”, flag);

model.addAttribute(“topicstos”, topicstos);

model.addAttribute(“projectName”, projectName);

model.addAttribute(“project_id”, project_id);

model.addAttribute(“XZproject”, httpSession.getAttribute(“XZproject”));

return “student/topicsinfoto”;

/**

• 选报课题

*/

@Autowired

SubjectselectedMapper subjectselectedMapper;

@RequestMapping(“/enroll”)

@ResponseBody

public String enroll(Long project_id, HttpSession httpSession) {

String projectName = topicsService.selectprojectname(project_id);

Student student = (Student) request.getSession().getAttribute(“student”);

List subjectselected = subjectselectedMapper.selectBystudentid(student.getId());

if(subjectselected.size() == 0){

studentService.updateselectnumAdd(projectName);

topicsService.insertproject(projectName, student.getId());

httpSession.setAttribute(“XZproject”, projectName);

return “200”;

}else {

return “201”;

/**

• 取消选报

*/

@RequestMapping(“/cancel”)

@ResponseBody()

public String cancel(Long project_id, Model model, HttpSession httpSession) {

System.out.println(1);

String projectName = topicsService.selectprojectname(project_id);

Student student = (Student) request.getSession().getAttribute(“student”);

List subjectselected = subjectselectedMapper.selectBystudentid(student.getId());

if (subjectselected != null && subjectselected.size() != 0 && subjectselected.get(0).getStuselectFlag() != 3

&& project_id.equals(subjectselected.get(0).getIdProject())) {

topicsService.deleteprojectselectedid(student.getId());

httpSession.removeAttribute(“XZproject”);

model.addAttribute(“XZproject”, null);

httpSession.setAttribute(“XZproject”, null);

studentService.updateselectnumReduce(projectName);

return “200”;

} else {

return “203”;

/**

• 清除session中存的项目名

*/

public void removeSession(){

Student student = (Student) request.getSession().getAttribute(“student”);

Subject project = indexService.indexinfo(student.getId());

if(project==null){

request.getSession().removeAttribute(“XZproject”);

教师管理控制层：

@Authority(roles = {Role.TEACHER})

@Controller

@RequestMapping(“/teacher”)

public class TeacherController {

@Autowired

TeacherService teacherService;

@Autowired

SubjectService subjectService;

@RequestMapping(value = {“”, “/loginPage”})

public String loginPage() {

return “teacher/login”;

@GetMapping(“/index”)

public String homePage() {

return “teacher/public-teacher-index”;

@GetMapping(“/updatePwd”)

public String updatePwd() {

return “teacher/teacherInfo/updatePwd”;

@GetMapping(“/teacherInfo”)

public String teacherInfo() {

return “teacher/teacherInfo/teacherinfo”;

@GetMapping(“/modifyinfo”)

public String modifyInfo() {

return “teacher/teacherInfo/updateinfo”;

@GetMapping(“/workapprovalinfo”)

public String workInfo() {

return “teacher/workapproval/winfo”;

@GetMapping(“/workapprovaldata”)

public String workData() {

return “teacher/workapproval/wdata”;

@GetMapping(“/seeworkdata”)

public String seeWorkData() {

return “teacher/workapproval/seewdata”;

//填写表格页面

@GetMapping(“/term_debriefing”)

public String termDebriefing() {

return “teacher/fillouttable/termdebriefing”;

@GetMapping(“/year_debriefing”)

public String yearDebriefing() {

return “teacher/fillouttable/yeardebriefing”;

@GetMapping(“/annual_assessment”)

public String annualAssessment() {

return “teacher/fillouttable/annualassessment”;

@GetMapping(“/work_load”)

public String workLoad() {

return “teacher/fillouttable/workload”;

@GetMapping(“/technical_personnel”)

public String technicalPersonnel() {

return “teacher/fillouttable/technicalpersonnel”;

@GetMapping(“/term_business”)

public String termBusiness() {

return “teacher/fillouttable/termbusiness”;

//查看表格页面

@GetMapping(“/show_year_debriefing”)

public String showYearDebriefing() {

return “teacher/showtable/yeardebriefing”;

@GetMapping(“/show_term_debriefing”)

public String showTermDebriefing() {

return “teacher/showtable/termdebriefing”;

@GetMapping(“/show_annual_assessment”)

public String showAnnualAssessment() {

return “teacher/showtable/annualassessment”;

@GetMapping(“/show_technical_personnel”)

public String showTechnicalPersonnel() {

return “teacher/showtable/technicalpersonnel”;

@GetMapping(“/show_workload”)

public String showWorkLoad() {

return “teacher/showtable/workload”;

@GetMapping(“/exit”)

public String exit(HttpServletResponse response) {

//将Cookie 中的token 置空

Cookie cookie = new Cookie(“token”, null);

cookie.setPath(“/”);

response.addCookie(cookie);

return “redirect:/”;

//打印页面

@GetMapping(“/print_term_debriefing”)

public String printYearDebriefing(Long year, String term, Model model) {

model.addAttribute(“year”, year);

model.addAttribute(“term”, term);

return “teacher/showtable/print/termdebriefing”;

@GetMapping(“/print_year_debriefing”)

public String printTermDebriefing(Long year, Model model) {

model.addAttribute(“year”, year);

return “teacher/showtable/print/yeardebriefing”;

@GetMapping(“/login”)

@ResponseBody

public Msg login(String name, String pwd, HttpSession httpSession, HttpServletResponse response) throws ParseException {

name = name.trim();

int flag = teacherService.teacherDL(name, pwd);

if (flag == 200) {

User user = new User();

//-1表示为超管

user.setId(0L);

user.setRole(“teacher”);

user.setUserName(name);

//生成Token 存到 Cookie

Cookie cookie = new Cookie(“token”, TokenUtil.createToken(

user

));

//该Cookie无法被js读取

cookie.setHttpOnly(true);

cookie.setPath(“/”);

response.addCookie(cookie);

Teacher teacher = teacherService.selectTeacher(name);

httpSession.setAttribute(“teacherInfo”, teacher);

httpSession.setMaxInactiveInterval(3600);

return Msg.success().add(“info”, flag);

//教师信息修改

//修改教师密码

@PostMapping(“/teacherupdetpwd”)

@ResponseBody

public Msg fun6(String oldpwd, String newpwd, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

int flag = teacherService.teacherUpdetpwd(teacher.getUsername(), oldpwd, newpwd);

return Msg.success().add(“flag”, flag);

//修改教师信息

@PostMapping(“/teacherupdeteinfo”)

@ResponseBody

public Msg updateinfo(String name, String gender, HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

teacher.setName(name);

teacher.setGender(gender);

teacherService.teacherupdateInfo(teacher);

return Msg.success();

//教师出差模块

//查询所有教师出差申请信息

@GetMapping(“/select_work_all”)

@ResponseBody

public Msg fun1(HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

List list = teacherService.selectTeacherWorkAll(teacher.getId());

return Msg.success().add(“workinfo”, list);

//查询申请成功教师出差申请

@GetMapping(“/select_work_success”)

@ResponseBody

public Msg fun2(HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

List list = teacherService.selectWorkSuccess(teacher.getId());

return Msg.success().add(“workinfo”, list);

//查询申请失败教师出差申请

@GetMapping(“/select_work_failed”)

@ResponseBody

public Msg fun3(HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

List list = teacherService.selectWorkFailed(teacher.getId());

return Msg.success().add(“workinfo”, list);

//查询已提交教师出差申请

@GetMapping(“/select_work_submitted”)

@ResponseBody

public Msg fun4(HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

List list = teacherService.selectWorkSubmitted(teacher.getId());

return Msg.success().add(“workinfo”, list);

//删除申请失败的教师出差

@PostMapping(“/delete_work”)

@ResponseBody

public Msg deleteWork(Long id) {

teacherService.deleteWorkById(id);

return Msg.success();

//加载报告填写页面

@GetMapping(“/fillworkapproval”)

public String fun5(Long id, Model model) throws ParseException {

WorkapprovalWithBLOBs workapproval = teacherService.selectWorkById(id);

SimpleDateFormat sdf = new SimpleDateFormat(“yyyy/MM/dd”);

String start = sdf.format(workapproval.getBeginDate());

String end = sdf.format(workapproval.getEndDate());

String time = start + " - " + end;

model.addAttribute(“workapproval”, workapproval);

model.addAttribute(“time”, time);

return “teacher/workapproval/fillwdata”;

//上传出差报告

@PostMapping(“/fill_in_w”)

@ResponseBody

public Msg fun7(@RequestParam(“id_work”) Long idWork, @RequestParam(“news”) String news, @RequestParam(“flag”) Integer flag,

@RequestParam(“file”) MultipartFile file) throws IOException {

//判断file的值是否为空

if (file.isEmpty()) {

return Msg.error();

String fileName = file.getOriginalFilename();// 获取上传文件的原名

int size = (int) file.getSize();

System.out.println(fileName + “–>” + size);

File path = new File(ResourceUtils.getURL(“target”).getPath());

String savePath = path.getAbsolutePath() + “\classes\static\model”;

String saveFileName = savePath + “\” + fileName;

// String path = “D:/test”;//文件保存路径

File targetFile = new File(savePath);

if (!targetFile.getParentFile().exists()) { //判断文件父目录是否存在

targetFile.getParentFile().mkdir();

file.transferTo(new File(targetFile, fileName)); // 开始接受文件

Workapprovaldata workapprovaldata = new Workapprovaldata();

workapprovaldata.setIdWorkapproval(idWork);

workapprovaldata.setNews(news);

workapprovaldata.setDatarar(saveFileName);

//flag == 0 公有 flag == 1私有

workapprovaldata.setFlag(flag);

teacherService.insertWordData(workapprovaldata);

return Msg.success();

//查看出差报告

@GetMapping(“/select_work_data”)

@ResponseBody

public Msg fun8(Integer pn, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

PageHelper.startPage(pn, 9);

List list = teacherService.selectWorkData(teacher.getIdSection());

PageInfo page = new PageInfo(list, 5);

return Msg.success().add(“dataInfo”, page);

//出差附件下载

@RequestMapping(value = “/file_download”)

public ResponseEntity downloadFile(String dataId, HttpServletRequest req, HttpServletResponse response) throws IOException {

Workapprovaldata workapprovaldata = null;

if (dataId != null) {

Long id = Long.valueOf(dataId);

workapprovaldata = teacherService.selectWorkDataById(id);

if (workapprovaldata != null) {

String filePath = workapprovaldata.getDatarar();

//设置文件路径

File file = new File(filePath);

if (!file.exists()) {

file.mkdirs();

String fileName = file.getName();

HttpHeaders headers = new HttpHeaders();

headers.setContentType(MediaType.MULTIPART_FORM_DATA);

String encodeFilename = URLEncoder.encode(fileName, StandardCharsets.UTF_8.toString());

headers.setContentDispositionFormData(“attachment”, encodeFilename);

return new ResponseEntity(FileUtils.readFileToByteArray(file),

headers, HttpStatus.CREATED);

return null;

//学期述职

@PostMapping(“/upload_term_debriefing”)

@ResponseBody

public Msg fun9(String year, String term, String teachingTask, String scientificResearch,

String otherWork, String winAward, String summary, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

DebriefingWithBLOBs debriefingWithBLOBs = new DebriefingWithBLOBs();

debriefingWithBLOBs.setIdTeacher(teacher.getId());

debriefingWithBLOBs.setYear(Long.parseLong(year));

debriefingWithBLOBs.setTerm(term);

debriefingWithBLOBs.setTeachingtask(teachingTask);

debriefingWithBLOBs.setAchievementsinscientificresearch(scientificResearch);

debriefingWithBLOBs.setOtherwork(otherWork);

debriefingWithBLOBs.setWinaward(winAward);

debriefingWithBLOBs.setSummary(summary);

int flag = teacherService.selectTermDebriefingFlag(teacher.getId(), Long.parseLong(year), term);

if (flag == 1) {

teacherService.updateTermDebriefing(debriefingWithBLOBs);

} else {

int i = teacherService.insertTermDebriefing(debriefingWithBLOBs);

return Msg.success();

// 工作量表相关

@GetMapping(“/wordload”)

public String wordloadPage() {

return “teacher/table/workload”;

@GetMapping(“/wordloadData”)

@ResponseBody

public Msg wordloadData(

@RequestParam(“year”) String year,

@RequestParam(“trem”) String trem

) {

Teacher teacher = (Teacher) request.getSession().getAttribute(“teacherInfo”);

return Msg.success()

.add(“teacher”, teacher)

.add(“workloadDTO”, teacherService.getWorkload(teacher.getId(), year, trem));

private static final Logger LOGGER = LoggerFactory.getLogger(TeacherController.class);

@Autowired

HttpServletRequest request;

@PostMapping(“/wordload”)

@ResponseBody

public Msg wordloadSave(

@RequestBody WorkloadDTO workloadDTO

) {

Teacher teacher = (Teacher) request.getSession().getAttribute(“teacherInfo”);

// LOGGER.info(“{}”,workloadDTO);

teacherService.saveWorkload(workloadDTO, teacher);

return Msg.success();

// 教师业务表

@GetMapping(“/business”)

public String businessPage() {

return “teacher/table/business”;

@GetMapping(“/businessData”)

@ResponseBody

public Msg businessData(

@RequestParam(“year”) String year,

@RequestParam(“trem”) String trem

) {

Teacher teacher = (Teacher) request.getSession().getAttribute(“teacherInfo”);

return teacherService.getBusiness(teacher.getId(), year, trem)

.add(“teacher”, teacher);

@PostMapping(“/business”)

@ResponseBody

public Msg saveBusiness(

@RequestBody BusinessDTO businessDTO

) {

Teacher teacher = (Teacher) request.getSession().getAttribute(“teacherInfo”);

return Msg.sqlChange((int) teacherService.saveBusiness(businessDTO, teacher));

//年度述职

@PostMapping(“/upload_year_debriefing”)

@ResponseBody

public Msg fun10(String year, String teachingTask, String scientificResearch,

String otherWork, String winAward, String summary, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

DebriefingYearWithBLOBs debriefingYear = new DebriefingYearWithBLOBs();

debriefingYear.setIdTeacher(teacher.getId());

debriefingYear.setYear(Long.parseLong(year));

debriefingYear.setTeachingtask(teachingTask);

debriefingYear.setAchievementsinscientificresearch(scientificResearch);

debriefingYear.setOtherwork(otherWork);

debriefingYear.setWinaward(winAward);

debriefingYear.setSummary(summary);

Long flag = teacherService.selectYearDebriefingFlag(teacher.getId(), Long.parseLong(year));

if (flag == 1) {

teacherService.updateYearDebriefing(debriefingYear);

} else {

int i = teacherService.insertYearDebriefing(debriefingYear);

return Msg.success();

//查询年度述职中年份

@GetMapping(“/select_debriefing_year”)

@ResponseBody

public Msg fun11() {

List list = teacherService.selectDebriefingByYear();

// 把年份排序

Collections.sort(list, new Comparator() {

@Override

public int compare(DebriefingYear o1, DebriefingYear o2) {

return (int) (o2.getYear() - o1.getYear());

});

return Msg.success().add(“year”, list);

//查询指定年份的年度述职信息

@GetMapping(“/select_debriefing_year_info”)

@ResponseBody

public Msg fun12(Long year, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

DebriefingYearWithBLOBs debriefingYear = teacherService.selectYearDebriefingInfo(teacher.getId(), year);

return Msg.success().add(“debriefingInfo”, debriefingYear);

//查询学期述职中年份

@GetMapping(“select_debriefing_term”)

@ResponseBody

public Msg fun13() {

List list = teacherService.selectDebriefingTermByYear();

List temp = new ArrayList<>();

//去除重复的年份

for (Debriefing s : list) {

if (!temp.contains(s.getYear())) {

temp.add(s.getYear());

return Msg.success().add(“year”, temp);

//查询指定年份的学期述职信息

@GetMapping(“/select_debriefing_term_info”)

@ResponseBody

public Msg fun14(Long year, String term, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

DebriefingWithBLOBs debriefing = teacherService.selectTermDebriefingInfo(teacher.getId(), year, term);

return Msg.success().add(“debriefingInfo”, debriefing);

//年度考核

@PostMapping(“/upload_annual_assessment”)

@ResponseBody

public Msg fun15(String personalSummary, String year, String remark, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

AnnualAssessmentWithBLOBs assessment = new AnnualAssessmentWithBLOBs();

assessment.setIdTeacher(teacher.getId());

assessment.setPersonalsummary(personalSummary);

assessment.setYear(year);

assessment.setRemark(remark);

Long flag = teacherService.selectAnnualAssessmentFlag(teacher.getId(), year);

if (flag == 1) {

int i = teacherService.updateAnnualAssessment(assessment);

} else {

int i = teacherService.insertAnnualAssessment(assessment);

return Msg.success();

//年度专业技术人员考核表

@PostMapping(“/upload_technical_personnel”)

@ResponseBody

public Msg fun16(String year, String mainAchievements, String attendance, String rewardsAndPunishments, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

TechnicalPersonnelWithBLOBs technicalPersonnelWithBLOBs = new TechnicalPersonnelWithBLOBs();

technicalPersonnelWithBLOBs.setIdTeacher(teacher.getId());

technicalPersonnelWithBLOBs.setYear(year);

technicalPersonnelWithBLOBs.setMainachievements(mainAchievements);

technicalPersonnelWithBLOBs.setAttendance(attendance);

technicalPersonnelWithBLOBs.setRewardsandpunishments(rewardsAndPunishments);

Long flag = teacherService.selectTechnicalPersonnelFlag(teacher.getId(), Long.parseLong(year));

if (flag == 1) {

int i = teacherService.updateTechnicalPersonnel(technicalPersonnelWithBLOBs);

} else {

int i = teacherService.insertTechnicalPersonnel(technicalPersonnelWithBLOBs);

return Msg.success();

//查询年度考核年份

@GetMapping(“/select_annual_assessment”)

@ResponseBody

public Msg fun17(HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

List list = teacherService.selectAnnualAssessmentByYear(teacher.getId());

if (list.isEmpty()) {

return Msg.fail();

} else {

return Msg.success().add(“year”, list);

//查询指定年度考核信息

@GetMapping(“/select_annualassessment_year_info”)

@ResponseBody

public Msg fun18(Long year, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

AnnualAssessmentWithBLOBs assessment = teacherService.selectAnnualAssessmentInfo(teacher.getId(), year);

return Msg.success().add(“assessmentInfo”, assessment);

//查询度专业技术人员考核表年份

@GetMapping(“/select_technical_personnel_year”)

@ResponseBody

public Msg fun18(HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

List list = teacherService.selectTechnicalPersonnelByYear(teacher.getId());

if (list.isEmpty()) {

return Msg.fail();

} else {

return Msg.success().add(“year”, list);

//查询度专业技术人员考核表信息

@GetMapping(“/select_technicalpersonnel_year_info”)

@ResponseBody

public Msg fun19(Long year, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

TechnicalPersonnelWithBLOBs technicalPersonnelWithBLOBs = teacherService.selectTechnicalPersonnelInfo(teacher.getId(), year);

return Msg.success().add(“technicalPersonnel”, technicalPersonnelWithBLOBs);

// 毕业设计内容

// 加载上传课题页面

@GetMapping(“/upload_topic_page”)

public String uploadTopic(ModelMap modelMap, HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

List projecttypes = teacherService.select_allProjecttype();

List projectsources = teacherService.select_allProjectsource();

List specialties = teacherService.select_allSpecialty(teacher.getIdSection());

modelMap.addAttribute(“projecttypes”, projecttypes);

modelMap.addAttribute(“projectsources”, projectsources);

modelMap.addAttribute(“specialties”, specialties);

return “teacher/graduation/upload”;

// 上传课题

@PostMapping(“/up_project”)

@ResponseBody

public Msg fun20(String projectName, Long idProjecttype, Long idProjectsource, String marchspecialty, String teachernames, @RequestParam(“file”) MultipartFile file, HttpServletRequest request, HttpSession httpSession) throws IOException {

if (file == null) {

return Msg.fail().add(“msg”,“文件上传失败”);

if(teacherService.selectProjectByName(projectName).size()>0){

System.out.println(“上传失败”);

return Msg.fail().add(“msg”,“课题名已存在”);

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

ServletContext servletContext = request.getSession().getServletContext();

String uploadFileName = file.getOriginalFilename(); // 获取上传文件的原名

System.out.println(uploadFileName);

uploadFileName = uploadFileName.substring(uploadFileName.lastIndexOf(File.separator) + 1);

System.out.println(uploadFileName);

File path = new File(ResourceUtils.getURL(“target”).getPath());

String savePath =

path.getAbsolutePath() + File.separator+“classes+”+File.separator+“static”

+File.separator+“model”+File.separator + teacher.getId();

String saveFileName = savePath +File.separator + uploadFileName;

File dirs = new File(savePath);

//判断路径是否存在，如果不存在就创建一个

if (!dirs.exists()) {

dirs.mkdirs();

file.transferTo(new File(dirs, uploadFileName)); // 开始接受文件

System.out.println(teachernames);

ProjectWithBLOBs project = new ProjectWithBLOBs();

project.setProjectname(projectName);

project.setIdProjecttype(idProjecttype);

project.setIdProjectsource(idProjectsource);

project.setIdTeacher(teacher.getId());

project.setFilepath(saveFileName);

project.setMarchspecialty(marchspecialty.trim());

project.setTeachernames(teachernames);

project.setSelectcount(0);

project.setSelectFlag(0);

project.setVerifyprojectFlag(0);

project.setReleaseFlag(0);

int i = teacherService.insert_project(project);

return Msg.success();

//查看自己的课题发布记录

@GetMapping(“/cxmyProject”)

public String fun21(ModelMap modelMap, HttpSession httpSession) {

TeacherWithBLOBs teacher = (TeacherWithBLOBs) httpSession.getAttribute(“teacherInfo”);

List projecttypes = teacherService.select_allProjecttype();

List projectsources = teacherService.select_allProjectsource();

List specialties = teacherService.select_allSpecialty(teacher.getIdSection());

modelMap.addAttribute(“projecttypes”, projecttypes);

modelMap.addAttribute(“projectsources”, projectsources);

modelMap.addAttribute(“specialties”, specialties);

List projects = teacherService.selectTeacherProject(teacher.getName());

for (int i = 0; i < projects.size(); i++) {

if (projects.get(i).getVerifyprojectFlag() == 0) projects.get(i).setProjectZT(“未审核”);

else if (projects.get(i).getVerifyprojectFlag() == 1) projects.get(i).setProjectZT(“审核未通过”);

else projects.get(i).setProjectZT(“审核通过”);

modelMap.addAttribute(“Myproject”, projects);

return “teacher/graduation/section_xq/index”;

// 发布或取消发布已审核通过的课题

@PostMapping(“/fb_project”)

@ResponseBody

public String fun8(Long project_id, String pd,HttpSession httpSession) {

int s = Integer.parseInt(pd);

teacherService.updateProjectFB(project_id, s);

if (s == 0) {

teacherService.deleteSelectedAll(project_id);

teacherService.updateProjectCount(project_id);

Map map = new HashMap();

map.put(“pd”, “” + 1);

return JSONObject.toJSONString(map);

@PostMapping(“del_project”)

@ResponseBody

public Msg deleteProject(Long id) {

teacherService.deleteProject(id);

return Msg.success();

@PostMapping(“/updateSubject”)

@ResponseBody

public Msg updateProject(Long id, String projectName, Long idProjecttype, Long idProjectsource, String marchspecialty, String teachernames, @RequestParam(value = “file”, required = false) MultipartFile file, HttpServletRequest request, HttpSession httpSession) throws IOException {

//拼接 teacherNames 字段

TeacherWithBLOBs teacher = (TeacherWithBLOBs) request.getSession().getAttribute(“teacherInfo”);

String teacherName = teacher.getName();

if (teachernames == null || teachernames.trim().length() == 0) {

teachernames = teacherName;

} else {

teachernames = teacherName + “&” + teachernames;

SubjectWithBLOBs subject = null;

//文件大小 为 0 则表示 文件没上传

long size = file.getSize();

//不更新课题文件情况

if (file == null || size == 0) {

subject = new SubjectWithBLOBs();

subject.setId(id);

subject.setProjectname(projectName);

subject.setIdProjecttype(idProjecttype);

subject.setIdProjectsource(idProjectsource);

subject.setMarchspecialty(marchspecialty);

subject.setTeachernames(teachernames);

//修改后状态置 0

subject.setSelectFlag(0);

subject.setVerifyprojectFlag(0);

subject.setReleaseFlag(0);

subjectService.updateSubjectByid(subject);

return Msg.success();

} else {

//获取课题

SubjectWithBLOBs subject1 = subjectService.getSubjectByID(id);

//获取课题路径

String oldPath = subject1.getFilepath();

File oldFile = new File(oldPath);

//如果文件存在则删除

if (oldFile.exists()) {

//删除成功

if (oldFile.delete()) {

} else {

return Msg.fail();

ServletContext servletContext = request.getSession().getServletContext();

String uploadFileName = file.getOriginalFilename(); // 获取上传文件的原名

uploadFileName = uploadFileName.substring(uploadFileName.lastIndexOf(File.separator) + 1);

File path = new File(ResourceUtils.getURL(“target”).getPath());

// String savePath = path.getAbsolutePath() + “\classes\static\model\” + teacher.getId();

// String saveFileName = savePath + “\” + uploadFileName;

String savePath =

path.getAbsolutePath() + File.separator+“classes+”+File.separator+“static”

+File.separator+“model”+File.separator + teacher.getId();

String saveFileName = savePath +File.separator + uploadFileName;

File dirs = new File(savePath);

//判断路径是否存在，如果不存在就创建一个

if (!dirs.exists()) {

dirs.mkdirs();

file.transferTo(new File(dirs, uploadFileName)); // 开始接受文件

SubjectWithBLOBs project = subject1;

project.setProjectname(projectName);

project.setIdProjecttype(idProjecttype);

project.setIdProjectsource(idProjectsource);

project.setFilepath(saveFileName);

project.setMarchspecialty(marchspecialty.trim());

project.setTeachernames(teachernames);

//修改后状态置 0

project.setSelectFlag(0);

project.setVerifyprojectFlag(0);

project.setReleaseFlag(0);

int i = subjectService.updateSubjectByid(project);

return Msg.success();

@GetMapping(“/getSubjectById”)

@ResponseBody

public Msg getss(Long id) {

SubjectWithBLOBs subject = subjectService.getSubjectByID(id);

System.out.println(subject);

subject.setFilepath(subject.getFilepath().substring(subject.getFilepath().lastIndexOf(“\”) + 1));

String[] teachers = subject.getTeachernames().split(“&”);

String teacher2 = “”;

if (teachers.length >= 2) {

teacher2 = teachers[teachers.length - 1];

subject.setTeachernames(teacher2);

return Msg.success()

.add(“subject”, subject)

//查看自己所在教研室的课题发布记录

@GetMapping(“/cxallProject”)

public String fun7(ModelMap modelMap, HttpSession httpSession) {

Teacher teacher = (Teacher) httpSession.getAttribute(“teacherInfo”);

List projects = teacherService.selecSectionProject(teacher.getSectionName());

for (int i = 0; i < projects.size(); i++) {

if (projects.get(i).getVerifyprojectFlag() == 0) projects.get(i).setProjectZT(“未审核”);

else if (projects.get(i).getVerifyprojectFlag() == 1) projects.get(i).setProjectZT(“审核未通过”);

else projects.get(i).setProjectZT(“审核通过”);

modelMap.addAttribute(“allproject”, projects);

return “teacher/graduation/section_xq/subjectinfoto”;

管理员后台管理层：

@Authority(roles = {Role.ADMIN, Role.SADMIN})

@Controller

@RequestMapping(“/admin”)

public class AdminController {

private static final Logger LOGGER = LoggerFactory.getLogger(AdminController.class);

@Autowired

AdminService adminService;

@Autowired

AdminMapper adminMapper;

@Autowired

CollegeService collegeService;

@Autowired

SectionService sectionService;

@Autowired

SpecialtyService specialtyService;

@Autowired

ClassService classService;

@Autowired

TeacherService teacherService;

@Autowired

StudentService studentService;

@Autowired

SubjectService subjectService;

@Autowired

ExcelService excelService;

@Autowired

SubjectRelationStudentMapper subjectRelationStudentMapper;

@Autowired

HttpServletRequest request;

@Autowired

HttpServletResponse response;

@Autowired

HttpSession session;

@ModelAttribute(“id_institute”)

public long getRoleInfo() {

User user = (User) request.getAttribute(“user”);

// LOGGER.info(“USER:{}”,user);

if (user != null) {

if (user.getRole().equals(“admin”)) {

Institute institute = collegeService.selectCollege(adminMapper.selectByPrimaryKey(user.getId()).getIdInstitute());

return institute.getId();

if (user.getRole().equals(“sadmin”)) {

return -1;

return 0;

} else {

return 0;

// admin index page 子管首页

@GetMapping(value = {“”, “/index”})

public String index() {

User user = (User) request.getAttribute(“user”);

// LOGGER.info(“index user:{}”,user);

//这部分还是用了session存储部分信息 后续可能修改

//根据 user的id 判断 渲染页面

if (user.getId() == -1) {

LOGGER.info(“超级管理员登录”);

session.setAttribute(“instituteName”, “超级管理员”);

session.setAttribute(“ROLE”, “sadmin”);

session.setAttribute(“username”, user.getUserName());

return “admin/public-admin-index”;

Institute institute = collegeService.selectCollege(adminMapper.selectByPrimaryKey(user.getId()).getIdInstitute());

System.out.println(institute.getInstituteName());

session.setAttribute(“instituteName”, institute.getInstituteName());

session.setAttribute(“ROLE”, “admin”);

session.setAttribute(“username”, user.getUserName());

return “admin/public-admin-index”;

// exit 退出登录

@GetMapping(“/exit”)

public String exit(HttpSession httpSession) {

//将Cookie 中的token 置空

Cookie cookie = new Cookie(“token”, null);

cookie.setPath(“/”);

response.addCookie(cookie);

return “login”;

// login 在单独Controller

// updatePwd 更新密码

@GetMapping(“/updatePwd”)

public String updatePwd() {

return “admin/updatePwd”;

@PostMapping(“/updatePwd”)

@ResponseBody

public Msg updatePwd(

@RequestBody Admin admin,

HttpSession httpSession) {

User user = (User) request.getAttribute(“user”);

adminService.updatePwdByUserName(

user.getUserName(),

admin.getPwd()

);

return Msg.success();

// 教研室

@GetMapping(“/SectionManagement”)

public String section() {

return “admin/Department/SectionManagement”;

@GetMapping(“/sections”)

@ResponseBody

public Msg getSections(@ModelAttribute(“id_institute”) long id_institute) {

return Msg.success().add(“sections”, sectionService.getSections(id_institute));

@DeleteMapping(“/section”)

@ResponseBody

public Msg delSection(@RequestBody Section section) {

return Msg.sqlChange((int) sectionService.delSection(section));

@PutMapping(“/section”)

@ResponseBody

public Msg updateSection(@RequestBody @Validated Section section, @ModelAttribute(“id_institute”) long id_institute) throws MyException {

return Msg.sqlChange((int) sectionService.updateSection(section, section.getSectionName(), id_institute));

@PostMapping(“/section”)

@ResponseBody

public Msg addSection(@RequestBody @Validated Section section, @ModelAttribute(“id_institute”) long id_institute) {

return Msg.sqlChange((int) sectionService.addSection(section, id_institute));

// 专业方向

@GetMapping(“/SpecialtyManagement”)

public String specialty() {

return “admin/Department/SpecialtyManagement”;

@GetMapping(“/specialtys”)

@ResponseBody

public Msg getSpecialtys(

@RequestParam Integer offset,

@RequestParam(required = false) Long sectionId,

@RequestParam(required = false) String keyWord,

@ModelAttribute(“id_institute”) long id_institute) {

long total = specialtyService.getSpecialtyCount(offset, keyWord, sectionId, id_institute);

return Msg.success()

.add(“specialtys”, specialtyService.getSpecialtys(offset, keyWord, sectionId, id_institute))

.add(“total”, total);

@ResponseBody

@DeleteMapping(“/specialty”)

public Msg delSpecialty(

@RequestBody Specialty specialty,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) specialtyService.delSpecialty(specialty, id_institute));

@ResponseBody

@PutMapping(“/specialty”)

public Msg putSpecialty(

@RequestBody @Validated({Update.class}) Specialty specialty,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) specialtyService.putSpecialty(specialty, id_institute));

@ResponseBody

@PostMapping(“/specialty”)

public Msg postSpecialty(

@RequestBody @Validated({Add.class}) Specialty specialty,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) specialtyService.postSpecialty(specialty, id_institute));

// 班级

@GetMapping(“/ClassManagement”)

public String Class() {

return “admin/Department/ClassManagement”;

// //获取管理员的 学院id

// public static Long getIdInstitute(ModelMap modelMap) {

// Subadmin subadmin = (Subadmin) modelMap.get(“admin”);

// return subadmin.getIdInstitute();

// }

@ResponseBody

@GetMapping(“/classes”)

public Msg getClasses(

@RequestParam(“offset”) Integer offset,

@RequestParam(required = false) Long specialtyId,

@RequestParam(required = false) String keyWord,

@ModelAttribute(“id_institute”) long id_institute) {

long total = classService.getClassesCount(offset, keyWord, specialtyId, id_institute);

return Msg.success()

.add(“classes”, classService.getClasses(offset, keyWord, specialtyId, id_institute))

.add(“total”, total);

@ResponseBody

@DeleteMapping(“/class”)

public Msg delClass(

@RequestBody MyClass myClass,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) classService.delClass(myClass, id_institute));

@ResponseBody

@PutMapping(“/class”)

public Msg putClass(

@RequestBody @Validated({One.class}) MyClass myClass,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) classService.putClass(myClass, id_institute));

@ResponseBody

@PostMapping(“/class”)

public Msg postClass(

@RequestBody @Validated({One.class}) MyClass myClass,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) classService.postClass(myClass, id_institute));

// 课题综合管理

@GetMapping(“/SourceManagement”)

public String source() {

return “admin/Subject/SourceManagement”;

@ResponseBody

@GetMapping(“/sources”)

public Msg getSources() {

return Msg.success().add(“sources”, subjectService.selectSubjectSources());

@ResponseBody

@PostMapping(“/source”)

public Msg addSource(@RequestBody @Validated SubjectSource source) throws MyException {

return Msg.sqlChange((int) subjectService.insertSubjectSource(source.getSourcename()));

@ResponseBody

@DeleteMapping(“/source”)

public Msg delSource(@RequestBody SubjectSource source) throws MyException {

return Msg.sqlChange(subjectService.delSubjectSource(source.getId()));

@ResponseBody

@PutMapping(“/source”)

public Msg updateSource(@RequestBody @Validated SubjectSource source) {

return Msg.sqlChange(subjectService.updateSubjectSource(source));

//课题类型

@GetMapping(“/TypeManagement”)

public String subjectType() {

return “admin/Subject/TypeManagement”;

@ResponseBody

@GetMapping(“/sujecttypes”)

public Msg getType() {

return Msg.success().add(“sujecttypes”, subjectService.selectSubjectTypes());

@ResponseBody

@PostMapping(“/sujecttype”)

public Msg addType(@RequestBody @Validated SubjectType type) throws MyException {

return Msg.sqlChange((int) subjectService.insertSubjectType(type.getTypename()));

@ResponseBody

@DeleteMapping(“/sujecttype”)

public Msg delType(@RequestBody SubjectType type) throws MyException {

return Msg.sqlChange(subjectService.delSubjectType(type.getId()));

@ResponseBody

@PutMapping(“/sujecttype”)

public Msg updateType(@RequestBody @Validated SubjectType type) {

return Msg.sqlChange(subjectService.updateSubjectType(type));

//课题管理

@GetMapping(“/SubjectManagement”)

public String Subject() {

return “admin/Subject/SubjectManagement”;

@ResponseBody

@GetMapping(“/subjects”)

public Msg getSubjects(

@RequestParam Integer offset,

@RequestParam(required = false) Long sectionId,

@RequestParam(required = false) String keyWord,

@ModelAttribute(“id_institute”) long id_institute) {

long total = subjectService.selectSubjectsCount(offset, keyWord, sectionId, id_institute);

return Msg.success()

.add(“subjects”, subjectService.selectSubjects(offset, keyWord, sectionId, id_institute))

.add(“total”, total);

@ResponseBody

@PostMapping(“/subject”)

public Msg addSubject(

@RequestBody @Validated(Add.class) SubjectWithBLOBs subject,

@ModelAttribute(“id_institute”) long id_institute) throws MyException {

return Msg.sqlChange((int) subjectService.insertSubject(subject, id_institute));

@ResponseBody

@DeleteMapping(“/subject”)

public Msg delSubject(

@RequestBody SubjectWithBLOBs subject,

@ModelAttribute(“id_institute”) long id_institute) throws MyException {

return Msg.sqlChange(subjectService.delSubject(subject, id_institute));

@ResponseBody

@PutMapping(“/subject”)

public Msg updateSubject(

@RequestBody @Validated(Update.class) SubjectWithBLOBs subject,

@ModelAttribute(“id_institute”) long id_institute) throws MyException {

return Msg.sqlChange(subjectService.updateSuject(subject, id_institute));

//get学生选题的状态

@GetMapping(“/SRS”)

@ResponseBody

public Msg getSelectSubjected(

@ModelAttribute(“id_institute”) long id_institute

) {

System.out.println(subjectService.getSelectSubjected(null, id_institute));

return Msg.success().add(“SRS”, subjectService.getSelectSubjected(null, id_institute));

//get 选某个课题的所有学生

@GetMapping(“/studentsBySubject”)

@ResponseBody

public Msg getStuentBySubject(

@RequestParam(“id”) Long id,

@ModelAttribute(“id_institute”) long id_institute

) {

return subjectService.getStuentBySubject(id, id_institute);

// 教师管理 增删改查

@GetMapping(“/TeacherManagement”)

public String teacher() {

return “admin/BasicInfo/TeacherManagement”;

@ResponseBody

@GetMapping(“/teachers”)

public Msg getTeachers(

@RequestParam Integer offset,

@RequestParam(required = false) Long sectionId,

@RequestParam(required = false) String keyWord,

@ModelAttribute(“id_institute”) long id_institute) {

long total = teacherService.selectTeachersCount(offset, keyWord, sectionId, id_institute);

return Msg.success()

.add(“teachers”, teacherService.selectTeachers(offset, keyWord, sectionId, id_institute))

.add(“total”, total);

@ResponseBody

@DeleteMapping(“/teacher”)

public Msg delTeacher(

@RequestBody TeacherWithBLOBs teacher,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) teacherService.delTeacher(teacher, id_institute));

@ResponseBody

@PostMapping(“/teacher”)

public Msg addTeacher(

@RequestBody @Validated(Add.class) TeacherWithBLOBs teacher,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) teacherService.addTeacher(teacher, id_institute));

@ResponseBody

@PutMapping(“/teacher”)

public Msg updateTeacher(

@RequestBody @Validated({Update.class}) TeacherWithBLOBs teacher,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) teacherService.updateTeacher(teacher, id_institute));

//教师批量教师导入

@PostMapping(“/TeacherExcel”)

@ResponseBody

public Msg addTeacherExcel(

@RequestParam(“excel”) MultipartFile excelFile,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException, IOException {

return excelService.teacherExcelImport(excelFile, id_institute);

//教师批量导入模板

@GetMapping(“/TeacherExcelDemo”)

public void getTeacherExcelDemo(HttpServletResponse response) throws IOException {

excelService.teacherExcelDownload(response);

// 学生管理

@GetMapping(“/StudentManagement”)

public String student() {

return “admin/BasicInfo/StudentManagement”;

@ResponseBody

@GetMapping(“/students”)

public Msg getStudents(

@RequestParam Integer offset,

@RequestParam(required = false) Long classId,

@RequestParam(required = false) Long specialtyId,

@RequestParam(required = false) String keyWord,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

long total = studentService.selectStudentsCount(offset, keyWord, classId, specialtyId, id_institute);

return Msg.success()

.add(“students”, studentService.selectStudents(offset, keyWord, classId, specialtyId, id_institute))

.add(“total”, total);

@ResponseBody

@DeleteMapping(“/student”)

public Msg delStudent(

@RequestBody StudentWithBLOBs student,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) studentService.delStudent(student, id_institute));

@ResponseBody

@PostMapping(“/student”)

public Msg addStudent(

@RequestBody @Validated(Add.class) StudentWithBLOBs student,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) studentService.addStudent(student, id_institute));

@ResponseBody

@PutMapping(“/student”)

public Msg updateStudent(

@RequestBody @Validated({Update.class}) StudentWithBLOBs student,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException {

return Msg.sqlChange((int) studentService.updateStudent(student, id_institute));

// 批量导入模板

@GetMapping(“/StudentExcelDemo”)

public void getStudentExcelDemo(HttpServletResponse response) throws IOException {

excelService.studentExcelDownload(response);

//批量学生导入

@PostMapping(“/StudentExcel”)

@ResponseBody

public Msg addStudentExcel(

@RequestParam(“excel”) MultipartFile excelFile,

@ModelAttribute(“id_institute”) long id_institute

) throws MyException, IOException {

return excelService.studentExcelImport(excelFile, id_institute);

// 生成一览表

//课题一览表

@GetMapping(“/SubjectExcel”)

public void getSubjectExcel(

HttpServletResponse response,

HttpServletRequest request,

@ModelAttribute(“id_institute”) long id_institute) throws IOException {

excelService.subjectExcelDownload(response, request, id_institute);

创作打卡挑战赛

赢取流量/现金/CSDN周边激励大奖

---