How to use SSM+MySql to implement a warehouse management system

system introduction

This system implements the warehouse management system for SSM and realizes the basic functions required by the warehouse system such as supplier management, dealer management, commodity management, outbound management, and receipt order management. The system implementation is relatively clear in layering and operation is relatively simple.

functional module

Related technical points

Front-end: The system front-end is developed using a combination of jsp JavaScript css

Backend: SSM framework

Database: MySQL

Development and running environment: IDEA/Eclipse and other development tools, Tomcat7/8 container, JDK1.8/1.7, Mysql database.

Function screenshot

The system currently mainly implements the supplier management module, dealer management module, commodity management module, inventory management module, and order management module. Due to limited space, only screenshots of some functions are posted.

1

Supplier Management

Dealer Management

Product Management

Add product information

Inventory management

Order management

Part of the source code

Controller

package com.synnex.wms.controller;

import java.io.IOException;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

import com.synnex.wms.pojo.Buyer;

import com.synnex.wms.pojo.Storer;

import com.synnex.wms.service.BuyerService;

@Controller

@RequestMapping(value = "/buyer")

public class BuyerController {

@Autowired

BuyerService buyerService ;

@RequestMapping(value = "/findAll")

public void findAll(HttpServletRequest request, HttpServletResponse response)

Throws ServletException, IOException {

List list_buyer = buyerService.findAll();

System.out.println("------list_buyer:" list_buyer);

​ request.setAttribute("list_buyer", list_buyer);

​ request.getRequestDispatcher("/jsp/buyer/buyer.jsp").forward(request,response);

}

@RequestMapping("/toUpdateBuyerPage/{buyer_id}")

public void toUpdateStorerPage(@PathVariable Integer buyer_id,

HttpServletResponse response, HttpServletRequest request)

Throws ServletException, IOException {

System.out.println("=-=-=-=-=---------------------------------");

Buyer buyer = buyerService.findBuyerByBuyer_id(buyer_id);

System.out.println("============================buyer" buyer);

​ request.setAttribute("buyer", buyer);

​ request.getRequestDispatcher("/jsp/buyer/updateBuyer.jsp").forward(

             request, response);

}

@RequestMapping(value = "/update")

public String update(Buyer buyer) {

buyerService.update(buyer);

Return "redirect:/buyer/findAll";

}

@RequestMapping(value = "/delete/{buyer_id}")

public String delete(@PathVariable Integer buyer_id) {

buyerService.delete(buyer_id);

Return "redirect:/buyer/findAll";

}

@RequestMapping(value = "/insert")

public String insert(Buyer buyer) {

buyerService.insert(buyer);

Return "redirect:/buyer/findAll";

}

}

Service

package com.synnex.wms.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

import com.synnex.wms.mapper.BuyerMapper;

import com.synnex.wms.pojo.Buyer;

@Service

@Transactional

public class BuyerService {

@Autowired

BuyerMapper buyermapper;

public List findAll(){

Return buyermapper.findAll();

}

   public void update(Buyer buyer) {

      // TODO Auto-generated method stub

      buyermapper.update(buyer);

   }

   public void delete(Integer buyer_id) {

      // TODO Auto-generated method stub

      buyermapper.delete(buyer_id);

   }

   public Buyer findBuyerByBuyer_id(Integer buyer_id) {

      // TODO Auto-generated method stub

      return buyermapper.findBuyerByBuyer_id(buyer_id);

   }

   public void insert(Buyer buyer) {

      // TODO Auto-generated method stub

      buyermapper.insert(buyer);

   }

}

Mapper

package com.synnex.wms.mapper;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.synnex.wms.pojo.Buyer;

public interface BuyerMapper {

   List findAll();

   void update(Buyer buyer);

   void delete(Integer buyer_id);

   Buyer findBuyerByBuyer_id(Integer buyer_id);

   void insert(Buyer buyer);

}

MyBatis映射文件

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

   

     

      select * from buyer

   

   

   

      select * from buyer where buyer_id = #{buyer_id}

   

   

   

      update buyer SET 

      company = #{company},

      phone = #{phone},

      address = #{address},

      email = #{email},

      comment = #{comment}

      where buyer_id = #{buyer_id}

   

   

   

      delete from buyer where buyer_id = #{buyer_id}

   

   

   

      insert into buyer(buyer_id,company,phone,address,email,comment) 

      value(#{buyer_id},#{company},#{phone},#{address},#{email},#{comment})

   

The above is the detailed content of How to use SSM+MySql to implement a warehouse management system. For more information, please follow other related articles on the PHP Chinese website!