您好,登錄后才能下訂單哦!
這篇“怎么用SSM+MySql實(shí)現(xiàn)倉庫管理系統(tǒng)”文章的知識(shí)點(diǎn)大部分人都不太理解,所以小編給大家總結(jié)了以下內(nèi)容,內(nèi)容詳細(xì),步驟清晰,具有一定的借鑒價(jià)值,希望大家閱讀完這篇文章能有所收獲,下面我們一起來看看這篇“怎么用SSM+MySql實(shí)現(xiàn)倉庫管理系統(tǒng)”文章吧。
系統(tǒng)介紹
該系統(tǒng)為SSM實(shí)現(xiàn)在倉庫管理系統(tǒng),實(shí)現(xiàn)了供應(yīng)商管理、經(jīng)銷商管理、商品管理、出庫管理、收貨單管理等等倉庫系統(tǒng)所需在基本功能。系統(tǒng)實(shí)現(xiàn)上分層比較明確,操作比較簡單。
功能模塊
相關(guān)技術(shù)點(diǎn)
前端:系統(tǒng)前端采用jsp + JavaScript + css的組合開發(fā)
后端:SSM框架
數(shù)據(jù)庫:MySQL
開發(fā)運(yùn)行環(huán)境:IDEA/Eclipse等開發(fā)工具,Tomcat7/8容器、JDK1.8/1.7、Mysql數(shù)據(jù)庫。
功能截圖
系統(tǒng)目前主要實(shí)現(xiàn)了供應(yīng)商管理模塊、經(jīng)銷商管理模塊、商品管理模塊、庫存管理模塊、訂貨單管理模塊。由于篇幅有限,只貼出部分功能的運(yùn)行截圖。
1
供應(yīng)商管理
經(jīng)銷商管理
商品管理
添加商品信息
庫存管理
訂貨單管理
部分源碼
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";
}
}
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);
}
}
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);
}
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>
以上就是關(guān)于“怎么用SSM+MySql實(shí)現(xiàn)倉庫管理系統(tǒng)”這篇文章的內(nèi)容,相信大家都有了一定的了解,希望小編分享的內(nèi)容對大家有幫助,若想了解更多相關(guān)的知識(shí)內(nèi)容,請關(guān)注億速云行業(yè)資訊頻道。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。