[Link] I.T.

III Shree Tours & Travels Management System

CHAPTER : 1
INTRODUCTION
TO PROJECT

1
[Link] I.T. III Shree Tours & Travels Management System

1.1 INTRODUCTION TO SYSTEM

The Tours and Travel Management System is a web based application. The main
purpose of “SHREE TOURS AND TRAVELS MANAGEMENT SYSTEM ” is to provide
a convenient way for a customer to book for tours. The objective of this project is to
develop a system that automates the processes and activities of a travel agency. In
the present system a customer has to approach various agencies to find details of
places and to book tickets. This often requires a lot of time and effort. We provide
approach skills to critically examine how a tourist visits and its ability to operate in an
appropriate way when dealing with the consequences of tourism, locally, regionally,
and nationally including visitor security and ecological influences. It is tedious for a
customer to plan a particular journey and have it executed properly. The project ‘Shree
Tours and Travels Management System’ is developed to replace the currently existing
system, which helps in keeping records of the customer details of destination as well
as billing.

2
[Link] I.T. III Shree Tours & Travels Management System

1.2 EXISITING SYSTEM

All Work are done manually in Manual Booking System Customer has to go to the
Travelling office.

Ask Inquiry for Travelling then Book ticket Finally Pay Payment & Collect Receipt.

Difficult to Maintain the Customer Details of Package and Payment Receipt in Register.

They Register Tour Package in the notebook.

Add advertisement in Local newspaper or Local Market.

Use Travelling Facility For the Limited Area.

1.3 NEED FOR COMPUTERIZATION

We all know the importance of computerization. The world is moving ahead at lightning
speed and everyone is running short of time One always wants to get the information
and perform a task he/she/they desire(s) within a short period of time and too with
amount of efficiency and accuracy. The application areas for the computerization have
been selected on the basis of following factors:

Minimizing the manual records kept at different locations.

There will be more data integrity.

Facilitating desired information display, very quickly, by retrieving information from

users.

Facilitating various statistical information which helps in decision-making? To reduce

manual efforts in activities that involved repetitive work.

3
[Link] I.T. III Shree Tours & Travels Management System

1.4 SCOPE OF SYSTEM

The scope of a Tours and Travels Management System includes

[Link] & Reservations – Manage tour package bookings.

2. Customer Management – Store and handle customer details, preferences, and

history.

3. Planning – Create and customize travel plans for customers.

4. Payment & Billing – Process payments, invoices.

5. Reports & Analytics – Business performance.

6. Customer Support – Assist travellers with inquiries and emergencies.

4
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 2
PROPOSED
SYSTEM

5
[Link] I.T. III Shree Tours & Travels Management System

2.1 OBJECTIVES OF SYSTEM

• This application is develop to provide best travelling services to the customers

and travel agents. We have developed tours and travel management system
to provide a search platform where a tourist can find their tour places according
to their choices.

• This system also helps to promote responsible and interesting tourism so that
people can enjoy their holidays at their favourable places.

• Improve customer experience with personalized travel recommendations.

• Maintain a centralized database for customer details, bookings, and

transactions.

6
[Link] I.T. III Shree Tours & Travels Management System

2.2 REQUIREMENT ENGINEERING

FEASIBILITY STUDY

Preliminary investigation examine project feasibility, the likelihood the system will be
useful to the organization. The main objective of the feasibility study is to test the
Technical, Operational and Economical feasibility for adding new modules and
debugging old running system. All system is feasible if they are unlimited resources
and infinite time. There are aspects in the feasibility study portion of the preliminary
investigation:

• Technical Feasibility
• Operational Feasibility
• Economic Feasibility

TECHNICAL FEASIBILITY

The technical issue usually raised during the feasibility stage of the investigation
includes the following:

Does the necessary technology exist to do what is suggested?

Do the proposed equipment's have the technical capacity to hold the data required to
use the new system?

Will the proposed system provide adequate response to inquiries, regardless of the
number or location of users?

Can the system be upgraded if developed?

Are there technical guarantees of accuracy, reliability, ease of access and data
security?

Earlier no system existed to cater to the needs of 'Secure Infrastructure

Implementation System'. The current system developed is technically feasible. It is a
web based user interface for audit workflow at NIC-CSD

Thus it provides an easy access to the users. The database's purpose is to create,
establish and Maintain a workflow among various entities in order to facilitate all
concerned users in their various capacities or roles. Permission to the users would

7
[Link] I.T. III Shree Tours & Travels Management System

be granted based on the roles specified. Therefore, it provides the technical guarantee
of accuracy, reliability and security. The software and hard requirements for the
development of this project are not many and are already available in-house at NIC or
are available as free as open source. The work for the project is done with the Current
equipment and existing software technology. Necessary bandwidth exists for providing
a fast feedback to the users irrespective of the number of users

Using the system.

OPERATIONAL FEASIBILITY

Proposed projects are beneficial only if they can be turned out into information system.
That will meet the organization's operating requirements. Operational feasibility
aspects of the project are to be taken as an important part of the project
implementation. Some of the important issues raised are to test the operational
feasibility of a project includes the following: -

Is there sufficient support for the management from the users?

Will the system be used and work properly if it is being developed and implemented?

Will there be any resistance from the user that will undermine the possible application
benefits?

This system is targeted to be in accordance with the above-mentioned issues.

Beforehand, the management issues and user requirements have been taken into
consideration. So there is no question of resistance from the users that can undermine
the possible application benefits.

The well-planned design would ensure the optimal utilization of the computer
resources and would help in the improvement of performance status:

ECONOMICAL FEASIBILITY

A system can be developed technically and that will be used if installed must still be a
good investment for the organization. In the economic feasibility, the development cost
in creating the system is evaluated against the ultimate benefit derived from the new
systems. Financial benefits must equal or exceed the costs. The system is
economically feasible

8
[Link] I.T. III Shree Tours & Travels Management System

2.3 REQUIREMENT GATHERING:

FACT FINDING TECHNIQUES

In system under consideration during development phase following methods are

adopted.

A key part of feasibility is gathering information about the present system. The analyst
knows what information to gather to make of it.

Questionnaires

It allow sanely collect information from a group of individuals who may or may not be
using the system thus resulting sometimes in irrelevant data & data redundancy.

Interviews

Analysts use interview to collect information from individuals who they considers
should be the sources, who are current users of the existing system The analyst should
have a face conversation with the users & administrator of the system & fixed set of
question sis prepared.

Record Review

Consisting of analysed the previous operations in the company & fore casting the new
futures schemes. Record include table name, date &time creation, user login etc.

Observation

If information is not collected from the other fact-finding method, then observation
method is used. In this method analyst to observes flow of documents, way the process
is carried out steps followed person involved etc.

9
[Link] I.T. III Shree Tours & Travels Management System

2.4 SRS

In order to form a good SRS, here you will see some points that can be used and
should be considered to form a structure of good Software Requirements Specification
(SRS). It is a document prepared by business analyst or system analyst. It describes
what will be the features of software and what will be its behaviour. It is the detail
description of software system to be developed with its functional & non-functional
requirement.

FUNCTIONAL REQUIREMENT OF THE SYSTEM

Functional requirements specify the software functionality. Functional requirement are

useless without non-functional requirements. Statements of services the system
should provide, how the system should react to particular inputs and how the system
should behave in particular situations. May state what the system should not do. All
functional requirements which may include calculations, data processing, etc. are
placed in a ranked order. Help to understand the functions of the system. They are
easy to define.

NON-FUNCTIONAL REQUIREMENT OF THE SYSTEM

In this, non-functional attributes are explained that are required by software system for
better performance. An example may include Security, Portability, Reliability,
Reusability, Application compatibility, Data integrity, Scalability capacity, etc. non-
functional requirement are independent of function requirement. Help to understand
the system is performance. Often apply to the system as a whole rather than individual
features or services.

2.4.1 JAVA

INTRODUCTION

Java is object oriented programming language. Developed by James Gosling in early

[Link] a lang for digital devices such as set top boxes, television etc. James
Gosling and his team called their project “Greentalk” and its file extension was .gt and
later become to known as “oak”. Java language is known for its robustness, security,
and simplicity features. Java is mainly used for application programming. Java is
platform independent language

10
[Link] I.T. III Shree Tours & Travels Management System

FEATURES OF JAVA

1. Simple:

Java is a simple language because its syntax is simple, clean, and easy to
understand. Complex and ambiguous concepts of C++ are either eliminated or
re-implemented in Java. For example, pointer and operator overloading are not
used in Java.

2. Object-Oriented:

In Java, everything is in the form of the object. It means it has some data and
behaviour. A program must have at least one class and object.

3. Robust:

Java makes an effort to check error at run time and compile time. It uses a
strong memory management system called garbage collector. Exception
handling and garbage collection features make it strong.

4. Secure:

Java is a secure programming language because it has no explicit pointer and

programs runs in the virtual machine. Java contains a security manager that
defines the access of Java classes.

5. Platform-Independent:

Java provides a guarantee that code writes once and run anywhere. This byte
code is platform-independent and can be run on any machine.

6. Portable:

Java Byte code can be carried to any platform. No implementation-dependent

features. Everything related to storage is predefined, for example, the size of
primitive data types.

2.4.2 MYSQL

INTRODUCTION

MySQL is an open source RDBMS that uses SQL to create and manage databases.
As a relational database, MySQL stores data in tables of rows and columns organized

11
[Link] I.T. III Shree Tours & Travels Management System

into schemas. A schema defines how data is organized and stored and describes the
relationship among various tables. MySQL is very fast, reliable, and easy to use
database system. It uses standard SQL. MySQL compiles on a number of platforms.
MySQL is a free and open-source software.

WHAT IS MYSQL

• MySQL is a relational database management system

• MySQL is open-source

• MySQL is free

• MySQL is ideal for both small and large applications

• MySQL is very fast, reliable, scalable, and easy to use

• MySQL is cross-platform

• MySQL is compliant with the ANSI SQL standard

• MySQL was first released in 1995

WHY USE MYSQL

MySQL is open-source software, which means it’s free to use and has a large
community of developers contributing to its improvement. MySQL has been around for
a long time and is known for its stability and reliability. MySQL provides robust security
features to protect your data, including access controls, encryption, and auditing
capabilities.

FEACTURE MYSQL

Easy to use

MySQL is easy to use. We have to get only the basic knowledge of SQL. We can build
and interact with MySQL by using only a few simple SQL statements.

High Performance

MySQL provides comparatively higher performance without affecting its functionality.

It also has a very little memory leakage making it memory efficient as well.

12
[Link] I.T. III Shree Tours & Travels Management System

Platform Independent

MySQL can be run on various operating systems including Windows, Linux, macOS
etc. in several programming languages like C, C++, Java, Python, etc.

Open-Source

MySQL is open-source, which means this software can be downloaded, used and
modified by anyone. It is free-to-use and easy-to-understand. The source code of
MySQL can be studied, and changed based on the requirements.

13
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 3
SYSTEM
ANALYSIS

14
[Link] I.T. III Shree Tours & Travels Management System

System Diagram
3.1 DFD(Data Flow Diagram)

15
[Link] I.T. III Shree Tours & Travels Management System

3.2 ER Diagram –

16
[Link] I.T. III Shree Tours & Travels Management System

System Requirements

3.1.1 Hardware

• Processor : Pentium 3,4 Processor 3GHZ

• RAM : Min 1GB

• Hardware Device : Keyboard with Mouse, Inkjet Printer.

• Hard Disk : Min 80GB Hard Disk or Above

3.1.2 Software

Programming Language : Java

Operating System : Windows 7/8/10/11

Platform : JDK 1.8

IDE : Net Bean 8.2

Database : MySQL Server 5.0.88-win22

Report : Jaspersoft Studio 5.6.0

Jar File : [Link]

Connector : [Link]

17
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 4
SYSTEM
DESIGN

18
 [Link] I.T. III Shree Tours & Travels Management System

Table Name-login

Field Name Data Type Field Size Constraints

User_name char 20 NotNull

Password int 10 NotNull

Table Name-customer

Field Name Data Type Field Size Constraints

Cust_id int 30 Primary Key

Cust_name char 50 NotNull

Cust_addr varchar 20 NotNull

Cust_Cont varchar 10 NotNull

19
[Link] I.T. III Shree Tours & Travels Management System

Table name-package

Field Name Data type Field Size Constraints

P_id int 50 Primary Key

P_type char 50 NotNull

P_place varchar 30 NotNull

P_price int 20 NotNull

20
[Link] I.T. III Shree Tours & Travels Management System

Table Name-booking

Field Name Data Type Field Size Constraints

T_id int 50 Primary Key

Cust_id int 11 Foreign Key

P_id int 11 Foreign Key

P_price int 11 NotNull

T_date date 18 NotNull

21
[Link] I.T. III Shree Tours & Travels Management System

Table Name-bill_payment

Field Name Data Type Field Size Constraints

Bill_no int 50 Primary Key

T_id int 11 Foreign Key

Cust_id int 11 Foreign Key

P_id int 11 Foreign Key

P_price int 20 NotNull

No_of_seats int 20 NotNull

Bill_date date 18 NotNull

Grand_total int 50 NotNull

22
[Link] I.T. III Shree Tours & Travels Management System

Table Name-t_cancellation

Field Name Data Type Field Size Constraints

T_id int 11 Primary Key

Cust_id int 11 Foreign Key

P_id int 11 Foreign Key

P_price int 11 NotNull

T_date date 18 NotNull

Table Name-feedback

Field Name Data Type Field Size Constraints

Cust_id int 11 Primary Key

Cust_name char 50 NotNull

Feedback char 50 NotNull

23
[Link] I.T. III Shree Tours & Travels Management System

4.2 Input Design

[Link]

[Link]

24
[Link] I.T. III Shree Tours & Travels Management System

[Link] Form

[Link] Form

25
[Link] I.T. III Shree Tours & Travels Management System

[Link] Booking

[Link] Payment

26
[Link] I.T. III Shree Tours & Travels Management System

[Link] Cancellation

[Link] us

27
[Link] I.T. III Shree Tours & Travels Management System

• Created by

Home Form(Home, Detail, Booking, Report, Help, Exit)

❖ Home

28
[Link] I.T. III Shree Tours & Travels Management System

❖ Detail

❖ Booking

29
[Link] I.T. III Shree Tours & Travels Management System

❖ Report

❖ Help

30
[Link] I.T. III Shree Tours & Travels Management System

❖ Exit

31
[Link] I.T. III Shree Tours & Travels Management System

• Output Design-

❖ Login(Output)

• Customer(Save)

32
 [Link] I.T. III Shree Tours & Travels Management System

• Customer(Update)

• Customer(Delete)

33
 [Link] I.T. III Shree Tours & Travels Management System

• Customer(Invalid Character)

• Customer(Invalid Number)

34
 [Link] I.T. III Shree Tours & Travels Management System

• Package(Save)

• Package(Update)

35
 [Link] I.T. III Shree Tours & Travels Management System

• Package(Delete)

• Ticket Booking(Save)

36
[Link] I.T. III Shree Tours & Travels Management System

• Bill Payment(Save)

• Bill Payment(Delete)

37
[Link] I.T. III Shree Tours & Travels Management System

• Ticket Cancellation(Cancellation)

• Feedback(Save)

38
[Link] I.T. III Shree Tours & Travels Management System

• Feedback(Update)

• Feedback(Delete)

39
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 5
USER
GUIDELINES

40
[Link] I.T. III Shree Tours & Travels Management System

5.1 Installation Process

I)JDK 1.8 on Windows

To install JDK 1.8 (Java Development Kit 8) on Windows, follow these steps:

Step 1: Download JDK 1.8

[Link] the Oracle JDK download page:

• Go to the Oracle JDK 8 Downloads page.

[Link] the License Agreement:

• Scroll down and find the section for JDK 8.

• Under the "Java SE Development Kit 8u" section, accept the license agreement
by clicking the checkbox.

[Link] the JDK version for Windows:

• Look for the Windows x64 installer if you are using a 64-bit version of Windows
or the Windows x86 installer for 32-bit.

41
[Link] I.T. III Shree Tours & Travels Management System

• Click the download link for the appropriate version (for example, "jdk-8uXXX-
[Link]").

[Link] the file:

• Save the installer to your computer (usually in your Downloads folder)

Step 2: Run the JDK Installer

[Link] the downloaded installer:

• Go to the folder where you downloaded the .exe file (likely the Downloads
folder).

[Link] the installer:

• Double-click on the .exe file to begin the installation process.

[Link] the Installation:

• When the installation wizard opens, click Next to proceed.

42
[Link] I.T. III Shree Tours & Travels Management System

Step 3: Choose Installation Location

[Link] the Folder for Installation:

• By default, JDK will install to a folder like C:\Program Files\Java\jdk1.8.0_xx

(where "xx" refers to the update version).

• You can choose a different installation directory if you wish, or just use the
default location.

[Link] with the Installation:

• Click Next to continue the installation.

• Wait for the installer to copy all necessary files. This may take a few
minutes.

Step 4: Complete the Installation

[Link] Installation:

• Once the installation is complete, click Close to exit the installer.

Step 5: Set Up Environment Variables

43
[Link] I.T. III Shree Tours & Travels Management System

• For Java to work properly on your system, you'll need to set the JAVA_HOME
environment variable and update the PATH variable.

[Link] JAVA_HOME:

• Open Control Panel.

• Go to System and Security > System, then click Advanced system settings on the
left.

• In the System Properties window, click Environment Variables.

• Under System variables, click New to create a new variable:

• Variable Name: JAVA_HOME

• Variable Value: The path to the JDK installation folder. For example,
C:\Program Files\Java\jdk1.8.0_301 (this may differ depending on the version you
installed).

[Link] the PATH variable:

Find the Path variable under System variables and click Edit.

In the Edit environment variable window, click New, and add the following
path:

• C:\Program Files\Java\jdk1.8.0_301\bin (or the appropriate path for your system).

Click OK to save the changes.

44
[Link] I.T. III Shree Tours & Travels Management System

Step 6: Verify the Installation

[Link] a Command Prompt:

• Press Win + R, type cmd, and hit Enter to open the Command Prompt.

[Link] the Java version:

• Type the following command and press Enter:

bash

Copy

java –version

• You should see output similar to this:

scss

Copy

java version "1.8.0_301"

Java(TM) SE Runtime Environment (build 1.8.0_301-b09)

Java HotSpot(TM) 64-Bit Server VM (build 25.301-b09, mixed mode)

• This confirms that JDK 1.8 is installed correctly.

45
[Link] I.T. III Shree Tours & Travels Management System

Step 7: Set up JAVA_HOME in NetBeans or IDE (Optional)

If you are using an IDE like NetBeans or Eclipse, you may need to configure it to use
the newly installed JDK:

1. In NetBeans, open the IDE.

2. Go to Tools > Java Platforms.

3 . Click Add Platform, then browse to the directory where JDK 1.8 is installed (e.g.,
C:\Program Files\Java\jdk1.8.0_301).

[Link] the JDK folder and click Next to add it.

II) NetBeans 8.0.2 Installation Process for Windows:

To install NetBeans 8.0.2 on Windows, follow these steps:

Step 1: Download NetBeans 8.0.2

[Link] the official NetBeans website:

• Go to the NetBeans Download page.

• Look for NetBeans 8.0.2 (since it’s an older version, you may need to navigate
through archives or look under older releases).

• Select the version for Windows (the .exe installer)

46
[Link] I.T. III Shree Tours & Travels Management System

Step 2: Run the Installer:

[Link] the downloaded installer:

• After the download finishes, navigate to the folder where the .exe file was saved
(usually in your Downloads folder).

[Link] the Installer:

• Right-click on the downloaded .exe file and select Run as Administrator to

start the installation process with administrative privileges (this ensures
proper installation of all dependencies).

[Link] the Installation:

• Click Next to proceed with the setup wizard.

Step 3: Choose Installation Type

[Link] the Type of Installation:

• Java SE: If you plan to develop Java SE applications (regular Java

applications).

• Java EE: Choose this if you plan to develop enterprise applications with
Java EE (such as web apps or Java server applications).

47
[Link] I.T. III Shree Tours & Travels Management System

[Link] JDK Location:

• NetBeans 8.0.2 will ask you to specify the JDK location. If you don’t have
JDK installed, it will prompt you to download one.

• If you already have JDK installed on your system, you can browse and
select the folder where the JDK is located.

• If you don’t have it, you can download the latest JDK from the Oracle
website, or just choose the default option provided by the NetBeans
installer.

Step 4: Choose Install Location

[Link] the Folder for Installation:

• The installer will ask where you want to install NetBeans. You can either use
the default location or choose a custom folder.

• Click Next once you’re ready.

Step 5: Begin Installation

[Link] Install:

• After confirming your installation options, click the Install button to begin the
actual installation process.

48
[Link] I.T. III Shree Tours & Travels Management System

[Link] for Installation to Complete:

• The installer will copy all necessary files and set up NetBeans on your
system. This process will take a few minutes.

• Once the installation is finished, click Finish.

Step 6: Launch NetBeans

[Link] NetBeans:

• You can now find NetBeans 8.0.2 in your Start Menu or on your desktop,
depending on the options you selected during installation.

[Link] Launch:

• The first time you run NetBeans, it may ask you to configure your JDK path. If
it doesn’t detect the JDK automatically, make sure to point it to the directory
where your JDK is installed.

• Once configured, you’ll be taken to the NetBeans IDE.

Step 7: Verify Installation

Verify the Installation:

• Once NetBeans is running, you can verify the installation by going to the Help
menu and selecting About. This will show the version of NetBeans that is
installed, and you should see that it’s NetBeans 8.0.2.

49
[Link] I.T. III Shree Tours & Travels Management System

Step 8: Begin Using NetBeans

You are now ready to start working with NetBeans 8.0.2! You can create Java projects
or start working on other supported languages like PHP, C++, or HTML5 by installing
additional plugins.

III) MySQL 5.0 on Windows:

Installing MySQL 5.0 on Windows is a bit dated, as newer versions are now available,
but if you specifically need MySQL 5.0, here's the process:

Step 1: Download MySQL 5.0 Installer

1. Visit the MySQL Archives:

• Go to the MySQL Archive Page.

• Select MySQL 5.0 from the dropdown menu for "Select Version".

• Download the Windows (x86, 32-bit) installer or Windows (x86, 64-bit)

depending on your system's architecture. Choose the Windows ZIP/Installer
version.

• Choose the appropriate version (e.g., MySQL 5.0.67, which is one of the most
popular builds).

50
[Link] I.T. III Shree Tours & Travels Management System

Step 2: Run the MySQL Installer

[Link] the downloaded installer:

• Once the installer is downloaded, go to your Downloads folder or the directory

where you saved the file.

[Link] the installer:

• Double-click the installer .exe file to launch the MySQL installation process.

[Link] the installation type:

• The MySQL Installer gives you a few installation options (like Typical or
Custom). For most users, Typical should work fine.

[Link] MySQL:

• Click Next and then Install to begin the installation process.

• The installer will set up MySQL in the default directory (usually C:\Program
Files\MySQL\MySQL Server 5.0), but you can change this during installation if
needed.

51
[Link] I.T. III Shree Tours & Travels Management System

Step 3: Configure MySQL Server

1. Start the Configuration Wizard:

• After installation, the MySQL Configuration Wizard will appear.

• Choose the Standard Configuration for most users unless you need something
custom.

[Link] the Root Password:

• The wizard will prompt you to set a root password (administrator password).
Make sure to choose a strong password and remember it, as you'll need it to
log into MySQL.

• You can also set up other MySQL accounts at this point, but the root account
is sufficient for most purposes

• Choose MySQL as a Windows Service:

• Choose to configure MySQL as a Windows Service so that MySQL starts

automatically when Windows starts. This is generally a good option unless you
have specific needs.

52
[Link] I.T. III Shree Tours & Travels Management System

[Link] MySQL:

• The configuration wizard will start MySQL and set it to run automatically as a
service.

• Choose to Start MySQL Server after configuration to ensure it's running.

[Link] the Installation:

• Once MySQL is set up, click Finish to complete the installation.

Step 4: Verify Installation

1. Test MySQL from the Command Line:

• Open a Command Prompt by pressing Win + R, typing cmd, and hitting Enter.

• To verify MySQL is running, type the following command:

bash

Copy

mysql -u root –p

It will ask for the root password you set during the installation. After entering the
password, you should be logged into the MySQL shell. You’ll see something like:

53
[Link] I.T. III Shree Tours & Travels Management System

pgsql

Copy

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: [Link] MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[Link] MySQL Version:

• You can check the MySQL version by typing:

Sql

Copy

SELECT VERSION();

• This should return something like [Link], confirming you have MySQL 5.0
installed.

Step 5: (Optional) Set Up MySQL Workbench (GUI)

If you'd like to manage MySQL using a graphical interface, you can download
MySQL Workbench. MySQL Workbench allows you to connect to your MySQL
server, create databases, tables, and run queries with ease.

54
[Link] I.T. III Shree Tours & Travels Management System

[Link] MySQL Workbench:

• Visit the MySQL Workbench Download Page and select the appropriate version
for your system.

[Link] and Launch Workbench:

• After installation, launch MySQL Workbench and set up a new connection using
the following details:

➢ Host: localhost (or [Link])

➢ Port: 3306 (default)
➢ Username: root
➢ Password: The root password you set during installation.

[Link] MySQL Server:

• Now you can use the Workbench to manage your MySQL databases and
perform queries with ease.

IV) Jaspersoft 5.6.0

To install Jaspersoft 5.6.0 (Jaspersoft Studio, Jaspersoft Server, or Jaspersoft BI),

follow the instructions based on what you want to install. Jaspersoft 5.6.0 is an older
version, so you may need to get it from archives or repositories. Here’s the general
installation process for Jaspersoft Studio and Jaspersoft Server on Windows.

55
[Link] I.T. III Shree Tours & Travels Management System

Option 1: Install Jaspersoft Studio 5.6.0 (for Report Design)

Jaspersoft Studio is an Eclipse-based development environment for creating reports.

Step 1: Download Jaspersoft Studio 5.6.0

[Link] the Jaspersoft download page:

• Go to the Jaspersoft Studio Download page.

• Look for Jaspersoft Studio 5.6.0 (you may need to check the archives if it’s not
on the main page).

• Download the Windows installer.

Step 2: Install Jaspersoft Studio

[Link] the downloaded installer:

• After downloading the .exe installer file, go to the folder where it was saved
(usually in Downloads).

56
[Link] I.T. III Shree Tours & Travels Management System

[Link] the installer:

• Double-click the .exe file to start the installation.

• Follow the on-screen instructions to complete the installation.

➢ You can choose the default installation directory, or select a custom

path.
➢ The installer will automatically check if Java is installed and might
prompt you to install a suitable version of JDK (Java Development Kit)
if it’s not already installed.

Step 3: Launch Jaspersoft Studio

[Link] Jaspersoft Studio:

• After installation, you should find Jaspersoft Studio in your Start Menu or on
your desktop.

[Link] up your environment:

• On first launch, Jaspersoft Studio may ask you to configure the workspace (the
directory where your reports and resources will be saved). You can set this or
accept the default location.

57
[Link] I.T. III Shree Tours & Travels Management System

[Link] using Jaspersoft Studio:

• Now you can start designing reports using Jaspersoft Studio.

Option 2: Install Jaspersoft Server 5.6.0 (for BI Server)’

Jaspersoft Server is a complete solution for creating and managing reports and
dashboards.

Step 1: Download Jaspersoft Server 5.6.0

[Link] the Jaspersoft download page:

• Go to the Jaspersoft Server Download page.

• Navigate to the archives section to find Jaspersoft Server 5.6.0.

• Download the Windows (Windows 32-bit/64-bit) installer or the .zip distribution

(if you prefer manual setup).

Step 2: Install Jaspersoft Server

[Link] the installer:

• If you downloaded the .exe installer, double-click it to start the installation.

58
[Link] I.T. III Shree Tours & Travels Management System

• Follow the on-screen instructions. Here are a few prompts:

➢ Choose the installation folder.

➢ Choose the JDK location (Java Development Kit) if it’s not auto-
detected.

➢ You’ll also need to choose a Jaspersoft Server port (default is 8080, but
you can change it if necessary).

[Link] the required services:

• The installer will install Apache Tomcat, PostgreSQL (or your selected
database), and other required services to run Jaspersoft Server.

• You may be prompted to configure a Database (e.g., PostgreSQL, MySQL) that

will store reports and data.

[Link] the Server:

• Once installation is complete, the server will start automatically.

• You can verify that the server is running by visiting

[Link] in a web browser.

59
[Link] I.T. III Shree Tours & Travels Management System

Step 3: Access Jaspersoft Server Web Interface

1. Access the web interface:

• Open a browser and go to [Link] (or your custom

port if you changed it during installation).

• Log in with the default credentials (usually admin for both username and
password).

2. Start creating reports and dashboards:

• After logging in, you can begin creating, managing, and viewing reports on
Jaspersoft Server.

Optional: Set up Jaspersoft Integration with Jaspersoft Studio

If you want to connect Jaspersoft Studio with Jaspersoft Server:

1. Open Jaspersoft Studio.

2. Go to the Repository Explorer.

3. Right-click and select Add Repository Connection.

60
[Link] I.T. III Shree Tours & Travels Management System

4. Provide the connection details for your Jaspersoft Server (e.g., server URL,
username, and password).

5. Click Test Connection to ensure that everything is set up properly

4: Verify Installation

[Link] Jaspersoft Studio:

• Open Jaspersoft Studio and create a new report to confirm the installation is
working.

[Link] Jaspersoft Server:

• Open a web browser and access Jaspersoft Server via

[Link] to verify it is up and running.

5.2 User Manual

➢ USER MANUAL

Firstly when user visit To a Software You will find following menus.

➢ Login

This Form perform Authorization Of System.

61
[Link] I.T. III Shree Tours & Travels Management System

➢ Home Form

In these form perform the all detail fetch to my system. After Login You will

find following menus.

➢ Home

▪ Customer

It Perform the Customer Details.

▪ Package

It Perform the Package Details.

➢ Detail

▪ Feedback

It Provide the Feedback Details.

➢ Booking

▪ Booking

It Provide the Booking Details.

▪ Bill Payment

It Provide the Bill Payment Details.

▪ Ticket Cancellation

It Provide the Ticket Cancellation Details.

62
[Link] I.T. III Shree Tours & Travels Management System

➢Report

▪ Customer Report

It Generated the all report of our Customer Report

▪ Package Report

It Generated the all report of our Supplier Report

▪ Booking Report

It Generated the all report of our Product Report

▪ Bill Payment Report

It Generated the all report of our Purchase Report

▪ Feedback Report

It Generated the all report of our Sales Order Report

It generated the all report of our System.

63
[Link] I.T. III Shree Tours & Travels Management System

5.2 Data Dictionary

Field Name Description

Cust_id To store customer id(PK)

Cust_name To store customer name
Cust_addr To store customer address
Cust_cont To store customer contact
P_id To store Package id(PK)
P_type To store Package name
P_place To store Package place
P_price To store Package price
T_id To store Ticket id(PK)
T_date To store Ticket date
Bill_no To store Bill Number
Bill_date To store Bill date
No_of_seats To store Number of seats
Grand_total To store Grand Total
Feedback To store Customer Feedback

64
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 6
SYSTEM
. CODE

65
[Link] I.T. III Shree Tours & Travels Management System

Login Form

import [Link];

public class login1 extends [Link] {

public login1() {

initComponents();

Login(Save Button)

private void bloginActionPerformed([Link] evt) {

String user=[Link]();

String pass=[Link]();

if([Link]("Admin")&&([Link]("1234")))

home m=new home();

[Link]();

[Link](false);

else

[Link](null,"Invalid User name and Password");

[Link]("");

[Link](true);

66
[Link] I.T. III Shree Tours & Travels Management System

Login(Exit Button)

home h = new home();

[Link]();

[Link]();

Home Form

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

public class home extends [Link] {

public home() {

initComponents();

setExtendedState([Link].MAXIMIZED_BOTH);

67
[Link] I.T. III Shree Tours & Travels Management System

private void jMenuItem1ActionPerformed([Link] evt) {

customer c=new customer();

[Link]();

private void jMenuItem4ActionPerformed([Link] evt) {

Feedback f=new Feedback();

[Link]();

private void jMenuItem2ActionPerformed([Link] evt) {

Package p = new Package();

[Link]();

private void jMenuItem5ActionPerformed([Link] evt) {

Booking b = new Booking();

[Link]();

private void jMenuItem12ActionPerformed([Link] evt) {

TicketCancellation t = new TicketCancellation();

[Link]();

68
[Link] I.T. III Shree Tours & Travels Management System

private void jMenuItem3ActionPerformed([Link] evt) {

BillPayment s = new BillPayment();

[Link]();

private void jMenuItem6ActionPerformed([Link] evt) {

try {

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String
reportpath="C:\\Users\\pawar\\OneDrive\\JaspersoftWorkspace\\MyReports\\custome
[Link]";

JasperReport jr=[Link](reportpath);

JasperPrint jp=[Link](jr,null,con);

[Link](jp);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

catch(JRException ex)

69
[Link] I.T. III Shree Tours & Travels Management System

[Link]([Link]()).log([Link],null,ex);

private void jMenuItem7ActionPerformed([Link] evt) {

try {

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String
reportpath="C:\\Users\\pawar\\OneDrive\\JaspersoftWorkspace\\MyReports\\package
.jrxml";

[Link]
jr=[Link](reportpath);

[Link]
jp=[Link](jr,null,con);

[Link](jp);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (JRException ex) {

[Link]([Link]()).log([Link], null, ex);

70
[Link] I.T. III Shree Tours & Travels Management System

private void jMenuItem13ActionPerformed([Link] evt) {

try {

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String
reportpath="C:\\Users\\pawar\\OneDrive\\JaspersoftWorkspace\\MyReports\\booking.
jrxml";

[Link]
jr=[Link](reportpath);

[Link]
jp=[Link](jr,null,con);

[Link](jp);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (JRException ex) {

[Link]([Link]()).log([Link], null, ex);

private void jMenuItem8ActionPerformed([Link] evt) {

71
[Link] I.T. III Shree Tours & Travels Management System

try {

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String
reportpath="C:\\Users\\pawar\\OneDrive\\JaspersoftWorkspace\\MyReports\\feedbac
[Link]";

[Link]
jr=[Link](reportpath);

[Link]
jp=[Link](jr,null,con);

[Link](jp);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (JRException ex) {

[Link]([Link]()).log([Link], null, ex);

private void jMenuItem14ActionPerformed([Link] evt) {

try {

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

72
[Link] I.T. III Shree Tours & Travels Management System

String
reportpath="C:\\Users\\pawar\\OneDrive\\JaspersoftWorkspace\\MyReports\\billpaym
[Link]";

[Link]
jr=[Link](reportpath);

[Link]
jp=[Link](jr,null,con);

[Link](jp);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (JRException ex) {

[Link]([Link]()).log([Link], null, ex);

private void jMenuItem9ActionPerformed([Link] evt) {

About_us a=new About_us();

[Link]();

private void jMenuItem11ActionPerformed([Link] evt) {

login1 h = new login1();

[Link]();

73
[Link] I.T. III Shree Tours & Travels Management System

[Link]();

private void jMenuItem10ActionPerformed([Link] evt) {

Created_by b =new Created_by();

[Link]();

Customer(Save, Number Validation)

public static boolean isvalidmobile(String mobile)

return [Link]("[7-9][0-9]{9}");

private void jButton1ActionPerformed([Link] evt) {

String Cust_id=[Link]();

String Cust_name=[Link]();

String Cust_addr=[Link]();

String Cust_Cont=[Link]();

if(!isvalidmobile(Cust_Cont))

[Link](null,"Invalid mobile number!must be 10

digits");

[Link]("");

[Link](true);

return;

74
[Link] I.T. III Shree Tours & Travels Management System

try

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String sql="insert into

customer(Cust_id,Cust_name,Cust_addr,Cust_Cont)values(?,?,?,?)";

PreparedStatement ps=[Link](sql);

[Link](1,Cust_id);

[Link](2,Cust_name);

[Link](3,Cust_addr);

[Link](4,Cust_Cont);

int rowsInserted=[Link]();

if(rowsInserted>0)

[Link](null,"Record inserted
successfully......");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

75
[Link] I.T. III Shree Tours & Travels Management System

} catch (SQLException ex) {

[Link](null,"Error in customer data Insertion");

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

displaytable();

Customer(Character Validation)

private void cnametextKeyReleased([Link] evt) {

String pat="^[a-zA-Z ]+$";

Pattern p=[Link](pat);

Matcher match=[Link]([Link]());

if(![Link]())

[Link](null,"Please enter character only

name......");

[Link]("");

[Link](true);

Customer(Print Button)

private void jButton6ActionPerformed([Link] evt) {

try {

76
[Link] I.T. III Shree Tours & Travels Management System

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String
reportpath="C:\\Users\\pawar\\OneDrive\\JaspersoftWorkspace\\MyReports\\custome
[Link]";

JasperReport jr=[Link](reportpath);

JasperPrint jp=[Link](jr,null,con);

[Link](jp);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (JRException ex) {

[Link]([Link]()).log([Link], null, ex);

Package(Update Button)

private void jButton2ActionPerformed([Link] evt) {

try

[Link]("[Link]");

77
[Link] I.T. III Shree Tours & Travels Management System

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String sql="update package set P_type=?,P_place=?,P_price=? where P_id=?";

PreparedStatement ps=[Link](sql);

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

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

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

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

[Link]();

[Link](null,"Record Updated successfully......");

displaytable();

[Link]("");

[Link]("");

[Link]("");

[Link]("");

catch (SQLException ex) {

[Link](null,"Error in Feedback data Insertion");

} catch (ClassNotFoundException ex){

[Link]([Link]()).log([Link],null,ex);

78
[Link] I.T. III Shree Tours & Travels Management System

Booking(Clear)

private void jButton4ActionPerformed([Link] evt) {

[Link]("");

[Link]("");

[Link](null);

[Link](null);

[Link]("");

[Link]("");

TicketCancellation(Exit)

private void jButton2ActionPerformed([Link] evt) {

home h = new home();

[Link]();

[Link]();

BillPayement(Id_autoincrement)

private void id_autoincrement()

try

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

79
[Link] I.T. III Shree Tours & Travels Management System

String sql="select Bill_no from bill_payment order by Bill_no DESC LIMIT 1"
;

PreparedStatement ps=[Link](sql);

ResultSet rs= [Link]();

if([Link]())

int n;

int id=[Link](1);

n=id+1;

[Link]([Link](n));

catch(Exception e)

Feedback(displaytable)

private void displaytable()

try

[Link]("[Link]");

80
[Link] I.T. III Shree Tours & Travels Management System

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String sql="select * from feedback";

PreparedStatement ps=[Link](sql);

ResultSet rs= [Link]();

[Link]([Link](rs));

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

Booking(Fill Combo)

private void fillcombo()

try

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String sql="select Cust_id from customer";

81
[Link] I.T. III Shree Tours & Travels Management System

PreparedStatement ps=[Link](sql);

ResultSet rs=[Link]();

while([Link]())

int Cust_id=[Link]("Cust_id");

[Link](Cust_id);

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

Booking(Combo Box)

private void cbt1MouseClicked([Link] evt) {

try

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

int Cust_id=(int)[Link]();

String sql="select Cust_id from customer where Cust_id=?";

PreparedStatement ps=[Link](sql);

82
[Link] I.T. III Shree Tours & Travels Management System

[Link](1,Cust_id);

ResultSet rs=[Link]();

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

Feedback(Delete Button)

private void jButton3ActionPerformed([Link] evt) {

try

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql://localhost:3306/ttms","root","");

String sql="delete from feedback where Cust_id=?";

PreparedStatement ps=[Link](sql);

[Link](1,[Link]((String) [Link]().toString()));

[Link]();

[Link](null,"Record deleted successfully......");

displaytable();

83
[Link] I.T. III Shree Tours & Travels Management System

[Link]("");

[Link]("");

id_autoincrement();

} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link], null, ex);

} catch (SQLException ex) {

[Link]([Link]()).log([Link], null, ex);

BillPayment(Mouse Click)

private void t1MouseClicked([Link] evt) {

int srow=[Link]();

int Bill_no=(int)[Link](srow,0);

int T_id=(int)[Link](srow,1);

int Cust_id=(int)[Link](srow,2);

int P_id=(int)[Link](srow,3);

int P_price=(int)[Link](srow,4);

int No_of_seats=(int)[Link](srow,5);

Date Bill_date=(Date)[Link](srow,6);

int Grand_total=(int)[Link](srow,7);

[Link]([Link](Bill_no));

[Link]([Link](T_id));

[Link]([Link](Cust_id));

[Link]([Link](P_id));

84
[Link] I.T. III Shree Tours & Travels Management System

[Link]([Link](P_price));

[Link]([Link](No_of_seats));

[Link](Bill_date);

[Link]([Link](Grand_total));

85
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 7
OUTPUT

86
[Link] I.T. III Shree Tours & Travels Management System

7.1 Input Screen and Reports

[Link] Report

[Link] Report

[Link] Booking Report

87
[Link] I.T. III Shree Tours & Travels Management System

[Link] Payment Report

[Link] Report

88
[Link] I.T. III Shree Tours & Travels Management System

Output Screen and Reports

[Link] Report

[Link] Report

89
[Link] I.T. III Shree Tours & Travels Management System

[Link] Booking Report

[Link] Payment Report

90
[Link] I.T. III Shree Tours & Travels Management System

[Link] Report

91
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 8
CONCLUSION
AND
SUGGESTIONS

92
[Link] I.T. III Shree Tours & Travels Management System

8.1 Limitations , Conclusion And suggestion

Limitations

This system contains many advantage. But this system is not free form limitation can
be ruled over by using modification and transforming file to other software. the main
limitation are listed below.

1) The system is only used by single user at a time.

2) No backup system.

3) Data entry is tedious mistake happen due restriction in validations

Conclusion

Finally, we can conclude that the system we had developed will eliminate the existing
system' drawbacks and limitations to maximum extent And provide the user with a
product of high quality, standards and excellence. Hence, it will be very profit able to
the and satisfaction will also be achieved because the delay and inconvenience caused
due to existing system will be eliminated.

During the project, there a importance for following all principles of System Analysis
and Design dawned on me. We want through all the stages of Software Development
Life Cycle. i.e. starting with Requirement Analysis till Final Implementation of the
Software.

Suggestion

1) In this system you have to give correct password for this system.

2) The user should enter the data correctly.

3) To use this system check system date.

4) Date format is YYYY/MM/DD, Set this format.

93
[Link] I.T. III Shree Tours & Travels Management System

8.2 Future Enhancement

• The Shree Tours and Travels Management System could reduce the manual
work and physical entities of the system.
• The system can be further enhanced by proposing an advance Management
system. The system can be further enhanced by proposing an advance
facilities.
• In future due to increase in records of database file, data redundancy occurs.

94
[Link] I.T. III Shree Tours & Travels Management System

CHAPTER : 9
BIBLIGORAPHY

95
[Link] I.T. III Shree Tours & Travels Management System

Book

1. Pressman, R. S. Software Engineering: A Practitioner's Approach

2. Whitten, J. L., & Bentley, L. D.-Systems Analysis and Design Methods

3. Elmasri, R., & Navathe, S. B. Fundamentals of Database Systems

4. Sommerville, I. - Software Engineering

ONLINE REFERENCES:

Java Programming-[Link]

MySQL Documentation -[Link]

Jasper Reports-[Link]

NetBeans IDE Guide -[Link]

96