基于javaweb+mysql的ssm设备台账管理系统(java+ssm+html+jsp+js+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM设备台账管理系统(java+ssm+html+jsp+js+mysql)
项目介绍
管理员角色包含以下功能: 管理员登录,物理设备管理,IP地址资源管理,虚拟机管理,通知公告管理,学历管理,部门管理,员工管理等功能。
员工角色包含以下功能: 员工角色登录,查看物理设备,查看IP地址,查看虚拟机,通知公告查看等功能。
环境需要
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版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
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")
//设备类型统计
Map typeMap = deviceService.staDeviceByType(monthStr);
resultMap.put("typeMap",typeMap);
//设备品牌统计
Map brandMap = deviceService.staDeviceByBrand(monthStr);
resultMap.put("brandMap",brandMap);
//设备部门统计
Map orgMap = deviceService.staDeviceByOrg(monthStr);
resultMap.put("orgMap",orgMap);
//设备状态统计
Map statusMap = deviceService.staDeviceByStatus(monthStr);
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");
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);
* @param brandId
* @return
*/
@DeleteMapping("/brand/{brandId}")
@ResponseBody
public int delteDeviceBrandByid(@PathVariable("brandId") String brandId){
return baseInfoService.deleteDeviceBrandById(brandId);
/**
* 修改品牌
* @param deviceBrand
* @return
* @throws ParseException
*/
private String subMonth(String date) throws ParseException {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
Date dt = sdf.parse(date);
Calendar rightNow = Calendar.getInstance();
rightNow.setTime(dt);
rightNow.add(Calendar.MONTH, 1);
Date dt1 = rightNow.getTime();
String reStr = sdf.format(dt1);
* @return
* @throws ParseException
*/
@PostMapping
public String addDevice(HttpServletRequest request) throws ParseException {
Device device = new Device();
device.setDevId(request.getParameter("devId"));
device.setTypeId(request.getParameter("typeId"));
device.setBrandId(request.getParameter("brandId"));
device.setDevModel(request.getParameter("devModel"));
device.setErpCode(request.getParameter("erpCode"));
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
device.setPurchaseTime(sdf.parse(request.getParameter("purchaseTime")));
return baseInfoService.updateDeviceType(deviceType);
/**
* 获取所有设备品牌信息
* @param map
* @return
*/
@RequestMapping("/brand/list")
public String listDeviceBrand(ModelMap map){
List<DeviceBrand> brandList = baseInfoService.listDeviceBrand();
map.put("brandList",brandList);
return "deviceBrands::table-refresh";
* 修改设备状态
* @param devId
* @param status
* @return
*/
@PutMapping("/status")
@ResponseBody
public int updateStatus(String devId,int status){
return deviceService.updateStatusByid(devId,status);
/**
* 分配设备持有者
* @return
*/
* @return
* @throws ParseException
*/
@GetMapping("/statistics")
@ResponseBody
public Map<String, Object> reloadChart(HttpServletRequest request) throws ParseException {
String monthStr = request.getParameter("monthStr");
monthStr = subMonth(monthStr);
Map resultMap = new HashMap();
//设备类型统计
Map typeMap = deviceService.staDeviceByType(monthStr);
}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{
public int updateDevOrg(HttpServletRequest request){
String devId = request.getParameter("devId");
String fri_org = request.getParameter("fri_org");
String sec_org = request.getParameter("sec_org");
String orgid_addr = request.getParameter("orgid_addr");
return deviceService.updateDevOrgsByDevId(devId,fri_org,sec_org,orgid_addr);
};
/**
* 刷新使用信息模块
* @param map
* @param devId
* @return
*/
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>();
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());
* @return
*/
@GetMapping("/useage_info")
public String allotDevice(ModelMap map,String devId){
DeviceDTO deviceDTO = deviceService.getDeviceDtoById(devId);
map.put("deviceDTO",deviceDTO);
return "allotDevice::useage_info";
/**
* 导出报表
* @param response
* @param request
*/
@GetMapping("/exportExcel")
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");
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>();