jsp809 pharmaceutical warehouse 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

Main functions of warehouse drug management system

a. Setting of drug warning lines:

Set the inventory boundaries of various medicines in the warehouse and enter the critical quantity of medicines. When the quantity of medicines in the warehouse reaches the critical quantity, the system will issue a warning to facilitate the formulation of customer plans.

b. Drug management:

Enter the information of newly entered drugs, including the nature, name, specifications, manufacturer, storage quantity, unit price, validity period, serial number and other information of all drugs. For existing medicines, just add their quantity.

c.Inventory management:

If the drugs in the warehouse are expired, damaged, etc., a loss report form will be prepared and submitted to the superior leader for approval, and the system will automatically modify the quantity of the corresponding drugs. Drug information can be modified.

d. Outbound management:

The delivery of drugs from the warehouse is for outpatient pharmacies and wards. When the outpatient pharmacy or ward personnel receive the medicine, after confirmation, the system automatically modifies the quantity of drugs in the warehouse.

e. Query:

Inquire about drug entry, inventory, exit, loss reporting, etc. according to time range, drug category, nature, etc.

f. Statistics:

Statistics on the entry, exit and loss reporting of drugs are carried out according to time range, drug category, nature, etc.

Main functions of equipment management system

a. Warehousing management

Enter the information of the warehousing equipment, including the name, specification, manufacturer, warehousing quantity, unit price, etc. of all equipment information.

b.Inventory management:

If the equipment in the warehouse is damaged, a damage report form will be prepared and submitted to the superior leader for approval, and the system will automatically modify the quantity of the equipment. Device information can be modified.

c. Outbound management:

Drugs are sent out of the warehouse to multiple departments in the hospital. When the equipment is taken away, after confirmation by the operator, the system automatically modifies the warehouse quantity of the equipment taken by the patient.

d.Query:

Inquire about the entry, exit, loss reporting, etc. of equipment according to time range, equipment classification, etc.

e. Statistics:

Statistics are carried out according to time ranges, equipment classifications are distinguished, and statistics of inbound, outbound, and loss reports are realized.

Main functions of chemical reagent management system

a. Warehousing management:

Input the information of newly stored chemical reagents, including the nature, name, specifications, manufacturer, storage quantity, unit price, validity period and other chemical reagent information.

b.Inventory management:

If chemical reagents in the warehouse are expired or damaged, a loss report will be prepared and submitted to superior leaders for approval. The system will automatically modify the quantity of chemical reagents. The drug information in the warehouse can be modified.

c. Outbound management:

Chemical reagents are shipped out of the warehouse to the laboratory. After the laboratory's application is approved, the system automatically modifies the warehouse inventory quantity of the corresponding chemical reagents. Chemical reagent information can be modified.

d.Query:

Query the entry, exit, inventory and loss reporting of chemical reagents according to time range, chemical reagent category, etc.

f. Statistics:

Make statistics according to the time range, distinguish chemical reagent categories, and make statistics on the incoming, outgoing, and damage reports.

System screenshot