• Java项目：ssm实验室设备管理系统

    作者主页：源码空间站2022

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    ssm实验室设备管理系统。前台jsp+layui+easyui等框架渲染数据、后台java语言搭配ssm(spring、springmvc、mybatis、maven) 数据库mysql5.7、8.0版本均可。该系统主要分三种角色：管理员、教师、学生。主要功能学校实验设备的借、还、修以及实验课程的发布等等；

    管理员主要功能:

    实验室管理：实验室基本信息管理；
    系统管理：系统日志查看；
    权限中心：用户组信息管理、用户组权限控制、菜单管理；
    信息管理-管理员：教师信息管理、学生信息管理、用户账号管理、班级信息管理、专业信息管理、实验室类型管理、信息通告管理、实验设备管理、实验室使用审批、设备借用审批；

    教师主要功能:

    实验管理：实验课程管理；
    信息管理-教师：个人信息维护、学生信息管理、借用设备管理、设备损坏登记、设备维修登记、信息通告浏览、借用实验室管理。

    学生主要功能:

    信息管理-学生：个人信息维护；

    信息浏览：实验课程浏览、实验设备浏览、信息通告浏览；

    环境需要

    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/8.0 版本均可；

    技术栈

    1. 后端：Spring SpringMVC MyBatis
    2. 前端：jsp+layui+easyui

    使用说明

    1. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;

    若为maven项目，导入成功后请执行maven clean;maven install命令，下载所需jar包；
    2. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    3. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置
    4. 配置tomcat，然后运行项目，输入localhost:8080/xxx 登录

    运行截图

     

    相关代码 

    IndexController

    1. package com.sys.controller;
    2.  
    3. import com.sys.model.Groupinfo;
    4.  
    5. import com.sys.model.Users;
    6. import com.sys.service.GroupinfoService;
    7. import com.sys.service.LogService;
    8. import com.sys.service.MenuService;
    9. import com.sys.service.UsersService;
    10. import org.springframework.beans.factory.annotation.Autowired;
    11. import org.springframework.stereotype.Controller;
    12. import org.springframework.ui.Model;
    13. import org.springframework.web.bind.annotation.RequestMapping;
    14. import org.springframework.web.bind.annotation.RequestParam;
    15.  
    16. import javax.servlet.http.HttpServletRequest;
    17. import javax.servlet.http.HttpSession;
    18. import java.util.HashMap;
    19. import java.util.Map;
    20.  
    21. @Controller
    22. public class IndexController {
    23.     @Autowired
    24.     private UsersService usersService;
    25.     @Autowired
    26.     private GroupinfoService groupinfoService;
    27.     @Autowired
    28.     private MenuService menuService;
    29.     @Autowired
    30.     private LogService logService;
    31.  
    32.  
    33.     @RequestMapping("/Index")
    34.     public String index(Model model, HttpServletRequest httpServletRequest){
    35.         HttpSession httpSession = httpServletRequest.getSession();
    36.         Users users = (Users) httpSession.getAttribute("islogin");
    37.         if (users!=null) {
    38.             int groupid = users.getGroupid();
    39.             String username = users.getUsername();
    40.             String password = users.getUpassword();
    41.             Users users1 = usersService.getusersByusername(username);
    42.             if (users1.getUpassword().equals(password)){
    43. //                此处封装需要带到前端的数据
    44.                 model.addAttribute("users",users1);
    45.                 Groupinfo groupinfo = groupinfoService.selectByPrimaryKey(users1.getGroupid());
    46.              if (groupinfo!=null){
    47.                  /*start权限中心*/
    48.                  String quanxian = groupinfo.getQx();
    49.                  String qx[] = {};
    50.                  qx = quanxian.split(",");
    51.                  Map map = new HashMap();
    52.                  for (String qxcache : qx) {
    53.                      int qxid = Integer.parseInt(qxcache);
    54.                      Map map1 = new HashMap();
    55.                      map1.put("pmenu", menuService.selectByPrimaryKey(qxid));
    56.                      map1.put("cmenu", menuService.getmenubyfdm(qxid));
    57.                      map.put(String.valueOf(qxid) + "menus", map1);
    58.                  }
    59.                  model.addAttribute("parentmenus", map);
    60.                  /*end权限中心*/
    61.                  return "index";
    62.              }
    63.              else {
    64.                  model.addAttribute("errmsg","用户组信息错误！");
    65.                  return "login";
    66.              }
    67.             }
    68.             else {
    69.                 model.addAttribute("errmsg","您以更改密码请重新输入");
    70.                 return "login";
    71.             }
    72.         }
    73.         return "login";
    74.     }
    75.  
    76.     @RequestMapping("/Login")//登录模块
    77.     public String Login(@RequestParam String username,@RequestParam String password, Model model, HttpServletRequest httpServletRequest){
    78.         //管理员
    79.         HttpSession session = httpServletRequest.getSession();
    80.         password = UtilPacket.Md5MD5String(password);
    81. //        if (username.equals("admin")&&password.equals(UtilPacket.Md5MD5String("admin"))){
    82. //            Users users = usersService.getusersByusername(username); /*查询用户信息*/
    83. //            int groupid = users.getGroupid();
    84. //            Groupinfo groupinfo = groupinfoService.selectByPrimaryKey(groupid); // 获取管理员信息 权限
    85. //            if (groupinfo!=null) {
    86. //                /*start权限中心*/
    87. //                String quanxian = groupinfo.getQx();
    88. //                String qx[] = {};
    89. //                qx = quanxian.split(",");
    90. //                Map map = new HashMap();
    91. //                for (String qxcache : qx) {
    92. //                    int qxid = Integer.parseInt(qxcache);
    93. //                    Map map1 = new HashMap();
    94. //                    map1.put("pmenu", menuService.selectByPrimaryKey(qxid)); //获取菜单信息
    95. //                    map1.put("cmenu", menuService.getmenubyfdm(qxid));  //根据菜单id 获取 子模块
    96. //                    map.put(String.valueOf(qxid) + "menus", map1);
    97. //                }
    98. //                model.addAttribute("parentmenus", map);
    99. //                /*end权限中心*/
    100. //            }
    101. //            users.setUsername("admin");
    102. //            model.addAttribute("users",users);
    103. //            session.setAttribute("islogin",users);
    104. //            setLog.setlod(httpServletRequest,"admin登录",logService);
    105. //            return "index";
    106. //        }
    107. //        //教师，学生
    108. //        else
    109.  
    110.         if(usersService.getusersByusername(username)!=null){
    111.             if (usersService.getusersByusername(username).getUpassword().equals(password))
    112.             {
    113.                 Users users = usersService.getusersByusername(username); /*查询用户信息*/
    114.                 model.addAttribute("users",users);
    115.                 session.setAttribute("islogin",users);
    116.                 int groupid = users.getGroupid();
    117.                 Groupinfo groupinfo = groupinfoService.selectByPrimaryKey(groupid);/*根据用户组id查询信息*/
    118.                 if (groupinfo!=null){
    119.                     /*start权限中心*/
    120.                     String quanxian = groupinfo.getQx();
    121.                     String qx[] = {};
    122.                     qx = quanxian.split(",");
    123.                     System.out.printf("qx");
    124.                     Map map = new HashMap();
    125.                     for (String qxcache : qx) {
    126.                         int qxid = Integer.parseInt(qxcache);
    127.                         Map map1 = new HashMap();
    128.                         map1.put("pmenu", menuService.selectByPrimaryKey(qxid));    /*根据id 查询菜单信息*/
    129.                         map1.put("cmenu", menuService.getmenubyfdm(qxid));      /*根据父id 查询子模块信息*/
    130.                         map.put(String.valueOf(qxid) + "menus", map1);
    131.                     }
    132.                     model.addAttribute("parentmenus", map);
    133.                     /*end权限中心*/
    134.                     session.setAttribute("islogin",users);
    135.                     setLog.setlod(httpServletRequest,"id为"+users.getId()+"的用户登录",logService);
    136.                     return "index";
    137.                 }
    138.                 model.addAttribute("errmsg","用户组信息错误！");
    139.                 return "login";
    140.             }
    141.             else {
    142.                 model.addAttribute("errmsg","密码错误！");
    143.                 return "login";
    144.             }
    145.         }
    146.         else {
    147.             model.addAttribute("errmsg","用户名不存在！");
    148.             return "login";
    149.         }
    150.     }
    151. }

    jumpController

    1. package com.sys.controller;
    2.  
    3. import com.sys.service.LogService;
    4. import org.springframework.beans.factory.annotation.Autowired;
    5. import org.springframework.stereotype.Controller;
    6. import org.springframework.web.bind.annotation.RequestMapping;
    7. import org.springframework.web.bind.annotation.RequestParam;
    8.  
    9. import javax.servlet.http.HttpServletRequest;
    10. import javax.servlet.http.HttpSession;
    11.  
    12. @Controller
    13. public class jumpController {
    14.     @Autowired
    15.     private LogService logService;
    16.  
    17.     /*用户添加页面跳转*/
    18.     @RequestMapping("/Jumpto")
    19.     public String Jumpto(@RequestParam("url") String url){
    20.         return url;
    21.     }
    22.  
    23.     /*修改密码啊页面跳转*/
    24.     @RequestMapping("/resetpassword")
    25.     public String resetpassword()
    26.     {return  "table/xgmm";}
    27.  
    28.     /*安全退出页面跳转*/
    29.     @RequestMapping("/logout")
    30.     public String logout(HttpServletRequest httpServletRequest){
    31.         HttpSession httpSession = httpServletRequest.getSession();
    32.         setLog.setlod(httpServletRequest, "安全退出",logService);
    33.         httpSession.invalidate();
    34.         return "logout";
    35.     }
    36. }

    selectController

    1. package com.sys.controller;
    2. import com.alibaba.fastjson.JSONObject;
    3. import com.sys.model.*;
    4. import com.sys.service.*;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.web.bind.annotation.RequestMapping;
    7. import org.springframework.web.bind.annotation.RequestParam;
    8. import org.springframework.web.bind.annotation.RestController;
    9. import javax.servlet.http.HttpServletRequest;
    10. import javax.servlet.http.HttpSession;
    11.  
    12. import java.util.*;
    13.  
    14. @RestController
    15. public class selectController {
    16.     @Autowired
    17.     private MenuService menuService;
    18.     @Autowired
    19.     private LogService logService;
    20.     @Autowired
    21.     private GroupinfoService groupinfoService;
    22.     @Autowired
    23.     private StudentService studentService;
    24.     @Autowired
    25.     private TeacherService teacherService;
    26.     @Autowired
    27.     private ZyglService zyglService;
    28.     @Autowired
    29.     private ClassesService classesService;
    30.     @Autowired
    31.     private UsersService usersService;
    32.     @Autowired
    33.     private SyslxService syslxService;
    34.     @Autowired
    35.     private XxtgService xxtgService;
    36.     @Autowired
    37.     private SysbglService sysbglService;
    38.     @Autowired
    39.     private SysglService sysglService;
    40.     @Autowired
    41.     private JydjService jydjService;
    42.     @Autowired
    43.     private SyxxbService syxxbService;
    44.     @Autowired
    45.     private SbshdjService sbshdjService;
    46.     @Autowired
    47.     private SbwxdjService sbwxdjService;
    48.  
    49.     /**
    50.      *  管理员 修改密码
    51.      * @param oldpass
    52.      * @param newpass
    53.      * @param newpass2
    54.      * @param httpServletRequest
    55.      * @return
    56.      */
    57.     @RequestMapping("/getoldpass")
    58.     public JSONObject getoldpass(@RequestParam(value = "oldpass")String oldpass,
    59.                                  @RequestParam(value = "newpass")String newpass,
    60.                                  @RequestParam(value = "newpass2")String newpass2,
    61.                                  HttpServletRequest httpServletRequest) {
    62.         HttpSession session = httpServletRequest.getSession();
    63.         oldpass = UtilPacket.Md5MD5String(oldpass);
    64.         newpass = UtilPacket.Md5MD5String(newpass);
    65.         newpass2 = UtilPacket.Md5MD5String(newpass2); //获取前端传入的数据
    66.         Integer code = 500;
    67.         String msg= "账号服务器错误！";
    68.         Users users = (Users)session.getAttribute("islogin"); //获取登录账户
    69.         String upass = users.getUpassword();
    70.         setLog.setlod(httpServletRequest, "正在修改密码",logService);
    71.         if (upass.equals(oldpass)){
    72.             if (newpass2.equals(newpass)){
    73.                 if (!oldpass.equals(newpass)){
    74.                     code = 0;
    75.                     msg = "密码修改成功请重新登录";
    76.                     users.setUpassword(newpass);
    77.                     if(usersService.updateByPrimaryKeySelective(users)!=0) {
    78.                         setLog.setlod(httpServletRequest, users.getUsername() + "用户修改了密码",logService);
    79.                         session.invalidate();
    80.                     }
    81.                 }
    82.                 else{
    83.                     code=1;
    84.                     msg="新密码与原密码相同！";
    85.                 }
    86.             }
    87.             else {
    88.                 code = 2;
    89.                 msg="新密码两次输入不一致！";
    90.             }
    91.         }
    92.         else {
    93.             code = 3;
    94.             msg = "原密码错误！";
    95.         }
    96.         Map map = new HashMap<>();
    97.         map.put("success",true);
    98.         map.put("code",code);
    99.         map.put("msg",msg);
    100.         JSONObject json = new JSONObject(map);
    101.         return json;
    102.     }
    103.  
    104.     /**
    105.      *  管理员 查询全部实验室信息
    106.      * @param sysname
    107.      * @param bh
    108.      * @param httpServletRequest
    109.      * @return
    110.      */
    111.     @RequestMapping("/selectsysjbxxgl")
    112.     public JSONObject selectsysjbxxgl(@RequestParam(required = false)String sysname,@RequestParam(required = false)String bh,HttpServletRequest httpServletRequest) {
    113.         Map requestparamMap = new HashMap();
    114.         if (sysname!=null&&!sysname.equals(""))
    115.             requestparamMap.put("sysname","%"+sysname+"%");
    116.         if (bh!=null&&!bh.equals(""))
    117.             requestparamMap.put("bh","%"+bh+"%");
    118.         List sysgls = sysglService.getSysglList(requestparamMap);
    119.         List> list = new ArrayList<>();
    120.         if (sysgls != null) {
    121.             for (Sysgl sysgl : sysgls) {
    122.                 String yyridstr = "未预约";
    123.                 Integer id = sysgl.getId();
    124.                 String sysnamestr = sysgl.getSysname();
    125.                 if (sysgl.getYyrid()!=null&&!sysgl.getYyrid().equals("")) {
    126.                     Integer yyrid = sysgl.getYyrid();
    127.                     yyridstr = usersService.selectByPrimaryKey(yyrid).getUsername(); /*返回预约用户名*/
    128.                     System.out.println(yyridstr);
    129.                 }
    130.                 Integer lxid = sysgl.getLxid();
    131.                 String lc = sysgl.getLc();
    132.                 String fzrid = sysgl.getFzrid();
    133.                 String bhstr = sysgl.getBh();
    134.                 Integer sfyy = sysgl.getSfyy();
    135.                 String lxidstr = syslxService.getSyslxById(lxid).getLx(); //返回实验室类型名称
    136.                 String sfyystr = "未预约";
    137.                 if (sfyy==1){
    138.                     sfyystr="已预约";
    139.                 }
    140.                 if (sfyy==2){
    141.                     sfyystr="预约未审核";
    142.                 }
    143.                 Map map = new HashMap();
    144.                 map.put("id", id);
    145.                 map.put("yyrid", yyridstr);
    146.                 map.put("sysname", sysnamestr);
    147.                 map.put("lc", lc);
    148.                 map.put("fzrid", fzrid);
    149.                 map.put("bh", bhstr);
    150.                 map.put("lxid", lxidstr);
    151.                 map.put("sfyy", sfyystr);
    152.                 list.add(map);
    153.             }
    154.         }
    155.         Map map1 = new HashMap<>();
    156.         map1.put("code", 0);
    157.         map1.put("msg", "ok");
    158.         map1.put("count", list.size());
    159.         map1.put("data", list);
    160.         setLog.setlod(httpServletRequest, "查询了实验室基本信息数据",logService);
    161.         JSONObject json = new JSONObject(map1);
    162.         return json;
    163.     }
    164.  
    165.     /**
    166.      *  管理员 查询实验室 显示实验室名称
    167.      * @param httpServletRequest
    168.      * @return
    169.      */
    170.     @RequestMapping("/selectsys")
    171.     public JSONObject selectsys(HttpServletRequest httpServletRequest) {
    172.         Map requestparamMap = new HashMap();
    173.         List sysgls = sysglService.getSysglList(requestparamMap);
    174.         List> list = new ArrayList<>();
    175.         if (sysgls != null) {
    176.             for (Sysgl sysgl : sysgls) {
    177.                 Integer id = sysgl.getId();
    178.                 String sysname = sysgl.getSysname();
    179.                 Map map = new HashMap();
    180.                 map.put("id", id);
    181.                 map.put("sysname", sysname);
    182.                 list.add(map);
    183.             }
    184.         }
    185.         Map map1 = new HashMap<>();
    186.         map1.put("code", 0);
    187.         map1.put("msg", "ok");
    188.         map1.put("count", list.size());
    189.         map1.put("data", list);
    190.         setLog.setlod(httpServletRequest, "查询了实验室信息数据",logService);
    191.         JSONObject json = new JSONObject(map1);
    192.         return json;
    193.     }
    194.  
    195.     /**
    196.      *  管理员 查询全部实验室使用审批
    197.      * @param httpServletRequest
    198.      * @return
    199.      */
    200.     @RequestMapping("/selectsyssysp")
    201.     public JSONObject selectsyssysp(HttpServletRequest httpServletRequest) {
    202.         List sysgls = sysglService.getSysglBySfyy(2);
    203.         List> list = new ArrayList<>();
    204.         if (sysgls != null) {
    205.             for (Sysgl sysgl : sysgls) {
    206.                 Integer id = sysgl.getId();
    207.                 String sysname = sysgl.getSysname();
    208.                 String bh = sysgl.getBh();
    209.                 String fzrid = sysgl.getFzrid();
    210.                 String lc = sysgl.getLc();
    211.                 Integer lxid = sysgl.getLxid();
    212.                 Integer yyrid = sysgl.getYyrid();
    213.                 String lx = syslxService.getSyslxById(lxid).getLx();
    214.                 String yyr = usersService.selectByPrimaryKey(yyrid).getUsername();//显示预约人名称
    215.                 Map map = new HashMap();
    216.                 map.put("id", id);
    217.                 map.put("sysname", sysname);
    218.                 map.put("bh", bh);
    219.                 map.put("fzrid", fzrid);
    220.                 map.put("lc", lc);
    221.                 map.put("lx", lx);
    222.                 map.put("yyr", yyr);
    223.                 list.add(map);
    224.             }
    225.         }
    226.         Map map1 = new HashMap<>();
    227.         map1.put("code", 0);
    228.         map1.put("msg", "ok");
    229.         map1.put("count", list.size());
    230.         map1.put("data", list);
    231.         setLog.setlod(httpServletRequest, "打开了实验室使用审批",logService);
    232.         JSONObject json = new JSONObject(map1);
    233.         return json;
    234.     }
    235.  
    236.     /**
    237.      *  教师  查询已预约实验室
    238.      * @param httpServletRequest
    239.      * @return
    240.      */
    241.     @RequestMapping("/selecttgkysys")
    242.     public JSONObject selecttgkysys(HttpServletRequest httpServletRequest) {
    243.         HttpSession session = httpServletRequest.getSession();
    244.         Users users = (Users) session.getAttribute("islogin");
    245.         Integer tid = users.getId();
    246.         List sysgls = sysglService.getSysglByKysys(tid);
    247.         List> list = new ArrayList<>();
    248.         if (sysgls != null) {
    249.             for (Sysgl sysgl : sysgls) {
    250.                 Integer id = sysgl.getId();
    251.                 String sysname = sysgl.getSysname();
    252.                 String bh = sysgl.getBh();
    253.                 Map map = new HashMap();
    254.                 map.put("id", id);
    255.                 map.put("sysname", sysname);
    256.                 map.put("bh", bh);
    257.                 list.add(map);
    258.             }
    259.         }
    260.         Map map1 = new HashMap<>();
    261.         map1.put("code", 0);
    262.         map1.put("msg", "ok");
    263.         map1.put("count", list.size());
    264.         map1.put("data", list);
    265.         setLog.setlod(httpServletRequest, "查询了实验室信息数据",logService);
    266.         JSONObject json = new JSONObject(map1);
    267.         return json;
    268.     }
    269.  
    270.     /**
    271.      *  教师  查询全部借用实验室
    272.      * @param httpServletRequest
    273.      * @return
    274.      */
    275.     @RequestMapping("/selectjysysgl")
    276.     public JSONObject selectjysysgl(HttpServletRequest httpServletRequest) {
    277.         HttpSession session = httpServletRequest.getSession();
    278.         Users users = (Users) session.getAttribute("islogin");
    279.         Integer tid = users.getId();
    280.         List sysgls = sysglService.getSysglByteacher(tid);
    281.         List> list = new ArrayList<>();
    282.         if (sysgls != null) {
    283.             for (Sysgl sysgl : sysgls) {
    284.                 String yyridstr = "未预约";
    285.                 Integer id = sysgl.getId();
    286.                 String sysnamestr = sysgl.getSysname();
    287.                 if (sysgl.getYyrid()!=null&&!sysgl.getYyrid().equals("")) {
    288.                     Integer yyrid = sysgl.getYyrid();
    289.                     yyridstr = usersService.selectByPrimaryKey(yyrid).getUsername();
    290.                 }
    291.                 Integer lxid = sysgl.getLxid();
    292.                 String lc = sysgl.getLc();
    293.                 String fzrid = sysgl.getFzrid();
    294.                 String bhstr = sysgl.getBh();
    295.                 Integer sfyy = sysgl.getSfyy();
    296.                 String lxidstr = syslxService.getSyslxById(lxid).getLx();
    297.                 String sfyystr = "未预约";
    298.                 if (sfyy==1){
    299.                     sfyystr="已预约";
    300.                 }
    301.                 if (sfyy==2){
    302.                     sfyystr="预约未审核";
    303.                 }
    304.                 Map map = new HashMap();
    305.                 map.put("id", id);
    306.                 map.put("yyrid", yyridstr);
    307.                 map.put("sysname", sysnamestr);
    308.                 map.put("lc", lc);
    309.                 map.put("fzrid", fzrid);
    310.                 map.put("bh", bhstr);
    311.                 map.put("lxid", lxidstr);
    312.                 map.put("sfyy", sfyystr);
    313.                 list.add(map);
    314.             }
    315.         }
    316.         Map map1 = new HashMap<>();
    317.         map1.put("code", 0);
    318.         map1.put("msg", "ok");
    319.         map1.put("count", list.size());
    320.         map1.put("data", list);
    321.         setLog.setlod(httpServletRequest, "查询了实验室基本信息数据",logService);
    322.         JSONObject json = new JSONObject(map1);
    323.         return json;
    324.     }
    325.  
    326.     /**
    327.      *  教师  查询可用实验室  显示实验室名称
    328.      * @param httpServletRequest
    329.      * @return
    330.      */
    331.     @RequestMapping("/selectkysys")
    332.     public JSONObject selectkysys(HttpServletRequest httpServletRequest) {
    333.         List sysgls = sysglService.getSysglBySfyy(0);
    334.         List> list = new ArrayList<>();
    335.         if (sysgls != null) {
    336.             for (Sysgl sysgl : sysgls) {
    337.                 Integer id = sysgl.getId();
    338.                 String sysname = sysgl.getSysname();
    339.                 String bh = sysgl.getBh();
    340.                 Map map = new HashMap();
    341.                 map.put("id", id);
    342.                 map.put("sysname", sysname);
    343.                 map.put("bh", bh);
    344.                 list.add(map);
    345.             }
    346.         }
    347.         Map map1 = new HashMap<>();
    348.         map1.put("code", 0);
    349.         map1.put("msg", "ok");
    350.         map1.put("count", list.size());
    351.         map1.put("data", list);
    352.         setLog.setlod(httpServletRequest, "查询了实验室信息数据",logService);
    353.         JSONObject json = new JSONObject(map1);
    354.         return json;
    355.     }
    356.  
    357.  
    358.     /**
    359.      *  管理员 查询全部日志信息
    360.      * @param httpServletRequest
    361.      * @param page
    362.      * @param limit
    363.      * @return
    364.      */
    365.     @RequestMapping("/selectxtrzgl")
    366.     public Map selectxtrzgl(HttpServletRequest httpServletRequest, @RequestParam(value = "page") Integer page,@RequestParam(value = "limit") Integer limit) {
    367.         page = page-1;
    368.         Integer start = page*limit;
    369.         Integer end = (page+1)*limit-1;
    370.         List logs = logService.getlogList();
    371.         Integer datacount = logs.size();
    372.         Integer i = 0;
    373.         List> list = new ArrayList<>();
    374.         if (logs != null) {
    375.             for (Log log : logs) {
    376.                 if (i>=start&&i<=end){
    377.                     Integer id = log.getId();
    378.                     String cz = log.getCz();
    379.                     Integer czr = log.getCzr();
    380.                     Date date = log.getTime();
    381.                     String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    382.                     String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    383.                     String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    384.                     String timestr = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    385.                     String czrstr=usersService.selectByPrimaryKey(czr).getUsername();
    386.                     Map map = new HashMap();
    387.                     map.put("id", id);
    388.                     map.put("cz", cz);
    389.                     map.put("czr", czrstr);
    390.                     map.put("time", timestr);
    391.                     list.add(map);
    392.                 }
    393.                 i++;
    394.             }
    395.         }
    396.         Map map1 = new HashMap<>();
    397.         map1.put("code", 0);
    398.         map1.put("msg", "ok");
    399.         map1.put("count", datacount);
    400.         map1.put("data", list);
    401.         setLog.setlod(httpServletRequest, "查询了全部系统日志信息数据",logService);
    402.         return map1;
    403.     }
    404.  
    405.     /**
    406.      *   管理员 查询全部用户组信息
    407.      * @param name
    408.      * @param httpServletRequest
    409.      * @return
    410.      */
    411.     @RequestMapping("/selectyhzxxgl")
    412.     public JSONObject selectyhzxxgl(@RequestParam(required = false) String name, HttpServletRequest httpServletRequest) {
    413.         Map requestparamMap = new HashMap();
    414.         if (name!=null&&!name.equals(""))
    415.             requestparamMap.put("groupname","%"+name+"%");
    416.         List groupinfos = groupinfoService.getgroupinfoList(requestparamMap);
    417.         List> list = new ArrayList<>();
    418.         if (groupinfos != null) {
    419.             for (Groupinfo groupinfo : groupinfos) {
    420.                 Integer id = groupinfo.getId();
    421.                 String qx = groupinfo.getQx();
    422.                 String groupname = groupinfo.getGroupname();
    423.                 Map map = new HashMap();
    424.                 map.put("id", id);
    425.                 map.put("qx", qx);
    426.                 map.put("groupname", groupname);
    427.                 list.add(map);
    428.             }
    429.         }
    430.         Map map1 = new HashMap<>();
    431.         map1.put("code", 0);
    432.         map1.put("msg", "ok");
    433.         map1.put("count", list.size());
    434.         map1.put("data", list);
    435.         setLog.setlod(httpServletRequest, "查询了全部用户组信息数据",logService);
    436.         JSONObject json = new JSONObject(map1);
    437.         return json;
    438.     }
    439.  
    440.     /**
    441.      *  管理员 查询用户组权限信息
    442.      * @param httpServletRequest
    443.      * @return
    444.      */
    445.  
    446.     @RequestMapping("/selectyhzqxgl")
    447.     public JSONObject selectyhzqxgl(HttpServletRequest httpServletRequest) {
    448.         List groupinfos = groupinfoService.getgroupinfoList(null);
    449.         List> list = new ArrayList<>();
    450.         if (groupinfos != null) {
    451.             for (Groupinfo groupinfo : groupinfos) {
    452.                 Integer id = groupinfo.getId();
    453.                 String qx = groupinfo.getQx();
    454.                 String groupname = groupinfo.getGroupname();
    455.                 String qxs[] ={};
    456.                 Map map = new HashMap();
    457.                 map.put("id", id+"_a");
    458.                 map.put("field", id+"_a");
    459.                 map.put("title", groupname);
    460.                 if (qx!=null)
    461.                     qxs = qx.split(",");
    462.                 Map child = selectfcd(httpServletRequest);
    463.                 List childdatas = (List) child.get("data");
    464.                 List childsmap = new ArrayList();
    465.                 for (Integer i = 0 ;i
    466.                     boolean sfxz = false;
    467.                     Map childmap = (Map)childdatas.get(i);
    468.                     Integer childid = Integer.parseInt(String.valueOf(childmap.get("id")));
    469.                     String aaaa= Arrays.toString(qxs);
    470.                     if (aaaa.length()>2&&qxs!=null) {
    471.                         for (String qxbsstr : qxs) {
    472.                             if (Integer.parseInt(qxbsstr) == childid) {
    473.                                 sfxz = true;
    474.                                 break;
    475.                             }
    476.                         }
    477.                     }
    478.                     String childmenuname = String.valueOf(childmap.get("menuname"));
    479.                     childmap.put("id",childid+"_b_"+id);
    480.                     childmap.put("title",childmenuname);
    481.                     childmap.put("checked",sfxz);
    482.                     childmap.put("field",childid+"_b_"+id);
    483.                     childsmap.add(childmap);
    484.                 }
    485.                 map.put("children",childsmap);
    486.                 list.add(map);
    487.             }
    488.         }
    489.         Map map1 = new HashMap<>();
    490.         map1.put("data", list);
    491.         setLog.setlod(httpServletRequest, "查询了全部权限节点数据",logService);
    492.         JSONObject json = new JSONObject(map1);
    493.         return json;
    494.     }
    495.  
    496.     /*
    497.      * 管理员 查询父菜单*/
    498.     @RequestMapping("/selectfcd")
    499.     public Map selectfcd(HttpServletRequest httpServletRequest) {
    500.         List menus = menuService.getfdmmenuList();
    501.         List> list = new ArrayList<>();
    502.         if (menus != null) {
    503.             for (Menu menu : menus) {
    504.                 Integer id = menu.getId();
    505.                 String menuname = menu.getMenuname();
    506.                 Map map = new HashMap();
    507.                 map.put("id", id);
    508.                 map.put("menuname", menuname);
    509.                 list.add(map);
    510.             }
    511.         }
    512.         Map map1 = new HashMap<>();
    513.         map1.put("code", 0);
    514.         map1.put("msg", "ok");
    515.         map1.put("count", list.size());
    516.         map1.put("data", list);
    517.         setLog.setlod(httpServletRequest, "查询了父菜单信息数据",logService);
    518.         return map1;
    519.     }
    520.  
    521.     /**
    522.      *  管理员 查询菜单信息信息
    523.      * @param httpServletRequest
    524.      * @return
    525.      */
    526.  
    527.     @RequestMapping("/selectcdgl")
    528.     public JSONObject selectcdgl(HttpServletRequest httpServletRequest) {
    529.         List menus = menuService.getmenuList();
    530.         List> list = new ArrayList<>();
    531.         if (menus != null) {
    532.             for (Menu menu : menus) {
    533.                 Integer id = menu.getId();
    534.                 String fdm = null;
    535.                 if(menu.getFdm()!=null&&menu.getFdm()!="") {
    536.                     /*查询父菜单名称他*/
    537.                     fdm = menuService.selectByPrimaryKey(Integer.parseInt(menu.getFdm())).getMenuname();
    538.                 }
    539.                 String menulink = menu.getMenulink();
    540.                 String menuname = menu.getMenuname();
    541.                 Map map = new HashMap();
    542.                 map.put("id", id);
    543.                 map.put("fdm", fdm);
    544.                 map.put("menulink", menulink);
    545.                 map.put("menuname", menuname);
    546.                 list.add(map);
    547.             }
    548.         }
    549.         Map map1 = new HashMap<>();
    550.         map1.put("code", 0);
    551.         map1.put("msg", "ok");
    552.         map1.put("count", list.size());
    553.         map1.put("data", list);
    554.         setLog.setlod(httpServletRequest, "查询了全部菜单信息数据",logService);
    555.         JSONObject json = new JSONObject(map1);
    556.         return json;
    557.     }
    558.  
    559.  
    560.  
    561.     /**
    562.      *  管理员 查询父菜单信息 根据fdm是空查询
    563.      * @param httpServletRequest
    564.      * @return
    565.      */
    566.     @RequestMapping("/selectfcd2")
    567.     public JSONObject selectfcd2(HttpServletRequest httpServletRequest) {
    568.         List menus = menuService.getfdmmenuList();
    569.         List> list = new ArrayList<>();
    570.         if (menus != null) {
    571.             for (Menu menu : menus) {
    572.                 Integer id = menu.getId();
    573.                 String menuname = menu.getMenuname();
    574.                 Map map = new HashMap();
    575.                 map.put("id", id);
    576.                 map.put("menuname", menuname);
    577.                 list.add(map);
    578.             }
    579.         }
    580.         Map map1 = new HashMap<>();
    581.         map1.put("code", 0);
    582.         map1.put("msg", "ok");
    583.         map1.put("count", list.size());
    584.         map1.put("data", list);
    585.         setLog.setlod(httpServletRequest, "查询了父菜单信息数据",logService);
    586.         JSONObject json = new JSONObject(map1);
    587.         return json;
    588.     }
    589.  
    590.  
    591.  
    592.     /**
    593.      * 管理员  查询全部教师信息
    594.      * @param tname
    595.      * @param idcard
    596.      * @param httpServletRequest
    597.      * @return
    598.      */
    599.     @RequestMapping("/selectjsxxgl")
    600.     public JSONObject selectjsxxgl(@RequestParam(required = false)String tname,@RequestParam(required = false) String idcard, HttpServletRequest httpServletRequest) {
    601.         Map requestparamMap = new HashMap();
    602.         if (tname!=null&&!tname.equals(""))
    603.         requestparamMap.put("tname","%"+tname+"%");
    604.         if (idcard!=null&&!idcard.equals(""))
    605.         requestparamMap.put("idcard","%"+idcard+"%");
    606.         List teachers = teacherService.getTeacherList(requestparamMap);
    607.         List> list = new ArrayList<>();
    608.         if (teachers != null) {
    609.             for (Teacher teacher : teachers) {
    610.                 Integer id = teacher.getId();
    611.                 String tnamestr = teacher.getTname();
    612.                 String sex = teacher.getSex();
    613.                 Date date = teacher.getBirth();
    614.                 String birth = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
    615.                 String zyzc = teacher.getZyzc();
    616.                 Integer zyid = teacher.getZyid();
    617.                 String zystr = zyglService.getZyglById(zyid).getZname();
    618.                 String tel = teacher.getTel();
    619.                 String jl = teacher.getJl();
    620.                 String idcardstr = String.valueOf(teacher.getIdcard());
    621.                 Map map = new HashMap();
    622.                 map.put("id", id);
    623.                 map.put("tname", tnamestr);
    624.                 map.put("sex", sex);
    625.                 map.put("birth", birth);
    626.                 map.put("zyzc", zyzc);
    627.                 map.put("zystr", zystr);
    628.                 map.put("tel", tel);
    629.                 map.put("jl", jl);
    630.                 map.put("idcard", idcardstr);
    631.                 list.add(map);
    632.             }
    633.         }
    634.         Map map1 = new HashMap<>();
    635.         map1.put("code", 0);
    636.         map1.put("msg", "ok");
    637.         map1.put("count", list.size());
    638.         map1.put("data", list);
    639.         setLog.setlod(httpServletRequest, "查询了教师信息数据",logService);
    640.         JSONObject json = new JSONObject(map1);
    641.         return json;
    642.     }
    643.  
    644.     /**
    645.      *   管理员  查询最后一条教师信息 账号
    646.      * @param httpServletRequest
    647.      * @return
    648.      */
    649.     @RequestMapping("/selectjslast")
    650.     public JSONObject selectjslast(HttpServletRequest httpServletRequest) {
    651.         Teacher teacher = teacherService.getteacherlast();
    652.         List> list = new ArrayList<>();
    653.         Integer idcard = teacher.getIdcard();
    654.         Map map = new HashMap();
    655.         map.put("idcard", idcard+1);
    656.         list.add(map);
    657.         Map map1 = new HashMap<>();
    658.         map1.put("code", 0);
    659.         map1.put("msg", "ok");
    660.         map1.put("count", list.size());
    661.         map1.put("data", list);
    662.         setLog.setlod(httpServletRequest, "查询了最后一条教师数据",logService);
    663.         JSONObject json = new JSONObject(map1);
    664.         return json;
    665.     }
    666.  
    667.     /**
    668.      *   管理员 查询教师信息 显示教师名称
    669.      * @param httpServletRequest
    670.      * @return
    671.      */
    672.     @RequestMapping("/selectjs")
    673.     public JSONObject selectjs(HttpServletRequest httpServletRequest) {
    674.         Map requestparamMap = new HashMap();
    675.         List teachers = teacherService.getTeacherList(requestparamMap);
    676.         List> list = new ArrayList<>();
    677.         if (teachers != null) {
    678.             for (Teacher teacher : teachers) {
    679.                 Integer id = teacher.getId();
    680.                 Integer idcard = teacher.getIdcard();
    681.                 String tname = teacher.getTname();
    682.                 Map map = new HashMap();
    683.                 map.put("id", id);
    684.                 map.put("tname", tname);
    685.                 map.put("idcard",idcard);
    686.                 list.add(map);
    687.             }
    688.         }
    689.         Map map1 = new HashMap<>();
    690.         map1.put("code", 0);
    691.         map1.put("msg", "ok");
    692.         map1.put("count", list.size());
    693.         map1.put("data", list);
    694.         setLog.setlod(httpServletRequest, "查询了教师信息数据",logService);
    695.         JSONObject json = new JSONObject(map1);
    696.         return json;
    697.     }
    698.  
    699.     /**
    700.      *  教师 查询个人信息
    701.      * @param httpServletRequest
    702.      * @return
    703.      */
    704.     @RequestMapping("/selectgrxxwhjs")
    705.     public JSONObject selectgrxxwhjs(HttpServletRequest httpServletRequest) {
    706.         HttpSession session = httpServletRequest.getSession();
    707.         Users users = (Users) session.getAttribute("islogin");
    708.         String username = users.getUsername();
    709.         Integer groupid = users.getGroupid();
    710.         List> list = new ArrayList<>();
    711.         if (groupid==2) {
    712.             Teacher teacher = teacherService.getTeacherByIdcard(Integer.parseInt(username));
    713.             if (teacher!=null){
    714.                 Integer id = teacher.getId();
    715.                 Integer idcard = teacher.getIdcard();
    716.                 Date date = teacher.getBirth();
    717.                 String birth = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
    718.                 String zyzc = teacher.getZyzc();
    719.                 String jl = teacher.getJl();
    720.                 String sex = teacher.getSex();
    721.                 String tname = teacher.getTname();
    722.                 String tel = teacher.getTel();
    723.                 Integer zid = teacher.getZyid();
    724.                 String zidstr = zyglService.getZyglById(zid).getZname();
    725.                 Map map = new HashMap();
    726.                 map.put("id",id);
    727.                 map.put("idcard",idcard);
    728.                 map.put("birth",birth);
    729.                 map.put("zyzc",zyzc);
    730.                 map.put("jl",jl);
    731.                 map.put("sex",sex);
    732.                 map.put("tname",tname);
    733.                 map.put("tel",tel);
    734.                 map.put("zid",zidstr);
    735.                 list.add(map);
    736.             }
    737.         }
    738.         if (groupid==3){
    739.             Student student = studentService.getStudentByIdcard(Integer.parseInt(username));
    740.  
    741.         }
    742.         Map map1 = new HashMap<>();
    743.         map1.put("code", 0);
    744.         map1.put("msg", "ok");
    745.         map1.put("count", list.size());
    746.         map1.put("data", list);
    747.         setLog.setlod(httpServletRequest, "查询了个人信息数据",logService);
    748.         JSONObject json = new JSONObject(map1);
    749.         return json;
    750.     }
    751.  
    752.     /**
    753.      *  管理员 查询全部专业信息
    754.      * @param httpServletRequest
    755.      * @return
    756.      */
    757.     @RequestMapping("/selectzy")
    758.     public JSONObject selectzy(HttpServletRequest httpServletRequest) {
    759.         Map requestparamMap = new HashMap();
    760.         List zygls = zyglService.getZyglList(requestparamMap);
    761.         List> list = new ArrayList<>();
    762.         if (zygls != null) {
    763.             for (Zygl zygl : zygls) {
    764.                 Integer id = zygl.getId();
    765.                 String zname = zygl.getZname();
    766.                 Map map = new HashMap();
    767.                 map.put("id", id);
    768.                 map.put("zname", zname);
    769.                 list.add(map);
    770.             }
    771.         }
    772.         Map map1 = new HashMap<>();
    773.         map1.put("code", 0);
    774.         map1.put("msg", "ok");
    775.         map1.put("count", list.size());
    776.         map1.put("data", list);
    777.         setLog.setlod(httpServletRequest, "查询了专业信息数据",logService);
    778.         JSONObject json = new JSONObject(map1);
    779.         return json;
    780.     }
    781.  
    782.  
    783.     /**
    784.      *  管理员  查询全部学生信息
    785.      * @param sname
    786.      * @param idcard
    787.      * @param httpServletRequest
    788.      * @return
    789.      */
    790.     @RequestMapping("/selectxsxxgl")
    791.     public JSONObject selectxsxxgl(@RequestParam(required = false)String sname,@RequestParam(required = false) String idcard, HttpServletRequest httpServletRequest) {
    792.         Map requestparamMap = new HashMap();
    793.         if (sname!=null&&!sname.equals(""))
    794.             requestparamMap.put("sname","%"+sname+"%");
    795.         if (idcard!=null&&!idcard.equals(""))
    796.             requestparamMap.put("idcard","%"+idcard+"%");
    797.         List students = studentService.getStudentList(requestparamMap);
    798.         List> list = new ArrayList<>();
    799.         if (students != null) {
    800.             for (Student student : students) {
    801.                 Integer id = student.getId();
    802.                 String snamestr = student.getSname();
    803.                 String sex = student.getSex();
    804.                 Date date = student.getBirth();
    805.                 String birth = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
    806.                 Integer zyid = student.getZid();
    807.                 Integer cid = student.getCid();
    808.                 String cstr = classesService.getClassesById(cid).getBname();
    809.                 String zystr = zyglService.getZyglById(zyid).getZname();
    810.                 String tel = String.valueOf(student.getTel());
    811.                 String jl = student.getJl();
    812.                 String idcardstr = String.valueOf(student.getIdcard());
    813.                 Map map = new HashMap();
    814.                 map.put("id", id);
    815.                 map.put("sname", snamestr);
    816.                 map.put("sex", sex);
    817.                 map.put("birth", birth);
    818.                 map.put("zystr", zystr);
    819.                 map.put("cstr", cstr);
    820.                 map.put("tel", tel);
    821.                 map.put("jl", jl);
    822.                 map.put("idcard", idcardstr);
    823.                 list.add(map);
    824.             }
    825.         }
    826.         Map map1 = new HashMap<>();
    827.         map1.put("code", 0);
    828.         map1.put("msg", "ok");
    829.         map1.put("count", list.size());
    830.         map1.put("data", list);
    831.         setLog.setlod(httpServletRequest, "查询了学生信息数据",logService);
    832.         JSONObject json = new JSONObject(map1);
    833.         return json;
    834.     }
    835.  
    836.     /**
    837.      * 管理员  查询最后一条学生信息 账号
    838.      * @param httpServletRequest
    839.      * @return
    840.      */
    841.     @RequestMapping("/selectxslast")
    842.     public JSONObject selectxslast(HttpServletRequest httpServletRequest) {
    843.         Student student = studentService.getStudentBylast();
    844.         List> list = new ArrayList<>();
    845.         Integer idcard = student.getIdcard();
    846.         Map map = new HashMap();
    847.         map.put("idcard", idcard+1);
    848.         list.add(map);
    849.         Map map1 = new HashMap<>();
    850.         map1.put("code", 0);
    851.         map1.put("msg", "ok");
    852.         map1.put("count", list.size());
    853.         map1.put("data", list);
    854.         setLog.setlod(httpServletRequest, "查询了最后一条学生数据",logService);
    855.         JSONObject json = new JSONObject(map1);
    856.         return json;
    857.     }
    858.  
    859.     /**
    860.      *  学生 个人信息维护
    861.      * @param httpServletRequest
    862.      * @return
    863.      */
    864.     @RequestMapping("/selectgrxxwh")
    865.     public JSONObject selectgrxxwh(HttpServletRequest httpServletRequest) {
    866.         HttpSession session = httpServletRequest.getSession();
    867.         Users users = (Users) session.getAttribute("islogin");
    868.         String username = users.getUsername();
    869.         Integer groupid = users.getGroupid();
    870.         List> list = new ArrayList<>();
    871.         if (groupid==2) {
    872.             Teacher teacher = teacherService.getTeacherByIdcard(Integer.parseInt(username));
    873.         }
    874.         if (groupid==3){
    875.             Student student = studentService.getStudentByIdcard(Integer.parseInt(username));
    876.             if (student!=null){
    877.                 Integer id = student.getId();
    878.                 Integer idcard = student.getIdcard();
    879.                 Date date = student.getBirth();
    880.                 String birth = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
    881.                 Integer cid = student.getCid();
    882.                 String cidstr = classesService.getClassesById(cid).getBname();
    883.                 String jl = student.getJl();
    884.                 String sex = student.getSex();
    885.                 String sname = student.getSname();
    886.                 String tel = student.getTel();
    887.                 Integer zid = student.getZid();
    888.                 String zidstr = zyglService.getZyglById(zid).getZname();
    889.                 Map map = new HashMap();
    890.                 map.put("id",id);
    891.                 map.put("idcard",idcard);
    892.                 map.put("birth",birth);
    893.                 map.put("cid",cidstr);
    894.                 map.put("jl",jl);
    895.                 map.put("sex",sex);
    896.                 map.put("sname",sname);
    897.                 map.put("tel",tel);
    898.                 map.put("zid",zidstr);
    899.                 list.add(map);
    900.             }
    901.         }
    902.         Map map1 = new HashMap<>();
    903.         map1.put("code", 0);
    904.         map1.put("msg", "ok");
    905.         map1.put("count", list.size());
    906.         map1.put("data", list);
    907.         setLog.setlod(httpServletRequest, "查询了个人信息数据",logService);
    908.         JSONObject json = new JSONObject(map1);
    909.         return json;
    910.     }
    911.  
    912.     /**
    913.      * 管理员  查询用户账号信息
    914.      * @param username
    915.      * @param httpServletRequest
    916.      * @return
    917.      */
    918.     @RequestMapping("/selectyhzhgl")
    919.     public JSONObject selectyhzhgl(@RequestParam(required = false)String username,HttpServletRequest httpServletRequest) {
    920.         Map requestparamMap = new HashMap();
    921.         if (username!=null&&!username.equals(""))
    922.             requestparamMap.put("username","%"+username+"%");
    923.         List userss = usersService.getuserList(requestparamMap);
    924.         List> list = new ArrayList<>();
    925.         if (userss != null) {
    926.             for (Users users : userss) {
    927.                 Integer id = users.getId();
    928.                 String usernamestr = users.getUsername();
    929.                 Integer gid = users.getGroupid();
    930.                 String groupstr = groupinfoService.selectByPrimaryKey(gid).getGroupname();// 显示用户组名称
    931.                 Date date = users.getRegtime();
    932.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    933.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    934.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    935.                 String regtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    936.                 Map map = new HashMap();
    937.                 map.put("id", id);
    938.                 map.put("username", usernamestr);
    939.                 map.put("groupstr", groupstr);
    940.                 map.put("regtime", regtime);
    941.                 list.add(map);
    942.             }
    943.         }
    944.         Map map1 = new HashMap<>();
    945.         map1.put("code", 0);
    946.         map1.put("msg", "ok");
    947.         map1.put("count", list.size());
    948.         map1.put("data", list);
    949.         setLog.setlod(httpServletRequest, "查询了用户信息数据",logService);
    950.         JSONObject json = new JSONObject(map1);
    951.         return json;
    952.     }
    953.  
    954.     /**
    955.      *  管理员  查询全部班级信息
    956.      * @param bname
    957.      * @param httpServletRequest
    958.      * @return
    959.      */
    960.     @RequestMapping("/selectbjxxgl")
    961.     public JSONObject selectbjxxgl(@RequestParam(required = false)String bname,HttpServletRequest httpServletRequest) {
    962.         Map requestparamMap = new HashMap();
    963.         if (bname!=null&&!bname.equals(""))
    964.             requestparamMap.put("bname","%"+bname+"%");
    965.         List classess = classesService.getClassesList(requestparamMap);
    966.         List> list = new ArrayList<>();
    967.         if (classess != null) {
    968.             for (Classes classes : classess) {
    969.                 Integer id = classes.getId();
    970.                 String bnamestr = classes.getBname();
    971.                 Integer tid = classes.getTid();
    972.                 String idcard = String.valueOf(teacherService.getTeacherById(tid).getIdcard());
    973.                 String tid1 = teacherService.getTeacherById(tid).getTname();
    974.                 String tidstr = tid1+"---"+idcard;
    975.                 Map map = new HashMap();
    976.                 map.put("id", id);
    977.                 map.put("bname", bnamestr);
    978.                 map.put("tid", tidstr);
    979.                 list.add(map);
    980.             }
    981.         }
    982.         Map map1 = new HashMap<>();
    983.         map1.put("code", 0);
    984.         map1.put("msg", "ok");
    985.         map1.put("count", list.size());
    986.         map1.put("data", list);
    987.         setLog.setlod(httpServletRequest, "查询了班级信息数据",logService);
    988.         JSONObject json = new JSONObject(map1);
    989.         return json;
    990.     }
    991.  
    992.     /**
    993.      * 管理员  查询班级信息 显示班级名称
    994.      * @param httpServletRequest
    995.      * @return
    996.      */
    997.     @RequestMapping("/selectbj")
    998.     public JSONObject selectbj(HttpServletRequest httpServletRequest) {
    999.         Map requestparamMap = new HashMap();
    1000.         List classess = classesService.getClassesList(requestparamMap);
    1001.         List> list = new ArrayList<>();
    1002.         if (classess != null) {
    1003.             for (Classes classes : classess) {
    1004.                 Integer id = classes.getId();
    1005.                 String bname = classes.getBname();
    1006.                 Map map = new HashMap();
    1007.                 map.put("id", id);
    1008.                 map.put("bname", bname);
    1009.                 list.add(map);
    1010.             }
    1011.         }
    1012.         Map map1 = new HashMap<>();
    1013.         map1.put("code", 0);
    1014.         map1.put("msg", "ok");
    1015.         map1.put("count", list.size());
    1016.         map1.put("data", list);
    1017.         setLog.setlod(httpServletRequest, "查询了班级信息数据",logService);
    1018.         JSONObject json = new JSONObject(map1);
    1019.         return json;
    1020.     }
    1021.  
    1022.  
    1023.     /**
    1024.      *  管理员  查询全部专业信息
    1025.      * @param zname
    1026.      * @param httpServletRequest
    1027.      * @return
    1028.      */
    1029.     @RequestMapping("/selectzyxxgl")
    1030.     public JSONObject selectzyxxgl(@RequestParam(required = false)String zname, HttpServletRequest httpServletRequest) {
    1031.         Map requestparamMap = new HashMap();
    1032.         if (zname!=null&&!zname.equals(""))
    1033.             requestparamMap.put("zname","%"+zname+"%");
    1034.         List zygls = zyglService.getZyglList(requestparamMap);
    1035.         List> list = new ArrayList<>();
    1036.         if (zygls != null) {
    1037.             for (Zygl zygl : zygls) {
    1038.                 Integer id = zygl.getId();
    1039.                 String znamestr = zygl.getZname();
    1040.                 Map map = new HashMap();
    1041.                 map.put("id", id);
    1042.                 map.put("zname", znamestr);
    1043.                 list.add(map);
    1044.             }
    1045.         }
    1046.         Map map1 = new HashMap<>();
    1047.         map1.put("code", 0);
    1048.         map1.put("msg", "ok");
    1049.         map1.put("count", list.size());
    1050.         map1.put("data", list);
    1051.         setLog.setlod(httpServletRequest, "查询了专业信息数据",logService);
    1052.         JSONObject json = new JSONObject(map1);
    1053.         return json;
    1054.     }
    1055.  
    1056.     /**
    1057.      * 管理员 查询全部实验室类型
    1058.      * @param lx
    1059.      * @param httpServletRequest
    1060.      * @return
    1061.      */
    1062.     @RequestMapping("/selectsylxgl")
    1063.     public JSONObject selectsylxgl(@RequestParam(required = false)String lx, HttpServletRequest httpServletRequest) {
    1064.         Map requestparamMap = new HashMap();
    1065.         if (lx!=null&&!lx.equals(""))
    1066.             requestparamMap.put("lx","%"+lx+"%");
    1067.         List syslxes = syslxService.getSyslxList(requestparamMap);
    1068.         List> list = new ArrayList<>();
    1069.         if (syslxes != null) {
    1070.             for (Syslx syslx : syslxes) {
    1071.                 Integer id = syslx.getId();
    1072.                 String lxstr = syslx.getLx();
    1073.                 Map map = new HashMap();
    1074.                 map.put("id", id);
    1075.                 map.put("lx", lxstr);
    1076.                 list.add(map);
    1077.             }
    1078.         }
    1079.         Map map1 = new HashMap<>();
    1080.         map1.put("code", 0);
    1081.         map1.put("msg", "ok");
    1082.         map1.put("count", list.size());
    1083.         map1.put("data", list);
    1084.         setLog.setlod(httpServletRequest, "查询了实验室类型信息数据",logService);
    1085.         JSONObject json = new JSONObject(map1);
    1086.         return json;
    1087.     }
    1088.  
    1089.     /**
    1090.      *  管理员 查询实验室类型 显示实验类型名称
    1091.      * @param httpServletRequest
    1092.      * @return
    1093.      */
    1094.     @RequestMapping("/selectsyslx")
    1095.     public JSONObject selectsyslx(HttpServletRequest httpServletRequest) {
    1096.         Map requestparamMap = new HashMap();
    1097.         List syslxs = syslxService.getSyslxList(requestparamMap);
    1098.         List> list = new ArrayList<>();
    1099.         if (syslxs != null) {
    1100.             for (Syslx syslx : syslxs) {
    1101.                 Integer id = syslx.getId();
    1102.                 String lx = syslx.getLx();
    1103.                 Map map = new HashMap();
    1104.                 map.put("id", id);
    1105.                 map.put("lx", lx);
    1106.                 list.add(map);
    1107.             }
    1108.         }
    1109.         Map map1 = new HashMap<>();
    1110.         map1.put("code", 0);
    1111.         map1.put("msg", "ok");
    1112.         map1.put("count", list.size());
    1113.         map1.put("data", list);
    1114.         setLog.setlod(httpServletRequest, "查询了实验室类型数据",logService);
    1115.         JSONObject json = new JSONObject(map1);
    1116.         return json;
    1117.     }
    1118.  
    1119.     /**
    1120.      *  管理员 查询全部信息通告
    1121.      * @param httpServletRequest
    1122.      * @return
    1123.      */
    1124.     @RequestMapping("/selectxxtggl")
    1125.     public JSONObject selectxxtggl(HttpServletRequest httpServletRequest) {
    1126.         Map requestparamMap = new HashMap();
    1127.         List xxtgs = xxtgService.getXxtgList(requestparamMap);
    1128.         List> list = new ArrayList<>();
    1129.         if (xxtgs != null) {
    1130.             for (Xxtg xxtg : xxtgs) {
    1131.                 Integer id = xxtg.getId();
    1132.                 String fbrstr = usersService.selectByPrimaryKey(xxtg.getFbrid()).getUsername(); //显示账号名称
    1133.                 String info = xxtg.getInfo();
    1134.                 Date date = xxtg.getFbtime();
    1135.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1136.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1137.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1138.                 String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1139.                 Map map = new HashMap();
    1140.                 map.put("id", id);
    1141.                 map.put("fbrid", fbrstr);
    1142.                 map.put("info", info);
    1143.                 map.put("fbtime", fbtime);
    1144.                 list.add(map);
    1145.             }
    1146.         }
    1147.         Map map1 = new HashMap<>();
    1148.         map1.put("code", 0);
    1149.         map1.put("msg", "ok");
    1150.         map1.put("count", list.size());
    1151.         map1.put("data", list);
    1152.         setLog.setlod(httpServletRequest, "查询了信息通告数据",logService);
    1153.         JSONObject json = new JSONObject(map1);
    1154.         return json;
    1155.     }
    1156.  
    1157.     /**
    1158.      *  教师 学生 查询全部信息通告
    1159.      * @param httpServletRequest
    1160.      * @return
    1161.      */
    1162.     @RequestMapping("/selectxxtgll")
    1163.     public JSONObject selectxxtgll(@RequestParam(required = false) String info, HttpServletRequest httpServletRequest) {
    1164.         Map requestparamMap = new HashMap();
    1165.         if (info!=null&&!info.equals(""))
    1166.             requestparamMap.put("info","%"+info+"%");
    1167.         List xxtgs = xxtgService.getXxtgList(requestparamMap);
    1168.         List> list = new ArrayList<>();
    1169.         if (xxtgs != null) {
    1170.             for (Xxtg xxtg : xxtgs) {
    1171.                 Integer id = xxtg.getId();
    1172.                 Integer fbrid = xxtg.getFbrid();
    1173.                 String infostr = xxtg.getInfo();
    1174.                 Date date = xxtg.getFbtime();
    1175.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1176.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1177.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1178.                 String fbsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1179.                 Users users = usersService.selectByPrimaryKey(fbrid);
    1180.                 String username = users.getUsername();
    1181.                 Map map = new HashMap();
    1182.                 map.put("id", id);
    1183.                 map.put("fbrid", username);
    1184.                 map.put("info", infostr);
    1185.                 map.put("fbtime", fbsj);
    1186.                 list.add(map);
    1187.             }
    1188.         }
    1189.         Map map1 = new HashMap<>();
    1190.         map1.put("code", 0);
    1191.         map1.put("msg", "ok");
    1192.         map1.put("count", list.size());
    1193.         map1.put("data", list);
    1194.         setLog.setlod(httpServletRequest, "查看了信息通告",logService);
    1195.         JSONObject json = new JSONObject(map1);
    1196.         return json;
    1197.     }
    1198.  
    1199.  
    1200.     /**
    1201.      *  管理员 查询全部实验设备
    1202.      * @param sbname
    1203.      * @param bh
    1204.      * @param httpServletRequest
    1205.      * @return
    1206.      */
    1207.     @RequestMapping("/selectsysbgl")
    1208.     public JSONObject selectsysbgl(@RequestParam(required = false)String sbname,@RequestParam(required = false) String bh, HttpServletRequest httpServletRequest) {
    1209.         Map requestparamMap = new HashMap();
    1210.         if (sbname!=null&&!sbname.equals(""))
    1211.             requestparamMap.put("sbname","%"+sbname+"%");
    1212.         if (bh!=null&&!bh.equals(""))
    1213.             requestparamMap.put("bh","%"+bh+"%");
    1214.         List sysbgls = sysbglService.getSysbglList(requestparamMap);
    1215.         List> list = new ArrayList<>();
    1216.         if (sysbgls != null) {
    1217.             for (Sysbgl sysbgl : sysbgls) {
    1218.                 Integer id = sysbgl.getId();
    1219.                 String sbnamestr = sysbgl.getSbname();
    1220.                 String bhstr = sysbgl.getBh();
    1221.                 String sysid = sysglService.getSysglById(sysbgl.getSysid()).getSysname(); //查询实验室名称
    1222.                 Date date = sysbgl.getCgsj();
    1223.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1224.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1225.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1226.                 String cgsj =  String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
    1227.                 Integer price = sysbgl.getPrice();
    1228.                 Integer ztid = sysbgl.getZtid();
    1229.                 String ztstr="未使用";
    1230.                 if (ztid==1)
    1231.                     ztstr = "正在使用";
    1232.                 if (ztid==2)
    1233.                     ztstr = "待审核";
    1234.                 if (ztid==3)
    1235.                     ztstr = "维修中";
    1236.                 if (ztid==4)
    1237.                     ztstr = "已损坏";
    1238.                 if (ztid==5)
    1239.                     ztstr = "无法维修";
    1240.                 String sfbxstr = "未报修";
    1241.                 Integer sfbx = sysbgl.getSfbx();
    1242.                 if (sfbx==1)
    1243.                     sfbxstr="已报修";
    1244.                 String info = sysbgl.getInfo();
    1245.                 String img = sysbgl.getImg();
    1246.                 Map map = new HashMap();
    1247.                 map.put("id", id);
    1248.                 map.put("sbname", sbnamestr);
    1249.                 map.put("bh", bhstr);
    1250.                 map.put("sysid", sysid);
    1251.                 map.put("cgsj", cgsj);
    1252.                 map.put("price", price);
    1253.                 map.put("ztid", ztstr);
    1254.                 map.put("sfbx", sfbxstr);
    1255.                 map.put("info", info);
    1256.                 map.put("img", img);
    1257.                 list.add(map);
    1258.             }
    1259.         }
    1260.         Map map1 = new HashMap<>();
    1261.         map1.put("code", 0);
    1262.         map1.put("msg", "ok");
    1263.         map1.put("count", list.size());
    1264.         map1.put("data", list);
    1265.         setLog.setlod(httpServletRequest, "查询了设备信息数据",logService);
    1266.         JSONObject json = new JSONObject(map1);
    1267.         return json;
    1268.     }
    1269.  
    1270.     /**
    1271.      *  管理员  查询全部设备借用
    1272.      * @param httpServletRequest
    1273.      * @return
    1274.      */
    1275.     @RequestMapping("/selectsbsysp")
    1276.     public JSONObject selectsbsysp(HttpServletRequest httpServletRequest) {
    1277.         List jydjs = jydjService.getJydjByZtid(2);
    1278.         List> list = new ArrayList<>();
    1279.         if (jydjs != null) {
    1280.             for (Jydj jydj : jydjs) {
    1281.                 Integer id = jydj.getId();
    1282.                 String info = jydj.getInfo();
    1283.                 Date date = jydj.getJysj();
    1284.                 Integer sbid = jydj.getSbid();
    1285.                 Integer uid = jydj.getUid();
    1286.                 String sbstr = sysbglService.getSysbglById(sbid).getSbname();
    1287.                 String ustr = usersService.selectByPrimaryKey(uid).getUsername();
    1288.                 String sbbh = sysbglService.getSysbglById(sbid).getBh();
    1289.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1290.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1291.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1292.                 String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1293.                 Map map = new HashMap();
    1294.                 map.put("id", id);
    1295.                 map.put("info", info);
    1296.                 map.put("sbid", sbstr);
    1297.                 map.put("uid", ustr);
    1298.                 map.put("sbbh", sbbh);
    1299.                 map.put("jysj", fbtime);
    1300.                 list.add(map);
    1301.             }
    1302.         }
    1303.         Map map1 = new HashMap<>();
    1304.         map1.put("code", 0);
    1305.         map1.put("msg", "ok");
    1306.         map1.put("count", list.size());
    1307.         map1.put("data", list);
    1308.         setLog.setlod(httpServletRequest, "打开了设备使用审批",logService);
    1309.         JSONObject json = new JSONObject(map1);
    1310.         return json;
    1311.     }
    1312.  
    1313.     /**
    1314.      *  教师 查询借用设备
    1315.      * @param httpServletRequest
    1316.      * @return
    1317.      */
    1318.     @RequestMapping("/selectjysbgl")
    1319.     public JSONObject selectjysbgl(HttpServletRequest httpServletRequest) {
    1320.         HttpSession session = httpServletRequest.getSession();
    1321.         Users users = (Users) session.getAttribute("islogin");
    1322.         Integer tid = users.getId();
    1323.         List jydjs = jydjService.getJydjByUid(tid);
    1324.         List> list = new ArrayList<>();
    1325.         if (jydjs != null) {
    1326.             for (Jydj jydj : jydjs) {
    1327.                 Integer id = jydj.getId();
    1328.                 Integer sbid = jydj.getSbid();
    1329.                 Date date = jydj.getJysj();
    1330.                 String info = jydj.getInfo();
    1331.                 Date date1 = jydj.getGhsj();
    1332.                 Integer ztid = jydj.getZtid();
    1333.                 Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
    1334.                 String sbname = sysbgl.getSbname();
    1335.                 String bh = sysbgl.getBh();
    1336.                 String ghsj = "未归还";
    1337.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1338.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1339.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1340.                 String jysj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1341.                 if (date1!=null) {
    1342.                     String hour2 = date1.getHours() > 9 ? String.valueOf(date1.getHours()) : 0 + String.valueOf(date1.getHours());
    1343.                     String minute2 = date1.getMinutes() > 9 ? String.valueOf(date1.getMinutes()) : 0 + String.valueOf(date1.getMinutes());
    1344.                     String second2 = date1.getSeconds() > 9 ? String.valueOf(date1.getSeconds()) : 0 + String.valueOf(date1.getSeconds());
    1345.                     ghsj = String.valueOf(date1.getYear() + 1900) + "年" + String.valueOf(date1.getMonth() + 1) + "月" + String.valueOf(date1.getDate()) + "日--" + hour + ":" + minute + ":" + second;
    1346.                 }
    1347.                 if(ztid==2)
    1348.                     ghsj="管理员审核中";
    1349.                 if(ztid==3)
    1350.                     ghsj="借用被拒绝";
    1351.                 Map map = new HashMap();
    1352.                 map.put("id", id);
    1353.                 map.put("sbname", sbname);
    1354.                 map.put("bh", bh);
    1355.                 map.put("jysj", jysj);
    1356.                 map.put("ghsj", ghsj);
    1357.                 map.put("info", info);
    1358.                 map.put("ztid", ztid);
    1359.                 list.add(map);
    1360.             }
    1361.         }
    1362.         Map map1 = new HashMap<>();
    1363.         map1.put("code", 0);
    1364.         map1.put("msg", "ok");
    1365.         map1.put("count", list.size());
    1366.         map1.put("data", list);
    1367.         setLog.setlod(httpServletRequest, "查询了借用设备记录数据",logService);
    1368.         JSONObject json = new JSONObject(map1);
    1369.         return json;
    1370.     }
    1371.  
    1372.     /**
    1373.      *  教师 查询可用设备
    1374.      * @param httpServletRequest
    1375.      * @return
    1376.      */
    1377.     @RequestMapping("/selectkysb")
    1378.     public JSONObject selectkysb(HttpServletRequest httpServletRequest) {
    1379.         List sysbgls = sysbglService.getSysbglByky();
    1380.         List> list = new ArrayList<>();
    1381.         if (sysbgls != null) {
    1382.             for (Sysbgl sysbgl : sysbgls) {
    1383.                 Integer id = sysbgl.getId();
    1384.                 String bh = sysbgl.getBh();
    1385.                 String sbname = sysbgl.getSbname();
    1386.                 Map map = new HashMap();
    1387.                 map.put("id", id);
    1388.                 map.put("bh", bh);
    1389.                 map.put("sbname", sbname);
    1390.                 list.add(map);
    1391.             }
    1392.         }
    1393.         Map map1 = new HashMap<>();
    1394.         map1.put("code", 0);
    1395.         map1.put("msg", "ok");
    1396.         map1.put("count", list.size());
    1397.         map1.put("data", list);
    1398.         setLog.setlod(httpServletRequest, "查询了可用实验设备列表",logService);
    1399.         JSONObject json = new JSONObject(map1);
    1400.         return json;
    1401.     }
    1402.  
    1403.     /**
    1404.      *  教师 查询全部损坏设备记录
    1405.      * @param httpServletRequest
    1406.      * @return
    1407.      */
    1408.     @RequestMapping("/selectsbshdj")
    1409.     public JSONObject selectsbshdj(HttpServletRequest httpServletRequest) {
    1410.         HttpSession session = httpServletRequest.getSession();
    1411.         Users users = (Users) session.getAttribute("islogin");
    1412.         Integer uid = users.getId();
    1413.         List sbshdjs = sbshdjService.getSbshdjByUid(uid);
    1414.         List> list = new ArrayList<>();
    1415.         if (sbshdjs != null) {
    1416.             for (Sbshdj sbshdj : sbshdjs) {
    1417.                 Integer id = sbshdj.getId();
    1418.                 Integer sbid = sbshdj.getSbid();
    1419.                 String info = sbshdj.getInfo();
    1420.                 Integer ztid = sbshdj.getZtid();
    1421.                 String ztidstr = "已损坏";
    1422.                 if (ztid==1){
    1423.                     ztidstr="已维修";
    1424.                 }
    1425.                 if (ztid==2){
    1426.                     ztidstr="无法维修";
    1427.                 }
    1428.                 if (ztid==3){
    1429.                     ztidstr="维修中";
    1430.                 }
    1431.                 Date date = sbshdj.getShsj();
    1432.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1433.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1434.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1435.                 String shsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1436.                 Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
    1437.                 String sbname = sysbgl.getSbname();
    1438.                 String bh = sysbgl.getBh();
    1439.                 Map map = new HashMap();
    1440.                 map.put("id", id);
    1441.                 map.put("sbname", sbname);
    1442.                 map.put("bh", bh);
    1443.                 map.put("shsj", shsj);
    1444.                 map.put("info", info);
    1445.                 map.put("ztid", ztidstr);
    1446.                 list.add(map);
    1447.             }
    1448.         }
    1449.         Map map1 = new HashMap<>();
    1450.         map1.put("code", 0);
    1451.         map1.put("msg", "ok");
    1452.         map1.put("count", list.size());
    1453.         map1.put("data", list);
    1454.         setLog.setlod(httpServletRequest, "查询了设备损坏记录数据",logService);
    1455.         JSONObject json = new JSONObject(map1);
    1456.         return json;
    1457.     }
    1458.  
    1459.     /**
    1460.      *  教师 查询全部维修设备
    1461.      * @param info
    1462.      * @param httpServletRequest
    1463.      * @return
    1464.      */
    1465.     @RequestMapping("/selectsbwxdj")
    1466.     public JSONObject selectsbwxdj(@RequestParam(required = false) String info, HttpServletRequest httpServletRequest) {
    1467.         Map requestparamMap = new HashMap();
    1468.         if (info!=null&&!info.equals(""))
    1469.             requestparamMap.put("info","%"+info+"%");
    1470.         List sbwxdjs = sbwxdjService.getSbwxdjList(requestparamMap);
    1471.         List> list = new ArrayList<>();
    1472.         if (sbwxdjs != null) {
    1473.             for (Sbwxdj sbwxdj : sbwxdjs) {
    1474.                 Integer id = sbwxdj.getId();
    1475.                 Integer sbid = sbwxdj.getSbid();
    1476.                 String infostr = sbwxdj.getInfo();
    1477.                 Integer ztid = sbwxdj.getZtid();
    1478.                 String wxr = sbwxdj.getWxr();
    1479.                 Integer money = sbwxdj.getMoney();
    1480.                 String ztidstr = "正在维修";
    1481.                 if (ztid==1){
    1482.                     ztidstr="维修完毕";
    1483.                 }
    1484.                 if (ztid==2){
    1485.                     ztidstr="无法维修";
    1486.                 }
    1487.                 Date date = sbwxdj.getWssj();
    1488.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1489.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1490.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1491.                 String wxsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1492.                 Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
    1493.                 String sbname = sysbgl.getSbname();
    1494.                 String bh = sysbgl.getBh();
    1495.                 Map map = new HashMap();
    1496.                 map.put("id", id);
    1497.                 map.put("sbname", sbname);
    1498.                 map.put("bh", bh);
    1499.                 map.put("wxsj", wxsj);
    1500.                 map.put("info", infostr);
    1501.                 map.put("ztid", ztidstr);
    1502.                 map.put("wxr", wxr);
    1503.                 map.put("money", money);
    1504.                 list.add(map);
    1505.             }
    1506.         }
    1507.         Map map1 = new HashMap<>();
    1508.         map1.put("code", 0);
    1509.         map1.put("msg", "ok");
    1510.         map1.put("count", list.size());
    1511.         map1.put("data", list);
    1512.         setLog.setlod(httpServletRequest, "查询了设备维修记录数据",logService);
    1513.         JSONObject json = new JSONObject(map1);
    1514.         return json;
    1515.     }
    1516.  
    1517.     /**
    1518.      *  教师 查询已损坏设备 显示维修设备名
    1519.      * @param httpServletRequest
    1520.      * @return
    1521.      */
    1522.     @RequestMapping("/selectkwxsb")
    1523.     public JSONObject selectkwxsb(HttpServletRequest httpServletRequest) {
    1524.         List sbshdjs = sbshdjService.getSbshdjByZtid(0);
    1525.         List> list = new ArrayList<>();
    1526.         if (sbshdjs != null) {
    1527.             for (Sbshdj sbshdj : sbshdjs) {
    1528.                 Integer id = sbshdj.getId();
    1529.                 Integer sbid = sbshdj.getSbid();
    1530.                 Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
    1531.                 String sbname = sysbgl.getSbname();
    1532.                 String bh = sysbgl.getBh();
    1533.                 Map map = new HashMap();
    1534.                 map.put("id", sbid);
    1535.                 map.put("sbname", sbname);
    1536.                 map.put("bh", bh);
    1537.                 list.add(map);
    1538.             }
    1539.         }
    1540.         Map map1 = new HashMap<>();
    1541.         map1.put("code", 0);
    1542.         map1.put("msg", "ok");
    1543.         map1.put("count", list.size());
    1544.         map1.put("data", list);
    1545.         setLog.setlod(httpServletRequest, "查询了可维修设备列表数据",logService);
    1546.         JSONObject json = new JSONObject(map1);
    1547.         return json;
    1548.     }
    1549.  
    1550.     /**
    1551.      *  学生 查询实验设备信息
    1552.      * @param httpServletRequest
    1553.      * @return
    1554.      */
    1555.     @RequestMapping("/selectsysbll")
    1556.     public JSONObject selectsysbll(HttpServletRequest httpServletRequest) {
    1557.         HttpSession session = httpServletRequest.getSession();
    1558.         Users users = (Users) session.getAttribute("islogin");
    1559.         List> list = new ArrayList<>();
    1560.         if (users.getGroupid()==3){
    1561.             Student student = studentService.getStudentByIdcard(Integer.parseInt(users.getUsername()));
    1562.             List syxxbList = syxxbService.getSyxxbByCid(student.getCid());
    1563.             if (syxxbList!=null)
    1564.                 for (Syxxb syxxb : syxxbList){
    1565.                     Integer sysid = syxxb.getSysid();
    1566.                     List sysbgls = sysbglService.getSysbglBySysid(sysid);
    1567.                     for (Sysbgl sysbgl:sysbgls){
    1568.                         Integer id = sysbgl.getId();
    1569.                         String sbnamestr = sysbgl.getSbname();
    1570.                         String bhstr = sysbgl.getBh();
    1571.                         String sysidstr = sysglService.getSysglById(sysid).getSysname();
    1572.                         Date date = sysbgl.getCgsj();
    1573.                         String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1574.                         String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1575.                         String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1576.                         String cgsj =  String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
    1577.                         Integer price = sysbgl.getPrice();
    1578.                         Integer ztid = sysbgl.getZtid();
    1579.                         String ztstr="未使用";
    1580.                         if (ztid==1)
    1581.                             ztstr = "正在使用";
    1582.                         if (ztid==2)
    1583.                             ztstr = "待审核";
    1584.                         if (ztid==3)
    1585.                             ztstr = "维修中";
    1586.                         if (ztid==4)
    1587.                             ztstr = "已损坏";
    1588.                         if (ztid==5)
    1589.                             ztstr = "无法维修";
    1590.                         String sfbxstr = "未报修";
    1591.                         Integer sfbx = sysbgl.getSfbx();
    1592.                         if (sfbx==1)
    1593.                             sfbxstr="已报修";
    1594.                         String info = sysbgl.getInfo();
    1595.                         String img = sysbgl.getImg();
    1596.                         Map map = new HashMap();
    1597.                         map.put("id", id);
    1598.                         map.put("sbname", sbnamestr);
    1599.                         map.put("bh", bhstr);
    1600.                         map.put("sysid", sysidstr);
    1601.                         map.put("cgsj", cgsj);
    1602.                         map.put("price", price);
    1603.                         map.put("ztid", ztstr);
    1604.                         map.put("sfbx", sfbxstr);
    1605.                         map.put("info", info);
    1606.                         map.put("img", img);
    1607.                         list.add(map);
    1608.                     }
    1609.                 }
    1610.             Map map1 = new HashMap<>();
    1611.             map1.put("code", 0);
    1612.             map1.put("msg", "ok");
    1613.             map1.put("count", list.size());
    1614.             map1.put("data", list);
    1615.             setLog.setlod(httpServletRequest, "查询了设备信息数据",logService);
    1616.             JSONObject json = new JSONObject(map1);
    1617.             return json;
    1618.         }
    1619.         Map map1 = new HashMap<>();
    1620.         map1.put("code", 0);
    1621.         map1.put("msg", "ok");
    1622.         map1.put("count", list.size());
    1623.         map1.put("data", list);
    1624.         setLog.setlod(httpServletRequest, "查询了设备信息数据",logService);
    1625.         JSONObject json = new JSONObject(map1);
    1626.         return json;
    1627.     }
    1628.  
    1629.  
    1630.     /**
    1631.      *  教师 查询全部实验课程信息
    1632.      * @param info
    1633.      * @param httpServletRequest
    1634.      * @return
    1635.      */
    1636.     @RequestMapping("/selectsykcgl")
    1637.     public JSONObject selectsykcgl(@RequestParam(required = false)String info,HttpServletRequest httpServletRequest) {
    1638.         HttpSession session = httpServletRequest.getSession();
    1639.         Users users = (Users) session.getAttribute("islogin");
    1640.         Integer uid = users.getId();
    1641.         System.out.printf("uid");
    1642.         Map requestparamMap = new HashMap();
    1643.         if (info!=null&&!info.equals(""))
    1644.             requestparamMap.put("info","%"+info+"%");
    1645.         if (uid!=null&&!uid.equals(""))
    1646.             requestparamMap.put("tid",uid);
    1647.         List syxxbs = syxxbService.getSyxxbList(requestparamMap);
    1648.         List> list = new ArrayList<>();
    1649.         if (syxxbs != null) {
    1650.             for (Syxxb syxxb : syxxbs) {
    1651.                 Integer cid = syxxb.getCid();
    1652.                 Date date = syxxb.getFbtime();
    1653.                 Integer id = syxxb.getId();
    1654.                 String infostr = syxxb.getInfo();
    1655.                 Integer sfwc = syxxb.getSfwc();
    1656.                 Integer sysid = syxxb.getSysid();
    1657.                 String cidstr = classesService.getClassesById(cid).getBname();
    1658.                 String sfwcstr = "未完成";
    1659.                 if (sfwc==1){
    1660.                     sfwcstr="已完成";
    1661.                 }
    1662.                 String sysidstr = sysglService.getSysglById(sysid).getSysname();
    1663.                 String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1664.                 String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1665.                 String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1666.                 String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1667.                 Map map = new HashMap();
    1668.                 map.put("id", id);
    1669.                 map.put("info", infostr);
    1670.                 map.put("sysid", sysidstr);
    1671.                 map.put("cid", cidstr);
    1672.                 map.put("sfwc", sfwcstr);
    1673.                 map.put("fbtime", fbtime);
    1674.                 list.add(map);
    1675.             }
    1676.         }
    1677.         Map map1 = new HashMap<>();
    1678.         map1.put("code", 0);
    1679.         map1.put("msg", "ok");
    1680.         map1.put("count", list.size());
    1681.         map1.put("data", list);
    1682.         setLog.setlod(httpServletRequest, "查询了实验课程信息数据",logService);
    1683.         JSONObject json = new JSONObject(map1);
    1684.         return json;
    1685.     }
    1686.  
    1687.     /**
    1688.      *  学生 查询实验课程信息
    1689.      * @param httpServletRequest
    1690.      * @return
    1691.      */
    1692.     @RequestMapping("/selectsykcll")
    1693.     public JSONObject selectsykcll(HttpServletRequest httpServletRequest) {
    1694.         HttpSession session = httpServletRequest.getSession();
    1695.         Users users = (Users) session.getAttribute("islogin");
    1696.         List> list = new ArrayList<>();
    1697.         if (users.getGroupid()==3){
    1698.             Student student = studentService.getStudentByIdcard(Integer.parseInt(users.getUsername()));
    1699.             List syxxbs = syxxbService.getSyxxbByCid(student.getCid());
    1700.             if (syxxbs != null) {
    1701.                 for (Syxxb syxxb : syxxbs) {
    1702.                     Date date = syxxb.getFbtime();
    1703.                     Integer id = syxxb.getId();
    1704.                     String infostr = syxxb.getInfo();
    1705.                     Integer sysid = syxxb.getSysid();
    1706.                     String bh = sysglService.getSysglById(sysid).getBh();
    1707.                     String sysidstr = sysglService.getSysglById(sysid).getSysname();
    1708.                     String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
    1709.                     String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
    1710.                     String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
    1711.                     String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
    1712.                     Map map = new HashMap();
    1713.                     map.put("id", id);
    1714.                     map.put("info", infostr);
    1715.                     map.put("bh", bh);
    1716.                     map.put("sysid", sysidstr);
    1717.                     map.put("fbtime", fbtime);
    1718.                     list.add(map);
    1719.                 }
    1720.             }
    1721.             Map map1 = new HashMap<>();
    1722.             map1.put("code", 0);
    1723.             map1.put("msg", "ok");
    1724.             map1.put("count", list.size());
    1725.             map1.put("data", list);
    1726.             setLog.setlod(httpServletRequest, "查询了实验课程信息数据",logService);
    1727.             JSONObject json = new JSONObject(map1);
    1728.             return json;
    1729.         }
    1730.         Map map1 = new HashMap<>();
    1731.         map1.put("code", 0);
    1732.         map1.put("msg", "ok");
    1733.         map1.put("count", list.size());
    1734.         map1.put("data", list);
    1735.         setLog.setlod(httpServletRequest, "查询了实验课程信息数据",logService);
    1736.         JSONObject json = new JSONObject(map1);
    1737.         return json;
    1738.     }
    1739.  
    1740. }

    如果也想学习本系统，下面领取。关注并回复：035ssm 

  • 相关阅读:
    GB28181学习（十三）——订阅与通知
    Java里使用AspectJ实现AOP
    Flutter 教程之 Kotlin 多平台与 Flutter，为您的应用选择哪一个
    Linux sed命令增删改查 附代码
    纯手工总结超详细关于计算机网络的五层知识点，看看你都掌握了没
    阅读Android源代码
    什么是RESTful API，Spring MVC如何支持RESTful架构
    【计算机视觉】24-Object Detection
    Redis缓存的雪崩、穿透、击穿
    使用vue3搭建后台系统的过程记录
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128156303