RSS-Automobiles

Short description:

An automobile showroom management system where a sales personnel of a showroom (Ex-Manager) can do basic inventory CRUD operations on automobiles (Cars) and order with some extensible features such as billing form with proper authentication.

Authors

• RAFID SHAHRIAR - rafid211
• SAYMON,AKTHER HAMID - AhSaymon
• SAKIB,AHMED SHAHRIAR - ahmedshahriar

Prerequisites

java , mysql

Target Users of this application:

• Sales personnel of an automobile showroom (ex- Manager).

Features :

• User Access :

  • User can sign in to the system .
  • User can register for access .
  • User can sign out from the system .

• User Control :

  • Check inventory.
  • Check order history.
  • Check customer history.
  • Create an order form.
  • Generate a bill (which is saved in pdf format).
  • Check revenue.
  • User can sort multiple data from data table in ascending and descending order.
  • User can search specific data(along with the row) from the table .

Built With

• Java 1.8,swing,awt - Core
• iTextpdf - Billing Form Pdf generation
• mysql - Database management

Project Structure:

This project is divided into three packages :

• guiPackage :
  • Car
  • Customer
  • LoginPage
  • Main Frame
  • Order
  • Selectionpage
  • Order Form
  • Sign Up Page
  • Total Revenue
• Event Handling :
  • Car Event
  • Customer Event
  • Export Pdf
  • Login Event
  • Order Event
  • Order Form Event
  • Selection Page Event
• Database connection :
  • CarDataProvider
  • DBConnector

Database connection code snippet

import java.sql.Connection;
import java.sql.DriverManager;


public class DBConnector {
    private static Connection c;
    public static Connection getDataBaseConnection(String url){
        if(c==null) {
            try {
                String username = "root";
                String pass = "";
                Class.forName("com.mysql.jdbc.Driver");
                c = DriverManager.getConnection(url, username, pass);
            } catch (Exception e) {
                e.printStackTrace();
            }
            return c;
        }
        else{
            return c;
        }
    }

}

Entity relationship Diagram :

Relational Schema :

GUI :

Generated Bill as pdf

Click here to download the sample bill as pdf