基于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/ 登录

@Controller
public class ProductController extends BaseController{

	@Autowired
	private ProductService productService;
	
	
	
	
	/**
	 * 查询客户列表
	 * @param request
	 * @return
	 */
	@RequestMapping("/findProductList")
	public ModelAndView findProductList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/product/product.jsp"); //返回的文件名  
        
        super.pagination.setTotal(productService.findProductListCount());
        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<Product> productList = productService.findProductList(map);

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

        return mav;
		
	}
	
	
	
	
	/**

                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();

        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);


        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){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/customer/customer_handle.jsp"); //返回的文件名  
        
        String motion = request.getParameter("motion");
        String customerId = request.getParameter("customerId");

        if (null!=motion&&motion.length()>0) {
            if (motion.equals("add")) {
                mav.addObject("customerBean", null);
            } else if (motion.equals("edit") &&null!=customerId&&customerId.length()>0) {


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

        }

    

        return mav;
     
		
		
	}
	
	
	/**
	 * 删除客户
	 * @param request
	 * @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;

			Integer quantity = Integer.valueOf( StringUtils.isEmpty(request.getParameter("quantity")) ? "0":request.getParameter("quantity"));
			if(quantity > 0 ){
				order.setQuantity(quantity);
			}
			String deliveryDateStr = request.getParameter("deliveryDateStr");
			if(StringUtils.isNotEmpty(deliveryDateStr)){
				
				SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");         
				Date deliveryDate = format.parse(deliveryDateStr);   
				order.setDeliveryDate(deliveryDate);
			}
			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;
     
		
		
	}
	
	
	/**
	 * 删除设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/delWorkshop")
	public ModelAndView delWorkshop(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findWorkshopList"); //返回的文件名  

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

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

        return mav;
     
		
		
	}
	
	


    

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

        String customerId = request.getParameter("customerId");
        String customerCode = request.getParameter("customerCode");
        String customerName = request.getParameter("customerName");
        String linkman = request.getParameter("linkman");
        String contactNumber = request.getParameter("contactNumber");
        String address = request.getParameter("address");
        String description = request.getParameter("description");

        //SimpleDateFormat simpleDateFormat = new SimpleDateFormat();

        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);


            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")
	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;


        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")
	public ModelAndView delCustomer(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  

                }
            }
        }

    

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

        String userId = request.getParameter("userId");
        String userCode = request.getParameter("userCode");
        String loginName = request.getParameter("loginName");
        String userName = request.getParameter("userName");
        String sex = request.getParameter("sex");
        String birthday = request.getParameter("birthday");
        String idNum = request.getParameter("idNum");
        String nation = request.getParameter("nation");
        String married = request.getParameter("married");
        String hireDate = request.getParameter("hireDate");
        String postion = request.getParameter("postion");
        String job = request.getParameter("job");
        String email = request.getParameter("email");
        String deptName = request.getParameter("deptName");
        String mobile = request.getParameter("mobile");
        String description = request.getParameter("description");

        if (null!=userCode&&userCode.length()>0) {
            User user = new User();
            if (motion.equals("edit") && null!=userId&&userId.length()>0) {
                user.setID(Integer.parseInt(userId));
            }

        return mav;
     
		
		
	}
	
	/**
     * 人员离职
     *
     * @param request
     * @param response
     */
	@RequestMapping("/dismission")
    private ModelAndView dismission(HttpServletRequest request, HttpServletResponse response) {
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findUserList"); //返回的文件名  
        
        String userId = request.getParameter("userId");
        if (null!=userId&&userId.length()>0) {
            User user = new User();
            user.setStatus(Byte.parseByte("1"));
            user.setID(Integer.parseInt(userId));
            userService.updateByPrimaryKeySelective(user);
        }
        return mav;
    }
	
	
	
	
}


                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);
                }

            } catch (Exception e) {

		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);
            } else if (motion.equals("edit") &&null!=userId&&userId.length()>0) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", userId);
                User user = userService.selectByPrimaryKey(Integer.parseInt(userId));
                if (user != null) {
                	mav.addObject("user", user);
                }
            }
        }

    

        return mav;
     
		
		
	}
	

	 * @return
	 */
	@RequestMapping("/updateOrder")
	public ModelAndView updateOrder(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findOrderList"); //返回的文件名  
        
		try {
			Order order = new Order();
			Integer id = Integer.valueOf(request.getParameter("orderid"));
			if(id > 0){
				order.setID(id);
			}
			Integer prodId = Integer.valueOf(request.getParameter("prodid")); 
			if(prodId > 0){
				order.setProductID(prodId);
			}
			
			Integer customerId = Integer.valueOf(request.getParameter("customid")); 
			if(customerId > 0 ){
				order.setCustomID(customerId);
			}
			Integer quantity = Integer.valueOf( StringUtils.isEmpty(request.getParameter("quantity")) ? "0":request.getParameter("quantity"));
			if(quantity > 0 ){
				order.setQuantity(quantity);
			}
			String deliveryDateStr = request.getParameter("deliveryDateStr");
			if(StringUtils.isNotEmpty(deliveryDateStr)){
				SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");         
				Date deliveryDate = format.parse(deliveryDateStr);   
				order.setDeliveryDate(deliveryDate);
			}
			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.updateByPrimaryKey(order);

			}
			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;
     
		
		
	}
	
	
	
	/**
	 * 修改订单
	 * @param request
	 * @return
	 */
	@RequestMapping("/updateOrder")
	public ModelAndView updateOrder(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findOrderList"); //返回的文件名  

	}
	
	
	/**
	 * 修改产品
	 * @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();  
        mav.setViewName("forward:/findProductList"); //返回的文件名  

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

     * @param request
     * @param response
     */
	@RequestMapping("/dismission")
    private ModelAndView dismission(HttpServletRequest request, HttpServletResponse response) {
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findUserList"); //返回的文件名  
        
        String userId = request.getParameter("userId");
        if (null!=userId&&userId.length()>0) {
            User user = new User();
            user.setStatus(Byte.parseByte("1"));
            user.setID(Integer.parseInt(userId));
            userService.updateByPrimaryKeySelective(user);
        }
        return mav;
    }
	
	
	
	
}

@Controller
public class OrderController extends BaseController{


	
	
	
}

@Controller
public class DeviceController extends BaseController{

	@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");

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

# mysql # 制造 # java
Logo
开源宁波（NBopen）开发者社区

宁波官方开源宣传和活动阵地，欢迎各位和我们共建开源生态体系！

更多推荐

cover

锁过期了，旧任务为什么还在运行

avatar 开源宁波（NBopen）开发者社区
cover

让留白决定人物位置：九组原创成年时装提示词

avatar 开源宁波（NBopen）开发者社区
cover

TCP写入成功之后，AI为什么还不能宣布设备已执行

avatar 开源宁波（NBopen）开发者社区