基于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版本;
技术栈
- 后端: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/ 登录
}
/**
* 跳转到添加或编辑用户页面
* @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){