基于SSM+MySql實作的倉庫管理系統

基于SSM的倉庫管理系統

系統介紹

該系統為SSM實作在倉庫管理系統，實作了供應商管理、經銷商管理、商品管理、出庫管理、識訓單管理等等倉庫系統所需在基本功能，系統實作上分層比較明確，操作比較簡單，

功能模塊

相關技術點

前端：系統前端采用jsp + JavaScript + css的組合開發
后端：SSM框架
資料庫：MySQL
開發運行環境：IDEA/Eclipse等開發工具，Tomcat7/8容器、JDK1.8/1.7、Mysql資料庫，

功能截圖

    系統目前主要實作了供應商管理模塊、經銷商管理模塊、商品管理模塊、庫存管理模塊、訂貨單管理模塊，由于篇幅有限，只貼出部分功能的運行截圖，

1. 供應商管理
   
2. 經銷商管理
   
3. 商品管理
   
4. 添加商品資訊
   
5. 庫存管理
   
6. 訂貨單管理
   

部分原始碼

1. 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<Buyer> 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";
   }

}

2. 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<Buyer> 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);
   }
}

3. 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<Buyer> findAll();

   void update(Buyer buyer);

   void delete(Integer buyer_id);

   Buyer findBuyerByBuyer_id(Integer buyer_id);

   void insert(Buyer buyer);

}

4. MyBatis映射檔案

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.synnex.wms.mapper.BuyerMapper">
   
   <select id="findAll" resultType="com.synnex.wms.pojo.Buyer">
      <!-- List<Buyer> findALl(); -->
      select * from buyer
   </select>
   
   <!-- Buyer findBuyerByBuyer_id(Integer buyer_id); -->
   <select id="findBuyerByBuyer_id" resultType="com.synnex.wms.pojo.Buyer">
      select * from buyer where buyer_id = #{buyer_id}
   </select>
   
   <!-- void update(Buyer buyer); -->
   <update id="update">
      update buyer SET 
      company = #{company},
      phone = #{phone},
      address = #{address},
      email = #{email},
      comment = #{comment}
      where buyer_id = #{buyer_id}
   </update>
   
   <!-- void delete(Integer buyer_id); -->
   <delete id="delete" >
      delete from buyer where buyer_id = #{buyer_id}
   </delete>
   
   <!-- void insert(Buyer record); -->
   <insert id="insert">
      insert into buyer(buyer_id,company,phone,address,email,comment) 
      value(#{buyer_id},#{company},#{phone},#{address},#{email},#{comment})
   </insert>
</mapper>

最后

如果想要進一步了解實作思路或者需要全部原始碼和報告（僅供自學、課設、畢設等學習使用），可加博主V：（Code2Life2）交流、獲取，