基于javaweb+mysql的springboot体育器材管理系统(java+springboot+bootstrap+html+mysql)

基于javaweb+mysql的springboot体育器材管理系统(java+springboot+bootstrap+html+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SpringBoot体育器材管理系统(java+springboot+bootstrap+html+mysql)

体育器材管理系统主要包含以下功能： 登录注册； 体育器材管理：显示器材表、显示价目表、显示供应商表； 器材借还管理：借用申请、归还申请； 管理员个人信息：对当前管理员的信息进行查看或修改 器材报废登记：登记报废器材，生成、修改以及导出采购清单

信息录入：用户信息录入以及体育器材信息录入

    public JsonResult<Void> updatePassword(String oldPassword,String newPassword,String phone,String email,HttpSession session){
        String num=getNumFromSession(session);
        managerService.changeInfo(oldPassword,newPassword,num,phone,email);
        return new JsonResult<>(OK);
    }

    @GetMapping("showinfo")
    public JsonResult<Manager> showEmp(HttpSession session){
        return new JsonResult<>(OK,manager.findByNum(getNumFromSession(session)));
    }
    @GetMapping("/delManager")
    public JsonResult<Manager> delManager(Integer num){
        if (num!=null) {
            if (manager.delManager(num) != 1) {
                return new JsonResult<>(50001);
            } else {
                return new JsonResult<>(OK);
            }
        }else {
            return new JsonResult<>(50001);
        }
    }

    /*显示所有员工信息*/
    @RequestMapping("showallemp")
    public JsonResult<List> showAllEmp(Integer page){
        List<Emp> list=managerMapper.findEmpByPage(page);
        for (Emp map : list) {
            System.err.println(map);
        }

        return new JsonResult<List>(OK,list);
    }

    @PostMapping("uploademp")
    public JsonResult<String> uploadEmp(
            @RequestParam("file") MultipartFile file, HttpSession session) {
        // 日志
        System.err.println("导入员工表");

        service.delEmp(id);
        return new JsonResult<>(OK);
    }
    @RequestMapping("/updateEmpById")
    public JsonResult<Void> updateEmp(Emp emp){
        service.updateEmp(emp);
        return new JsonResult<>(OK);
    }
    @RequestMapping("/updateEquById")
    public JsonResult<Void> updateEqu(Equipment equipment){
        service.updateEqu(equipment);
        return new JsonResult<>(OK);
    }

    @RequestMapping("/showlist")
    public JsonResult<List<Equipment>> showlist(Integer page){
        List<Equipment> list=mapper.orderequlist(page);
        for (Equipment map : list) {
            System.err.println(map);
        }
        return new JsonResult<>(OK,list);
    }
    @RequestMapping("/showprice")
    public JsonResult<List<Equipment>> showprice(Integer page){
        System.err.println("showprice执行");
        List<Equipment> list=mapper.pricelist(page);
        for (Equipment map : list) {
            System.err.println(map);
        }
        System.err.println("showprice执行完毕");
        return new JsonResult<>(OK,list);
    }

    @RequestMapping("/showsup")
    public JsonResult<List<Equipment>> showsup(Integer page){
        List<Equipment> list=mapper.suplist(page);
        for (Equipment map : list) {
            System.err.println(map);
        }
        return new JsonResult<>(OK,list);
    }
    @RequestMapping("/showEquHistory")
    public JsonResult<List<Equipment>> showEquHistory(Integer page){
        List<Equipment> list=mapper.equhistory(page);
        for (Equipment map : list) {
            System.err.println(map);

            json.setState(8000);
        }else if(e instanceof PasswordMisMatchException){
            json.setState(9000);
        }else if(e instanceof UpdateException){
            json.setState(10000);
        }else if (e instanceof ReturnOutofNumberException){
            json.setState(12700);
        }
        return json;
    }
}
package com.zm.se.controller;

/**
 * 控制器类的基类，用于封装各控制器都需要使用的常量和方法
 */
public abstract class BaseController {
    /**
     * 成功响应码常量
     */
    public static final Integer OK = 2000;

    /**
     * 从Session中获取当前登陆用户的id
     * @param session   HttpSession对象
     * @return  当前登录用户的id
     */
    protected  final Integer getMidFromSession(HttpSession session){

        return  Integer.valueOf(session.getAttribute("mid").toString());
    }

    /**
     * 从Session中获取当前登录用户的工号
     * @param session   HttpSession对象
     * @return  当前登录用户的用户名
     */
    protected final String getNumFromSession(HttpSession session){

        return session.getAttribute("num").toString();
    }

}
package com.zm.se.interceptor;

    public JsonResult<Void> logininfo(HttpSession session){
       session.removeAttribute("num");
        return  new JsonResult<>(OK);
    }

    @Autowired
    EmailSend emailSend;

    @Autowired
    ManagerMapper managerMapper;

   private String realKey="";
   //获取验证码
    @RequestMapping("/sendRegKey")
    public JsonResult<String> sendVerificationCode(String num){
        System.out.println(num);
        realKey= emailSend.KeyCreated();
        if (emailSend.RegisterManager(realKey,managerService.findRegPwd(num))==1){
          return new JsonResult<>(OK);
        }
        return new JsonResult<>(1000,"发送失败，请重试");
    }

    //注册
    //http//localhost:8080/users/register?username=zm&password=1234
    @RequestMapping("/register")
    public JsonResult<String> register(Manager manager,String key){
        System.out.println("key"+key);
        System.out.println("realkey"+realKey);
        if (key.equals(realKey)){
            System.out.println("==");
           managerService.reg(manager);
            System.out.println("success");
            return new JsonResult<>(OK);
        }else {
            System.out.println("false");
            return new JsonResult<>(1111);
        }
    }

    @RequestMapping("/loginnum")
    public JsonResult<String> loginnum( HttpSession session){
        String managernum=getNumFromSession(session);
        System.err.println(managernum);
        return new JsonResult<>(OK,managernum);
    }

    private String VerificationCode="";

    public JsonResult<String> sendVerificationCode(String num){
        System.out.println(num);
        realKey= emailSend.KeyCreated();
        if (emailSend.RegisterManager(realKey,managerService.findRegPwd(num))==1){
          return new JsonResult<>(OK);
        }
        return new JsonResult<>(1000,"发送失败，请重试");
    }

    //注册
    //http//localhost:8080/users/register?username=zm&password=1234
    @RequestMapping("/register")
    public JsonResult<String> register(Manager manager,String key){
        System.out.println("key"+key);
        System.out.println("realkey"+realKey);
        if (key.equals(realKey)){
            System.out.println("==");
           managerService.reg(manager);
            System.out.println("success");
            return new JsonResult<>(OK);
        }else {
            System.out.println("false");
            return new JsonResult<>(1111);
        }
    }

    @RequestMapping("/loginnum")
    public JsonResult<String> loginnum( HttpSession session){
        String managernum=getNumFromSession(session);
        System.err.println(managernum);
        return new JsonResult<>(OK,managernum);
    }

    private String VerificationCode="";
    @RequestMapping("/sendFindPwd")
    public JsonResult<String> sendFindPwd(String num){
        System.out.println(num);
        VerificationCode=emailSend.KeyCreated();
        System.out.println(VerificationCode);
            if (emailSend.RegisterManager(VerificationCode,managerService.findPwd(num))==1){

    public JsonResult<List<Scrap>> ShowScrapHistory(Integer page){
        System.err.println(page);
        return new JsonResult<>(OK,equMapper.showScrap(page));
    }

    @RequestMapping("updatescrap")
    public JsonResult<Void> updateScrap(Integer id,String sup,Integer enumber,String ename,HttpSession session){
        System.err.println("updatescrapcontroller");
        System.err.println("id: "+id+" sup: "+sup+"  name:  "+ename+" number: "+enumber);
        String manager=managerMapper.findByNum(getNumFromSession(session)).getUsername();
        System.out.println(manager);

        System.err.println(service.scrapupdate(id,ename,enumber,sup,"zm"));
        return new JsonResult<>(OK);
    }
    @RequestMapping("addpurchase")
    public JsonResult<Void> addPurchase(Purchase purchase,HttpSession session){
        String manager=managerMapper.findByNum(getNumFromSession(session)).getUsername();

        System.out.println(purchase.getEname());
        System.out.println(purchase.getEnumber());
        System.out.println(purchase.getUnit());
        if (service.addPurchase(purchase,manager)==0){
            throw new UpdateException("插入失败，采购表中有这条数据，您可以直接修改");
        }
        return new  JsonResult<>(OK);
    }

    @RequestMapping("getscrapnotes")
    public JsonResult<Scrap> change(Integer id){
        System.err.println(id);
        Scrap scrap=equMapper.findScrapById(id);
        System.err.println(scrap);
        return new JsonResult<>(OK,scrap);
    }

    //
    @RequestMapping("createpurchase")
    public JsonResult<Void> createPurchase(){
        return new JsonResult<>(OK);
    }
    @RequestMapping("purchase")
    public JsonResult<List<Purchase>> ShowPurchase(Integer page){
        System.err.println(page);
        return new JsonResult<>(OK,equMapper.showPurchase(page));

                    .substring(beginIndex);
        }
        String child = filename + suffix;

        // 将客户端上传的文件保存到服务器端
        File dest = new File(parent, child);
        try {
            file.transferTo(dest);
        } catch (IllegalStateException e) {
            System.out.println(
                    "上传失败！您的文件的状态异常！");
        } catch (IOException e) {
            System.out.println(
                    "上传失败！读写文件时出现错误，请重新上传！");
        }

        // 将保存的文件的路径记录到数据库中
        String avatar = File.separator + child;
        System.err.println("\tavatar path=" + avatar);
        System.out.println();
        System.out.println(managerService.ExcelRead(parent,avatar));
        return new JsonResult<>(OK);
    }
}
package com.zm.se.controller;

@RestController
@RequestMapping("scrap")
public class ScrapController extends BaseController {
    @Autowired
    EquMapper equMapper;
    @Autowired
    ManagerMapper managerMapper;
    @Autowired
    EquServiceImpl service;
    @RequestMapping("addScrap")     //  器材名            器材数          器材品牌（单价根据品牌和器材名从eprice表i中查出）session查管理员
    public JsonResult<Scrap> addScrap(String ename, Integer enumber, String sup, HttpSession session){

        return new JsonResult<>(OK);
    }
}
package com.zm.se.controller;

@RestController
@RequestMapping("scrap")
public class ScrapController extends BaseController {
    @Autowired
    EquMapper equMapper;
    @Autowired
    ManagerMapper managerMapper;
    @Autowired
    EquServiceImpl service;
    @RequestMapping("addScrap")     //  器材名            器材数          器材品牌（单价根据品牌和器材名从eprice表i中查出）session查管理员
    public JsonResult<Scrap> addScrap(String ename, Integer enumber, String sup, HttpSession session){
        Integer price=equMapper.selectPriceByEnameSup(ename,sup);
        if (null==price){
            return new JsonResult<>("您填写的信息有误，请重新核对");
        }
        System.err.println(ename+"损坏"+enumber+"个,品牌为："+sup+"单价为："+price);

        String manager=managerMapper.findByNum(getNumFromSession(session)).getUsername();
        //调用service方法向scrap表和scrapnote表中插入信息
        service.addScrap(ename,enumber,price,sup,manager);
        return new JsonResult<>(OK);
    }

        String managernum=getNumFromSession(session);
        System.err.println(managernum);
        return new JsonResult<>(OK,managernum);
    }
    @RequestMapping("/showupdate")
    public JsonResult<Manager> showupdate(HttpSession session){
        Manager info=manager.findByNum(getNumFromSession(session));
        return new JsonResult<>(OK,info);
    }

    //修改信息（密码，手机号）
    @RequestMapping("/updateInfo")
    public JsonResult<Void> updatePassword(String oldPassword,String newPassword,String phone,String email,HttpSession session){
        String num=getNumFromSession(session);
        managerService.changeInfo(oldPassword,newPassword,num,phone,email);
        return new JsonResult<>(OK);
    }

    @GetMapping("showinfo")
    public JsonResult<Manager> showEmp(HttpSession session){
        return new JsonResult<>(OK,manager.findByNum(getNumFromSession(session)));
    }
    @GetMapping("/delManager")
    public JsonResult<Manager> delManager(Integer num){
        if (num!=null) {
            if (manager.delManager(num) != 1) {
                return new JsonResult<>(50001);
            } else {
                return new JsonResult<>(OK);
            }
        }else {
            return new JsonResult<>(50001);
        }
    }

    /*显示所有员工信息*/
    @RequestMapping("showallemp")
    public JsonResult<List> showAllEmp(Integer page){
        List<Emp> list=managerMapper.findEmpByPage(page);
        for (Emp map : list) {
            System.err.println(map);

        return new JsonResult<>(OK,mapper.selectersup());
    }
}
package com.zm.se.controller;

@RestControllerAdvice
public class GlobalExceptionHandler {

    /**
     * 自动捕获异常并处理异常
     * @param e 异常的大爹，能转换成他就代表这个异常它能够处理
     * @return
     */
    @ExceptionHandler(ServiceException.class)
    public JsonResult<Void> handleException(Throwable e){
        JsonResult<Void> json=new JsonResult<>(e);
        if (e instanceof UserNameDuplicateException){
            json.setState(3000);
        }else if(e instanceof FileTypeException){
            json.setState(2000);
        }else if(e instanceof FileUploadException){
            json.setState(2001);
        }else if(e instanceof InsertException){
            json.setState(4000);
        }else if(e instanceof NoEmpException){
            json.setState(5000);
        }else if(e instanceof ManagerNotFoundException){
            json.setState(50001);
        }else if (e instanceof CheckException){
            json.setState(6000);
        }else if(e instanceof BorrowException){
            json.setState(7000);
        }else if(e instanceof UnderStockException){
            json.setState(8000);
        }else if(e instanceof PasswordMisMatchException){
            json.setState(9000);
        }else if(e instanceof UpdateException){

        }
        // 获取文件的MIME类型
        String contentType = file.getContentType();
        System.err.println("\tcontentType=" + contentType);
        // 判断上传的文件类型是否符合：excel/xls
        if (!AVATAR_TYPES.contains(contentType)) {
            throw new FileTypeException(
                    "上传失败！仅允许上传以下类型的文件：" + AVATAR_TYPES);
        }

        // 获取原始文件名(客户端设备中的文件名)
        String originalFilename
                = file.getOriginalFilename();
        System.err.println("\toriginalFilename=" + originalFilename);

        if (originalFilename=="") {
            System.out.println("empty");

            throw new FileTypeException(
                    "上传失败！文件不能为空：" + AVATAR_TYPES);
        }

        // 将文件上传到哪个文件夹
        String parent = session
                .getServletContext().getRealPath("upload");
        System.err.println("\tupload path=" + parent);
        File dir = new File(parent);
        if (!dir.exists()) {
            dir.mkdirs();
        }

        // 保存上传的文件时使用的文件名
        String filename = ""
                + System.currentTimeMillis()
                + System.nanoTime();
        String suffix = "";
        int beginIndex = originalFilename
                .lastIndexOf(".");
        if (beginIndex >= 1) {
            suffix = originalFilename
                    .substring(beginIndex);
        }
        String child = filename + suffix;

        // 将客户端上传的文件保存到服务器端
        File dest = new File(parent, child);
        try {
            file.transferTo(dest);
        } catch (IllegalStateException e) {
            System.out.println(
                    "上传失败！您的文件的状态异常！");
        } catch (IOException e) {

        //调用service使用mapper插入一条新记录（empname,empnum，ename，enumber，createdtime,modifiedtime,createduser，modifieduser）
        equService.empborrow(empname,empnum,ename,enumber,getNumFromSession(session));
        return new JsonResult<>(OK);
    }

    @RequestMapping("return")
    public JsonResult<Void> eReturn(Integer id,Integer enumber,HttpSession session){
        System.err.println(id+enumber);
        String managerNum=getNumFromSession(session);
        String manager=managerMapper.findByNum(managerNum).getUsername();
        equService.empreturn(id,enumber,manager);
        return new JsonResult<>(OK);
    }

    @RequestMapping("getnotes")
    public JsonResult<Borrow> change(Integer id){
        System.err.println(id);
        Borrow borrow=mapper.findById(id);
        System.err.println(borrow);
        return new JsonResult<>(OK,borrow);
    }

    @RequestMapping("showBorrowList")
    public JsonResult<List<Borrow>> BorrowList(Integer page){
        List<Borrow> list=mapper.showBorrow(page);
        return new JsonResult<>(OK,list);
    }
    @RequestMapping("selecter")
    public JsonResult<List<String>> selecter(){
        return new JsonResult<>(OK,mapper.selecter());
    }
    @RequestMapping("selectersup")
    public JsonResult<List<String>> selectersup(){
        return new JsonResult<>(OK,mapper.selectersup());
    }
}
package com.zm.se.controller;

        System.out.println(purchase.getEnumber());
        System.out.println(purchase.getUnit());
        if (service.addPurchase(purchase,manager)==0){
            throw new UpdateException("插入失败，采购表中有这条数据，您可以直接修改");
        }
        return new  JsonResult<>(OK);
    }

    @RequestMapping("getscrapnotes")
    public JsonResult<Scrap> change(Integer id){
        System.err.println(id);
        Scrap scrap=equMapper.findScrapById(id);
        System.err.println(scrap);
        return new JsonResult<>(OK,scrap);
    }

    //
    @RequestMapping("createpurchase")
    public JsonResult<Void> createPurchase(){
        return new JsonResult<>(OK);
    }
    @RequestMapping("purchase")
    public JsonResult<List<Purchase>> ShowPurchase(Integer page){
        System.err.println(page);
        return new JsonResult<>(OK,equMapper.showPurchase(page));
    }

    @RequestMapping("updatepurchase")
    public JsonResult<Void> updatePurchase(Integer id,String unit,Integer enumber,String ename,HttpSession session){
        System.err.println("updatePurchasecontroller");
        String manager=managerMapper.findByNum(getNumFromSession(session)).getUsername();
        System.err.println("id: "+id+" unit: "+unit+"  name:  "+ename+" number: "+enumber+"manager:"+manager);
        System.err.println(service.purchasepdate(id,ename,enumber,unit,manager));
        return new JsonResult<>(OK);
    }

    @RequestMapping("getpurchasenotes")
    public JsonResult<Purchase> changePurchase(Integer id){
        System.err.println(id);
       Purchase purchase=equMapper.findPurchaseById(id);
        System.err.println(purchase);
        return new JsonResult<>(OK,purchase);
    }

}
package com.zm.se.controller;

           equipment=mapper.findEquById(id);
            System.out.println(equipment);
        }
        if (key.equals("emp")){
            System.out.println(id);
           emp=managerMapper.findEmpById(id);
            System.out.println(emp);

        }
        return new JsonResult<>(OK);
    }
    @RequestMapping("/getEquNotes")
    public JsonResult<Equipment> getEquNote(){
        System.out.println(equipment);
        return new JsonResult<>(OK,equipment);
    }
    @RequestMapping("/getEmpNotes")
    public JsonResult<Emp> getEmpNotes(){
        System.out.println(emp);
        return new JsonResult<>(OK,emp);
    }

    @RequestMapping("/addEqu")
    public JsonResult<String> addEqu(Equipment equipment){
        System.out.println(equipment);
        if (service.addEqu(equipment)!=1){
            return new JsonResult<>("添加失败，请重试");
        }
        return new JsonResult<>(OK);
    }
    @RequestMapping("/addEmp")
    public JsonResult<String> addEmp(Emp emp){
        System.out.println(emp);
        if (service.addEmp(emp)!=1){
            return new JsonResult<>("添加失败，请重试");
        }
        return new JsonResult<>(OK);
    }

    /**
     * 允许上传的文件类型的集合
     */
    private static final List<String> AVATAR_TYPES = new ArrayList<>();

    static {
        AVATAR_TYPES.add("application/vnd.ms-excel");
        AVATAR_TYPES.add("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    }

    @PostMapping("/uploadequ")
    public JsonResult<String> uploadEqu(
            @RequestParam("file") MultipartFile file, HttpSession session) {
        // 日志
        System.err.println("uploadequ");

        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,mapper.showreturn(username,page));

    }
    @RequestMapping("borrow")
    public JsonResult<Void> borrow(Integer enumber,String ename,HttpSession session){
        String empname=session.getAttribute("empname").toString();  //sql条件之一
        String empnum=session.getAttribute("empnum").toString();
        System.err.println(ename+enumber);
        //调用service使用mapper插入一条新记录（empname,empnum，ename，enumber，createdtime,modifiedtime,createduser，modifieduser）
        equService.empborrow(empname,empnum,ename,enumber,getNumFromSession(session));
        return new JsonResult<>(OK);
    }

    @RequestMapping("return")
    public JsonResult<Void> eReturn(Integer id,Integer enumber,HttpSession session){
        System.err.println(id+enumber);
        String managerNum=getNumFromSession(session);
        String manager=managerMapper.findByNum(managerNum).getUsername();
        equService.empreturn(id,enumber,manager);
        return new JsonResult<>(OK);
    }

    @RequestMapping("getnotes")
    public JsonResult<Borrow> change(Integer id){
        System.err.println(id);
        Borrow borrow=mapper.findById(id);
        System.err.println(borrow);
        return new JsonResult<>(OK,borrow);
    }

    @RequestMapping("showBorrowList")
    public JsonResult<List<Borrow>> BorrowList(Integer page){
        List<Borrow> list=mapper.showBorrow(page);
        return new JsonResult<>(OK,list);
    }
    @RequestMapping("selecter")
    public JsonResult<List<String>> selecter(){
        return new JsonResult<>(OK,mapper.selecter());
    }
    @RequestMapping("selectersup")
    public JsonResult<List<String>> selectersup(){
        return new JsonResult<>(OK,mapper.selectersup());
    }
}
package com.zm.se.controller;

        String originalFilename
                = file.getOriginalFilename();
        System.err.println("\toriginalFilename=" + originalFilename);

        if (originalFilename=="") {
            System.out.println("empty");

            throw new FileTypeException(
                    "上传失败！文件不能为空：" + AVATAR_TYPES);
        }

        // 将文件上传到哪个文件夹
        String parent = session
                .getServletContext().getRealPath("upload");
        System.err.println("\tupload path=" + parent);
        File dir = new File(parent);
        if (!dir.exists()) {
            dir.mkdirs();
        }

        // 保存上传的文件时使用的文件名
        String filename = ""
                + System.currentTimeMillis()
                + System.nanoTime();
        String suffix = "";
        int beginIndex = originalFilename
                .lastIndexOf(".");
        if (beginIndex >= 1) {
            suffix = originalFilename
                    .substring(beginIndex);
        }
        String child = filename + suffix;

        // 将客户端上传的文件保存到服务器端
        File dest = new File(parent, child);
        try {
            file.transferTo(dest);
        } catch (IllegalStateException e) {
            System.out.println(
                    "上传失败！您的文件的状态异常！");
        } catch (IOException e) {
            System.out.println(
                    "上传失败！读写文件时出现错误，请重新上传！");
        }

        // 获取原始文件名(客户端设备中的文件名)
        String originalFilename
                = file.getOriginalFilename();
        System.err.println("\toriginalFilename=" + originalFilename);

        // 将文件上传到哪个文件夹
        String parent = session
                .getServletContext().getRealPath("upload");
        System.err.println("\tupload path=" + parent);
        File dir = new File(parent);
        if (!dir.exists()) {
            dir.mkdirs();
        }

        // 保存上传的文件时使用的文件名
        String filename = ""
                + System.currentTimeMillis()
                + System.nanoTime();
        String suffix = "";
        int beginIndex = originalFilename
                .lastIndexOf(".");
        if (beginIndex >= 1) {
            suffix = originalFilename
                    .substring(beginIndex);
        }
        String child = filename + suffix;

        // 将客户端上传的文件保存到服务器端
        File dest = new File(parent, child);
        try {
            file.transferTo(dest);
        } catch (IllegalStateException e) {
            System.out.println(
                    "上传失败！您的文件的状态异常！");
        } catch (IOException e) {
            System.out.println(
                    "上传失败！读写文件时出现错误，请重新上传！");
        }

        // 将保存的文件的路径记录到数据库中
        String avatar = File.separator + child;
        System.err.println("\tavatar path=" + avatar);
        System.out.println();
        System.out.println(managerService.ExcelRead(parent,avatar));
        return new JsonResult<>(OK);
    }
}
package com.zm.se.controller;

        return new JsonResult<>(OK);
    }

}
package com.zm.se.controller;

@RestController
@RequestMapping("/users")
public class ManagerController extends BaseController{
    @Resource
    IManagerService managerService;

    @Autowired
    ManagerMapper manager;

    //登录
    @RequestMapping("/logininfo")
    public JsonResult<Void> logininfo(HttpSession session){
       session.removeAttribute("num");
        return  new JsonResult<>(OK);
    }

    @Autowired
    EmailSend emailSend;

    @Autowired
    ManagerMapper managerMapper;

   private String realKey="";
   //获取验证码
    @RequestMapping("/sendRegKey")
    public JsonResult<String> sendVerificationCode(String num){
        System.out.println(num);
        realKey= emailSend.KeyCreated();

            System.out.println(
                    "上传失败！读写文件时出现错误，请重新上传！");
        }

        // 将保存的文件的路径记录到数据库中
        String avatar = File.separator + child;
        System.err.println("\tavatar path=" + avatar);
        System.out.println();
        System.out.println(managerService.ExcelRead(parent,avatar));
        return new JsonResult<>(OK);
    }
}
package com.zm.se.controller;

@RestController
@RequestMapping("scrap")
public class ScrapController extends BaseController {
    @Autowired
    EquMapper equMapper;
    @Autowired
    ManagerMapper managerMapper;
    @Autowired
    EquServiceImpl service;
    @RequestMapping("addScrap")     //  器材名            器材数          器材品牌（单价根据品牌和器材名从eprice表i中查出）session查管理员
    public JsonResult<Scrap> addScrap(String ename, Integer enumber, String sup, HttpSession session){
        Integer price=equMapper.selectPriceByEnameSup(ename,sup);
        if (null==price){
            return new JsonResult<>("您填写的信息有误，请重新核对");
        }
        System.err.println(ename+"损坏"+enumber+"个,品牌为："+sup+"单价为："+price);

        String manager=managerMapper.findByNum(getNumFromSession(session)).getUsername();
        //调用service方法向scrap表和scrapnote表中插入信息
        service.addScrap(ename,enumber,price,sup,manager);
        return new JsonResult<>(OK);

    @Autowired
    ManagerMapper managerMapper;

    @RequestMapping("checkborrow")
    public JsonResult<Void> checkBorrow(String username,String num,HttpSession session){
        session.setAttribute("empname",username);
        session.setAttribute("empnum",num);
        service.check(username,num);
        return new JsonResult<>(OK);
    }

    @RequestMapping("checkreturn")
    public JsonResult<Void> checkReturn(String username,String num,HttpSession session){
        session.setAttribute("empname",username);
        session.setAttribute("empnum",num);
        service.check(username,num);
        return new JsonResult<>(OK);
    }
    @RequestMapping("borrowready")
    public JsonResult<String> borrowusername(HttpSession session){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,username);

    }
    @RequestMapping("returnready")
    public JsonResult<List<Borrow>> returnusername(HttpSession session,Integer page){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,mapper.showreturn(username,page));

    }
    @RequestMapping("borrow")
    public JsonResult<Void> borrow(Integer enumber,String ename,HttpSession session){
        String empname=session.getAttribute("empname").toString();  //sql条件之一
        String empnum=session.getAttribute("empnum").toString();
        System.err.println(ename+enumber);
        //调用service使用mapper插入一条新记录（empname,empnum，ename，enumber，createdtime,modifiedtime,createduser，modifieduser）
        equService.empborrow(empname,empnum,ename,enumber,getNumFromSession(session));
        return new JsonResult<>(OK);
    }

    @RequestMapping("return")
    public JsonResult<Void> eReturn(Integer id,Integer enumber,HttpSession session){
        System.err.println(id+enumber);
        String managerNum=getNumFromSession(session);
        String manager=managerMapper.findByNum(managerNum).getUsername();
        equService.empreturn(id,enumber,manager);
        return new JsonResult<>(OK);
    }

    @RequestMapping("getnotes")
    public JsonResult<Borrow> change(Integer id){

    @Autowired
    ManagerMapper managerMapper;

    @RequestMapping("checkborrow")
    public JsonResult<Void> checkBorrow(String username,String num,HttpSession session){
        session.setAttribute("empname",username);
        session.setAttribute("empnum",num);
        service.check(username,num);
        return new JsonResult<>(OK);
    }

    @RequestMapping("checkreturn")
    public JsonResult<Void> checkReturn(String username,String num,HttpSession session){
        session.setAttribute("empname",username);
        session.setAttribute("empnum",num);
        service.check(username,num);
        return new JsonResult<>(OK);
    }
    @RequestMapping("borrowready")
    public JsonResult<String> borrowusername(HttpSession session){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,username);

    }
    @RequestMapping("returnready")
    public JsonResult<List<Borrow>> returnusername(HttpSession session,Integer page){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,mapper.showreturn(username,page));

    }
    @RequestMapping("borrow")
    public JsonResult<Void> borrow(Integer enumber,String ename,HttpSession session){
        String empname=session.getAttribute("empname").toString();  //sql条件之一
        String empnum=session.getAttribute("empnum").toString();
        System.err.println(ename+enumber);
        //调用service使用mapper插入一条新记录（empname,empnum，ename，enumber，createdtime,modifiedtime,createduser，modifieduser）
        equService.empborrow(empname,empnum,ename,enumber,getNumFromSession(session));
        return new JsonResult<>(OK);
    }

    public JsonResult<Emp> getEmpNotes(){
        System.out.println(emp);
        return new JsonResult<>(OK,emp);
    }

    @RequestMapping("/addEqu")
    public JsonResult<String> addEqu(Equipment equipment){
        System.out.println(equipment);
        if (service.addEqu(equipment)!=1){
            return new JsonResult<>("添加失败，请重试");
        }
        return new JsonResult<>(OK);
    }
    @RequestMapping("/addEmp")
    public JsonResult<String> addEmp(Emp emp){
        System.out.println(emp);
        if (service.addEmp(emp)!=1){
            return new JsonResult<>("添加失败，请重试");
        }
        return new JsonResult<>(OK);
    }

    /**
     * 允许上传的文件类型的集合
     */
    private static final List<String> AVATAR_TYPES = new ArrayList<>();

    static {
        AVATAR_TYPES.add("application/vnd.ms-excel");
        AVATAR_TYPES.add("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    }

    @PostMapping("/uploadequ")
    public JsonResult<String> uploadEqu(
            @RequestParam("file") MultipartFile file, HttpSession session) {
        // 日志
        System.err.println("uploadequ");

        // 判断文件是否为空
        boolean isEmpty = file.isEmpty();
        System.err.println("\tisEmpty=" + isEmpty);
        if (isEmpty) {
            System.out.println("empty");

            throw new FileTypeException(
                    "上传失败！文件不能为空：" + AVATAR_TYPES);
        }
        // 获取文件的MIME类型
        String contentType = file.getContentType();
        System.err.println("\tcontentType=" + contentType);
        // 判断上传的文件类型是否符合：excel/xls
        if (!AVATAR_TYPES.contains(contentType)) {

public class BorrowController extends BaseController{
    @Autowired
    ManagerServiceImpl service;
    @Autowired
    EquServiceImpl equService;
    @Autowired
    EquMapper mapper;
    @Autowired
    ManagerMapper managerMapper;

    @RequestMapping("checkborrow")
    public JsonResult<Void> checkBorrow(String username,String num,HttpSession session){
        session.setAttribute("empname",username);
        session.setAttribute("empnum",num);
        service.check(username,num);
        return new JsonResult<>(OK);
    }

    @RequestMapping("checkreturn")
    public JsonResult<Void> checkReturn(String username,String num,HttpSession session){
        session.setAttribute("empname",username);
        session.setAttribute("empnum",num);
        service.check(username,num);
        return new JsonResult<>(OK);
    }
    @RequestMapping("borrowready")
    public JsonResult<String> borrowusername(HttpSession session){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,username);

    }
    @RequestMapping("returnready")
    public JsonResult<List<Borrow>> returnusername(HttpSession session,Integer page){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,mapper.showreturn(username,page));

    }
    @RequestMapping("borrow")
    public JsonResult<Void> borrow(Integer enumber,String ename,HttpSession session){
        String empname=session.getAttribute("empname").toString();  //sql条件之一
        String empnum=session.getAttribute("empnum").toString();
        System.err.println(ename+enumber);
        //调用service使用mapper插入一条新记录（empname,empnum，ename，enumber，createdtime,modifiedtime,createduser，modifieduser）
        equService.empborrow(empname,empnum,ename,enumber,getNumFromSession(session));
        return new JsonResult<>(OK);
    }

    public JsonResult<List<Borrow>> returnusername(HttpSession session,Integer page){
        String username=session.getAttribute("empname").toString();  //sql条件之一
        return new JsonResult<>(OK,mapper.showreturn(username,page));

    }
    @RequestMapping("borrow")
    public JsonResult<Void> borrow(Integer enumber,String ename,HttpSession session){
        String empname=session.getAttribute("empname").toString();  //sql条件之一
        String empnum=session.getAttribute("empnum").toString();
        System.err.println(ename+enumber);
        //调用service使用mapper插入一条新记录（empname,empnum，ename，enumber，createdtime,modifiedtime,createduser，modifieduser）
        equService.empborrow(empname,empnum,ename,enumber,getNumFromSession(session));
        return new JsonResult<>(OK);
    }

    @RequestMapping("return")
    public JsonResult<Void> eReturn(Integer id,Integer enumber,HttpSession session){
        System.err.println(id+enumber);
        String managerNum=getNumFromSession(session);
        String manager=managerMapper.findByNum(managerNum).getUsername();
        equService.empreturn(id,enumber,manager);
        return new JsonResult<>(OK);
    }

    @RequestMapping("getnotes")
    public JsonResult<Borrow> change(Integer id){
        System.err.println(id);
        Borrow borrow=mapper.findById(id);
        System.err.println(borrow);
        return new JsonResult<>(OK,borrow);
    }

    @RequestMapping("showBorrowList")
    public JsonResult<List<Borrow>> BorrowList(Integer page){
        List<Borrow> list=mapper.showBorrow(page);
        return new JsonResult<>(OK,list);
    }
    @RequestMapping("selecter")
    public JsonResult<List<String>> selecter(){
        return new JsonResult<>(OK,mapper.selecter());
    }
    @RequestMapping("selectersup")
    public JsonResult<List<String>> selectersup(){
        return new JsonResult<>(OK,mapper.selectersup());
    }
}
package com.zm.se.controller;

        }
        return new JsonResult<>(1000,"发送失败，请重试");
    }

    //注册
    //http//localhost:8080/users/register?username=zm&password=1234
    @RequestMapping("/register")
    public JsonResult<String> register(Manager manager,String key){
        System.out.println("key"+key);
        System.out.println("realkey"+realKey);
        if (key.equals(realKey)){
            System.out.println("==");
           managerService.reg(manager);
            System.out.println("success");
            return new JsonResult<>(OK);
        }else {
            System.out.println("false");
            return new JsonResult<>(1111);
        }
    }

    @RequestMapping("/loginnum")
    public JsonResult<String> loginnum( HttpSession session){
        String managernum=getNumFromSession(session);
        System.err.println(managernum);
        return new JsonResult<>(OK,managernum);
    }

    private String VerificationCode="";
    @RequestMapping("/sendFindPwd")
    public JsonResult<String> sendFindPwd(String num){
        System.out.println(num);
        VerificationCode=emailSend.KeyCreated();
        System.out.println(VerificationCode);
            if (emailSend.RegisterManager(VerificationCode,managerService.findPwd(num))==1){
                return new JsonResult<>(OK);
            }
        return new JsonResult<>(1000,"发送失败，请重试");
    }

    @RequestMapping("/backPwd")

public class GlobalExceptionHandler {

    /**
     * 自动捕获异常并处理异常
     * @param e 异常的大爹，能转换成他就代表这个异常它能够处理
     * @return
     */
    @ExceptionHandler(ServiceException.class)
    public JsonResult<Void> handleException(Throwable e){
        JsonResult<Void> json=new JsonResult<>(e);
        if (e instanceof UserNameDuplicateException){
            json.setState(3000);
        }else if(e instanceof FileTypeException){
            json.setState(2000);
        }else if(e instanceof FileUploadException){
            json.setState(2001);
        }else if(e instanceof InsertException){
            json.setState(4000);
        }else if(e instanceof NoEmpException){
            json.setState(5000);
        }else if(e instanceof ManagerNotFoundException){
            json.setState(50001);
        }else if (e instanceof CheckException){
            json.setState(6000);
        }else if(e instanceof BorrowException){
            json.setState(7000);
        }else if(e instanceof UnderStockException){
            json.setState(8000);
        }else if(e instanceof PasswordMisMatchException){
            json.setState(9000);
        }else if(e instanceof UpdateException){
            json.setState(10000);
        }else if (e instanceof ReturnOutofNumberException){
            json.setState(12700);
        }
        return json;
    }
}
package com.zm.se.controller;

/**
 * 控制器类的基类，用于封装各控制器都需要使用的常量和方法
 */
public abstract class BaseController {
    /**
     * 成功响应码常量
     */