本周完成的后端api

目录

科目管理

公告管理

教师管理

---

科目管理

package com.mwt.oes.controller;

import com.mwt.oes.domain.ProgramingLanguage;
import com.mwt.oes.service.AdminSubjectService;
import com.mwt.oes.util.ServerResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;
import java.util.Map;

@CrossOrigin
@RestController
@RequestMapping("/api/admin")
public class AdminSubjectController {
    @Autowired
    private AdminSubjectService adminSubjectService;

    //    获取全部科目信息
    @RequestMapping("/getSubjectsList")
    public ServerResponse getSubjectsList(){
        List<Map<String, Object>> resultList = adminSubjectService.getSubjectsList();
        return ServerResponse.createBySuccess("获取全部科目信息成功",resultList);
    }

    //    获取搜索科目信息
    @RequestMapping("/searchSubjectsList")
    public ServerResponse searchSubjectsList(@RequestParam("langName")String langName,
                                             @RequestParam("langDesc")String langDesc,
                                             @RequestParam("langCreatedBy")String langCreatedBy,
                                             @RequestParam("isRecommend")String isRecommend){
        List<Map<String, Object>> resultList = adminSubjectService.searchSubjectsList(langName, langDesc, langCreatedBy, isRecommend);
        return ServerResponse.createBySuccess("获取搜索科目信息成功",resultList);
    }

    //    添加科目信息
    @RequestMapping(value = "/insertSubjectInfo",method = RequestMethod.POST)
    public ServerResponse insertSubjectInfo(@RequestBody(required = false)ProgramingLanguage programingLanguage){
        int result = adminSubjectService.insertSubjectInfo(programingLanguage);
        if (result > 0){
            return ServerResponse.createBySuccess("添加科目信息成功",null);
        }
        else {
            return ServerResponse.createByError("数据库错误，添加科目信息失败");
        }
    }

    //    更新科目信息
    @RequestMapping(value = "/updateSubjectInfo",method = RequestMethod.POST)
    public ServerResponse updateSubjectInfo(@RequestBody(required = false)ProgramingLanguage programingLanguage){
        int result = adminSubjectService.updateSubjectInfo(programingLanguage);
        if (result > 0){
            return ServerResponse.createBySuccess("更新科目信息成功",null);
        }
        else {
            return ServerResponse.createByError("数据库错误，更新科目信息失败");
        }
    }

    //  删除科目信息
    @RequestMapping(value = "/deleteSubject",method = RequestMethod.POST)
    public ServerResponse deleteSubject(@RequestBody Map<String, Object> obj){
        Integer langId = (Integer) obj.get("langId");
        int result = adminSubjectService.deleteSubject(langId);
        if(result > 0){
            return ServerResponse.createBySuccess("删除成功",null);
        } else {
            return ServerResponse.createByError("数据库错误，删除失败");
        }
    }
}

公告管理

package com.mwt.oes.controller;

import com.mwt.oes.domain.TeacherNotice;
import com.mwt.oes.service.TeacherNoticeService;
import com.mwt.oes.util.ServerResponse;
import com.mwt.oes.websocket.WebSocketDemo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.io.IOException;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;

@CrossOrigin
@RestController
@RequestMapping("/api/teacher")
public class TeacherNoticeController {
    @Autowired
    private TeacherNoticeService teacherNoticeService;

    //    获取公告列表信息
    @RequestMapping("/getNoticesList")
    public ServerResponse getNoticesList(){
        List<Map<String, Object>> resultList = teacherNoticeService.getNoticesList();
        return ServerResponse.createBySuccess("获取全部公告信息成功",resultList);
    }

    //    获取搜索公告列表信息
    @RequestMapping("/searchNoticesList")
    public ServerResponse searchNoticesList(@RequestParam("noticeContent")String noticeContent,
                                            @RequestParam("teaName")String teaName){
        List<Map<String, Object>> resultList = teacherNoticeService.searchNoticeInfo(noticeContent, teaName);
        return ServerResponse.createBySuccess("获取搜索公告信息成功",resultList);
    }

    //    更新公告信息
    @RequestMapping(value = "/updateNoticeInfo",method = RequestMethod.POST)
    public ServerResponse updateNoticeInfo(@RequestBody(required = false)TeacherNotice teacherNotice){
        int result = teacherNoticeService.updateNoticeInfo(teacherNotice);
        if (result > 0){
            return ServerResponse.createBySuccess("更新公告信息成功",null);
        }
        else {
            return ServerResponse.createByError("数据库错误，更新公告信息失败");
        }
    }

    //    添加公告信息
    @RequestMapping(value = "/insertNoticeInfo",method = RequestMethod.POST)
    public ServerResponse insertNoticeInfo(@RequestBody(required = false)TeacherNotice teacherNotice) throws IOException {
        boolean noticeContentIsExist = teacherNoticeService.noticeContentIsExist(teacherNotice.getNoticeContent());
        if(noticeContentIsExist){
            return ServerResponse.createByError("此公告内容已存在，请创新新的公告内容");
        }

        teacherNotice.setNoticeCreateTime(new Date());
        int result = teacherNoticeService.insertNoticeInfo(teacherNotice);
        if (result > 0){
            // 插入公告时向学生推送消息
            ConcurrentHashMap<String, WebSocketDemo> webSocketSet = WebSocketDemo.getWebSocketDemo();
            for (String key : webSocketSet.keySet()) {
                if (key.length() == 12) {
                    webSocketSet.get(key).sendMessage("公告");
                }
            }
            return ServerResponse.createBySuccess("插入公告信息成功",null);
        }
        else {
            return ServerResponse.createByError("数据库错误，插入公告信息失败");
        }
    }

    //  删除公告信息
    @RequestMapping(value = "/deleteNotice",method = RequestMethod.POST)
    public ServerResponse deleteScore(@RequestBody Map<String, Object> obj) throws IOException {
        Integer noticeId = (Integer) obj.get("noticeId");
        int result = teacherNoticeService.deleteNotice(noticeId);
        if(result > 0){
            // 删除公告时向学生推送消息
            ConcurrentHashMap<String, WebSocketDemo> webSocketSet = WebSocketDemo.getWebSocketDemo();
            for (String key : webSocketSet.keySet()) {
                if (key.length() == 12) {
                    webSocketSet.get(key).sendMessage("公告");
                }
            }
            return ServerResponse.createBySuccess("删除成功",null);
        } else {
            return ServerResponse.createByError("数据库错误，删除失败");
        }
    }
}

教师管理

package com.mwt.oes.controller;

import com.mwt.oes.domain.Teacher;
import com.mwt.oes.service.AdminTeacherService;
import com.mwt.oes.util.ServerResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;
import java.util.Map;

@CrossOrigin
@RestController
@RequestMapping("/api/admin")
public class AdminTeacherController {

    @Autowired
    private AdminTeacherService adminTeacherService;

    // 添加导入教师信息Excel文件
    @RequestMapping(value = "/insertTeacherInfoList",method = RequestMethod.POST)
    public ServerResponse insertTeacherInfoList(@RequestBody Map<String, Object> obj){
        List<Map<String, Object>> teacherList = (List<Map<String, Object>>) obj.get("teacherList");
        Map<String, Object> result = adminTeacherService.insertTeacherInfoList(teacherList);
        return ServerResponse.createBySuccess("文件上传成功",result);
    }

    //    获取教师列表信息
    @RequestMapping("/getTeachersList")
    public ServerResponse getTeachersList(){
        List<Teacher> resultList = adminTeacherService.getTeachersList();
        return ServerResponse.createBySuccess("获取全部教师信息成功",resultList);
    }
    //    更新教师信息
    @RequestMapping(value = "/updateTeacherInfo",method = RequestMethod.POST)
    public ServerResponse updateTeacherInfo(@RequestBody(required = false)Teacher teacher){
        int result = adminTeacherService.updateTeacherInfo(teacher);
        if (result > 0){
            return ServerResponse.createBySuccess("更新教师信息成功",null);
        }
        else {
            return ServerResponse.createByError("数据库错误，更新教师信息失败");
        }
    }

    //    获取搜索教师列表信息
    @RequestMapping("/searchTeacherInfo")
    public ServerResponse searchTeacherInfo(@RequestParam("tno")String tno,
                                            @RequestParam("teaName")String teaName,
                                            @RequestParam("teaSex")String teaSex){
        List<Teacher> resultList = adminTeacherService.searchTeacherInfo(tno, teaName, teaSex);
        return ServerResponse.createBySuccess("获取搜索教师信息成功",resultList);
    }

    //    添加教师信息
    @RequestMapping(value = "/insertTeacherInfo",method = RequestMethod.POST)
    public ServerResponse insertTeacherInfo(@RequestBody(required = false)Teacher teacher){
        boolean isRegistered = adminTeacherService.tnoIsExist(teacher.getTno());
        if(isRegistered){
            return ServerResponse.createByError("此教工号已被注册");
        }
        int result = adminTeacherService.insertTeacherInfo(teacher);
        if (result > 0){
            return ServerResponse.createBySuccess("插入教师信息成功",null);
        }
        else {
            return ServerResponse.createByError("数据库错误，插入教师信息失败");
        }
    }
}