基于javaweb+mysql的ssm+maven实验室设备管理系统(java+ssm+thymeleaf+html+layui+easyui+mysql+redis)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven实验室设备管理系统(java+ssm+thymeleaf+html+layui+easyui+mysql+redis)
项目介绍
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 版本均可;
技术栈
- 后端:Spring SpringMVC MyBatis 2. 前端:jsp+layui+easyui
使用说明
- 使用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 登录
}
return false;
}
/*教师 修改实验课程*/
@RequestMapping("/upsykcgl")
public boolean upsykcgl(@RequestParam(value = "id") int id,
@RequestParam(value = "field") String field,
@RequestParam(value = "updateValue") String updateValue,
HttpServletRequest httpServletRequest){
Syxxb syxxb = syxxbService.getSyxxbById(id);
if (syxxb != null) {
if (field.equals("info"))
syxxb.setInfo(updateValue);
if (syxxbService.upSyxxb(syxxb) != 0) {
setLog.setlod(httpServletRequest, "修改了id为" + id + "的实验课程" + field + "为" + updateValue,logService);
return true;
}
return false;
}
return false;
}
/**
* 教师 完成实验课程
* @param httpServletRequest
* @param id
* @return
*/
@RequestMapping("/sykcglwc")
public boolean sykcglwc(HttpServletRequest httpServletRequest, @RequestParam int id){
Syxxb syxxb = syxxbService.getSyxxbById(id);
syxxb.setSfwc(1);
if (syxxbService.upSyxxb(syxxb)!=0) {
setLog.setlod(httpServletRequest, "实验id为" + syxxb.getId() + "的实验已完成", logService);
return true;
}
return false;
}
/**
* 上传图片
JSONObject json = new JSONObject(map1);
return json;
}
/**
* 教师 查询全部维修设备
* @param info
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectsbwxdj")
public JSONObject selectsbwxdj(@RequestParam(required = false) String info, HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (info!=null&&!info.equals(""))
requestparamMap.put("info","%"+info+"%");
List<Sbwxdj> sbwxdjs = sbwxdjService.getSbwxdjList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (sbwxdjs != null) {
for (Sbwxdj sbwxdj : sbwxdjs) {
Integer id = sbwxdj.getId();
Integer sbid = sbwxdj.getSbid();
String infostr = sbwxdj.getInfo();
Integer ztid = sbwxdj.getZtid();
String wxr = sbwxdj.getWxr();
Integer money = sbwxdj.getMoney();
String ztidstr = "正在维修";
if (ztid==1){
ztidstr="维修完毕";
}
if (ztid==2){
ztidstr="无法维修";
}
Date date = sbwxdj.getWssj();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String wxsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
String sbname = sysbgl.getSbname();
String bh = sysbgl.getBh();
Map map = new HashMap();
map.put("id", id);
map.put("sbname", sbname);
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 sbname
* @param bh
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectsysbgl")
public JSONObject selectsysbgl(@RequestParam(required = false)String sbname,@RequestParam(required = false) String bh, HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (sbname!=null&&!sbname.equals(""))
requestparamMap.put("sbname","%"+sbname+"%");
if (bh!=null&&!bh.equals(""))
requestparamMap.put("bh","%"+bh+"%");
List<Sysbgl> sysbgls = sysbglService.getSysbglList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (sysbgls != null) {
for (Sysbgl sysbgl : sysbgls) {
Integer id = sysbgl.getId();
String sbnamestr = sysbgl.getSbname();
String bhstr = sysbgl.getBh();
String sysid = sysglService.getSysglById(sysbgl.getSysid()).getSysname(); //查询实验室名称
Date date = sysbgl.getCgsj();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String cgsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
Integer price = sysbgl.getPrice();
Integer ztid = sysbgl.getZtid();
String ztstr="未使用";
if (ztid==1)
ztstr = "正在使用";
return true;
} else
return false;
}
}
package com.sys.controller;
@RestController
public class delController {
@Autowired
private LogService logService;
@Autowired
private GroupinfoService groupinfoService;
@Autowired
private MenuService menuService;
@Autowired
private TeacherService teacherService;
@Autowired
private UsersService usersService;
@Autowired
private StudentService studentService;
@Autowired
private ClassesService classesService;
@Autowired
private ZyglService zyglService;
@Autowired
private SyslxService syslxService;
@Autowired
private XxtgService xxtgService;
@Autowired
private SysbglService sysbglService;
@Autowired
private SysglService sysglService;
@Autowired
private SyxxbService syxxbService;
/**
* 管理员 修改专业信息
* @param id
* @param field
* @param updateValue
* @param httpServletRequest
* @return
*/
@RequestMapping("/upzyxxgl")
public boolean upzyxxgl(@RequestParam(value = "id") int id,
@RequestParam(value = "field") String field,
@RequestParam(value = "updateValue") String updateValue,
HttpServletRequest httpServletRequest) {
Zygl zygl = zyglService.getZyglById(id);
if (zygl != null) {
if (field.equals("zname"))
zygl.setZname(updateValue);
if (zyglService.upZygl(zygl) != 0) {
setLog.setlod(httpServletRequest, "修改了id为" + id + "的专业" + field + "为" + updateValue,logService);
return true;
}
return false;
}
return false;
}
/**
* 管理员 修改实验室类型
* @param id
* @param field
* @param updateValue
* @param httpServletRequest
* @return
*/
@RequestMapping("/upsylxgl")
public boolean upsylxgl(@RequestParam(value = "id") int id,
@RequestParam(value = "field") String field,
@RequestParam(value = "updateValue") String updateValue,
HttpServletRequest httpServletRequest) {
Syslx syslx = syslxService.getSyslxById(id);
if (syslx != null) {
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("/selectkysys")
public JSONObject selectkysys(HttpServletRequest httpServletRequest) {
List<Sysgl> sysgls = sysglService.getSysglBySfyy(0);
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();
Map map = new HashMap();
map.put("id", id);
map.put("sysname", sysname);
map.put("bh", bh);
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);
for (Xxtg xxtg : xxtgs) {
Integer id = xxtg.getId();
String fbrstr = usersService.selectByPrimaryKey(xxtg.getFbrid()).getUsername(); //显示账号名称
String info = xxtg.getInfo();
Date date = xxtg.getFbtime();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Map map = new HashMap();
map.put("id", id);
map.put("fbrid", fbrstr);
map.put("info", info);
map.put("fbtime", fbtime);
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("/selectxxtgll")
public JSONObject selectxxtgll(@RequestParam(required = false) String info, HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (info!=null&&!info.equals(""))
requestparamMap.put("info","%"+info+"%");
List<Xxtg> xxtgs = xxtgService.getXxtgList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (xxtgs != null) {
for (Xxtg xxtg : xxtgs) {
Integer id = xxtg.getId();
Integer fbrid = xxtg.getFbrid();
String infostr = xxtg.getInfo();
Date date = xxtg.getFbtime();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String fbsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Users users = usersService.selectByPrimaryKey(fbrid);
* 管理员 查询全部实验室使用审批
* @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 = sysgl.getYyrid();
String lx = syslxService.getSyslxById(lxid).getLx();
String yyr = usersService.selectByPrimaryKey(yyrid).getUsername();//显示预约人名称
Map map = new HashMap();
map.put("id", id);
map.put("sysname", sysname);
map.put("bh", bh);
map.put("fzrid", fzrid);
map.put("lc", lc);
map.put("lx", lx);
map.put("yyr", yyr);
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;
}
/**
* 教师 查询已预约实验室
syxxb.setCid(Integer.parseInt(cid));
syxxb.setFbtime(new Date(new Date().getTime()));
syxxb.setSysid(Integer.parseInt(sysid));
syxxb.setTid(tid);
if (syxxbService.insertSyxxb(syxxb) != 0) {
setLog.setlod(httpServletRequest, "成功创建实验课程", logService);
return true;
} else
return false;
}
/**
* 教师 添加借用设备
* @param httpServletRequest
* @param sbid
* @param info
* @return
*/
@RequestMapping("/Insertjysbgl")
public boolean Insertjysbgl(HttpServletRequest httpServletRequest, @RequestParam int sbid,@RequestParam String info){
HttpSession session = httpServletRequest.getSession();
Users users = (Users) session.getAttribute("islogin");
int uid = users.getId();
Jydj jydj = new Jydj();
jydj.setZtid(2);
jydj.setInfo(info);
jydj.setJysj(new Date(new Date().getTime()));
jydj.setSbid(sbid);
jydj.setUid(uid);
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
sysbgl.setZtid(2);
if (jydjService.insertJydj(jydj)!=0&&sysbglService.upSysbgl(sysbgl)!=0) {
setLog.setlod(httpServletRequest, "提交设备编号为" + sysbgl.getBh() + "的实验设备借用请求", logService);
return true;
}
return false;
}
/**
* 教师 添加损坏设备记录
* @param sbid
* @param info
* @param httpServletRequest
* @return
*/
@RequestMapping("Insertsbshdj")
public boolean Insertsbshdj(@RequestParam int sbid,
@RequestParam String info,
HttpServletRequest httpServletRequest) {
HttpSession httpSession = httpServletRequest.getSession();
Users users = (Users) httpSession.getAttribute("islogin");
Sbshdj sbshdj = new Sbshdj();
*/
@RequestMapping("/selectjysysgl")
public JSONObject selectjysysgl(HttpServletRequest httpServletRequest) {
HttpSession session = httpServletRequest.getSession();
Users users = (Users) session.getAttribute("islogin");
Integer tid = users.getId();
List<Sysgl> sysgls = sysglService.getSysglByteacher(tid);
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();
}
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);
@RestController
public class upController {
@Autowired
private LogService logService;
@Autowired
private GroupinfoService groupinfoService;
@Autowired
private MenuService menuService;
@Autowired
private TeacherService teacherService;
@Autowired
private StudentService studentService;
@Autowired
private UsersService usersService;
@Autowired
private ClassesService classesService;
@Autowired
private ZyglService zyglService;
@Autowired
private SyslxService syslxService;
@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 id
* @param field
/**
* 管理员 查询全部设备借用
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectsbsysp")
public JSONObject selectsbsysp(HttpServletRequest httpServletRequest) {
List<Jydj> jydjs = jydjService.getJydjByZtid(2);
List<Map<String, Object>> list = new ArrayList<>();
if (jydjs != null) {
for (Jydj jydj : jydjs) {
Integer id = jydj.getId();
String info = jydj.getInfo();
Date date = jydj.getJysj();
Integer sbid = jydj.getSbid();
Integer uid = jydj.getUid();
String sbstr = sysbglService.getSysbglById(sbid).getSbname();
String ustr = usersService.selectByPrimaryKey(uid).getUsername();
String sbbh = sysbglService.getSysbglById(sbid).getBh();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Map map = new HashMap();
map.put("id", id);
map.put("info", info);
map.put("sbid", sbstr);
map.put("uid", ustr);
map.put("sbbh", sbbh);
map.put("jysj", fbtime);
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 sbid
* @param info
* @param httpServletRequest
* @return
*/
@RequestMapping("Insertsbshdj")
public boolean Insertsbshdj(@RequestParam int sbid,
@RequestParam String info,
HttpServletRequest httpServletRequest) {
HttpSession httpSession = httpServletRequest.getSession();
Users users = (Users) httpSession.getAttribute("islogin");
Sbshdj sbshdj = new Sbshdj();
sbshdj.setZtid(0);
sbshdj.setInfo(info);
sbshdj.setSbid(sbid);
sbshdj.setShsj(new Date(new Date().getTime()));
sbshdj.setUid(users.getId());
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
sysbgl.setSfbx(0);
sysbgl.setZtid(4);
if (sysbglService.upSysbgl(sysbgl) != 0&&sbshdjService.InsertSbshdj(sbshdj)!=0) {
setLog.setlod(httpServletRequest, "设备"+sysbgl.getSbname()+"---"+sysbgl.getBh()+"损坏", logService);
return true;
} else
return false;
}
/**
* 教师 添加维修设备记录
* @param sbid
* @param info
* @param ztid
* @param wxr
* @param money
* @param httpServletRequest
* @return
* @throws ParseException
*/
@RequestMapping("Insertsbwxdj")
public boolean Insertsbwxdj(@RequestParam int sbid,
@RequestParam String info,
@RequestParam int ztid,
@RequestParam String wxr,
@RequestParam int money,
map.put("groupstr", groupstr);
map.put("regtime", regtime);
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 bname
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectbjxxgl")
public JSONObject selectbjxxgl(@RequestParam(required = false)String bname,HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (bname!=null&&!bname.equals(""))
requestparamMap.put("bname","%"+bname+"%");
List<Classes> classess = classesService.getClassesList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (classess != null) {
for (Classes classes : classess) {
Integer id = classes.getId();
String bnamestr = classes.getBname();
Integer tid = classes.getTid();
String idcard = String.valueOf(teacherService.getTeacherById(tid).getIdcard());
String tid1 = teacherService.getTeacherById(tid).getTname();
String tidstr = tid1+"---"+idcard;
Map map = new HashMap();
map.put("id", id);
map.put("bname", bnamestr);
map.put("tid", tidstr);
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;
}
map.put("bh", bhstr);
map.put("sysid", sysidstr);
map.put("cgsj", cgsj);
map.put("price", price);
map.put("ztid", ztstr);
map.put("sfbx", sfbxstr);
map.put("info", info);
map.put("img", img);
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;
}
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 info
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectsykcgl")
public JSONObject selectsykcgl(@RequestParam(required = false)String info,HttpServletRequest httpServletRequest) {
HttpSession session = httpServletRequest.getSession();
Users users = (Users) session.getAttribute("islogin");
Integer uid = users.getId();
System.out.printf("uid");
Map requestparamMap = new HashMap();
if (info!=null&&!info.equals(""))
requestparamMap.put("info","%"+info+"%");
@RequestMapping("/sbwxdjwxwb")
public boolean sbshdjwxwb(HttpServletRequest httpServletRequest, @RequestParam int id){
Sbwxdj sbwxdj = sbwxdjService.getSbwxdjById(id);
int sbid = sbwxdj.getSbid();
sbwxdj.setZtid(1);
Sbshdj sbshdj = sbshdjService.getSbshdjBySbid(sbid);
sbshdj.setZtid(1);
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
if (sysbgl!=null) {
sysbgl.setZtid(0);
sysbgl.setSfbx(0);
if (sysbglService.upSysbgl(sysbgl)!=0&&sbshdjService.upSbshdj(sbshdj)!=0&&sbwxdjService.upSbwxdj(sbwxdj)!=0) {
setLog.setlod(httpServletRequest, "设备编号为" + sysbgl.getBh() + "的设备维修完毕", logService);
return true;
}
return false;
}
return false;
}
/**
* 教师 修改无法维修设备状态
* @param httpServletRequest
* @param id
* @return
*/
@RequestMapping("/sbwxdjwfwx")
public boolean sbshdjwfwx(HttpServletRequest httpServletRequest, @RequestParam int id){
Sbwxdj sbwxdj = sbwxdjService.getSbwxdjById(id);
int sbid = sbwxdj.getSbid();
sbwxdj.setZtid(2);
Sbshdj sbshdj = sbshdjService.getSbshdjBySbid(sbid);
sbshdj.setZtid(2);
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
if (sysbgl!=null) {
sysbgl.setZtid(5);
sysbgl.setSfbx(1);
if (sysbglService.upSysbgl(sysbgl)!=0&&sbshdjService.upSbshdj(sbshdj)!=0&&sbwxdjService.upSbwxdj(sbwxdj)!=0) {
setLog.setlod(httpServletRequest, "设备编号为" + sysbgl.getBh() + "的设备无法维修", logService);
return true;
}
return false;
}
return false;
}
/*教师 修改实验课程*/
@RequestMapping("/upsykcgl")
public boolean upsykcgl(@RequestParam(value = "id") int id,
@RequestParam(value = "field") String field,
@RequestParam(value = "updateValue") String updateValue,
HttpServletRequest httpServletRequest){
@RequestMapping("/selectjysbgl")
public JSONObject selectjysbgl(HttpServletRequest httpServletRequest) {
HttpSession session = httpServletRequest.getSession();
Users users = (Users) session.getAttribute("islogin");
Integer tid = users.getId();
List<Jydj> jydjs = jydjService.getJydjByUid(tid);
List<Map<String, Object>> list = new ArrayList<>();
if (jydjs != null) {
for (Jydj jydj : jydjs) {
Integer id = jydj.getId();
Integer sbid = jydj.getSbid();
Date date = jydj.getJysj();
String info = jydj.getInfo();
Date date1 = jydj.getGhsj();
Integer ztid = jydj.getZtid();
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
String sbname = sysbgl.getSbname();
String bh = sysbgl.getBh();
String ghsj = "未归还";
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String jysj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
if (date1!=null) {
String hour2 = date1.getHours() > 9 ? String.valueOf(date1.getHours()) : 0 + String.valueOf(date1.getHours());
String minute2 = date1.getMinutes() > 9 ? String.valueOf(date1.getMinutes()) : 0 + String.valueOf(date1.getMinutes());
String second2 = date1.getSeconds() > 9 ? String.valueOf(date1.getSeconds()) : 0 + String.valueOf(date1.getSeconds());
ghsj = String.valueOf(date1.getYear() + 1900) + "年" + String.valueOf(date1.getMonth() + 1) + "月" + String.valueOf(date1.getDate()) + "日--" + hour + ":" + minute + ":" + second;
}
if(ztid==2)
ghsj="管理员审核中";
if(ztid==3)
ghsj="借用被拒绝";
Map map = new HashMap();
map.put("id", id);
map.put("sbname", sbname);
map.put("bh", bh);
map.put("jysj", jysj);
map.put("ghsj", ghsj);
map.put("info", info);
map.put("ztid", ztid);
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 lx
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectsylxgl")
public JSONObject selectsylxgl(@RequestParam(required = false)String lx, HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (lx!=null&&!lx.equals(""))
requestparamMap.put("lx","%"+lx+"%");
List<Syslx> syslxes = syslxService.getSyslxList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (syslxes != null) {
for (Syslx syslx : syslxes) {
Integer id = syslx.getId();
String lxstr = syslx.getLx();
Map map = new HashMap();
map.put("id", id);
map.put("lx", lxstr);
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("/selectsyslx")
public JSONObject selectsyslx(HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
List<Syslx> syslxs = syslxService.getSyslxList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (syslxs != null) {
for (Syslx syslx : syslxs) {
Integer id = syslx.getId();
String lx = syslx.getLx();
Map map = new HashMap();
map.put("id", id);
map.put("lx", lx);
list.add(map);
}
}
Map<String, Object> map1 = new HashMap<>();
}
}
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("/selectxxtgll")
public JSONObject selectxxtgll(@RequestParam(required = false) String info, HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (info!=null&&!info.equals(""))
requestparamMap.put("info","%"+info+"%");
List<Xxtg> xxtgs = xxtgService.getXxtgList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (xxtgs != null) {
for (Xxtg xxtg : xxtgs) {
Integer id = xxtg.getId();
Integer fbrid = xxtg.getFbrid();
String infostr = xxtg.getInfo();
Date date = xxtg.getFbtime();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String fbsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Users users = usersService.selectByPrimaryKey(fbrid);
String username = users.getUsername();
Map map = new HashMap();
map.put("id", id);
map.put("fbrid", username);
map.put("info", infostr);
map.put("fbtime", fbsj);
list.add(map);
}
return true;
}
return false;
}
return false;
}
/**
* 教师 修改无法维修设备状态
* @param httpServletRequest
* @param id
* @return
*/
@RequestMapping("/sbwxdjwfwx")
public boolean sbshdjwfwx(HttpServletRequest httpServletRequest, @RequestParam int id){
Sbwxdj sbwxdj = sbwxdjService.getSbwxdjById(id);
int sbid = sbwxdj.getSbid();
sbwxdj.setZtid(2);
Sbshdj sbshdj = sbshdjService.getSbshdjBySbid(sbid);
sbshdj.setZtid(2);
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
if (sysbgl!=null) {
sysbgl.setZtid(5);
sysbgl.setSfbx(1);
if (sysbglService.upSysbgl(sysbgl)!=0&&sbshdjService.upSbshdj(sbshdj)!=0&&sbwxdjService.upSbwxdj(sbwxdj)!=0) {
setLog.setlod(httpServletRequest, "设备编号为" + sysbgl.getBh() + "的设备无法维修", logService);
return true;
}
return false;
}
return false;
}
/*教师 修改实验课程*/
@RequestMapping("/upsykcgl")
public boolean upsykcgl(@RequestParam(value = "id") int id,
@RequestParam(value = "field") String field,
@RequestParam(value = "updateValue") String updateValue,
HttpServletRequest httpServletRequest){
Syxxb syxxb = syxxbService.getSyxxbById(id);
if (syxxb != null) {
if (field.equals("info"))
syxxb.setInfo(updateValue);
if (syxxbService.upSyxxb(syxxb) != 0) {
setLog.setlod(httpServletRequest, "修改了id为" + id + "的实验课程" + field + "为" + updateValue,logService);
return true;
}
return false;
}
return false;
}
Integer id = users.getId();
String usernamestr = users.getUsername();
Integer gid = users.getGroupid();
String groupstr = groupinfoService.selectByPrimaryKey(gid).getGroupname();// 显示用户组名称
Date date = users.getRegtime();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String regtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Map map = new HashMap();
map.put("id", id);
map.put("username", usernamestr);
map.put("groupstr", groupstr);
map.put("regtime", regtime);
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 bname
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectbjxxgl")
public JSONObject selectbjxxgl(@RequestParam(required = false)String bname,HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (bname!=null&&!bname.equals(""))
requestparamMap.put("bname","%"+bname+"%");
List<Classes> classess = classesService.getClassesList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (classess != null) {
for (Classes classes : classess) {
Integer id = classes.getId();
String bnamestr = classes.getBname();
Integer tid = classes.getTid();
String idcard = String.valueOf(teacherService.getTeacherById(tid).getIdcard());
String tid1 = teacherService.getTeacherById(tid).getTname();
String tidstr = tid1+"---"+idcard;
Integer id = users.getId();
String usernamestr = users.getUsername();
Integer gid = users.getGroupid();
String groupstr = groupinfoService.selectByPrimaryKey(gid).getGroupname();// 显示用户组名称
Date date = users.getRegtime();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String regtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Map map = new HashMap();
map.put("id", id);
map.put("username", usernamestr);
map.put("groupstr", groupstr);
map.put("regtime", regtime);
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 bname
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectbjxxgl")
public JSONObject selectbjxxgl(@RequestParam(required = false)String bname,HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
if (bname!=null&&!bname.equals(""))
requestparamMap.put("bname","%"+bname+"%");
List<Classes> classess = classesService.getClassesList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (classess != null) {
for (Classes classes : classess) {
Integer id = classes.getId();
String bnamestr = classes.getBname();
Integer tid = classes.getTid();
String idcard = String.valueOf(teacherService.getTeacherById(tid).getIdcard());
String tid1 = teacherService.getTeacherById(tid).getTname();
String tidstr = tid1+"---"+idcard;
Map map = new HashMap();
map.put("id", id);
map.put("bname", bnamestr);
map.put("tid", tidstr);
list.add(map);
@RequestMapping("/deljsxxgl")
public boolean deljsxxgl(HttpServletRequest httpServletRequest, @RequestParam int id){
Teacher teacher = teacherService.getTeacherById(id);
if (teacherService.delTeacher(id)!=0) {
setLog.setlod(httpServletRequest, "删除了主键为"+id+"的教师",logService);
Users users = usersService.getusersByusername(String.valueOf(teacher.getIdcard()));
if (usersService.deleteByPrimaryKey(users.getId())!=0)
setLog.setlod(httpServletRequest, "删除了主键为"+id+"的教师账号",logService);
return true;
}
return false;
}
/**
* 删除学生信息
* @param httpServletRequest
* @param id
* @return
*/
@RequestMapping("/delxsxxgl")
public boolean delxsxxgl(HttpServletRequest httpServletRequest, @RequestParam int id){
Student student = studentService.getStudentById(id);
if (studentService.delStudent(id)!=0) {
setLog.setlod(httpServletRequest, "删除了主键为"+id+"的学生",logService);
Users users = usersService.getusersByusername(String.valueOf(student.getIdcard()));
if (usersService.deleteByPrimaryKey(users.getId())!=0)
setLog.setlod(httpServletRequest, "删除了主键为"+id+"的学生账号",logService);
return true;
}
return false;
}
/**
* 删除用户账号信息
* @param httpServletRequest
* @param id
* @return
*/
@RequestMapping("/delyhzhgl")
public boolean delyhzhgl(HttpServletRequest httpServletRequest, @RequestParam int id){
if (usersService.deleteByPrimaryKey(id)!=0) {
setLog.setlod(httpServletRequest, "删除了主键为"+id+"的用户",logService);
return true;
}
return false;
}
/**
* 删除班级信息
list.add(map);
}
}
if (groupid==3){
Student student = studentService.getStudentByIdcard(Integer.parseInt(username));
}
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("/selectzy")
public JSONObject selectzy(HttpServletRequest httpServletRequest) {
Map requestparamMap = new HashMap();
List<Zygl> zygls = zyglService.getZyglList(requestparamMap);
List<Map<String, Object>> list = new ArrayList<>();
if (zygls != null) {
for (Zygl zygl : zygls) {
Integer id = zygl.getId();
String zname = zygl.getZname();
Map map = new HashMap();
map.put("id", id);
map.put("zname", zname);
list.add(map);
}
}
Map<String, Object> map1 = new HashMap<>();
map1.put("code", 0);
map1.put("msg", "ok");
* 教师 查询全部损坏设备记录
* @param httpServletRequest
* @return
*/
@RequestMapping("/selectsbshdj")
public JSONObject selectsbshdj(HttpServletRequest httpServletRequest) {
HttpSession session = httpServletRequest.getSession();
Users users = (Users) session.getAttribute("islogin");
Integer uid = users.getId();
List<Sbshdj> sbshdjs = sbshdjService.getSbshdjByUid(uid);
List<Map<String, Object>> list = new ArrayList<>();
if (sbshdjs != null) {
for (Sbshdj sbshdj : sbshdjs) {
Integer id = sbshdj.getId();
Integer sbid = sbshdj.getSbid();
String info = sbshdj.getInfo();
Integer ztid = sbshdj.getZtid();
String ztidstr = "已损坏";
if (ztid==1){
ztidstr="已维修";
}
if (ztid==2){
ztidstr="无法维修";
}
if (ztid==3){
ztidstr="维修中";
}
Date date = sbshdj.getShsj();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String shsj = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Sysbgl sysbgl = sysbglService.getSysbglById(sbid);
String sbname = sysbgl.getSbname();
String bh = sysbgl.getBh();
Map map = new HashMap();
map.put("id", id);
map.put("sbname", sbname);
map.put("bh", bh);
map.put("shsj", shsj);
map.put("cgsj", cgsj);
map.put("price", price);
map.put("ztid", ztstr);
map.put("sfbx", sfbxstr);
map.put("info", info);
map.put("img", img);
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("/selectsbsysp")
public JSONObject selectsbsysp(HttpServletRequest httpServletRequest) {
List<Jydj> jydjs = jydjService.getJydjByZtid(2);
List<Map<String, Object>> list = new ArrayList<>();
if (jydjs != null) {
for (Jydj jydj : jydjs) {
Integer id = jydj.getId();
String info = jydj.getInfo();
Date date = jydj.getJysj();
Integer sbid = jydj.getSbid();
Integer uid = jydj.getUid();
String sbstr = sysbglService.getSysbglById(sbid).getSbname();
String ustr = usersService.selectByPrimaryKey(uid).getUsername();
String sbbh = sysbglService.getSysbglById(sbid).getBh();
String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
String fbtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
Map map = new HashMap();
map.put("id", id);
map.put("info", info);
map.put("sbid", sbstr);