怎么用SSM+MySql实现仓库管理系统
这篇“怎么用SSM+MySQL实现仓库管理系统”文章的知识点大部分人都不太理解,所以小编给大家总结了以下内容,内容详细,步骤清晰,具有一定的借鉴价值,希望大家阅读完这篇文章能有所收获,下面我们一起来看看这篇“怎么用SSM+MySql实现仓库管理系统”文章吧。
创新互联云计算的互联网服务提供商,拥有超过13年的服务器租用、服务器托管、云服务器、虚拟空间、网站系统开发经验,已先后获得国家工业和信息化部颁发的互联网数据中心业务许可证。专业提供云主机、虚拟空间、域名注册、VPS主机、云服务器、香港云服务器、免备案服务器等。
系统介绍
该系统为SSM实现在仓库管理系统,实现了供应商管理、经销商管理、商品管理、出库管理、收货单管理等等仓库系统所需在基本功能。系统实现上分层比较明确,操作比较简单。
功能模块
相关技术点
前端:系统前端采用jsp + JavaScript + css的组合开发
后端:SSM框架
数据库:MySQL
开发运行环境:IDEA/Eclipse等开发工具,Tomcat7/8容器、JDK1.8/1.7、Mysql数据库。
功能截图
系统目前主要实现了供应商管理模块、经销商管理模块、商品管理模块、库存管理模块、订货单管理模块。由于篇幅有限,只贴出部分功能的运行截图。
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
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
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
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})
以上就是关于“怎么用SSM+MySql实现仓库管理系统”这篇文章的内容,相信大家都有了一定的了解,希望小编分享的内容对大家有帮助,若想了解更多相关的知识内容,请关注创新互联行业资讯频道。
网页标题:怎么用SSM+MySql实现仓库管理系统
文章路径:http://myzitong.com/article/pejcds.html