系统介绍
该系统为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<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">
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>
以上就是怎么用ssm+mysql实现仓库管理系统的详细内容。