基于javaweb的大学实验室设备管理系统(java+jsp+easyui+html+mysql)

基于javaweb的大学实验室设备管理系统(java+jsp+easyui+html+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的大学实验室设备管理系统(java+JSP+easyui+HTML+Mysql)

项目介绍

本项目为后台管理系统，主要功能如下： 管理员登录,管理数据字典,设备信息管理,进购管理,报损管理,查看库存,账号管理等功能。

环境需要

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.数据库：MySql 5.7版本； 6.是否Maven项目：否；

技术栈

HTML+CSS+JavaScript+JSP+jquery+easyui+mysql

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中dbpool.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/jsp_dxsys_sys/ 登录 管理员账号密码：admin/admin

系统用户管理控制层：

@Controller

public class SysuserController {

@Resource

private SysuserServier userService;

@RequestMapping(“flogin.do”)

public String login() {

return “login”;

@RequestMapping(“admin/showUserInfo.do”)

public String showUserInfo(ModelMap map,HttpSession session){

if(session.getAttribute(“auser”)==null){

return “login”;

Sysuser u=(Sysuser)session.getAttribute(“auser”);

map.put(“user”,userService.getById(u.getUid()));

return “admin/update_user_persion”;

@RequestMapping(“admin/updatePersionUser.do”)

public String updateUserInfo(ModelMap map,HttpSession session,Sysuser user){

userService.update(user);

map.put(“user”, userService.getById(user.getUid()));

session.setAttribute(“suc”, “cc”);

return “redirect:showUserInfo.do”;

@RequestMapping(“admin/login.do”)

public String aLogin() {

return “admin/login”;

// 处理修改个人信息

@RequestMapping(“showInfo.do”)

public String showInfo(HttpSession session,ModelMap map) {

Sysuser u=(Sysuser)session.getAttribute(“user”);

if(u==null){

return “fore_login”;

}else{

map.put(“user”, userService.getById(u.getUid()));

return “showUserinfo”;

// 处理修改个人信息

@RequestMapping(“addShowInfo.do”)

public String addShowInfo(HttpSession session,ModelMap map,Sysuser user) {

userService.update(user);

return “success”;

// 文件上传

public String fileUpload(@RequestParam(value=“file”,required=false)MultipartFile file,

HttpServletRequest request,String img){

String path=request.getSession().getServletContext().getRealPath(“upload”);

System.out.println(“path===”+path);

System.out.println(“file===”+file);

String fileName=file.getOriginalFilename();

System.out.println(“fileName===”+fileName);

File targetFile=new File(path,fileName);

if(!targetFile.exists()){

targetFile.mkdirs();

try {

file.transferTo(targetFile);

} catch (IllegalStateException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

String pa=request.getContextPath()+“/upload/”+fileName;

System.out.println(“path===”+pa);

if(fileName!=null&&!fileName.equals(“”)){

img=fileName;

}else{

img=null;

return img;

// 后台登录

@RequestMapping(“admin/alogin.do”)

public String checkLogin(ModelMap map,Sysuser user, HttpSession session) {

Map<String,Object> u=new HashMap<String,Object>();

System.out.println(“name===” + user.getUname());

System.out.println(“pwd===” + user.getPwd());

u.put(“uname”,user.getUname());

u.put(“utype”, user.getUtype());

u.put(“pwd”,user.getPwd());

user = userService.adminLogin(u);

if (user != null) {

session.setAttribute(“auser”, user);

System.out.println(“auser=” + user);

return “admin/index”;

} else {

map.put(“errorInfo”, “用户名或者密码错误！”);

return “admin/login”;

// 后台注销登录

@RequestMapping(“admin/loginout.do”)

public String adminLoginOut(HttpSession session) {

session.removeAttribute(“auser”);

return “redirect:login.do”;

// 前台注销登录

@RequestMapping(“loginout.do”)

public String loginOut(HttpSession session) {

session.removeAttribute(“user”);

session.removeAttribute(“p”);

return “fore_login”;

// 验证用户名是否存在

@RequestMapping(“admin/checkUname.do”)

public void checkUname(Sysuser user,HttpServletResponse response){

Map<String,Object> map=new HashMap<String,Object>();

map.put(“uname”, user.getUname());

System.out.println(“uname===”+user.getUname());

System.out.println(“uname222===”+userService.checkUname(map));

JSONObject obj=new JSONObject();

if(userService.checkUname(map)!=null){

obj.put(“info”, “ok”);

}else{

obj.put(“info”, “用户名可以用！”);

response.setContentType(“text/html;charset=utf-8”);

PrintWriter out=null;

try {

out=response.getWriter();

out.print(obj);

out.flush();

} catch (IOException e) {

e.printStackTrace();

}finally{

out.close();

@RequestMapping(“checkmibao.do”)

public void checkMB(Sysuser user,HttpServletResponse response,HttpSession session){

JSONObject obj=new JSONObject();

Sysuser u=userService.getById(user.getUid());

String q=u.getQuestion();

if(u==null||u.equals(“”)){

obj.put(“info”, “ng”);

}else{

if(q.equals(user.getQuestion())){

obj.put(“info”, u.getPwd());

}else{

obj.put(“info”, “ng”);

response.setContentType(“text/html;charset=utf-8”);

PrintWriter out=null;

try {

out=response.getWriter();

out.print(obj);

out.flush();

} catch (IOException e) {

e.printStackTrace();

}finally{

out.close();

// 验证用户名是否存在

@RequestMapping(“checkUname.do”)

public void checkReg(Sysuser user,HttpServletResponse response){

Map map=new HashMap();

map.put(“uname”, user.getUname());

System.out.println(“uname===”+user.getUname());

System.out.println(“uname222===”+userService.checkUname(map));

JSONObject obj=new JSONObject();

if(userService.checkUname(map)!=null){

System.out.println(“uname233333333333===”);

obj.put(“info”, “ng”);

}else{

System.out.println(“uname255555555555555===”);

obj.put(“info”, “用户名可以用！”);

response.setContentType(“text/html;charset=utf-8”);

PrintWriter out=null;

try {

out=response.getWriter();

out.print(obj);

out.flush();

} catch (IOException e) {

e.printStackTrace();

}finally{

out.close();

@RequestMapping(“checkPass.do”)

public void checkPass(Sysuser user,HttpServletResponse response){

Map map=new HashMap();

map.put(“uname”, user.getUname());

System.out.println(“uname===”+user.getUname());

System.out.println(“uname222===”+userService.checkUname(map));

JSONObject obj=new JSONObject();

if(userService.checkUname(map)!=null){

obj.put(“info”, userService.checkUname(map).getPwd());

}else{

obj.put(“info”, “ng”);

response.setContentType(“text/html;charset=utf-8”);

PrintWriter out=null;

try {

out=response.getWriter();

out.print(obj);

out.flush();

} catch (IOException e) {

e.printStackTrace();

}finally{

out.close();

@RequestMapping(“reg.do”)

public String addReg(Sysuser user, HttpSession session) {

user.setIsdel(“1”);

user.setUtype(“会员”);

Timestamp time=new Timestamp(System.currentTimeMillis());

user.setPubtime(time.toString());

userService.add(user);

return “fore_login”;

// 添加用户

@RequestMapping(“admin/addUser.do”)

public String addUser(Sysuser user, HttpSession session) {

user.setIsdel(“1”);

Timestamp time=new Timestamp(System.currentTimeMillis());

user.setPubtime(time.toString());

userService.add(user);

return “redirect:userList.do”;

// 管理员注册

@RequestMapping(“admin/addUser2.do”)

public String addUser2(Sysuser user, HttpSession session) {

user.setIsdel(“1”);

Timestamp time=new Timestamp(System.currentTimeMillis());

user.setPubtime(time.toString());

userService.add(user);

return “admin/login”;

// 处理更新用户的信息

@RequestMapping(“admin/doUpdateUser.do”)

public String doUpdateUser(ModelMap map, int id) {

System.out.println(“id==”+id);

map.put(“user”,userService.getById(id));

return “admin/update_user”;

// 更新用户的信息

@RequestMapping(“admin/updateUser.do”)

public String updateUser(Sysuser user) {

userService.update(user);

return “redirect:userList.do”;

// 查询所有用户的信息

@RequestMapping(“admin/userList.do”)

public String userList(@RequestParam(value = “page”, required = false) String page, HttpSession session,

ModelMap map) {

if (page == null || page.equals(“”)) {

page = “1”;

PageBean pageBean = new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap = new HashMap<String, Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map cmap=new HashMap();

/*pmap.put(“utype”, “会员”);

cmap.put(“utype”, “会员”);*/

int total = userService.getCount(cmap);

pageBean.setTotal(total);

List list = userService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 1);

return “admin/user_list”;

// 模糊查询并分页

@RequestMapping(“admin/userListQuery.do”)

public String useListQuery(@RequestParam(value = “page”, required = false) String page, HttpSession session,

ModelMap map,Sysuser user) {

if (page == null || page.equals(“”)) {

page = “1”;

PageBean pageBean = new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap = new HashMap<String, Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

pmap.put(“uname”, user.getUname());

Map cmap=new HashMap();

/* pmap.put(“utype”, “会员”);

cmap.put(“utype”, “会员”);*/

int total = userService.getCount(pmap);

pageBean.setTotal(total);

List list = userService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 2);

return “admin/user_list”;

@RequestMapping(“admin/deleteUser.do”)

public String deleteUser(int id){

userService.delete(id);

return “redirect:userList.do”;

实验室管理控制层：

@Controller

public class ShiYanController {

@Resource

private ShiYanServer ShiYanService;

@Resource

private ForderServer orderService;

@Resource

private SysuserServier userService;

// 文件上传

public String fileUpload(@RequestParam(value=“file”,required=false)MultipartFile file,

HttpServletRequest request,String img){

String path=request.getSession().getServletContext().getRealPath(“upload”);

String fileName=file.getOriginalFilename();

File targetFile=new File(path,fileName);

if(!targetFile.exists()){

targetFile.mkdirs();

try {

file.transferTo(targetFile);

} catch (IllegalStateException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

String pa=request.getContextPath()+“/upload/”+fileName;

System.out.println(“path===”+pa);

if(fileName!=null&&!fileName.equals(“”)){

img=fileName;

}else{

img=“zanwu.jpg”;

return img;

// 实验室管理

@RequestMapping(“admin/addShiYan.do”)

public String addShiYan(ModelMap map,ShiYan shiYan,HttpServletRequest request){

Timestamp time=new Timestamp(System.currentTimeMillis());

shiYan.setFtype(“实验室”);

shiYan.setMstatus(“空闲中”);

shiYan.setIsdel(“1”);

shiYan.setPubtime(time.toString().substring(0, 19));

ShiYanService.add(shiYan);

return “redirect:ShiYanList.do”;

@RequestMapping(“admin/doUpdateShiYan.do”)

public String doUpdateShiYan(ModelMap map,int id){

map.put(“sy”, ShiYanService.getById(id));

return “admin/update_ShiYan”;

@RequestMapping(“admin/updateShiYan.do”)

public String updateShiYan( HttpServletRequest request,ShiYan ShiYan){

ShiYanService.update(ShiYan);

return “redirect:ShiYanList.do”;

// 分页查询

@RequestMapping(“admin/ShiYanList.do”)

public String shiYanList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session){

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map<String, Object> cmap=new HashMap<String, Object>();

pmap.put(“name”, null);

cmap.put(“name”, null);

cmap.put(“ftype”, “实验室”);

pmap.put(“ftype”, “实验室”);

int total=ShiYanService.getCount(cmap);

pageBean.setTotal(total);

List list=ShiYanService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 1);

return “admin/list_ShiYan”;

// 分页模糊查询

@RequestMapping(“admin/vagueShiYanList.do”)

public String vagueShiYanList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session,ShiYan cd){

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page),PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map<String, Object> cmap=new HashMap<String,Object>();

if(cd.getName()!=null&&!cd.getName().equals(“”)){

cmap.put(“name”, cd.getName());

pmap.put(“name”, cd.getName());

cmap.put(“ftype”, “实验室”);

pmap.put(“ftype”, “实验室”);

int total=ShiYanService.getCount(cmap);

pageBean.setTotal(total);

List list=ShiYanService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 2);

return “admin/list_ShiYan”;

@RequestMapping(“admin/deleteShiYan.do”)

public String deleteShiYan(int id){

ShiYanService.delete(id);

return “redirect:ShiYanList.do”;

// 设备管理

@RequestMapping(“admin/addSheBei.do”)

public String addSheBei(ModelMap map,ShiYan shiYan,HttpServletRequest request){

Timestamp time=new Timestamp(System.currentTimeMillis());

shiYan.setFtype(“设备”);

shiYan.setMstatus(“充足”);

shiYan.setIsdel(“1”);

shiYan.setPubtime(time.toString().substring(0, 19));

ShiYanService.add(shiYan);

return “redirect:SheBeiList.do”;

@RequestMapping(“admin/doUpdateSheBei.do”)

public String doUpdateSheBei(ModelMap map,int id){

map.put(“sy”, ShiYanService.getById(id));

return “admin/update_SheBei”;

// 处理申请设备

@RequestMapping(“admin/doAddForderSheBei.do”)

public String doAddForderSheBei(ModelMap map,int id){

map.put(“sy”, ShiYanService.getById(id));

return “admin/add_order_sheBei”;

// 处理申请耗材

@RequestMapping(“admin/doAddForderHaoCai.do”)

public String doAddForderHaoCai(ModelMap map,int id){

map.put(“sy”, ShiYanService.getById(id));

return “admin/add_order_haoCai”;

@RequestMapping(“admin/updateSheBei.do”)

public String updateSheBei(HttpServletRequest request,ShiYan ShiYan){

ShiYanService.update(ShiYan);

return “redirect:SheBeiList.do”;

// 分页查询

@RequestMapping(“admin/SheBeiList.do”)

public String sheBeiList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session){

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map<String, Object> cmap=new HashMap<String, Object>();

cmap.put(“ftype”, “设备”);

pmap.put(“ftype”, “设备”);

int total=ShiYanService.getCount(cmap);

pageBean.setTotal(total);

List list=ShiYanService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 1);

return “admin/list_SheBei”;

// 分页模糊查询

@RequestMapping(“admin/vagueSheBeiList.do”)

public String vagueSheBeiList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session,ShiYan cd){

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page),PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map<String, Object> cmap=new HashMap<String,Object>();

if(cd.getName()!=null&&!cd.getName().equals(“”)){

cmap.put(“name”, cd.getName());

pmap.put(“name”, cd.getName());

cmap.put(“ftype”, “设备”);

pmap.put(“ftype”, “设备”);

int total=ShiYanService.getCount(cmap);

pageBean.setTotal(total);

List list=ShiYanService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 2);

return “admin/list_SheBei”;

@RequestMapping(“admin/deleteSheBei.do”)

public String deleteSheBei(int id){

ShiYanService.delete(id);

return “redirect:SheBeiList.do”;

// 耗材管理

@RequestMapping(“admin/addHaoCai.do”)

public String addHaoCai(ModelMap map,ShiYan shiYan,HttpServletRequest request){

Timestamp time=new Timestamp(System.currentTimeMillis());

shiYan.setFtype(“耗材”);

shiYan.setMstatus(“充足”);

shiYan.setIsdel(“1”);

shiYan.setPubtime(time.toString().substring(0, 19));

ShiYanService.add(shiYan);

return “redirect:HaoCaiList.do”;

@RequestMapping(“admin/doUpdateHaoCai.do”)

public String doUpdateHaoCai(ModelMap map,int id){

map.put(“sy”, ShiYanService.getById(id));

return “admin/update_HaoCai”;

@RequestMapping(“admin/updateHaoCai.do”)

public String updateHaoCai(HttpServletRequest request,ShiYan ShiYan){

ShiYanService.update(ShiYan);

return “redirect:HaoCaiList.do”;

// 分页查询

@RequestMapping(“admin/HaoCaiList.do”)

public String haoCaiList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session){

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map<String, Object> cmap=new HashMap<String, Object>();

pmap.put(“ftype”, null);

cmap.put(“name”, null);

cmap.put(“ftype”, “耗材”);

pmap.put(“ftype”, “耗材”);

int total=ShiYanService.getCount(cmap);

pageBean.setTotal(total);

List list=ShiYanService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 1);

return “admin/list_HaoCai”;

// 分页模糊查询

@RequestMapping(“admin/vagueHaoCaiList.do”)

public String vagueHaoCaiList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session,ShiYan cd){

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page),PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

Map<String, Object> cmap=new HashMap<String,Object>();

if(cd.getName()!=null&&!cd.getName().equals(“”)){

cmap.put(“name”, cd.getName());

pmap.put(“name”, cd.getName());

cmap.put(“ftype”, “耗材”);

pmap.put(“ftype”, “耗材”);

int total=ShiYanService.getCount(cmap);

pageBean.setTotal(total);

List list=ShiYanService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

session.setAttribute(“p”, 2);

return “admin/list_HaoCai”;

@RequestMapping(“admin/deleteHaoCai.do”)

public String deleteHaoCai(int id){

ShiYanService.delete(id);

return “redirect:HaoCaiList.do”;

实验室设备管理控制层：

@Controller

public class ForderController {

@Resource

private ForderServer orderService;

@Resource

private SysuserServier userService;

@Resource

private ShiYanServer shiYanService;

// 文件上传

public String fileUpload(@RequestParam(value=“file”,required=false)MultipartFile file,

HttpServletRequest request,String img){

String path=request.getSession().getServletContext().getRealPath(“upload”);

System.out.println(“path===”+path);

System.out.println(“file===”+file);

String fileName=file.getOriginalFilename();

System.out.println(“fileName===”+fileName);

File targetFile=new File(path,fileName);

if(!targetFile.exists()){

targetFile.mkdirs();

try {

file.transferTo(targetFile);

} catch (IllegalStateException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

String pa=request.getContextPath()+“/upload/”+fileName;

System.out.println(“path===”+pa);

if(fileName!=null&&!fileName.equals(“”)){

img=fileName;

}else{

img=null;

return img;

/实验室/

// 分页查询

@RequestMapping(“admin/shiYanShiForderList.do”)

public String shiYanShiList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

Map<String, Object> cmap=new HashMap<String,Object>();

/Map<String, Object> smap=new HashMap<String,Object>();/

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

if(u.getUtype().equals(“管理员”)){

pmap.put(“uid”,null);

cmap.put(“uid”,null);

}else{

pmap.put(“uid”,u.getUid());

cmap.put(“uid”,u.getUid());

pmap.put(“etime”,“实验室”);

cmap.put(“etime”,“实验室”);

/smap.put(“stime”, “实验室”);/

int total=orderService.getCount(cmap);

pageBean.setTotal(total);

List list=orderService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

map.put(“ulist”, userService.getAll(null));

map.put(“slist”, shiYanService.getAll(null));

session.setAttribute(“p”, 1);

return “admin/list_order_shiYanShi”;

// 归还

@RequestMapping(“admin/guiHuan.do”)

public String guiHuan(HttpServletRequest request,Forder yp,ModelMap map,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

/Timestamp time=new Timestamp(System.currentTimeMillis());/

if(u==null){

return “admin/login”;

}else{

Forder syso=orderService.getById(id);

syso.setIsdel(“0”);

syso.setKid(id);

orderService.update(syso);

ShiYan sy=shiYanService.getById(syso.getFid());

sy.setMstatus(“空闲中”);

sy.setId(syso.getFid());

shiYanService.update(sy);

/*map.put(“etime”, “实验室”);

map.put(“fid”, syso.getFid());

List list=orderService.getByPage(map);

for(Forder o:list){

if(!o.getKid().equals(id)){

Forder fo=orderService.getById(o.getKid());

fo.setStatus(“审核失败”);

fo.setKid(id);

orderService.update(fo);

}*/

return “success”;

// 申请通过

@RequestMapping(“admin/tongGuoSYS.do”)

public String tongGuoSYS(HttpServletRequest request,Forder yp,ModelMap map,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

/Timestamp time=new Timestamp(System.currentTimeMillis());/

if(u==null){

return “admin/login”;

}else{

Forder syso=orderService.getById(id);

syso.setStatus(“审核通过”);

syso.setKid(id);

orderService.update(syso);

ShiYan sy=shiYanService.getById(syso.getFid());

sy.setMstatus(“已预订”);

sy.setId(syso.getFid());

shiYanService.update(sy);

map.put(“etime”, “实验室”);

map.put(“fid”, syso.getFid());

List list=orderService.getByPage(map);

for(Forder o:list){

if(!o.getKid().equals(id)){

Forder fo=orderService.getById(o.getKid());

fo.setStatus(“审核失败”);

fo.setKid(id);

orderService.update(fo);

return “success”;

// 申请不通过

@RequestMapping(“admin/buTongGuoSYS.do”)

public String buTongGuoSYS(HttpServletRequest request,Forder yp,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

//Timestamp time=new Timestamp(System.currentTimeMillis());

if(u==null){

return “admin/login”;

}else{

Forder f=orderService.getById(id);

f.setStatus(“审核失败”);

f.setKid(id);

orderService.update(f);

return “success”;

// 申请

@RequestMapping(“admin/shenQin.do”)

public String addForder(HttpServletRequest request,Forder yp,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

Timestamp time=new Timestamp(System.currentTimeMillis());

if(u==null){

return “admin/login”;

}else{

yp.setUid(u.getUid());

yp.setStatus(“待审核”);

yp.setIsdel(“1”);

yp.setFid(id);

yp.setEtime(“实验室”);

yp.setPubtime(time.toString().substring(0, 19));

orderService.add(yp);

return “success”;

/设备管理/

// 分页查询

@RequestMapping(“admin/sheBeiForderList.do”)

public String sheBeiForderList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

Map<String, Object> cmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

if(u.getUtype().equals(“管理员”)){

pmap.put(“uid”,null);

cmap.put(“uid”,null);

}else{

pmap.put(“uid”,u.getUid());

cmap.put(“uid”,u.getUid());

pmap.put(“etime”,“设备”);

cmap.put(“etime”,“设备”);

int total=orderService.getCount(cmap);

pageBean.setTotal(total);

List list=orderService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

map.put(“ulist”, userService.getAll(null));

map.put(“slist”, shiYanService.getAll(null));

session.setAttribute(“p”, 1);

return “admin/list_order_sheBei”;

// 添加设备申请

@RequestMapping(“admin/addForderSheBei.do”)

public String addForderSheBei(HttpServletRequest request,Forder yp,HttpSession session){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

Timestamp time=new Timestamp(System.currentTimeMillis());

if(u==null){

return “admin/login”;

}else{

ShiYan syy=shiYanService.getById(yp.getFid());

if(syy.getSnum()<yp.getSnum()){

return “admin/error”;

}else{

//syy.setSnum(syy.getSnum()-yp.getSnum());

syy.setId(yp.getFid());

shiYanService.update(syy);

yp.setUid(u.getUid());

yp.setStatus(“待审核”);

yp.setIsdel(“1”);

yp.setEtime(“设备”);

yp.setPubtime(time.toString().substring(0, 19));

orderService.add(yp);

return “success”;

// 申请不通过

@RequestMapping(“admin/buTongGuoShenBei.do”)

public String buTongGuoShenBei(HttpServletRequest request,Forder yp,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

Forder f=orderService.getById(id);

f.setStatus(“审核失败”);

f.setKid(id);

orderService.update(f);

return “success”;

// 申请通过

@RequestMapping(“admin/tongGuoShenBei.do”)

public String tongGuoShenBei(HttpServletRequest request,Forder yp,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

Forder f=orderService.getById(id);

ShiYan syy=shiYanService.getById(f.getFid());

syy.setSnum(syy.getSnum()-f.getSnum());

shiYanService.update(syy);

f.setStatus(“审核成功”);

f.setKid(id);

orderService.update(f);

return “success”;

/耗材/

// 分页查询

@RequestMapping(“admin/haoCaiForderList.do”)

public String haoCaiForderList(@RequestParam(value=“page”,required=false)String page,

ModelMap map,HttpSession session){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

if(page==null||page.equals(“”)){

page=“1”;

PageBean pageBean=new PageBean(Integer.parseInt(page), PageBean.PAGESIZE);

Map<String, Object> pmap=new HashMap<String,Object>();

Map<String, Object> cmap=new HashMap<String,Object>();

pmap.put(“pageno”, pageBean.getStart());

pmap.put(“pageSize”, pageBean.getPageSize());

if(u.getUtype().equals(“管理员”)){

pmap.put(“uid”,null);

cmap.put(“uid”,null);

}else{

pmap.put(“uid”,u.getUid());

cmap.put(“uid”,u.getUid());

pmap.put(“etime”,“耗材”);

cmap.put(“etime”,“耗材”);

int total=orderService.getCount(cmap);

pageBean.setTotal(total);

List list=orderService.getByPage(pmap);

map.put(“page”, pageBean);

map.put(“list”, list);

map.put(“ulist”, userService.getAll(null));

map.put(“slist”, shiYanService.getAll(null));

session.setAttribute(“p”, 1);

return “admin/list_order_haoCai”;

// 申请耗材

@RequestMapping(“admin/addForderHaoCai.do”)

public String addForderHaoCai(HttpServletRequest request,Forder yp,HttpSession session){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

Timestamp time=new Timestamp(System.currentTimeMillis());

if(u==null){

return “admin/login”;

}else{

ShiYan syy=shiYanService.getById(yp.getFid());

if(syy.getSnum()<yp.getSnum()){

return “admin/error”;

}else{

//syy.setSnum(syy.getSnum()-yp.getSnum());

syy.setId(yp.getFid());

shiYanService.update(syy);

yp.setUid(u.getUid());

yp.setStatus(“待审核”);

yp.setIsdel(“1”);

yp.setEtime(“耗材”);

yp.setPubtime(time.toString().substring(0, 19));

orderService.add(yp);

return “success”;

// 申请不通过

@RequestMapping(“admin/buTongGuoHaoCai.do”)

public String buTongGuoHaoCai(HttpServletRequest request,Forder yp,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

Forder f=orderService.getById(id);

f.setStatus(“审核失败”);

f.setKid(id);

orderService.update(f);

return “success”;

// 申请通过

@RequestMapping(“admin/tongGuoHaoCai.do”)

public String tongGuoHaoCai(HttpServletRequest request,Forder yp,HttpSession session,int id){

Sysuser u=(Sysuser)session.getAttribute(“auser”);

if(u==null){

return “admin/login”;

}else{

Forder f=orderService.getById(id);

ShiYan syy=shiYanService.getById(f.getFid());

syy.setSnum(syy.getSnum()-f.getSnum());

shiYanService.update(syy);

f.setStatus(“审核成功”);

f.setKid(id);

orderService.update(f);

return “success”;

// 查询统计

@RequestMapping(“admin/forderTongJiList.do”)

public String forderTongJiList(ModelMap map,HttpSession session,Forder order,String etime1,String stime1){

System.out.println(“stime1===”+stime1);

System.out.println(“etime1===”+etime1);

System.out.println(“etime===”+order.getStime());

Map<String, Object> pmap=new HashMap<String,Object>();

if(order.getStime()!=null&&!order.getStime().equals(“”)){

pmap.put(“etime”,order.getStime());

pmap.put(“stime1”,stime1);

pmap.put(“etime1”,etime1);

List list=orderService.getTongJi(pmap);

System.out.println(“list====”+list);

for(TongJi tj:list){

System.out.println(“name===”+tj.getName()+“amount===”+tj.getAmount());

map.put(“list”, list);

map.put(“etime1”, etime1);

map.put(“stime1”, stime1);

session.setAttribute(“p”, 1);

return “admin/list_order_tongji”;

@RequestMapping(“admin/deleteForder.do”)

public String deleteForder(int id){

orderService.delete(id);

return “success”;

---