Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to use SSM+MySql to realize Warehouse Management system

2025-01-30 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >

Share

Shulou(Shulou.com)06/01 Report--

The knowledge of this article "how to use SSM+MySql to achieve warehouse management system" is not understood by most people, so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to use SSM+MySql to achieve warehouse management system" article.

System introduction

The system is implemented in the warehouse management system for SSM, which realizes the basic functions of the warehouse system, such as supplier management, dealer management, commodity management, out-of-warehouse management, receipt management and so on. The layering of the system is relatively clear and the operation is relatively simple.

Function module

Related technical points

Front end: the front end of the system is developed by the combination of jsp, JavaScript and css.

Backend: SSM framework

Database: MySQL

Development environment: IDEA/Eclipse and other development tools, Tomcat7/8 container, JDK1.8/1.7, Mysql database.

Function screenshot

At present, the system mainly realizes the supplier management module, dealer management module, commodity management module, inventory management module, order management module. Due to the limited space, only some screenshots of the functions are posted.

one

Supplier management

Dealer management

Commodity management

Add commodity information

Inventory management

Order management

Partial source code

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 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 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 findAll ()

Void update (Buyer buyer)

Void delete (Integer buyer_id)

Buyer findBuyerByBuyer_id (Integer buyer_id)

Void insert (Buyer buyer)

}

MyBatis mapping file

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})

The above is about "how to use SSM+MySql to achieve warehouse management system" this article content, I believe we all have a certain understanding, I hope the editor to share the content to help you, if you want to know more related knowledge content, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 236

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Development

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report