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.
The Project can be setup locally with the following steps.
Use git clone
to clone this repo to your local machine:
$ git clone https://github.com/Parbhat/CRM.git
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.