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.