Skip to content
Customer Relationship Management (CRM) Software made with Swing, JDBC, MySQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
build project files Dec 4, 2014
dist project files Dec 4, 2014
nbproject Local Setup described Dec 4, 2014
src/crm project files Dec 4, 2014
LICENSE Initial commit Dec 4, 2014
README.md typo fixed Dec 4, 2014
build.xml project files Dec 4, 2014
database.sql Database .sql file Dec 4, 2014
manifest.mf project files Dec 4, 2014

README.md

CRM

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 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.

Screenshots

You can’t perform that action at this time.