jsp1375 purchase, sale and inventory management system sqlserver graduation project

Free installation

Technical implementation

Development language: jsp. Framework: jsp+servlet. Mode: B/S. Database: sqlserver. Development tools: myeclipse or eclipse. The word count of the paper: about 10,000.

Function realization

1. Basic information management module

(1) Supplier information management

Supplier information management provides user information management functions, including the function of adding supplier information and modifying and deleting supplier information.

(2) Product information management

Product information management provides user information management functions, including the function of adding product information and modifying and deleting product information.

(3) User information management function

User information management provides user information management functions, including the function of adding user information and modifying and deleting user information.

2. Purchase management module

(1) Purchase

Purchasing provides the function of purchasing goods, including the function of adding purchased product information, the function of warehousing goods, and at the same time, it simply provides the function of calculating the amount required to purchase goods.

(2) Purchase and return

The purchase return function provides the function of returning purchased goods, including the function of adding information about goods that need to be withdrawn, the function of sending goods out of the warehouse, and at the same time, it simply provides the function of calculating the amount of money received from withdrawing goods.

3. Sales management module

(1) Sales

Sales provides product sales functions, including the function of adding sales product information, the provision of the product shipping function, and the simple calculation function of the amount of income from selling products.

(2) Sales returns

Sales returns provide users with the function of returning unqualified goods that they will purchase, including adding product information, providing the function of warehousing goods, and at the same time simply providing the function of calculating the amount required for users to return goods.

4. Inventory management module

(1) Inventory count

Inventory counting provides the function of counting the goods in the inventory, provides the comparison between the inventory quantity of goods and the book quantity, and displays the profit and loss quantity function of the goods.

(2) Commodity storage

The product warehousing function provides the warehousing function of products purchased by buyers and products returned by users. And add product information to inventory.

(3) Goods leaving the warehouse

The product outbound warehouse provides the outbound function for products required by users and products returned to suppliers due to unqualified products.

5. Query statistics module

(1) User information query

User information query provides query for a single record of user information. It can use accurate and fuzzy query methods. It can also query and display the information of all users.

(2) Supplier information query

Supplier information query provides query for a single record of supplier information. It can use two methods: accurate and fuzzy query. It can also query and display the information of all suppliers.

(3) Product information query

Product information query provides the query of a single record of product information. It can use two methods: accurate and fuzzy query. It can also query and display the information of all products.

(4) Inquiry of warehousing information

The warehousing information query provides the query of a single record of the warehousing information of the goods. It can use two methods of accurate and fuzzy query. It can also query and display the information of all goods warehousing.

(5) Purchase and return inquiry

The purchase and return query provides the query of a single record of the purchase and return information. It can use two methods: accurate and fuzzy query. It can also query and display all the purchase and return information.

(6) Sales information inquiry

Sales information query provides the query of a single record of sales information. It can use two methods: accurate and fuzzy query. It can also query and display the information of all product sales.

(7) Sales return inquiry

Sales return query provides a single record query of sales return information. It can use accurate and fuzzy query methods. It can also query and display all information that was returned after sales.

(8) Report statistics

Report statistics provide statistical functions for sales reports, purchasing reports, and inventory reports. Provide important basis and reference for senior leaders’ analysis and decision-making.

6. System management module

The system management module provides customer management, including password modification, permission setting, and system exit.

System screenshot