warehouse_management_system

javaweb warehouse management system

• Although the front-end is jsp, only ${pageContext.request.contextPath} is used
• Front-end ui is layui
• Using a small amount of ajax is a front-end and back-end separation project

Project requirements

The basic module requirements are as follows:

• 1) Login function: You need to perform a database connection, and you can determine whether you are a legal user based on your username and password. If you successfully log in, you will jump to the main page. If you fail to log in, a dialog box will pop up.

• 2) Main page design: After logging in, you will jump to the main page. The links to each function page are displayed on the main page. Click to enter the corresponding function page.

• 3) Maintenance functions of product basic information: It can realize the addition, update, deletion of product basic information and query according to product name. Product query: Can perform fuzzy query and compound SQL statements (multi-table association query, multi-condition query, etc.) according to the product number and product name to display fuzzy query results. Product modification/deletion: For selected product information, click the Modify button to save it to the database and refresh the page; or click the Delete button to delete the corresponding records in the database and refresh the page display.

• 4) Input jobs: including the addition and update of input information, query and deletion.

• 5) Outbound job: including the addition and update of inbound information, query and deletion.

• 6) Full-process product tracking: Track the entry and exit of each batch of goods, and be able to check the corresponding outbound records and inventory changes of each batch of goods.

• 7) Employee management: employees' additions, deletions, modifications and checks.

Project screenshot

database

warehouse_management_system.sql