247-基于SSM的实验室设备管理系统（源码+数据库）

package com.sys.controller; import com.alibaba.fastjson.JSONObject; import com.sys.model.*; import com.sys.service.*; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import java.util.*; @RestController public class selectController { @Autowired private MenuService menuService; @Autowired private LogService logService; @Autowired private GroupinfoService groupinfoService; @Autowired private StudentService studentService; @Autowired private TeacherService teacherService; @Autowired private ZyglService zyglService; @Autowired private ClassesService classesService; @Autowired private UsersService usersService; @Autowired private SyslxService syslxService; @Autowired private XxtgService xxtgService; @Autowired private SysbglService sysbglService; @Autowired private SysglService sysglService; @Autowired private JydjService jydjService; @Autowired private SyxxbService syxxbService; @Autowired private SbshdjService sbshdjService; @Autowired private SbwxdjService sbwxdjService; /** * 管理员 修改密码 * @param oldpass * @param newpass * @param newpass2 * @param httpServletRequest * @return */ @RequestMapping("/getoldpass") public JSONObject getoldpass(@RequestParam(value = "oldpass")String oldpass, @RequestParam(value = "newpass")String newpass, @RequestParam(value = "newpass2")String newpass2, HttpServletRequest httpServletRequest) { HttpSession session = httpServletRequest.getSession(); oldpass = UtilPacket.Md5MD5String(oldpass); newpass = UtilPacket.Md5MD5String(newpass); newpass2 = UtilPacket.Md5MD5String(newpass2); //获取前端传入的数据 Integer code = 500; String msg= "账号服务器错误！"; Users users = (Users)session.getAttribute("islogin"); //获取登录账户 String upass = users.getUpassword(); setLog.setlod(httpServletRequest, "正在修改密码",logService); if (upass.equals(oldpass)){ if (newpass2.equals(newpass)){ if (!oldpass.equals(newpass)){ code = 0; msg = "密码修改成功请重新登录"; users.setUpassword(newpass); if(usersService.updateByPrimaryKeySelective(users)!=0) { setLog.setlod(httpServletRequest, users.getUsername() + "用户修改了密码",logService); session.invalidate(); } } else{ code=1; msg="新密码与原密码相同！"; } } else { code = 2; msg="新密码两次输入不一致！"; } } else { code = 3; msg = "原密码错误！"; } Map<String,Object> map = new HashMap<>(); map.put("success",true); map.put("code",code); map.put("msg",msg); JSONObject json = new JSONObject(map); return json; } /** * 管理员 查询全部实验室信息 * @param sysname * @param bh * @param httpServletRequest * @return */ @RequestMapping("/selectsysjbxxgl") public JSONObject selectsysjbxxgl(@RequestParam(required = false)String sysname,@RequestParam(required = false)String bh,HttpServletRequest httpServletRequest) { Map requestparamMap = new HashMap(); if (sysname!=null&&!sysname.equals("")) requestparamMap.put("sysname","%"+sysname+"%"); if (bh!=null&&!bh.equals("")) requestparamMap.put("bh","%"+bh+"%"); List<Sysgl> sysgls = sysglService.getSysglList(requestparamMap); List<Map<String, Object>> list = new ArrayList<>(); if (sysgls != null) { for (Sysgl sysgl : sysgls) { String yyridstr = "未预约"; Integer id = sysgl.getId(); String sysnamestr = sysgl.getSysname(); if (sysgl.getYyrid()!=null&&!sysgl.getYyrid().equals("")) { Integer yyrid = sysgl.getYyrid(); yyridstr = usersService.selectByPrimaryKey(yyrid).getUsername(); /*返回预约用户名*/ System.out.println(yyridstr); } Integer lxid = sysgl.getLxid(); String lc = sysgl.getLc(); String fzrid = sysgl.getFzrid(); String bhstr = sysgl.getBh(); Integer sfyy = sysgl.getSfyy(); String lxidstr = syslxService.getSyslxById(lxid).getLx(); //返回实验室类型名称 String sfyystr = "未预约"; if (sfyy==1){ sfyystr="已预约"; } if (sfyy==2){ sfyystr="预约未审核"; } Map map = new HashMap(); map.put("id", id); map.put("yyrid", yyridstr); map.put("sysname", sysnamestr); map.put("lc", lc); map.put("fzrid", fzrid); map.put("bh", bhstr); map.put("lxid", lxidstr); map.put("sfyy", sfyystr); list.add(map); } } Map<String, Object> map1 = new HashMap<>(); map1.put("code", 0); map1.put("msg", "ok"); map1.put("count", list.size()); map1.put("data", list); setLog.setlod(httpServletRequest, "查询了实验室基本信息数据",logService); JSONObject json = new JSONObject(map1); return json; } /** * 管理员 查询实验室 显示实验室名称 * @param httpServletRequest * @return */ @RequestMapping("/selectsys") public JSONObject selectsys(HttpServletRequest httpServletRequest) { Map requestparamMap = new HashMap(); List<Sysgl> sysgls = sysglService.getSysglList(requestparamMap); List<Map<String, Object>> list = new ArrayList<>(); if (sysgls != null) { for (Sysgl sysgl : sysgls) { Integer id = sysgl.getId(); String sysname = sysgl.getSysname(); Map map = new HashMap(); map.put("id", id); map.put("sysname", sysname); list.add(map); } } Map<String, Object> map1 = new HashMap<>(); map1.put("code", 0); map1.put("msg", "ok"); map1.put("count", list.size()); map1.put("data", list); setLog.setlod(httpServletRequest, "查询了实验室信息数据",logService); JSONObject json = new JSONObject(map1); return json; } /** * 管理员 查询全部实验室使用审批 * @param httpServletRequest * @return */ @RequestMapping("/selectsyssysp") public JSONObject selectsyssysp(HttpServletRequest httpServletRequest) { List<Sysgl> sysgls = sysglService.getSysglBySfyy(2); List<Map<String, Object>> list = new ArrayList<>(); if (sysgls != null) { for (Sysgl sysgl : sysgls) { Integer id = sysgl.getId(); String sysname = sysgl.getSysname(); String bh = sysgl.getBh(); String fzrid = sysgl.getFzrid(); String lc = sysgl.getLc(); Integer lxid = sysgl.getLxid(); Integer yyrid = sysg