CSE3104 - Database
This Project is made by using Microsoft SQL Server and Neatbeans
To run this project you have to open the project in Neatbeans and import these jar file in the library
- sqljdbc41.jar
- sqljdbc42.jar
- rs2xml.jar
Total Class:
-
Dashboard.java : 4818 lines
-
DashboardSalesman.java : 2300 lines
-
Company.java : 34 lines
-
ConnectMSQL.java : 53 lines
-
Execute.java : 79 lines
-
ExecuteQuery.java : 267 lines
-
Generic.java : 29 lines
-
Inventory.java : 63 lines
-
itemDetails.java : 44 lines
-
Login.java : 402 lines
-
Medicine.java : 50 lines
-
Purchase.java : 64 lines
-
SellingDetails.java : 58 lines
-
Signup.java : 461 lines
-
UserDetails.java : 56 lines
Total : 8778 linesNo of Table shown in the project : 9 Tables
No of Work Procedure/User Defined Function : 19 Functions
No of Distinct Queries : 51 Queries
CRUD Operation,Search Operation,Logical Operation
CRUD Operation :
- Medicine Insert,Edit,Delete
- Purchase insert
- inventory insert through purchase,delete,edit
- SellingDetails insert
- UserDetails Details Insert,edit,delete
- Company Insert,edit,delete
- Generic Insert,edit,delete
- Record/ItemDetails insert
- Temporary Cart Table insert,edit,delete
Search Operation :
- Medicine Search using name,category,medicine type,comapany name
- Purchase Search using name,category,medicine type,comapany name
- Inventory Search using name,category,medicine type
- Selling Details Search using customer name,salesman name,selling date
- User Details Search using Name,Role,Address,Phone
- Company Search company name,address
- Generic Search category,uses
Logical Operation:
- Setting number of user
- Setting number of medicine
- setting number of sales for overall sales/specific salesman sales
- Setting number of out of stock medicine
- Setting number of Upcoming ExpireDate alert medicine
- Query Execution of Insert,Update Delete 7.i) Logical cart add(can not add quantity more than stock) ii) Logical cart edit(can not edit more than stock) iii) logical cart: same medicine can be added multiple times but quantity can not be more than stock iv) after saving cart inventory medicine stock will be minus from orderd quantity