基于javaweb+mysql的ssm智能制造车间管理系统(java+ssm+js+jsp+mysql)

于 2023-07-31 20:25:11 发布
阅读量97 收藏
点赞数
文章标签： mysql 制造 java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_71054991/article/details/132029927
版权

基于javaweb+mysql的ssm智能制造车间管理系统(java+ssm+js+jsp+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SSM智能制造车间管理系统(java+ssm+js+jsp+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版本；

技术栈

  1. 后端：Spring+SpringMVC+Mybatis 2. 前端：HTML+CSS+JavaScript+jsp

使用说明

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

        return mav;
     
		
		
	}
	
	/**
	 * 跳转到添加或编辑设备页面
	 * @param request
	 * @return
	 */
	@RequestMapping("/toAddOrEditDevice")
	public ModelAndView toAddOrEditUser(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/device/device_handle.jsp"); //返回的文件名  
        
        String motion = request.getParameter("motion");
        String deviceId = request.getParameter("deviceId");

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("deviceBean", null);
            } else if (motion.equals("edit") &&null!=deviceId&&deviceId.length()>0) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", deviceId); 
                Device device = deviceService.selectByPrimaryKey(Integer.parseInt(deviceId));
                if (device != null) {
                	mav.addObject("device", device);
                }
            }
        }

    

        return mav;
     
		
		
	}

	
	/**
	 * 查询客户列表
	 * @param request
	 * @return
	 */
	@RequestMapping("/findCustomerList")
	public ModelAndView findCustomerList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/customer/customer_list.jsp"); //返回的文件名  
        
        super.pagination.setTotal(customerService.findCustomerListCount());
        super.initPagination(pagination, request);
        
        
        String pageNo = request.getParameter("pageNo");
		String pageSize = request.getParameter("pageSize");
		
		Map map=new HashMap();
		map.put("pageNo", pagination.getPageNo());
		map.put("pageSize", pagination.getPageSize());

        List<Customer> customerList = customerService.findCustomerList(map);

        mav.addObject("customerList", customerList);
        mav.addObject("pagination", pagination);

        return mav;
     
		
		
	}
	
	/**
	 * 跳转到添加或编辑客户页面
	 * @param request
	 * @return
	 */
	@RequestMapping("/toAddOrEditCustomer")
	public ModelAndView toAddOrEditCustomer(HttpServletRequest request,HttpServletResponse response){

        mav.setViewName("/jsp/process/process.jsp"); //返回的文件名  
        
        super.pagination.setTotal(processService.findProcessListCount());
        super.initPagination(pagination, request);
        
        
        String pageNo = request.getParameter("pageNo");
		String pageSize = request.getParameter("pageSize");
		
		Map map=new HashMap();
		map.put("pageNo", pagination.getPageNo());
		map.put("pageSize", pagination.getPageSize());

        List<Process> processList = processService.findProcessList(map);

        mav.addObject("processList", processList);
        mav.addObject("pagination", pagination);

        return mav;
		
	}
	
	
	
	
	/**
	 * 添加工序
	 * @param request
	 * @return
	 */
	@RequestMapping("/addProcess")
	public ModelAndView addOrEditProcess(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findProcessList"); //返回的文件名  
        
		Process process = new  Process();
		String processCode = request.getParameter("processCode");
		String processName = request.getParameter("processName");
		String description = request.getParameter("description");
		Integer deviceId = StringUtils.getIntegerFromString(request.getParameter("deviceId"));
		if(StringUtils.isNotEmpty(processCode)){
			 process.setProcessCode(processCode);
		}
		if(StringUtils.isNotEmpty(processName)){
			process.setProcessName(processName);
		}
		if(StringUtils.isNotEmpty(description)){
			process.setDescription(description);

		Integer deviceId = StringUtils.getIntegerFromString(request.getParameter("deviceId"));
		if( deviceId > 0 ){
			process.setDeviceId(deviceId);
		}
		String processCode = request.getParameter("processCode");
		if(StringUtils.isNotEmpty(processCode)){
			process.setProcessCode(processCode);
		}
		String processName = request.getParameter("processName");
		if(StringUtils.isNotEmpty(processName)){
			process.setProcessName(processName);
		}
		String description = request.getParameter("description");
		if(StringUtils.isNotEmpty(description)){
			process.setDescription(description);
		}
		processService.updateByPrimaryKey(process);
        

        return mav;
     
		
		
	}
	
	
	/**
	 * 删除工序
	 * @param request
	 * @return
	 */
	@RequestMapping("/delProcess")
	public ModelAndView delProcess(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findProcessList"); //返回的文件名  

        String processId = request.getParameter("processId");
        if (null!=processId&&processId.length()>0) {
            try {
                processService.deleteByPrimaryKey(Integer.parseInt(processId));

            } catch (Exception e) {
                e.printStackTrace();
            }
        }


        if (null!=customerCode&&customerCode.length()>0) {
            Customer customer = new Customer();
            if (motion.equals("edit") && null!=customerId&&customerId.length()>0) {
                customer.setID(Integer.parseInt(customerId));
            }
            customer.setCustomCode(customerCode);
            customer.setCustomName(customerName);
            customer.setLinkman(linkman);
            customer.setContactNumber(contactNumber);
            customer.setAddress(address);
            customer.setDescription(description);

            try {
                if (motion.equals("add")) {
                    customerService.insertSelective(customer);
                } else if (motion.equals("edit")) {
                	customerService.updateByPrimaryKey(customer);
                }

            } catch (Exception e) {
                e.printStackTrace();
            }

        }

    

        return mav;
     
		
		
	}
	
	
	/**
	 * 删除客户
	 * @param request
	 * @return
	 */
	@RequestMapping("/delCustomer")

			}
			String description  = request.getParameter("description");
			if(StringUtils.isNotEmpty(description)){
				order.setDescription(description);
			}
			String orderCode = request.getParameter("orderCode");
			if(StringUtils.isNotEmpty(orderCode)){
				order.setOrderCode(orderCode);
			}
			orderService.insertSelective(order);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
        return mav;
		
	}
	
	
	/**
	 * 修改初始化
	 * @param request
	 * @return
	 */
	@RequestMapping("/updateOrderInit")
	public ModelAndView updateOrderInit(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/jsp/order/order_add.jsp"); //返回的文件名  
        
        String id=request.getParameter("id").toString();
        String action = request.getParameter("action");
        mav.addObject("act", action);
        Order order=orderService.selectOrderById(Integer.parseInt(id));
		mav.addObject("order", order);
        return mav;
     
		
		
	}
	
	

                e.printStackTrace();
            }
        }

        return mav;
     
		
		
	}
	
	
	
}
package com.hyg.im.controller;

@Controller
public class CustomerController extends BaseController{

	@Autowired
	private CustomerService customerService;
	
	
	
	
	/**
	 * 查询客户列表
	 * @param request
	 * @return
	 */
	@RequestMapping("/findCustomerList")
	public ModelAndView findCustomerList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  

		productService.insertSelective(p);
	

        return mav;
     
		
		
	}
	
	
	/**
	 * 修改产品
	 * @param request
	 * @return
	 */
	@RequestMapping("/updateProduct")
	public ModelAndView updateProduct(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findProductList"); //返回的文件名  

		String id = request.getParameter("proid");
		String prodCode = request.getParameter("prodCode");
		String prodName = request.getParameter("prodName");
		String prodSpec = request.getParameter("prodSpec");
		String prodType = request.getParameter("prodType");
		String price = request.getParameter("price");
		String description = request.getParameter("description");

		Product p = new Product();
		p.setID(Integer.valueOf(id));
		p.setProdCode(prodCode);
		p.setProdName(prodName);
		p.setProdSpec(prodSpec);
		p.setProdType(prodType);
		p.setPrice(new BigDecimal(price));
		p.setDescription(description);
		productService.updateByPrimaryKey(p);
        

        return mav;
     
		
		
	}
	
	
	/**
	 * 删除产品
	 * @param request
	 * @return
	 */
	@RequestMapping("/delProduct")
	public ModelAndView delProduct(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  

	@RequestMapping("/toAddOrEditWorkshop")
	public ModelAndView toAddOrEditUser(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/workshop/workshop_handle.jsp"); //返回的文件名  
        
        String motion = request.getParameter("motion");
        String workshopId = request.getParameter("workshopId");

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("workshopBean", null);
            } else if (motion.equals("edit") &&null!=workshopId&&workshopId.length()>0) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", workshopId); 
                Workshop workshop = workshopService.selectByPrimaryKey(Integer.parseInt(workshopId));
                if (workshop != null) {
                	mav.addObject("workshop", workshop);
                }
            }
        }

    

        return mav;
     
		
		
	}
	
	
	/**
	 * 添加或编辑设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/addOrEditWorkshop")
	public ModelAndView addOrEditWorkshop(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findWorkshopList"); //返回的文件名  

        String workshopId = request.getParameter("workshopId");
        String workshopCode = request.getParameter("workshopCode");
        String workshopName = request.getParameter("workshopName");
        String description = request.getParameter("description");

        //SimpleDateFormat simpleDateFormat = new SimpleDateFormat();

        if (null!=workshopCode&&workshopCode.length()>0) {
            Workshop workshop = new Workshop();

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("workshopBean", null);
            } else if (motion.equals("edit") &&null!=workshopId&&workshopId.length()>0) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", workshopId); 
                Workshop workshop = workshopService.selectByPrimaryKey(Integer.parseInt(workshopId));
                if (workshop != null) {
                	mav.addObject("workshop", workshop);
                }
            }
        }

    

        return mav;
     
		
		
	}
	
	
	/**
	 * 添加或编辑设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/addOrEditWorkshop")
	public ModelAndView addOrEditWorkshop(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findWorkshopList"); //返回的文件名  

        String workshopId = request.getParameter("workshopId");
        String workshopCode = request.getParameter("workshopCode");
        String workshopName = request.getParameter("workshopName");
        String description = request.getParameter("description");

        //SimpleDateFormat simpleDateFormat = new SimpleDateFormat();

        if (null!=workshopCode&&workshopCode.length()>0) {
            Workshop workshop = new Workshop();
            if (null!=motion&&motion.equals("edit") && null!=workshopId&&workshopId.length()>0) {
                workshop.setID(Integer.parseInt(workshopId));
            }
            workshop.setWorkshopCode(workshopCode);
            workshop.setWorkshopName(workshopName);
            workshop.setDescription(description);

            try {
                if (null!=motion&&motion.equals("add")) {
                    workshopService.insertSelective(workshop);
                } else if (motion.equals("edit")) {
                    workshopService.updateByPrimaryKey(workshop);
                }

	
	/**
	 * 修改初始化
	 * @param request
	 * @return
	 */
	@RequestMapping("/updateInit")
	public ModelAndView updateInit(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/jsp/process/process_add.jsp"); //返回的文件名  
        
        String id=request.getParameter("id").toString();
        String action = request.getParameter("action");
//        mav.addObject("action", action);
        mav.addObject("act", action);
//		Process process=processService.selectByPrimaryKey(Integer.parseInt(id));
        Process process=processService.selectProcessById(Integer.parseInt(id));
		mav.addObject("process", process);
        return mav;
     
		
		
	}
	
	
	
	
	
	
	/**
	 * 修改工序
	 * @param request
	 * @return
	 */
	@RequestMapping("/updateProcess")
	public ModelAndView updateProcess(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findProcessList"); //返回的文件名  

		Process process = new Process();
		String id =request.getParameter("processid");
		if(StringUtils.isNotEmpty(id)){
			 process.setID(Integer.valueOf(id));
		}
		Integer deviceId = StringUtils.getIntegerFromString(request.getParameter("deviceId"));
		if( deviceId > 0 ){
			process.setDeviceId(deviceId);
		}
		String processCode = request.getParameter("processCode");

        mav.addObject("pagination", pagination);

        return mav;
     
		
		
	}
	
	/**
	 * 跳转到添加或编辑设备页面
	 * @param request
	 * @return
	 */
	@RequestMapping("/toAddOrEditDevice")
	public ModelAndView toAddOrEditUser(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/device/device_handle.jsp"); //返回的文件名  
        
        String motion = request.getParameter("motion");
        String deviceId = request.getParameter("deviceId");

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("deviceBean", null);
            } else if (motion.equals("edit") &&null!=deviceId&&deviceId.length()>0) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", deviceId); 
                Device device = deviceService.selectByPrimaryKey(Integer.parseInt(deviceId));
                if (device != null) {
                	mav.addObject("device", device);
                }
            }
        }

    

        return mav;
     
		
		
	}
	
	
	/**
	 * 添加或编辑设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/addOrEditDevice")

	public ModelAndView findUserList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/user/user_list.jsp"); //返回的文件名  
        
        super.pagination.setTotal(userService.findUserListCount());
        super.initPagination(pagination, request);
        
        
        String pageNo = request.getParameter("pageNo");
		String pageSize = request.getParameter("pageSize");
		
		Map map=new HashMap();
		map.put("pageNo", pagination.getPageNo());
		map.put("pageSize", pagination.getPageSize());

        List<User> userList = userService.findUserList(map);

        mav.addObject("userList", userList);
        mav.addObject("pagination", pagination);

        return mav;
     
		
		
	}
	
	/**
	 * 跳转到添加或编辑用户页面
	 * @param request
	 * @return
	 */
	@RequestMapping("/toAddOrEditUser")
	public ModelAndView toAddOrEditUser(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/user/user_handle.jsp"); //返回的文件名  
        
        String motion = request.getParameter("motion");
        String userId = request.getParameter("userId");

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("user", null);

	@Autowired
	private DeviceService deviceService;
	
	
	
	
	/**
	 * 查询设备列表
	 * @param request
	 * @return
	 */
	@RequestMapping("/findDeviceList")
	public ModelAndView findDeviceList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/device/device_list.jsp"); //返回的文件名  
        
        super.pagination.setTotal(deviceService.findDeviceListCount());
        super.initPagination(pagination, request);
        
        
        String pageNo = request.getParameter("pageNo");
		String pageSize = request.getParameter("pageSize");
		
		Map map=new HashMap();
		map.put("pageNo", pagination.getPageNo());
		map.put("pageSize", pagination.getPageSize());

        List<Device> deviceList = deviceService.findDeviceList(map);

        mav.addObject("deviceList", deviceList);
        mav.addObject("pagination", pagination);

        return mav;
     
		
		
	}
	
	/**
	 * 跳转到添加或编辑设备页面
	 * @param request
	 * @return

        mav.setViewName("/jsp/device/device_handle.jsp"); //返回的文件名  
        
        String motion = request.getParameter("motion");
        String deviceId = request.getParameter("deviceId");

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("deviceBean", null);
            } else if (motion.equals("edit") &&null!=deviceId&&deviceId.length()>0) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", deviceId); 
                Device device = deviceService.selectByPrimaryKey(Integer.parseInt(deviceId));
                if (device != null) {
                	mav.addObject("device", device);
                }
            }
        }

    

        return mav;
     
		
		
	}
	
	
	/**
	 * 添加或编辑设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/addOrEditDevice")
	public ModelAndView addOrEditDevice(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findDeviceList"); //返回的文件名  

        String deviceId = request.getParameter("deviceId");
        String deviceCode = request.getParameter("deviceCode");
        String deviceSpec = request.getParameter("deviceSpec");
        String deviceName = request.getParameter("deviceName");
        String description = request.getParameter("description");

        //SimpleDateFormat simpleDateFormat = new SimpleDateFormat();

	 * @return
	 */
	@RequestMapping("/delCustomer")
	public ModelAndView delCustomer(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findCustomerList"); //返回的文件名  

        String customerId = request.getParameter("customerId");
        if (null!=customerId&&customerId.length()>0) {
            try {
                customerService.deleteByPrimaryKey(Integer.parseInt(customerId));

            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        return mav;
     
		
		
	}
	
	
	
}
package com.hyg.im.controller;

@Controller
public class WorkshopController extends BaseController{

	@Autowired
	private WorkshopService workshopService;

	public ModelAndView addOrEditProduct(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findProductList"); //返回的文件名  
        
		String prodCode = request.getParameter("prodCode");
		String prodName = request.getParameter("prodName");
		String prodSpec = request.getParameter("prodSpec");
		String prodType = request.getParameter("prodType");
		String price = request.getParameter("price");
		String description = request.getParameter("description");

		Product p = new Product();
		p.setProdCode(prodCode);
		p.setProdName(prodName);
		p.setProdSpec(prodSpec);
		p.setProdType(prodType);
		p.setPrice(new BigDecimal(price));
		p.setDescription(description);
		productService.insertSelective(p);
	

        return mav;
     
		
		
	}
	
	
	/**
	 * 修改产品
	 * @param request
	 * @return
	 */
	@RequestMapping("/updateProduct")
	public ModelAndView updateProduct(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findProductList"); //返回的文件名  

		String id = request.getParameter("proid");
		String prodCode = request.getParameter("prodCode");
		String prodName = request.getParameter("prodName");
		String prodSpec = request.getParameter("prodSpec");
		String prodType = request.getParameter("prodType");
		String price = request.getParameter("price");
		String description = request.getParameter("description");

		Product p = new Product();

	
	
	/**
	 * 添加或编辑设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/addOrEditDevice")
	public ModelAndView addOrEditDevice(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findDeviceList"); //返回的文件名  

        String deviceId = request.getParameter("deviceId");
        String deviceCode = request.getParameter("deviceCode");
        String deviceSpec = request.getParameter("deviceSpec");
        String deviceName = request.getParameter("deviceName");
        String description = request.getParameter("description");

        //SimpleDateFormat simpleDateFormat = new SimpleDateFormat();

        if (null!=deviceCode&&deviceCode.length()>0) {
            Device device = new Device();
            if (null!=motion&&motion.equals("edit") && null!=deviceId&&deviceId.length()>0) {
                device.setID(Integer.parseInt(deviceId));
            }
            device.setDeviceCode(deviceCode);
            device.setDeviceSpec(deviceSpec);
            device.setDeviceName(deviceName);
            device.setDescription(description);

            try {
                if (null!=motion&&motion.equals("add")) {
                    deviceService.insertSelective(device);
                } else if (motion.equals("edit")) {
                    deviceService.updateByPrimaryKey(device);
                }

            } catch (Exception e) {
                e.printStackTrace();
            }

        }

        return mav;

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

m0_71054991
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值