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

基于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/ 登录
		
	}
	
	/**
	 * 跳转到添加或编辑用户页面
	 * @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;
     
		
		
	}
	
	
	
	/**
	 * 添加或编辑用户
	 * @param request
	 * @return
	 */
            }

        }

    

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

	/**
	 * 修改产品
	 * @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 {
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        return mav;
     
		
		
	}
	
	
	
}

public class BaseController {

	public Pagination pagination = new Pagination();

	/**
	 * @param pagination
	 * @param request
	 */
	public void initPagination(Pagination pagination , HttpServletRequest request) {
		String pageNo = request.getParameter("pageNo");
		String pageSize = request.getParameter("pageSize");
		pagination.setPageSize(StringUtils.isEmpty(pageSize) ? 10 : Integer.valueOf(pageSize) );
		pagination.setPageNo(StringUtils.isEmpty(pageNo) ? 1 : Integer.valueOf(pageNo) );
		if ((pagination.getTotal() % pagination.getPageSize()) == 0) {
			pagination.setPageIndex(pagination.getTotal() / pagination.getPageSize());
		} else {
			pagination.setPageIndex(pagination.getTotal() / pagination.getPageSize() + 1);
		}

	}
	
	
	/**
	 * @param response
	 * @param json
	 */
	/*@SuppressWarnings("null")
	public void  writeToJson(HttpServletResponse response ,JSONObject json) {
		response.setContentType("text/html;charset=utf-8");
		response.setCharacterEncoding("UTF-8");
	 */
	@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) {
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("ID", customerId); 
                Customer customer = customerService.selectByPrimaryKey(Integer.parseInt(customerId));
                if (customer != null) {
                	mav.addObject("customer", customer);
                }
            }
        }

    

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

                e.printStackTrace();
            }

        }

        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;
    }
	
	
	
	
}
	/**
	 * 添加订单
	 * @param request
	 * @return
	 */
	@RequestMapping("/addOrder")
	public ModelAndView addOrEditOrder(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findOrderList"); //返回的文件名  
        
		try {
			Order order = new Order();
			Integer prodId = Integer.valueOf(request.getParameter("prodid")); 
			if(prodId > 0){
				order.setProductID(prodId);
			}
			//TODO  客户模块完成后添加从页面获取客户id相关代码
			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.insertSelective(order);
        
        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();

	private UserService userService;
	
	/**
	 * 检查用户登录
	 * @param request
	 * @return
	 */
	@RequestMapping("/checkLogin")
	public ModelAndView checkLogin(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/login.jsp"); //返回的文件名  
        
		 Map<String, Object> map = new HashMap<String,Object>();
		String loginName = request.getParameter("loginName");
		String pwd = request.getParameter("pwd");
		System.out.println("--loginName--"+loginName);
		System.out.println("--pwd--"+pwd);
		map.put("loginName", loginName);
		map.put("password", pwd);
		int checkResult = userService.checkLogin(map) ; 
//		RequestDispatcher rd = request.getRequestDispatcher("/main.jsp");
		if(checkResult == 0 ){
			mav.addObject("msg","用户名或者密码错误!");  
//			request.setAttribute("msg", "用户名或者密码错误!");
			return mav;
		}else{
			request.getSession().setAttribute("userName", loginName);
			Cookie cookie = new Cookie("userName" , loginName) ;
			cookie.setMaxAge(60*60*24*30);
			response.addCookie(cookie);
			
			 mav.setViewName("/main.jsp"); //返回的文件名  
			return mav;
		}
		
		
	}
	
	/**
	 * 用户注销
	 * @param request
	 * @return
	 */
	@RequestMapping("/logout")
	public ModelAndView logout(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/login.jsp"); //返回的文件名  
        
        request.getSession().removeAttribute("userName");
        
        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;
     
		
		
	}
	
	
	
}

		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;
     
		
		
	}
	
	
	/**
	 * 删除设备
	 * @param request
	 * @return
	 */
	@RequestMapping("/delDevice")
	public ModelAndView delDevice(HttpServletRequest request,HttpServletResponse response, String motion){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("forward:/findDeviceList"); //返回的文件名  

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

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

        return mav;
     
		
		
	}
	
	
	
}

	 * @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();
            }
        }

        return mav;
     
		
		
	}
	
	
	
}

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

	 * @return
	 */
	@RequestMapping("/findWorkshopList")
	public ModelAndView findWorkshopList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
        mav.setViewName("/jsp/workshop/workshop_list.jsp"); //返回的文件名  
        
        super.pagination.setTotal(workshopService.findWorkshopListCount());
        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<Workshop> workshopList = workshopService.findWorkshopList(map);

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

        return mav;
     
		
		
	}
	
	/**
	 * 跳转到添加或编辑设备页面
	 * @param request
	 * @return
	 */
	@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);
                }

@Controller
public class OrderController extends BaseController{

	@Autowired
	private OrderService orderService;
	
	
	/**
	 * 查询订单列表
	 * @param request
	 * @return
	 */
	@RequestMapping("/findOrderList")
	public ModelAndView findOrderList(HttpServletRequest request,HttpServletResponse response){
		ModelAndView mav = new ModelAndView();  
		try {
			request.setCharacterEncoding("UTF-8");
			mav.setViewName("/jsp/order/order.jsp"); //返回的文件名  
			
			
			String pageNo = request.getParameter("pageNo");
			String pageSize = request.getParameter("pageSize");
			
			String customerName = request.getParameter("customerName");
			String prodName = request.getParameter("prodName");
			String deliveryDateBegin = request.getParameter("deliveryDateBegin");
			String deliveryDateEnd = request.getParameter("deliveryDateEnd");
			
			Map map=new HashMap();
			map.put("pageNo", pagination.getPageNo());
			map.put("pageSize", pagination.getPageSize());
			
			map.put("customerName", customerName);
			map.put("prodName", prodName);
			map.put("deliveryDateBegin", deliveryDateBegin);
			map.put("deliveryDateEnd", deliveryDateEnd);
			
			
			super.pagination.setTotal(orderService.findOrderListCount(map));
			super.initPagination(pagination, request);
			
			

        return mav;
     
		
		
	}
	
	
	/**
	 * 修改初始化
	 * @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){

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值