In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.