Preface [Date]

1
Preface-

I am glad to make this project Vehicle Renting System and now I make this
project report. In this project report, I include about my project, objective of
project, lists of project activities etc.

Doing this project, I have a great experience and I get knowledge

about boutique system. These all experience and knowledge I am going to
share by my project report.

During work on this project I met many technical problems. These

technical problems are solved by my Teacher Khushnuma Ashraf .she is very
helpful for me in this project so I am very thankful to him.

Thanking you.

[Date]

2
Acknowledgement [Date]

3
ACKNOWLEDGEMENT: -I worked on Vehicle Renting System. The conceptual
Knowledge acquired by Management/ Computer student is best manifested in the project they
undergo. The present project gives a perfect vent to my understanding of the practicalities of
information of different Educational areas. I express my whole-hearted gratitude towards Shri
Ramswaroop memorial college for having given me the opportunity to undergo my project in
the field of Website development of great report and allowing me to gain invaluable experience. I

express my heart-felt gratitude to Khushnuma ashraf Ma”am for supervising me during

the project period. I also express my special thanks to all the staff member who gave me their
precious time and help me whenever required.

I am also grateful to my parents who have always been supportive in giving me correct decision

and advice.

I also express my sincere thanks to all the Respondents, without whose help the completion of this

project report was not possible

(Signature of Student)
[Date]

4
 REPORT
(VEHICLE RENTING SYSTEM)

[Date]

5
Introduction
[Date]

6
1.1 Background: -
Nowadays, there are online vehicle reservations which give much benefit to user.
A rental service is a service in which customers arrive to request the hire of a
rental unit. It is more convenient than carrying the cost of owning and maintaining
the unit.

This project is designed so as to be used by Vehicle Rental Company specializing

in renting vehicles to customers. It is an online system through which customers
can view available vehicles, register, view profile and book vehicle.

A vehicle rental or vehicle hire agency is a company that rents automobiles for
short period of time for a fee whether in a few hours or a few days or week. It is
an extended form of a rental shop, often organized with numerous local branches
(which allow a user to return a vehicle to a different location), and primarily
located near airports or busy city areas and often complemented by a website
allowing online reservations.

Vehicle rental agencies primarily serve people who have vehicles that are
temporarily out of reach or out of service, for example travelers who are out of
town or owners of damaged or destroyed vehicles who are awaiting repair or
insurance compensation.

Because of the variety of sizes of the vehicles, our company serves the self-
moving industry needs, by renting vans or trucks, and in certain markets other
types of vehicles such as motorcycles or scooters are also offered. In short, it is a
system design especially for large, premium and small vehicle rental business.
The vehicle rental system provides complete functionality of listing and booking
vehicles.
[Date]

1.2 Objective: -
7
Today’s world is computer world because most of work is doing with the help of
computer. Dependency on computer is behind the few reasons. We cannot easily
manage to store large number of data or information single handle. If we will be
needing some information or data in urgency then we cannot manage in manually
these works are very difficult if we cannot use computer.

This software is basically updating the manual chemist Inventory system to

automated Inventory system. So that organization can manage their record in
efficient and organize them.

• The main objective is to automate non-computer environment

• To save manpower.

• It will speed the processing of data and transaction.

• It will provide best security features such as provisions of passwords

• To transform the manual process of hiring vehicle to a computerize system.

• To validate the Rental vehicle system using user satisfaction test.

• To produce the documentation such as Software Requirement Specification

(SRS), Software Design Description (SDD) as system development reference.

• To produce a web-based system that allow customer to register and reserve

vehicle online and for the company to effectively manage their vehicle rental
business.

• To ease customer’s task whenever they need to rent a vehicle.

1. System Objective: -

Today’s world is computer world because most of work is doing with the help of
computer. Dependency on computer is behind the few reasons. We cannot easily
manage to store large number of data or information single handle.

If we will be needing some information or data in urgency then we cannot

manage in manually these works are very difficult if we cannot use computer.

2. System Context: -
This section clearly depicts the environment and boundaries of the Vehicle Rental
System and the entities with which it interacts. It helps us see how the system fits
[Date]

into the existing scheme of things. What the system will do by itself.

8
 3. Functional Requirement: -
This Software must request Username and Password for access to data, only after
authentication will allow access to the system. The Software must allow input of
products data from administrator and secured access.

Requirement analysis is a software engineering technique that is composed of the

various tasks that determine the needs or conditions that are to be met for a new
or altered product, taking into consideration the possible conflicting requirements
of the various users.

Functional requirements are those requirements that are used to illustrate the
internal working nature of the system, the description of the system, and
explanation of each subsystem. It consists of what task the system should
perform, the processes involved, which data should the system holds and the
interfaces with the user.

The functional requirements identified are:

a) Customer’s registration: The system should allow new users to register

online and generate membership card.

b) Online reservation of vehicles: Customers should be able to use the system

to make

c) Booking and online reservation.

d) Automatic update to database once reservation is made or new customer

registered: Whenever there’s new reservation or new registration, the system
should be able update the database without any additional efforts from the admin.

e) Feedbacks to customers: It should provide means for customers to leave

feedback.

4. Non-Functional Requirement: -
In this Software Input error will be returned in red with appropriate message box.
System should automatically update after every transaction. It describes aspects
of the system that are concerned with how the system provides the functional
requirements. They are:

a) Security: The subsystem should provide a high level of security and integrity
[Date]

of the data held by the system, only authorized personnel of the company can gain

9
access To the Company’s secured page on the system; and only users with valid
password and username can login to view user’s page.

b) Performance and Response time: The system should have high performance
rate when executing user’s input and should be able to provide feedback or
response within a short time span usually 50 seconds for highly complicated task
and 20 to 25seconds for less complicated task.

c) Error handling: Error should be considerably minimized and an appropriate

error message that guides the user to recover from an error should be provided.
Validation of user’s input is highly essential. Also, the standard time taken to
recover from an error should be 15 to 20 seconds.

d) Availability: This system should always be available for access at 24 hours, 7

days awake. Also, in the occurrence of any major system malfunctioning, the
system should be available in 1 to 2 working days, so that the business process is
not severely affected.

e) Ease of use: Considered the level of knowledge possessed by the users of this
system, a simple but quality user interface should be developed to make it easy
to understand and required less training.

1.3 Purpose and Scope

1.3.1 Purpose: -
The purpose of this document is to specify requirements and to give guidelines
for the development of above said project. In particular it gives guidelines on how
to prepare the above said project.

The advancement in Information Technology and internet penetration has greatly

enhanced various business processes and communication between companies
(services provider) and their customers of which car rental industry is not left out.

This Vehicle Rental System is developed to provide the following services:

• Enhance Business Processes: To be able to use internet technology to project

the rental company to the global world instead of limiting their services to their
local domain alone, thus increase their return on investment (ROI).
[Date]

• Online Vehicle Reservation: Tools through which customers can reserve

available vehicles online prior to their expected pick-up date or time.
10
• Customer’s registration: A registration portal to hold customer’s details,
monitor their transaction and used same to offer better and improve services to
them.

• Group bookings: Allows the customer to book space for a group in the case of
weddings or corporate meetings (Event management).

1.3.2 Scope: -
This project traverses a lot of areas ranging from business concept to computing
field and required to perform several researches to be able to achieve the project
objectives.

The area covers include:

•Car rental industry: This includes study on how the car rental business is being
done, process involved and opportunity that exist for improvement.

• Java Technology used for the development of the application.

• General customers as well as the company’s staff will be able to use the system
effectively.

• Web-platform means that the system will be available for access 24/7 except
when there is a temporary server issue which is expected to be minimal

• Eco-friendly: The monitoring of the vehicle activity and the overall business
becomes easy and includes the least of paper work.

• The software acts as an office that is open 24/7. It increases the efficiency of the
management at offering quality services to the customers.

• It provides custom features development and support with the software.

[Date]

11
 SURVEY OF
TECHNOLOGIES
[Date]

12
Java: -

Java is a general-purpose computer-programming language that is concurrent,

class-based, object-oriented and specifically designed to have as few
implementation dependencies as possible. It is intended to let application
developers "write once, run anywhere" (WORA), meaning that compiled Java
code can run on all platforms that support Java without the need for
recompilation. Java applications are typically compiled to bytecode that can run
on any Java virtual machine (JVM) regardless of computer architecture. As of
2016, Java is one of the most popular programming languages in use, particularly
for client-server web applications, with a reported 9 million developers. Java was
originally developed by James Gosling at Sun Microsystems (which has since
been acquired by Oracle Corporation) and released in 1995 as a core component
of Sun Microsystems' Java platform. The language derives much of its syntax
from C and C++, but it has fewer low-level facilities than either of them.

The original and reference implementation Java compilers, virtual machines, and
class libraries were originally released by Sun under proprietary licenses. As of
May 2007, in compliance with the specifications of the Java Community Process,
Sun relicensed most of its Java technologies under the GNU General Public
License. Others have also developed alternative implementations of these Sun
technologies, such as the GNU Compiler for Java (bytecode compiler), GNU
Class path (standard libraries), and Iced Tea-Web (browser plug-in for applets).

The latest version is Java released on March 20, 2018, which follows Java 9 after
only six months in line with the new release schedule. Java 8 is still supported but
there will be no more security updates for Java 9. Versions earlier than Java 8 are
supported by companies on a commercial basis; e.g. by Oracle back to Java 6 as
of October 2017 (while they still "highly recommend that you uninstall" pre-Java
8 from at least Windows computers).
[Date]

Release history

13
 Latest minor End of
Release General availability Latest release
version Support

November 14, 2008; 9 December

5.1 5.1.73 2013-12-03
years ago 2013

December 3, 2010; 7 December

5.5 5.5.60 2018-04-19
years ago 2018

February 5, 2013; 5 years February

5.6 5.6.40 2018-04-19
ago 2021

October 21, 2015; 2 years October

5.7 5.7.22 2018-04-19
ago 2023

April 19, 2018; 4 months September

8.0 8.0.11 2018-04-19
ago 2023
[Date]

14
Requirements and
Analysis
[Date]

15
3.1 Problem Definition: -
In a vehicle rental service, a vehicle that can be used temporarily by paying a fee
during a specified period. Getting a rental vehicle helps people get around
despite the fact they do not have access to their own personal vehicle or
don't own a vehicle at all.

The individual who needs a car must contact a rental vehicle company
and contract out for a vehicle. This system increases customer retention
and simplify vehicle and staff management.

3.2 Planning and Scheduling: -

PERT CHART
A project plan needs to be created to ensure the timely completion of the project.
As part of project analysis, we break the project down to a number of stages and
use a Gantt chart and PERT chart to describe specific tasks and status. The Work
Breakdown Structure of our proposed system “Vehicle Rental System” is shown
below.

ID Task Name Duratio Start Finish

n
1 Project 3 days 23/8/2023 25/8/2023
Initiation
2 Draft Project 4 days 26/8/2023 30/8/2023
Plan
3 Analysis 9 days 1/9/2023 9/9/2023
[Date]

Phase
4 interview 2 days 10/9/2023 12/9/2023
16
5 Schedule 4 days 13/9/2023 16/9/2023
users
Interviews
6 Conducting 3 days 17/9/2023 19/9/2023
users
Interviews
7 System 15 days 20/9/2023 4/10/2023
Design
8 Modules 11 days 5/10/2023 15/10/2023
Design
9 Data Structure 4 days 16/10/2023 19/10/2023
Design
10 User Interface 4 days 20/10/2023 24/10/2023
Design
11 Coding Phase 36 days 25/10/2023 28/11/2023
12 Testing Phase 9 days 29/11/2023 8/11/2023
13 Integration 6 days 9/11/2023 15/11/2023
Testing
14 System Level 5 days 16/11/2023 21/11/2023
Testing
15 Implementatio 4 days 23/11/2023 27/11/2023
n
16 Post- 2 day 29/11/2023 1/12/2023
Implementatio
n Review

3.3 Requirements Specification: -

3.3.1 Software Requirements

1 Java/JDK
2 Net Beans
3 MySQL
4 SQL YOG

3.3.2 Hardware Requirements

[Date]

• Pentium IV Processor

17
 • 512 MB RAM
• 40 GB HDD
• Color Monitor
• Keyboard, Mouse
3.4 Preliminary Product Description: -
It would be a multi user account system in key features. There will three types of
main modules in the system

• Admin

• Customer

• Invoice Management

ADMIN
Like every other management system, the vehicle rental management system will
have the admin. The admin will the entity that will monitor the activities and the
records of whole system.

Following are some main facts related to the admin of the system. There will be
only one admin in the system. Admin can view other user’s profile. The admin
will have the power to delete any other users form the records or update the data
of any other users. Any vehicle or the payment deal will be approved by the
admin.

CUSTOMERS

Customers are the reason why I feel to introduce the vehicle rental management
system, to make their journey wonderful, to get them fit for the environment they
are traveling into.

View the Vehicles –

You, as a customer, can observe the lists of vehicles available in the inventory.
The user can filter the records of the vehicle based on:

Price - The budget is an important factor. It will be easier to choose a vehicle

[Date]

rather than wondering what if I choose this vehicle and the price is higher. No
tension at all, you can analyze the vehicle record and choose your best vehicle.
18
Popular Vehicles: If you want to take the vehicle which is popular in the system
rather than thinking about the fact how this vehicle would perform, you better
look into it. The already registered customers have given the feedback of their
vehicle driving experience.

Vehicle Brand: If you are into brand, you can view the vehicles of your favorite
brand. I have taken that too into the account. The vehicle brand can be BMW,
Mercedes, Aston Martin, Honda, Mahindra etc. Just pick your pick.

Rent a Vehicle: After you have selected your favorite vehicle, you can fill the
vehicle rental form which is available online. You just have to fill some details
like for how many days you want to rent the vehicle, or if you want to rent on
hourly basis, the vehicle details of the vehicle model you want to rent. After
completing the rental form, you can pay suitable amount using net banking, your
credit / debit vehicle.

Return a rented Vehicle: The customer can return a vehicle and if all the
payments are cleared and the parts of the vehicles are not damaged, a number will
be provided to the customer so that the customer can enter that number into the
return vehicle section and the record is cleared from the rent a vehicle system and
is moved to rental vehicle history.

View Rental History: You as a user can view the history of the vehicle you have
rented in the vehicle rental management system. You can keep track of the
amount you have spent, the vehicle you have driven, the number of vehicles you
have rented etc.

Feedback: You as a user can share your experience with the vehicle rental
management system. How much you loved it, or hated it. You can give the stars
and provide some comments so that the dealer can assist the customers to their
best capability they can.

INVOICE MANAGEMENT
After the amount is paid by the customers, the invoice department will generate
the bill of the vehicle used and will reflect into the customers’ account. This
department will also keep the receipts of newly vehicle is brought to the system
so that it can further be used for analysis purpose.

3.5 CONCEPTUAL MODELS SYSTEM

ARCHETECTURE DESIGN
[Date]

1 DEFINING A SYSTEM: -

19
Collection of components, which are interconnected, and work together to realize
some objective, from a system. There are three components in every system,
namely input, processing and output

Input Processing Output

SYSTEM DEVELOPMENT LIFE CYCLE

The System development life cycle (SDLC), or Software development processing
systems engineering, information systems and software engineering, is a process
of creating or altering information systems, and the models and methodologies
that people use to develop these systems. In software engineering, the SDLC
concept underpins many kinds of software development methodologies.

These methodologies form the framework for planning and controlling the
creation of an information system the process. Broadly, following are the
different activities to be considered while defining the system development life
cycle for the said project:

• Problem Definition

• System Analysis

• Study of existing system

• Drawback of the existing system

• Proposed system

• System Requirement study

• Data flow analysis

• Feasibility study

• System design

• Input Design (Database & Forms)

[Date]

• Updating
20
 • Query /Report design

• Administration

• Testing

• Implementation

• Maintenance

2 SYSTEM ANALYSIS: -
Systems analysis is the study of sets of interacting entities, including computer
systems analysis. This field is closely related to requirements analysis or
operations research. It is also "an explicit formal inquiry carried out to help
someone (referred to as the decision maker) identify a better course of action and
make a better decision than he might otherwise have made.

System development can generally be thought of having two major components:

systems analysis and systems design. In System Analysis more emphasis is given
to understanding the details of an existing system or a proposed one and then
deciding whether the proposed system is desirable or not and whether the existing
system needs improvements.

Thus, system analysis is the process of investigating a system, identifying

problems, and using the information to recommend improvement to the system.

3 SYSTEM DESIGN: -

Systems design is the process of defining the architecture, components, modules,

interfaces, and data for a system to satisfy specified requirements. One could see
it as the application of systems theory to product development. There is some
overlap with the disciplines of systems analysis, systems architecture and systems
engineering. If the broader topic of product development "blends the perspective
of marketing, design, and manufacturing into a single approach to product
development," then design is the act of taking the marketing information and
creating the design of the product to be manufactured. Systems design is therefore
the process of defining and developing systems to satisfy specified requirements
of the user. Until the 1990s systems design had a crucial and respected role in the
[Date]

data processing industry. In the 1990s standardization of hardware and software

resulted in the ability to build modular systems. The increasing importance of
21
software running on generic platforms has enhanced the discipline of software
engineering.

Object-oriented analysis and design methods are becoming the most widely used
methods for computer systems design. The UML has become the standard
language in object-oriented analysis and design. It is widely used for modeling
software systems and is increasingly used for high designing non-software
systems and organizations.

ENTITY RELATION DIAGRAM

The Entity Relation Model or Entity Relation Diagram (ERD) is a data model or
diagram for high-level description of conceptual data model, and it provides a
graphical notation for representing such data models in the form of entity
relationship diagrams. Such models are typically used in the first stage of
Management information system design; they are used for example, to describe
information needs and/ or the type of information that is to be stored in the
Database during the requirement analysis.

The data modeling technique, however, can be used to describe any ontology (i.e.
an overview and classification of used term and their relationships) for a certain
universe of discourse (i.e. area of interest).

In the case of design, a Management Information System that is based on a

database, the conceptual data model is, a later stage (usually called logical
design), mapped to a logical data model such as, relational data model; this is turn
in mapped to a physical model during physical design.

Note that sometimes, both of the phases are referred a “physical design”. There
are number of conventions for entity-relation diagrams (ERDs). The classical
notation is described in the remainder of this article, and mainly related to the
conceptual modeling. There is a range of notation more typically employed in
physical and logical database design.
[Date]

22
 CH_NUMBE
R

VEHICLE_NUM VEHICLE NAME

PASSWORD

MANAG
VEHICLE DETAIL
ADMIN ES

ADMIN_ID
EN_NAM
VEHICLE TYPE
E

MANAG
ES VEHICLE
ID
CUS_ID
PH_NUM
EMAIL

VEHICLE REPORT
CUS_ID CUSTOMER

CUS_NAME
DAT
ADDRESS E
CUS_NAME

S HAS

RENT
WITH
VEHICLE ID
PRICE
[Date]

VEHICLE RENTAL
23
 DISCOUNT
CATEGOR
Y

DATA FLOW DIAGRAM

The data flow diagram shows the flow of data within any system. It is an
important tool for designing phase of software engineering. Larry Constantine
first developed it. It represents graphical view of flow of data. It’s also known as
BUBBLE CHART. The purpose of DFD is major transformation that will
become in system design symbols used in DFD.

In the DFD, four symbols are used and they are as follows.

1. A square defines a source (originator) or destination of system data.

2. An arrow identifies data flow-data in motion. It is 2a pipeline through

which information flows.

3. A circle or a “bubble “(Some people use an oval bubble) represents a

process that transfers informing data flows into outgoing data flows.
[Date]

24
 4. An open rectangle is a data store-data at rest, or a temporary

Repository of data.

Context Level Data Flow Diagram: -

This level shows the overall context of the system and its operating environment
and shows the whole system as just one process. Online book store is shown as
one process in the context diagram; which is also known as zero level DFD,
shown below.

VEHICLE

CUSTOMER
VEHICLE RENTAL
REQUEST SYSTEM
ADMIN

Zero Level Data Flow Diagram

The context diagram plays important role in understanding the system and
determining the boundaries. The main process can be broken into sub-processes
and system can be studied with more detail; this is where 1st level DFD comes
into play.

First Level DFD: -

[Date]

25
This level (level 1) shows all processes at the first level of numbering, data stores,
external entities and the data flows between them. The purpose of this level is to
show the major high-level processes of the system and their interrelation. A
process model will have one, and only one, level-1 diagram. A level-1 diagram
must be balanced with its parent context level diagram, i.e. there must be the same
external entities and the same data flows, these can be broken down to more detail
in the level 1.

PAY BILL
CUSTOMER

BUY OR VEHICLE
Vehicle
ASK
Rental system

Process
ADMIN or deal
by

One level data flow diagram

Data Tables
//Login Table
[Date]

26
//ADD VEHICLE Table

//ADD CUSTOMER Table [Date]

27
//ADD COMPANY Table

//ADD DRIVER Table

//ADD EMPLOYEE TABLE

//RETURN CAR TABLE

[Date]

28
Login form

Login: -
Name Column Data Type Size Constraints
User Varchar 20 Primary key
Password Varchar 20 Not Null

add_company: -

Name Column Data Type Size Constraints

Company_name Varchar 40 Primary key

add_customer: -

Name Column Data Type Size Constraints

Customer_ID Varchar 20 Primary key
Name Varchar 30 Not Null
Gender Varchar 10 Not Null
Address Varchar 50 Not Null
[Date]

Use_As Varchar 40 Not Null

29
Book_Date Varchar 20 Not Null
Rent_Date Varchar 30 Not Null
Mobile decimal 10,0 Not Null
Company Varchar 40 Not Null
Seating_Capacity Varchar 20 Not Null
Car_number Varchar 40 Not Null
Driver_ID Varchar 20 Primary key
Rent_Days Varchar 20 Not Null
Total_rent Varchar 40 Not Null

add_driver: -

Name Column Data Type Size Constraints

Name Varchar 40 Not Null

Gender Varchar 10 Not Null

Address Varchar 60 Not Null

Experience Varchar 50 Not Null

DOB Varchar 30 Not Null

Mobile Decimal 10,0 Not Null

Driver_ID Varchar 30 Not Null

Seating_Capacity Varchar 40 Not Null

Company Varchar 50 Not Null

Car_number Varchar 60 Not Null

Identification_Number Varchar 15 Not Null

[Date]

add_emp: -
30
Name Column Data Type Size Constraints

Name Varchar 40 Not Null

Gender Varchar 6 Not Null

Address Varchar 50 Not Null

DOB Varchar 20 Not Null

Qualification Varchar 20 Not Null

Mobile Decimal 10,0 Not Null

User Varchar 40 Not Null

Password Varchar 40 Not Null

Date_of_Joining Varchar 20 Not Null

add_vehicle: -

Name Column Data Type Size Constraints

Model Varchar 40 Not Null
Company Varchar 20 Not Null
Car_number Varchar 20 Primary key
Make_Year Year 4 Not Null
Use Varchar 30 Not Null
Seating_capacity Varchar 30 Not Null
Type Varchar 20 Not Null
Varient Varchar 30 Not Null
Engine_capacity Varchar 20 Not Null
Rent Varchar 30 Not Null
Avaliability tinyint 1 Not Null
[Date]

31
CODING
[Date]

32
Database Connectivity: -
Coding: -
package vehicle_renting_system;

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

public class DB {

public Connection con;

public PreparedStatement pstmt;

public Statement stmt;

public ResultSet rst;

public DB()

{
[Date]

try

33
 {

[Link]("[Link]");

con=[Link]("jdbc:mysql://localhost:3306/renting","root
","singh@323");

catch(Exception e)

[Link]();

ANIMATION: -
CODING: -
package vehicle_renting_system;

public class Vehicle_Renting_System

public static void main(String[] args)

splash sp=new splash();

[Link](true);

login l=new login();

try

for(int z=0;z<=100;z++)
[Date]

34
 [Link](30);

[Link](z);

if(z==100)

[Link](false);

[Link](true);

catch(Exception e)

[Link]();

[Date]

35
LOGIN: -
Coding On Login as Employee Button: -

private void jButton3ActionPerformed([Link] evt)

[Link](true);

Coding On Admin Button Coding: -

private void jButton2ActionPerformed([Link] evt)

[Link](true);

Coding On Admin Login Button: -

[Date]

private void jButton1ActionPerformed([Link] evt)

36
{

try

String user;

user = [Link]();

String password;

password = [Link]();

DB dbc=new DB();

[Link]=[Link]("select * from admin_login where

user=? And password=?");

[Link](1,user);

[Link](2,password);

[Link]=[Link]();

if([Link]())

new login().setVisible(false);

[Link](false);

new Driver().setVisible(true);

else

[Link](null,"Incorrect Username Or
Password");

}
[Date]

catch(Exception e)

{
37
 [Link]();

Coding On Admin Login Button: -

private void jButton4ActionPerformed([Link] evt)

try

String user;

user = [Link]();

String password;

password = [Link]();

DB dbc=new DB();

[Link]=[Link]("select * from admin_login where

user=? and

password=?");

[Link](1,user);

[Link](2,password);

[Link]=[Link]();

if([Link]())

new login().setVisible(false);

[Link](false);

new renting_system().setVisible(true);

[Link](null,"Matched");
[Date]

38
 else

[Link](null,"Incorrect Username Or
Password");

catch(Exception e)

[Link]();

Employee Main Window Coding: -

ADD DRIVER: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem8ActionPerformed([Link] evt)

Add_Driver.setVisible(true);

try

DB db=new DB();

[Link]=[Link]("select Company_name from

add_company");

[Link]=[Link]();
[Date]

while([Link]())
39
 {

[Link]([Link](1));

catch(Exception e)

[Link]();

Car Available Button Coding: -

private void jButton10ActionPerformed([Link] evt)

try

String number=[Link]();

String company=(String)[Link]();

String seater=(String)[Link]();

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Model");
[Date]

[Link]("Make Year");
40
 [Link]("Use As");

[Link]("Type");

[Link]("Varient");

[Link]("Engine Capacity");

[Link]("Rent");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link]("select * from add_vehicle where

Car_number='"+number+"' ");

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](4));

[Link]([Link](5));

[Link]([Link](7));

[Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link](data1);

[Link](new
[Link](data,header));

catch(Exception e)
[Date]

[Link]();
41
 }

Coding On Submit Button: -

private void jButton11ActionPerformed([Link] evt)

try

String name=[Link]();

String address=[Link]();

String Experience=(String) [Link]();

String DOB=[Link]();

String Mobile=[Link]();

String number=[Link]();

if([Link]())

gender="Male";

if([Link]())

gender="Female";

String Driver_ID=[Link]();

String Seating=(String) [Link]();

String company=(String)[Link]();

String car_number=[Link]();
[Date]

String message="";
42
 int a=1;

if([Link](""))

message=message+"Name Can not be Empty ";

a=0;

if([Link](""))

message=message+" Address Field can not be Empty ";

a=0;

if([Link](""))

message=message+" DOB Field can not be Empty ";

a=0;

if([Link](""))

message=message+" Mobile Field can not be Empty ";

a=0;

if(Driver_ID.equals(""))

message=message+" Driver ID can not be Empty ";

a=0;
[Date]

}
43
 if(car_number.equals(""))

message=message+" Car Number can not be Empty ";

a=0;

if(a==0)

[Link](this, message);

if(a==1)

DB db=new DB();

[Link]=[Link]("insert into add_Driver

values(?,?,?,?,?,?,?,?,?,?,?)");

[Link](1, name);

[Link](2,gender);

[Link](3, address);

[Link](4, Experience);

[Link](5, DOB);

[Link](6, Mobile);

[Link](7, Driver_ID);

[Link](8, Seating);

[Link](9, company);

[Link](10, car_number);

[Link](11, number);
[Date]

int i=[Link]();

44
 if(i>0)

[Link](this, "Driver Added Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link]("Select");

[Link](null);

[Link](null);

[Link](null);

[Link]("Select");

[Link]("Select");

[Link](null);

else

[Link](this, "ERROR!!!!!!!!!!");

catch(Exception e)

[Link]();

}
[Date]

Coding On Cancel Button: -

45
private void jButton14ActionPerformed([Link] evt)

Add_Driver.setVisible(false);

Modify Driver: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem9ActionPerformed([Link] evt)

Modify_Driver.setVisible(true);

Coding On Search Button: -

private void jButton15ActionPerformed([Link] evt)

String user2=[Link]();

try {
[Date]

DB dbc=new DB();

46
 [Link]=[Link]("select * from add_Driver where
Driver_ID='"+user2+"'");

[Link]=[Link]();

if([Link]())

[Link]([Link](1));

String s=[Link](2);

if([Link]("Male"))

[Link](true);

[Link](false);

if([Link]("Female"))

[Link](true);

[Link](false);

[Link]([Link](3));

String a=[Link](4);

for(int h=0;h<[Link]();h++)

if([Link]([Link](h)))

[Link](h);

}
[Date]

47
 [Link]([Link](5));

String q=[Link](6);

for(int h=0;h<[Link]();h++)

if([Link]([Link](h)))

[Link](h);

[Link]([Link](7));

} catch (Exception e) {

[Link]();

Coding On Update Button: -

private void jButton16ActionPerformed([Link] evt) {

String user2=[Link]();

String name=[Link]();

String address=[Link]();

String DOB=[Link]();

String qualification=(String)[Link]();

String Mobile=[Link]();

String Experience=(String)[Link]();
[Date]

if([Link]())
48
 {

gender="Male";

if([Link]())

gender="Female";

try

DB db=new DB();

[Link]=[Link]("update add_Driver set

Name=?,Gender=?,Address=?,Experience=?,DOB=?,Qualification=?,Mobile=?
where Driver_ID='"+user2+"' ");

[Link](1, name);

[Link](2, gender);

[Link](3, address);

[Link](4,Experience);

[Link](5,DOB);

[Link](6, qualification);

[Link](7, Mobile);

int i=[Link]();

if(i>0)

[Link](this, "Driver Record Updated

Successfully");

[Link](null);
[Date]

[Link](null);
49
 [Link](null);

[Link]("Select");

[Link](null);

[Link](null);

[Link]("Select");

[Link](false);

[Link](false);

else

[Link](this, "ERROR!!!!!!!!!!");

catch(Exception e)

[Link]();

Coding On Delete Button: -

private void jButton17ActionPerformed([Link] evt) {

try

String user2=[Link]();

DB db=new DB();
[Date]

50
 [Link]=[Link]("delete from add_Driver where
Driver_ID='"+user2+"' ");

int i=[Link]();

if(i>0)

[Link](this, "Driver Record Deleted

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link]("Select");

[Link](null);

[Link](null);

[Link]("Select");

[Link](false);

[Link](false);

else

[Link](this, "Error!!!");

catch (Exception e)

{
[Date]

[Link]();

}
51
 }

Driver List: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
Drivers_List.setVisible(true);

try

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Name");

[Link]("Gender");
[Date]

[Link]("Address");

[Link]("Experience");
52
[Link]("DOB");

[Link]("Mobile");

[Link]("Driver ID");

[Link]("Seating Capacity");

[Link]("Company");

[Link]("Car Number");

[Link]("Driver License");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link]("select * from add_Driver");

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](2));

[Link]([Link](3));

[Link]([Link](4));

[Link]([Link](5));

[Link]([Link](6));

[Link]([Link](7));

[Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link]([Link](11));

[Link](data1);
[Date]

53
 [Link](new
[Link](data,header));

catch(Exception e)

[Link]();

List Of Customer: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem12ActionPerformed([Link] evt)

Customer_List.setVisible(true);

try

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();
[Date]

[Link]();

[Link]("Customer ID");
54
[Link]("Name");

[Link]("Gender");

[Link]("Address");

[Link]("Use As");

[Link]("Book Date");

[Link]("Renting Date");

[Link]("Mobile");

[Link]("Company");

[Link]("Seating Capacity");

[Link]("Car Number");

[Link]("Driver ID");

[Link]("Renting Days");

[Link]("Total Renting Amount");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link]("select * from add_customer");

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](2));

[Link]([Link](3));

[Link]([Link](4));

[Link]([Link](5));

[Link]([Link](6));
[Date]

[Link]([Link](7));
55
 [Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link]([Link](11));

[Link]([Link](12));

[Link]([Link](13));

[Link]([Link](14));

[Link](data1);

[Link](new
[Link](data,header));

catch(Exception e)

{ [Link]();}}

Add Customer: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem10ActionPerformed([Link] evt)

Add_Customer.setVisible(true);

try

DB db=new DB();

[Link]=[Link]("select Company_name from

[Date]

add_company");

56
 [Link]=[Link]();

while([Link]())

[Link]([Link](1));

catch(Exception e)

[Link]();

Coding On Car Available Button:-

private void jButton18ActionPerformed([Link] evt) {

try

String number=[Link]();

String company=(String)[Link]();

String seater=(String)[Link]();

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Model");

[Link]("Make Year");

[Link]("Use As");
[Date]

[Link]("Type");
57
 [Link]("Varient");

[Link]("Engine Capacity");

[Link]("Rent");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link]("select * from add_vehicle where

Car_number='"+number+"' ");

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](4));

[Link]([Link](5));

[Link]([Link](7));

[Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link](data1);

[Link](new
[Link](data,header));

catch(Exception e)

[Link]();
[Date]

}
58
Coding On Calculate Button: -
private void jButton19ActionPerformed([Link] evt)

String days=[Link]();

String car_number=[Link]();

int total;

try{

String rent = null;

int temp;

DB dbc=new DB();

[Link]=[Link]("select rent from add_vehicle where

Car_number='"+car_number+"'");

[Link]=[Link]();

if([Link]())

rent=[Link](1);

temp=[Link](rent);

total=[Link](days)*temp;

[Link]([Link](total));

catch(Exception e)

[Link]();

}
[Date]

Coding On Submit Button: -

59
private void jButton20ActionPerformed([Link] evt) {

String customer_ID=[Link]();

String name=[Link]();

String address=[Link]();

String use_as=(String)[Link]();

String book=[Link]();

String Rent_date=[Link]();

String mobile=[Link]();

String company=(String)[Link]();

String capacity=(String)[Link]();

String car_number=[Link]();

String Driver_ID=[Link]();

String Rent_Days=[Link]();

String Total_rent=[Link]();

if([Link]())

gender="Male";

if([Link]())

gender="Female";

try

DB db=new DB();
[Date]

60
 [Link]=[Link]("insert into add_customer
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

[Link](1, customer_ID);

[Link](2, name);

[Link](3,gender);

[Link](4, address);

[Link](5, use_as);

[Link](6, book);

[Link](7,Rent_date);

[Link](8, mobile);

[Link](9, company);

[Link](10, capacity);

[Link](11, car_number);

[Link](12, Driver_ID);

[Link](13, Rent_Days);

[Link](14, Total_rent);

int i=[Link]();

if(i>0)

[Link](this, "Customer Added

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link]("Select");
[Date]

[Link]("Select");

[Link](null);
61
 [Link](null);

[Link]("Select");

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

else

[Link](this, "ERROR!!!!!!!!!!");

[Link]=[Link]("Update Avaliability from

add_vehicle where Car_number='"+car_number+"' ");

[Link](1,"0");

[Link]();

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton21ActionPerformed([Link] evt)

{
[Date]

Add_Customer.setVisible(false);

62
}

Modify Customer: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem11ActionPerformed([Link] evt)

Modify_Customer.setVisible(true);

Coding On Search By ID Button: -

private void jButton25ActionPerformed([Link] evt)

String user2=[Link]();

try
[Date]

DB dbc=new DB();
63
 [Link]=[Link]("select * from add_customer where
Customer_ID='"+user2+"'");

[Link]=[Link]();

if([Link]())

[Link]([Link](2));

String s=[Link](3);

if([Link]("Male"))

[Link](true);

[Link](false);

if([Link]("Female"))

[Link](true);

[Link](false);

[Link]([Link](4));

[Link]([Link](8));

catch (Exception e)

[Link]();
[Date]

64
 }

Coding On Search By Name: -

private void jButton22ActionPerformed([Link] evt) {

String user2=[Link]();

try {

DB dbc=new DB();

[Link]=[Link]("select * from add_customer where

Name='"+user2+"'");

[Link]=[Link]();

if([Link]())

[Link]([Link](1));

String s=[Link](3);

if([Link]("Male"))

[Link](true);

[Link](false);

if([Link]("Female"))

[Link](true);

[Link](false);

[Link]([Link](4));

[Link]([Link](8));
[Date]

65
 }

catch (Exception e)

[Link]();

Coding On Update Button: -

private void jButton23ActionPerformed([Link] evt) {

String user2=[Link]();

String name=[Link]();

String address=[Link]();

String Mobile=[Link]();

if([Link]())

gender="Male";

if([Link]())

gender="Female";

try

DB db=new DB();

[Link]=[Link]("update add_customer set

Name=?,Gender=?,Address=?,Mobile=? where Customer_ID='"+user2+"' ");
[Date]

[Link](1, name);

66
 [Link](2, gender);

[Link](3, address);

[Link](4, Mobile);

int i=[Link]();

if(i>0)

[Link](this, "Customer Record Updated

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](false);

[Link](false);

else

[Link](this, "ERROR!!!!!!!!!!");

catch(Exception e)

[Link]();

}
[Date]

Coding On Delete Button: -

67
private void jButton24ActionPerformed([Link] evt) {

try

String user2=[Link]();

DB db=new DB();

[Link]=[Link]("delete from add_Customer where

Customer_ID='"+user2+"' ");

int i=[Link]();

if(i>0)

[Link](this, "Driver Record Deleted

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](false);

[Link](false);

else

[Link](this, "Error!!!");

catch (Exception e)
[Date]

[Link]();
68
 }

Return Car: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem14ActionPerformed([Link] evt)

Return_Car.setVisible(true);

Coding On Search By ID Button: -

private void jButton26ActionPerformed([Link] evt)

String user2=[Link]();

try
[Date]

{
69
 DB dbc=new DB();

[Link]=[Link]("select * from add_customer

where Customer_ID='"+user2+"'");

[Link]=[Link]();

if([Link]())

[Link]([Link](2));

[Link]([Link](11));

[Link]([Link](9));

[Link]([Link](6));

[Link]([Link](7));

catch (Exception e)

[Link]();

String car_number=[Link]();

try

DB dbc=new DB();

[Link]=[Link]("select Model from add_vehicle

where Car_number='"+car_number+"'");

[Link]=[Link]();

if([Link]())
[Date]

[Link]([Link](1));
70
 }

catch(Exception e)

[Link]();

Coding On Search By Name Button: -

private void jButton27ActionPerformed([Link] evt) {

String user2=[Link]();

try

DB dbc=new DB();

[Link]=[Link]("select * from add_customer

where Name='"+user2+"'");

[Link]=[Link]();

if([Link]())

[Link]([Link](1));

[Link]([Link](11));

[Link]([Link](9));

[Link]([Link](6));

[Link]([Link](7));

}
[Date]

71
 catch (Exception e)

[Link]();

String car_number=[Link]();

try

DB dbc=new DB();

[Link]=[Link]("select Model from add_vehicle

where Car_number='"+car_number+"'");

[Link]=[Link]();

if([Link]())

[Link]([Link](1));

catch(Exception e)

[Link]();

Coding On Returned Button: -

private void jButton28ActionPerformed([Link] evt) {

String customer_id=[Link]();

String name=[Link]();
[Date]

String car_number=[Link]();

72
 String model=[Link]();

String company=[Link]();

String Booking_Date=[Link]();

String Return_Date=[Link]();

try

DB db=new DB();

[Link]=[Link]("insert into return_car

values(?,?,?,?,?,?,?)");

[Link](1, customer_id);

[Link](2, name);

[Link](3, car_number);

[Link](4,model);

[Link](5, company);

[Link](6, Booking_Date);

[Link](7, Return_Date);

int i=[Link]();

if(i>0)

[Link](this, "Vehicle Returned

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link](null);
[Date]

[Link](null);

[Link](null);
73
 [Link](null);

else

[Link](this, "ERROR!!!!!!!!!!");

catch(Exception e)

[Link]();

try

DB db=new DB();

[Link]=[Link]("Update Avaliability from

add_vehicle where Car_number='"+car_number+"' ");

[Link](1,"1");

[Link]();

catch(Exception e)

[Link]();

}
[Date]

Coding On Cancel Button: -

74
private void jButton29ActionPerformed([Link] evt)

Return_Car.setVisible(false);

View Cars: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem6ActionPerformed([Link] evt)

View_Cars.setVisible(true);

try

DB db=new DB();

[Link]=[Link]("select Company_name from

add_company");

[Link]=[Link]();

while([Link]())
[Date]

{
75
 [Link]([Link](1));

catch(Exception e)

[Link]();

Coding On View Available Cars: -

private void jButton9ActionPerformed([Link] evt) {

try

String company=(String)[Link]();

String Use_as=(String)[Link]();

String avail;

String a="select * from add_vehicle where Avaliability=1 AND

Company='"+company+"' ";

String b="select * from add_vehicle where Avaliability=0 AND

Company='"+company+"' ";

String q="select * from add_vehicle where Avaliability=0 AND

Company='"+company+"' ";

avail=(String)[Link]();

if([Link]("Available"))

q=a;

}
[Date]

if([Link]("Non Avaliable"))
76
{

q=b;

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Model");

[Link]("Car Number");

[Link]("Make Year");

[Link]("Seating Capacity");

[Link]("Type");

[Link]("Varient");

[Link]("Engine Capcity");

[Link]("Rent");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link](q);

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](3));

[Link]([Link](4));

[Link]([Link](6));
[Date]

[Link]([Link](7));
77
 [Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link](data1);

[Link](new
[Link](data,header));

catch(Exception e)

[Link](); } }

Change Password: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem1ActionPerformed([Link] evt)

Change_Password.setVisible(true);

Coding On Submit Button: -

private void jButton12ActionPerformed([Link] evt)

try
[Date]

{
78
String user1=[Link]();

String password=[Link]();

int a=1;

String message="";

DB dbc=new DB();

String newpassword=[Link]();

String conpassword=[Link]();

if([Link](""))

message=message+"User Field Can not be Empty ";

a=0;

if([Link](""))

message=message+" Password Field can not be Empty ";

a=0;

if([Link](""))

message=message+" New Password Field can not be Empty ";

a=0;

if([Link](""))

message=message+" Confirm Password Field can not be Empty ";

[Date]

a=0;
79
 }

if(a==0)

[Link](this, message);

if(a==1)

[Link]=[Link]("select Password from

driver_login where password=?");

[Link](1,password);

[Link]=[Link]();

if([Link]())

if([Link](conpassword))

[Link]=[Link]("update driver_login set

Password=? where user='"+user1+"' ");

[Link](1,conpassword);

int i=[Link]();

if(i>0)

[Link](this,"Changed Successfully");

else

{
[Date]

[Link](this,"Error in changing
Password!!");
80
 }

else

[Link](this,"Password Not Matched

Please Try again");

else

[Link](this,"Incorrect Password");

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton13ActionPerformed([Link] evt)

Change_Password.setVisible(false);

}
[Date]

81
Admin Main Window: -
Add Employee: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem2ActionPerformed([Link] evt)

Add_Employee.setVisible(true);

Coding On Submit Button: -

private void jButton1ActionPerformed([Link] evt)

try

{
[Date]

String name=[Link]();
82
String address=[Link]();

String DOB=[Link]();

String Qualification=(String) [Link]();

String Mobile=[Link]();

String user2=[Link]();

String password=[Link]();

String conpassword=[Link]();

String DOJ=[Link]();

if([Link]())

gender="Male";

if([Link]())

gender="Female";

int a=1;

String message="";

if([Link](""))

message=message+"Name Can not be Empty ";

a=0;

if([Link](""))

{
[Date]

message=message+" Address can not be Empty ";

83
 a=0;

if([Link](""))

message=message+" DOB can not be Empty ";

a=0;

if([Link](""))

message=message+" Mobile can not be Empty ";

a=0;

if([Link](""))

message=message+" User Name can not be Empty ";

a=0;

if([Link](""))

message=message+" Password Field can not be Empty ";

a=0;

if([Link](""))

message=message+" Confirm Password Field can not be Empty ";

[Date]

a=0;
84
 }

if([Link](""))

message=message+" Date Of Joinging can not be Empty ";

a=0;

if(a==0)

[Link](this, message);

if(a==1)

if([Link](conpassword))

DB db=new DB();

[Link]=[Link]("insert into add_emp

values(?,?,?,?,?,?,?,?,?)");

[Link](1, name);

[Link](2, gender);

[Link](3, address);

[Link](4,DOB);

[Link](5, Qualification);

[Link](6, Mobile);

[Link](7, user2);

[Link](8, password);
[Date]

[Link](9, DOJ);

85
 int i=[Link]();

if(i>0)

[Link](this, "Employee Added

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link]("Select");

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](false);

[Link](false);

else

[Link](this, "ERROR!!!!!!!!!!");

else

[Link](this,"Password Not Matched

[Date]

Please Try again");

}
86
 }

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton2ActionPerformed([Link] evt)

Add_Employee.setVisible(false);

[Date]

87
Modify Employee: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem3ActionPerformed([Link] evt)

Modify_Employee.setVisible(true);

Coding On Search Button: -

private void jButton10ActionPerformed([Link] evt) {

String user2=[Link]();

try {

DB dbc=new DB();

[Link]=[Link]("select * from add_emp where

user='"+user2+"'");
[Date]

[Link]=[Link]();
88
if([Link]())

[Link]([Link](1));

String s=[Link](2);

if([Link]("Male"))

[Link](true);

[Link](false);

if([Link]("Female"))

[Link](true);

[Link](false);

[Link]([Link](3));

[Link]([Link](4));

String q=[Link](5);

for(int h=0;h<[Link]();h++)

if([Link]([Link](h)))

[Link](h);

[Link]([Link](6));
[Date]

[Link]([Link](9));
89
 }

} catch (Exception e) {

[Link]();

Coding On Submit Button: -

private void jButton6ActionPerformed([Link] evt) {

String user2=[Link]();

String name=[Link]();

String address=[Link]();

String DOB=[Link]();

String qualification=(String) [Link]();

String Mobile=[Link]();

String DOJ=[Link]();

if([Link]())

gender="Male";

if([Link]())

gender="Female";

try

DB db=new DB();
[Date]

90
 [Link]=[Link]("update add_emp set
Name=?,Gender=?,Address=?,DOB=?,Qualification=?,Mobile=?,Date_of_Joini
ng=? where user='"+user2+"' ");

[Link](1, name);

[Link](2, gender);

[Link](3, address);

[Link](4,DOB);

[Link](5, qualification);

[Link](6, Mobile);

[Link](7, DOJ);

int i=[Link]();

if(i>0)

[Link](this, "Employee Record Updated

Successfully");

[Link](null);

[Link](null);

[Link](null);

[Link]("Select");

[Link](null);

[Link](null);

[Link](null);

[Link](false);

[Link](false);

else
[Date]

{
91
 [Link](this, "ERROR!!!!!!!!!!");

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton3ActionPerformed([Link] evt)

Modify_Employee.setVisible(false);

[Date]

92
Employee List: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem4ActionPerformed([Link] evt) {

Employees_List.setVisible(true);

try

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Name");
[Date]

[Link]("Gender");

[Link]("Address");
93
 [Link]("DOB");

[Link]("Qualification");

[Link]("Mobile");

[Link]("User Name");

[Link]("Date Of Joining");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link]("select * from add_emp");

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](2));

[Link]([Link](3));

[Link]([Link](4));

[Link]([Link](5));

[Link]([Link](6));

[Link]([Link](7));

[Link]([Link](9));

[Link](data1);

[Link](new
[Link](data,header));

catch(Exception e)
[Date]

94
 [Link]();

Driver List: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem5ActionPerformed([Link] evt) {

Drivers_List.setVisible(true);

try

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Name");

[Link]("Gender");
[Date]

[Link]("Address");
95
[Link]("Experience");

[Link]("DOB");

[Link]("Mobile");

[Link]("Driver ID");

[Link]("Seating Capacity");

[Link]("Company");

[Link]("Car Number");

[Link]("Driver License");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link]("select * from add_Driver");

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](2));

[Link]([Link](3));

[Link]([Link](4));

[Link]([Link](5));

[Link]([Link](6));

[Link]([Link](7));

[Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link]([Link](11));
[Date]

[Link](data1);
96
 [Link](new
[Link](data,header));

catch(Exception e)

[Link]();

View Cars: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem6ActionPerformed([Link] evt)

View_Cars.setVisible(true);

try

DB db=new DB();

[Link]=[Link]("select Company_name from

add_company");

[Link]=[Link]();

while([Link]())
[Date]

{
97
 [Link]([Link](1));

catch(Exception e)

[Link]();

Coding On View Available Cars Button: -

private void jButton9ActionPerformed([Link] evt) {

try

String company=(String)[Link]();

String Use_as=(String)[Link]();

String avail;

String a="select * from add_vehicle where Avaliability=1 AND

Company='"+company+"' ";

String b="select * from add_vehicle where Avaliability=0 AND

Company='"+company+"' ";

String q="select * from add_vehicle where Avaliability=0 AND

Company='"+company+"' ";

avail=(String)[Link]();

if([Link]("Available"))

q=a;

}
[Date]

if([Link]("Non Avaliable"))
98
{

q=b;

Vector<Vector<String>>data=new Vector<Vector<String>>();

[Link]();

Vector<String>header=new Vector<String>();

[Link]();

[Link]("Model");

[Link]("Car Number");

[Link]("Make Year");

[Link]("Seating Capacity");

[Link]("Type");

[Link]("Varient");

[Link]("Engine Capcity");

[Link]("Rent");

DB db=new DB();

[Link]=[Link]();

[Link]=[Link](q);

while([Link]())

Vector<String>data1=new Vector<String>();

[Link]([Link](1));

[Link]([Link](3));

[Link]([Link](4));

[Link]([Link](6));
[Date]

[Link]([Link](7));
99
 [Link]([Link](8));

[Link]([Link](9));

[Link]([Link](10));

[Link](data1);

[Link](new
[Link](data,header));

catch(Exception e)

[Link](); } }

Add Company: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem7ActionPerformed([Link] evt) {

Add_Company.setVisible(true);

try

DB db=new DB();

[Link]=[Link]("select Company_name from

add_company");

[Link]=[Link]();

while([Link]())

{
[Date]

[Link]([Link](1));

100
 }

catch(Exception e)

[Link]();

Coding On Submit Button: -

private void jButton4ActionPerformed([Link] evt) {

try

String company=[Link]();

DB db=new DB();

[Link]=[Link]("insert into add_company

values(?)");

[Link](1, company);

int i=[Link]();

if(i>0)

[Link](this, "Company Added

Successfully");

[Link](null);

else

{
[Date]

[Link](this, "ERROR!!!!!!!!!!");

}
101
 }

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton5ActionPerformed([Link] evt)

Add_Company.setVisible(false);

ADD Vehicle: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem13ActionPerformed([Link] evt) {

try

Add_Vehicle.setVisible(true);

DB db=new DB();

[Link]=[Link]("select Company_name from

add_company");

[Link]=[Link]();

while([Link]())

{
[Date]

[Link]([Link](1));
102
 }

catch(Exception e)

[Link]();

Coding On Submit Button: -

private void jButton7ActionPerformed([Link] evt) {

try

String avaliablity="1";

String model=[Link]();

String company=(String) [Link]();

String car_number=[Link]();

String make_year=[Link]();

String use_as=(String) [Link]();

String seating_capacity=(String) [Link]();

String type=(String) [Link]();

String varient=(String) [Link]();

String engine_capacity=[Link]();

String rent=[Link]();

int a=1;

String message="";

if([Link](""))
[Date]

{
103
 message=message+"Model Can not be Empty ";

a=0;

if(car_number.equals(""))

message=message+" Car Number can not be Empty ";

a=0;

if(make_year.equals(""))

message=message+" Make Year can not be Empty ";

a=0;

if(engine_capacity.equals(""))

message=message+" Engine Capacity can not be Empty ";

a=0;

if([Link](""))

message=message+" Rent Field can not be Empty ";

a=0;

if(a==0)

{
[Date]

[Link](this, message);
104
 }

if(a==1)

DB db=new DB();

[Link]=[Link]("insert into add_vehicle

values(?,?,?,?,?,?,?,?,?,?,?)");

[Link](1, model);

[Link](2, company);

[Link](3, car_number);

[Link](4,make_year);

[Link](5, use_as);

[Link](6, seating_capacity);

[Link](7, type);

[Link](8, varient);

[Link](9, engine_capacity);

[Link](10, rent);

[Link](11,avaliablity);

int i=[Link]();

if(i>0)

[Link](this, "Vehicle Added

Successfully");

[Link](null);

[Link](null);

[Link](null);
[Date]

[Link]("Select");

[Link]("Select");
105
 [Link]("Select");

[Link]("Select");

[Link]("Select");

[Link](null);

[Link](null);

else

[Link](this, "ERROR!!!!!!!!!!");

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton8ActionPerformed([Link] evt)

Add_Vehicle.setVisible(false);

}
[Date]

106
Change Password: -
Event Performed On Menu Item:-
Action Event performed(actionPerformed)

Coding: -
private void jMenuItem1ActionPerformed([Link] evt)

Change_Password.setVisible(true);

Coding On Submit Button: -

private void jButton12ActionPerformed([Link] evt) {

try

String user1=[Link]();
[Date]

String password=[Link]();

String newpassword=[Link]();
107
String conpassword=[Link]();

int a=1;

String message="";

if([Link](""))

message=message+"User Field Can not be Empty ";

a=0;

if([Link](""))

message=message+" Password Field can not be Empty ";

a=0;

if([Link](""))

message=message+" New Password Field can not be Empty ";

a=0;

if([Link](""))

message=message+" Confirm Password Field can not be Empty ";

a=0;

if(a==0)

{
[Date]

[Link](this, message);
108
 }

if(a==1)

DB dbc=new DB();

[Link]=[Link]("select Password from

employee_login where password=?");

[Link](1,password);

[Link]=[Link]();

if([Link]())

if([Link](conpassword))

[Link]=[Link]("update employee_login set

Password=? where user='"+user1+"' ");

[Link](1,conpassword);

int i=[Link]();

if(i>0)

[Link](this,"Changed Successfully");

else

[Link](this,"Error in changing
Password!!");

}
[Date]

else
109
 {

[Link](this,"Password Not Matched

Please Try again");

else

[Link](this,"Incorrect Password");

catch(Exception e)

[Link]();

Coding On Cancel Button: -

private void jButton13ActionPerformed([Link] evt)

Change_Password.setVisible(false);

}
[Date]

110
 DESIGN
SCREENSHOTS
[Date]

111
Splash Screen: -

[Date]

112
Login Window: -

[Date]

113
Employee Login: -

[Date]

114
Admin Login: -

[Date]

115
Employee Window: -

[Date]

116
 [Date]

117
 [Date]

118
 [Date]

119
 [Date]

120
Add Driver: -

[Date]

121
Modify Driver: -

[Date]

122
Driver List: -

[Date]

123
Add Customer: -

[Date]

124
Modify Customer: -

[Date]

125
Customer List: -

[Date]

126
Return Car: -

[Date]

127
View Cars: -

[Date]

128
Change Password: -

[Date]

129
Admin Window: -

[Date]

130
 [Date]

131
 [Date]

132
 [Date]

133
 [Date]

134
Add Employee: -

[Date]

135
Modify Employee: -

[Date]

136
Employee List: -

[Date]

137
Driver List: -

[Date]

138
View Cars: -

[Date]

139
Add Company: -

[Date]

140
Add Vehicle: -

[Date]

141
Change Password: -

[Date]

142
TESTING [Date]

143
System Testing: -
Black box testing method was used for system testing. The black box
testing usually demonstrates that software functions are operational; that the input
is properly accepted and the output is correctly produced; and that integrity of
external information (databases) is maintained.

Why testing is done

• Testing is the process of running a system with the intention of finding

errors.
• Testing enhances the integrity of a system by detecting deviations in
design and errors in the system.
• Testing aims at detecting error-prone areas. This helps in the prevention of
errors in a system.
• Testing also add value to the product by confirming to the user
requirements.

Causes of Errors

• The most common causes of errors in a software system are:

• Communication gap between the developer and the business

decisionmaker: A communication gap between the developer and the
business decision maker is normally due to subtle differences between them.
The differences can be classified into five broad areas: Thought process,
[Date]

Background and Experience, Interest, Priorities, Language

144
• .Time provided to a developer to complete the project: A common source
of errors in projects comes from time constraints in delivering a product. To
keep to the schedule, features can be cut. To keep the features, the schedule
can be slipped. Failing to adjust the feature set or schedule when problems are
discovered can lead to rushed work and flawed systems.
• Over Commitment by the developer: High enthusiasm can lead to over
commitment by the developer. In these situations, developers are usually
unable to adhere to deadlines or quality due to lack of resources or required
skills on
the team.

• Insufficient testing and quality control: Insufficient testing is also a major

source of breakdown of e-commerce systems during operations, as testing
must be done during all phases of development.
• Inadequate requirements gathering: A short time to market results in
developers starting work on the Web site development without truly
understanding the business and technical requirements. Also, developers may
create client-side scripts using language that may not work on some client
browsers.
• Keeping pace with the fast changing Technology: New technologies are
constantly introduced. There may not be adequate time to develop expertise
in the new technologies. This is a problem for two reasons. First, the
technology may not be properly implemented. Second, the technology may
not integrate well with the existing environment.

Testing Principles

• To discover as yet undiscovered errors.

[Date]

• All tests should be traceable to customer’s requirement.

• Tests should be planned long before the testing actually begins.
145
• Testing should begin “in the small” & progress towards “testing in the large”.
• Exhaustive Testing is not possible.
• To be most effective training should be conducted by an Independent Third
Party

Testing Objectives

• Testing is a process of executing a program with the intent of finding errors.

• A good test case is one that has a high probability of finding an as yet
undiscovered error.
• A successful test is one that uncovers an as yet undiscovered error.

Kinds of Testing:

Black Box Testing- Not based on any knowledge of internal designs or code.
Tests are based on requirements and functionality.

White Box Testing- Based on the knowledge of the internal logic of an

application’s code. Tests are based on coverage of code statements, branches,
paths and statements.

Unit Testing- The most ‘micro’ scale of testing; to test particular functions and
code modules. Typically done by the programmer and not by the testers, as it
requires detailed knowledge of the internal program design and code. Not always
easily done unless the application has a well-designed architecture with tight
code; may require developing test driver modules or test harnesses.
[Date]

146
Integration Testing- Testing of combined parts of an application to determine if
they function together correctly. The ‘parts’ can be code modules, individual
applications, client and server applications on a network, etc. This type of testing
is especially relevant to client/ server and distributed systems.

Functional Testing- Black-box type testing geared to functional requirements of

an application; testers should do this type of testing. This doesn’t mean that the
programmers shouldn’t check that their code works before releasing it.

Regression Testing- Re-testing after fixes or modifications of the software or its

environment. It is difficult to determine how much re testing is needed, especially
near the end of the development cycle. Automated testing tools can be especially
useful for this type of testing.

Acceptance Testing- Final testing based on the specifications of the end user or
customer or based on use by end-users/ customers over some limited period of
time.

User Acceptance Testing- Determining if software is satisfactory to an end user

customer

Testing Technique Used

We will continuously test our project to ensure that it is fully functional. In order
to perform testing test cases are designed with the intent of finding the errors in
the project and help in removing those errors. Testing begins at the module level
and is conducted systematically. It is generally conducted by independent test
groups or third party.
[Date]

147
Testing is done in our project Vehicle Renting System with help of black box
testing that exercise all the functional requirement of the project test cases are
designed using this approach by providing set of input conditions to get the
expected output.

FUTURE &
SCOPE
[Date]

148
1.3.1 Purpose: -
The purpose of this document is to specify requirements and to give guidelines
for the development of above said project. In particular it gives guidelines on how
to prepare the above said project.

The advancement in Information Technology and internet penetration has greatly

enhanced various business processes and communication between companies
(services provider) and their customers of which car rental industry is not left out.

This Vehicle Rental System is developed to provide the following services:

• Enhance Business Processes: To be able to use internet technology to project

the rental company to the global world instead of limiting their services to their
local domain alone, thus increase their return on investment (ROI).

• Online Vehicle Reservation: Tools through which customers can reserve

available vehicles online prior to their expected pick-up date or time.

• Customer’s registration: A registration portal to hold customer’s details,

monitor their transaction and used same to offer better and improve services to
them.

• Group bookings: Allows the customer to book space for a group in the case of
weddings or corporate meetings (Event management).

1.3.2 Scope: -
This project traverses a lot of areas ranging from business concept to computing
field and required to perform several researches to be able to achieve the project
objectives.

The area covers include:

[Date]

•Car rental industry: This includes study on how the car rental business is being
done, process involved and opportunity that exist for improvement.
149
• Java Technology used for the development of the application.

• General customers as well as the company’s staff will be able to use the system
effectively.

• Web-platform means that the system will be available for access 24/7 except
when there is a temporary server issue which is expected to be minimal

• Eco-friendly: The monitoring of the vehicle activity and the overall business
becomes easy and includes the least of paper work.

• The software acts as an office that is open 24/7. It increases the efficiency of the
management at offering quality services to the customers.

• It provides custom features development and support with the software.

[Date]

150
Bibliography

[Date]

151
References
The following books were referred during the analysis and execution phase of the
project

Common Language Runtime

By Steven Pratschner

SOFTWARE ENGINEERING

By Roger S. Pressman

UNIFIED MODELING LANGUAGE

By Gradi Booch, Ivar Jacobson,

James Rambaugh

COMPLETE REFERENCE .NET

By David S Platt

MSDN 2003

By Microsoft

IMAGES

Google Search

Msn Search

Bing Search

HTML PUBLISHING BIBL

- Alan Simpson.
[Date]

C# 2008

Andrew Troelson
152
WEBSITES:
[Link]

[Link]

[Link]

[Link]

[Link]

[Link]’

[Link]

[Date]

153