Customer Relationship Management (CRM) Software made with Swing, JDBC, MySql. This Software is a mini version which has the following features -
- Login for employees of the Company.
- Sell Products to customers.
- Track the details of products.
- Add new products and increment the quantity of other products.
- Check customer records for warranty.
The Software is made using following Technologies -
- Java - Programming Language.
- Swing - For User Interface.
- JDBC (Java Database Connectivity).
- MySQL - Database.
#Setup
The Project uses MySQL for database so install MySQL server into your local machine.
Use Username - `root` and Password - `3366` or change the following line in the project code.
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/crm", "root", "3366");
####Create a Database
mysql> CREATE DATABASE crm;
###Create the necessary Tables in the crm Database
This repository contains a sql file called **database.sql** which contains all the sql queries for creating Tables. The database can be imported with the following command.
mysql -u username -p databasename < filename.sql
_So everything is setup, open the project in Netbeans to use or modify it according to your needs._
)