您好,欢迎访问一九零五行业门户网

怎么用SSM+MySql实现仓库管理系统

系统介绍
该系统为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实现仓库管理系统的详细内容。
其它类似信息

推荐信息