A Project Report - New

Download as pdf or txt
Download as pdf or txt
You are on page 1of 72

A Project Report

On

“AIRLINE RESERVATION SYSTEM”


Submitted in partial Fulfillment of requirement for
The Award of the degree in

MASTER OF COMPUTER APPLICATION (MCA)


(2021 - 2022)

SUBMITTED BY
GUIDED BY

Kulsoom Zehra Ms.Jyoti Singh

Roll No :2000590140028
Ref. No. Date:

This is to certify that the minor project entitled " AIRLINE RESERVATION
SYSTEM " has been developed by Kulsoom Zehra in fulfillment for the award of the
degree "Master of Computer Application " for the session 2021- 2022.

Ms. Jyoti Maam

Project Guide

LBSIMDS

2
ACKNOWLEDGEMENT
I take this occasion to thank God, almighty for blessing me
with his grace and taking our endeavor to a successful
Culmination. I extend my sincere and heart felt thanks to my
esteemed guide, Ms. Jyoti Maam, for providing me with the
right guidance and advice at the crucial junctures and for
showing me the right way. I extend my sincere thanks to my
Respected Head of the division Ms. Jyoti Maam, for allowing
me to use the facilities available. I would like to thank the
other faculty members also at this occasion. Last but not the
least, I would like to thank my friends and family for the
support and encouragement they have given me during the
course of this work. THANKS TO ALL
Ms. Jyoti Maam
Project Guide
LBSIMDS

3
TITLE OF PROJECT

“AIRLINE RESERVATION SYSTEM”

4
ABSTRACT

The online reservation system is basically derived from the GDS (global distribution system) also known as
CRS (computer reservation system). The online reservation system has its database centrally located which is
accessed through an Application Programming Interface (API).With the invent of online reservation system
the traveller and the airline got the freedom to book a seat anywhere at anytime at their conveniance. The
traveller can book a ticket at a click of a mouse saving the time and money for the traveller. It has also
become a hassle free transaction for both the airline and the traveller. The online reservation system involves
three main actors the database , online operator and a database scheduler. The database scheduler updates
the database , the online operator accepts and confirms the booking and updates the data.

5
INTRODUCTION

SYSTEM ANALYSIS

HTML

JAVA SCRIPT

JVM

SERVLET

MYSQL

Project Module Description (with screenshot)

Home page

Admin Session
Member Session
Sample coding
Hardware requirement

6
INTRODUCTION

The online reservation system is basically derived from the GDS (global distribution system) also known as
CRS (computer reservation system). The online reservation system has its database centrally located which is
accessed through an Application Programming Interface (API).With the invent of online reservation system
the traveller and the airline got the freedom to book a seat anywhere at anytime at their conveniance. The
traveller can book a ticket at a click of a mouse saving the time and money for the traveller. It has also
become a hassle free transaction for both the airline and the traveller. The online reservation system involves
three main actors the database , online operator and a database scheduler. The database scheduler updates
the database , the online operator accepts and confirms the booking and updates the data.

EXISTING SYSTEM

The existing airline reservation system has many shortcomings associated with it. In the existing system airlines
used to set flight reservation levels higher than seating capacity to compensate for passenger cancellations
and no-shows accounting to
overbooking in the system. If a travelers had to make / cancel reservation he had to
visit either the airline or travel agent frequently to do so thus wasting time and money
for all. In the existing system due to non-availability of a central server the airline and
the agents suffered unwanted delays in bookings and payments. In the existing system
integration of different airlines on a single platform was not met. With the advent of
the online reservation system these flaws can be overcome.

PROPOSED SYSTEM

The new online reservation system maintains the database centrally giving the clients the information
required from anywhere in the world whenever required. This system requires the use of an API
(Application Programming Interface) through which it

7
extracts the data from a central database. The central database monitors all the data changes that are
made at the client side to it and updates it automatically.

Through online reservation system passenger is able to book & purchase the ticket from his
home/office conveniently it doesn’t require the passenger to go to the airline
or an agent to purchase a ticket thus saving time & money for the customer and an airline/agent. As
the information is stored centrally the passenger never loses his ticket as in the existing system.

PROCESS FLOW

Check Flight:

Book Flight:

8
9
Pay Ticket:

10
MODULE DESCRIPTION

Number of Modules
After careful analysis the system has been identified to have the following modules:

1. Administrator Module
2. Passenger Module
3. Check Flight Module
4. Book Ticket Module
5. Payment Module
6. Cancellation Module

1. Administrator Module

 Enables the airline administrator to perform all administrative


functions and manage inventory over LAN or the Internet.




 The administrator can define or modify routes, fares, schedules and assign or deny access rights for
qualified travel agents and other authorized users.

2.PassengerModule

 The passenger should register himself in order to proceed the book ticket service.



11
 They need to input all the required particular details during the registration process.

 The web service will perform validation checks on passenger input and length constraints.

 Upon successful login, the passenger will be registered officially to the web service and he can login
using his username and password.



 The guest is only permitted to check flight availability.

3.CheckFlightModule

 The passenger is permitted to search available flights based on the origin city, destination city,
departure date and return date.



 The web service will display any matching records based on the search criteria entered.



 The web service will notify the passenger about the flight availability.



 If the searched flights are available, then web service will display flights which are within a
week.Otherwise, the web service will prompt to ask the user to re-enter new searching criteria.


4. Book Ticket Module

 From the Check Flight, the passenger is required to log in and the web service will prompt the
passenger to confirm the flights.

12
 The web service will then ask the passenger whether to update his profile details or
not.Subsequently, the passenger will be asked to purchase and confirm the selected flights.

5. Payment Module

 After Book Ticket, the web service will generate payment ID upon successful transaction is made.



 Once it has been confirmed, the web service will generate booking id to the passenger and
require the passenger to view the payment receipt.

6.CancellationModule

 The passenger is required to be logged in before he has privilege to cancel his confirmed tickets.

 The passenger will select which ticket to be cancelled in the booking history. Once the confirmed
ticket has been selected then the web service will delete the data off from the database.

 The passenger is given cancellation ID upon successful transaction

13
System Analysis

 Introduction to System Analysis



 System

A system is an orderly group of interdependent components linked together


according to a plan to achieve a specific objective. Its main characteristics are
organization, interaction, interdependence, integration and a central objective.

 System Analysis


System analysis and design are the application of the system approach to problem
solving generally using computers. To reconstruct a system the analyst must consider
its elements output and inputs, processors, controls, feedback and environment.

 Analysis

Analysis is a detailed study of the various operations performed by a


system and their relationships within and outside of the system. One aspect
of analysis is defining the boundaries of the system and determining whether
or not a candidate system should consider other related systems. During
analysis data are collected on the available files decision points and
transactions handled by the present system. This involves gathering
information and using structured tools for analysis.

Existing System

In the existing system of book shop there is no system to register for book arrivals
and no support is avalible for the user category details

FEASIBILITY STUDY

14
Feasibility is the determination of whether or not a project is worth doing. The
process followed in making this determination is called feasibility Study. This type
of study if a project can and should be taken. In the conduct of the feasibility study,
the analyst will usually consider seven distinct, but inter-related types of feasibility.

Technical Feasibility

This is considered with specifying equipment and software that will successful
satisfy the user requirement the technical needs of the system may vary
considerably but might include

 
The facility to produce outputs in a given time.

 
Response time under certain conditions.

 
Ability to process a certain column of transaction at a particular speed.

Economic Feasibility

Economic analysis is the most frequently used technique for evaluating the
effectiveness of a proposed system. More commonly known as cost / benefit
analysis. The procedure is to determine the benefits and savings are expected form
a proposed system and a compare them with costs. It benefits outweigh costs; a
decision is taken to design and implement the system will have to be made if it is to
have a chance of being approved. There is an ongoing effort that improves in
accuracy at each phase of the system life cycle.

Operational Feasibility

It is mainly related to human organization and political aspects. These points are
considered are

15
 
 What changes will be brought with the system?

 
 What organizational structures are distributed?

 
 What new skills will be required?

 
 Do the existing system staff members have these skills?

 
If not, can they be trained in the course of time?

Html

HTML, an initialism of Hypertext Markup Language, is the predominant markup


language for web pages. It provides a means to describe the structure of text-based
information in a document — by denoting certain text as headings, paragraphs, lists,
and so on — and to supplement that text with interactive forms, embedded images, and
other objects. HTML is written in the form of labels (known as tags), surrounded by
angle brackets. HTML can also describe, to some degree, the appearance and semantics
of a document, and can include embedded scripting language code which can affect the
behavior of web browsers and other HTML processors.

HTML is also often used to refer to content of the MIME type text/html or even more
broadly as a generic term for HTML whether in its XML-descended form (such as
XHTML 1.0 and later) or its form descended directly from SGML

Hypertext Markup Language (HTML), the languages of the World Wide Web
(WWW), allows users to produces Web pages that include text, graphics and
pointer to other Web pages (Hyperlinks).

16
HTML is not a programming language but it is an application of ISO
Standard 8879, SGML (Standard Generalized Markup Language), but
specialized to hypertext and adapted to the Web. The idea behind
Hypertext is that instead of reading text in rigid linear structure, we
can easily jump from one point to another point. We can navigate
through the information based on our interest and preference. A
markup language is simply a series of elements, each delimited with
special characters that define how text or other items enclosed within
the elements should be displayed. Hyperlinks are underlined or
emphasized works that load to other documents or some portions of
the same document.

HTML can be used to display any type of document on the host computer,
which can be geographically at a different location. It is a versatile language
and can be used on any platform or desktop.

HTML provides tags (special codes) to make the document look attractive.
HTML tags are not case-sensitive. Using graphics, fonts, different sizes,
color, etc., can enhance the presentation of the document. Anything that is
not a tag is part of the document itself.

Basic HTML Tags:


<! -- --> specifies comments

<A>……….</A> Creates hypertext links

<B>……….</B> Formats text as bold

<BIG>……….</BIG> Formats text in large font. <BODY>…</BODY>


Contains all tags and text in the HTML document

<CENTER>...</CENTER> Creates text

<DD>…</DD> Definition of a term

<DL>...</DL> Creates definition list

<FONT>…</FONT> Formats text with a particular font

17
<FORM>...</FORM> Encloses a fill-out form

<FRAME>...</FRAME> Defines a particular frame in a set of frames

<H#>…</H#> Creates heading of different levels(1 – 6)

<HEAD>...</HEAD> Contains tags that specify information about a


document

<HR>...</HR> Creates a horizontal rule

<HTML>…</HTML> Contains all other HTML tags

<META>...</META> Provides meta-information about a document

<SCRIPT>…</SCRIPT> Contains client-side or server-side script

<TABLE>…</TABLE> Creates a table

<TD>…</TD> Indicates table data in a table

<TR>…</TR> Designates a table row

<TH>…</TH> Creates a heading in a table

Advantages

 A HTML document is small and hence easy to send over the net.

 It is small because it does not include formatted information.

 HTML is platform independent.

 HTML tags are not case-sensitive.

18
JavaScript

JavaScript is a script-based programming language that was developed by Netscape


Communication Corporation. JavaScript was originally called Live Script and
renamed as JavaScript to indicate its relationship with Java. JavaScript supports
the development of both client and server components of Web-based applications.
On the client side, it can be used to write programs that are executed by a Web
browser within the context of a Web page. On the server side, it can be used to write
Web server programs that can process information submitted by a Web browser and
then update the browser’s display accordingly

Even though JavaScript supports both client and server Web programming, we
prefer JavaScript at Client side programming since most of the browsers supports
it. JavaScript is almost as easy to learn as HTML, and JavaScript statements can be
included in HTML documents by enclosing the statements between a pair of
scripting tags

<Script> ………. </Script>

<Script Language = “JavaScript”>

JavaScript statements

</Script>

Here are a few things we can do with JavaScript

 Validate the contents of a form and make calculations.



 Add scrolling or changing messages to the Browser’s status line.

 Animate images or rotate images that change when we move the mouse over
them.

 Detect the browser in use and display different content for different browsers.

 Detect installed plug-ins and notify the user if a plug-in is required.

 We can do much more with JavaScript, including creating entire
application.

19
Java Technology

Initially the language was called as “oak” but it was renamed as “Java” in 1995. The
primary motivation of this language was the need for a platform-independent (i.e.,
architecture neutral) language that could be used to create software to be embedded
in various consumer electronic devices.

 Java is a programmer’s language.



 Java is cohesive and consistent.

 Except for those constraints imposed by the Internet environment, Java gives
the programmer, full control.


 Finally, Java is to Internet programming where C was to system programming.

IMPORTANCE OF JAVA TO THE INTERNET

Java has had a profound effect on the Internet. This is because; Java expands
the Universe of objects that can move about freely in Cyberspace. In a network,
two categories of objects are transmitted between the Server and the Personal
computer. They are: Passive information and Dynamic active programs. The
Dynamic, Self-executing programs cause serious problems in the areas of
Security and probability. But, Java addresses those concerns and by doing so,
has opened the door to an exciting new form of program called the Applet.

JAVA CAN BE USED TO CREATE TWO TYPES OF PROGRAMS

Applications and Applets: An application is a program that runs on our


Computer under the operating system of that computer. It is more or less
like one creating using C or C++. Java’s ability to create Applets makes it
important. An Applet is an application designed to be transmitted over the
Internet and executed by a Java –compatible web browser. An applet is
actually a tiny Java program, dynamically downloaded across the network,
just like an image. But the difference is, it is an intelligent program, not just
a media file. It can react to the user input and dynamically change.

20
FEATURES OF JAVA SECURITY

Every time you that you download a “normal” program you are risking a viral
infection. Prior to java, most users did not download executable programs
frequently, and those who did scan them for viruses prior to execution. Most
users still worried about the possibility of infecting their systems with a
virus. In addition, another type of malicious program exists that must be
guarded against. This type of program can gather private information, such
as credit card numbers, bank account balances, and passwords. Java
answers both these concerns by providing a “firewall” between a network
application and your computer.

When you use a java-compatible web browser, you can safely download java
applets without fear of virus infection or malicious intent.

PORTABILITY

For programs to be dynamically downloaded to all the various types of


platforms connected to the internet, some means of generating portable
executable code is needed .as you will see, the same mechanism that helps
ensure security also helps create portability. Indeed, java’s solution to these
two problems is both elegant and efficient.

THE BYTE CODE

The key that allows the Java to solve the security and portability problems is
that the output of Java compiler is Byte code. Byte code is a highly optimized
set of instructions designed to be executed by the Java run-time system,
which is called the Java Virtual Machine (JVM). That is, in its standard form,
the JVM is an interpreter for byte code.

21
Translating a Java program into byte code helps makes it much easier to run
a program in a wide variety of environments. The reason is, once the run-
time package exists for a given system, any Java program can run on it.

Although Java was designed for interpretation, there is technically nothing


about Java that prevents on-the-fly compilation of byte code into native code.
Sun has just completed its Just In Time (JIT) compiler for byte code. When
the JIT compiler is a part of JVM, it compiles byte code into executable code
in real time, on a piece – by –piece, demand basis. It is not possible to
compile an entire Java program into executable code all at once, because
Java performs various run-time checks that can be done only at run time.
The JIT compiles code, as it is needed, during execution.

Java Virtual Machine (JVM)

Beyond the language, there is the Java virtual machine. The Java virtual
machine is an important element of the Java technology. The virtual machine
can be embedded within a web browser or an operating system. Once a piece of
Java code is loaded onto a machine, it is verified. As part of the loading process,
a class loader is invoked and does byte code verification makes sure that the
code that’s has been generated by the compiler will not corrupt the machine
that it’s loaded on. Byte code verification takes place at the end of

22
the compilation process to make sure that is all accurate and correct. So
byte code verification is integral to the compiling and executing of Java code.

Overall Description

Java Source Java byte code Java VM

Java .Class

Picture showing the development process of JAVA Program

Java programming uses to produce byte codes and executes them. The first
box indicates that the Java source code is located in a. Java file that is
processed with a Java compiler called javac. The Java compiler produces a
file called a. class file, which contains the byte code. The .Class file is then
loaded across the network or loaded locally on your machine into the
execution environment is the Java virtual machine, which interprets and
executes the byte code.

23
Java Architecture

Java architecture provides a portable, robust, high performing environment


for development. Java provides portability by compiling the byte codes for
the Java Virtual Machine, which is then interpreted on each platform by the
run-time environment. Java is a dynamic system, able to load code when
needed from a machine in the same room or across the planet.

Compilation of code

When you compile the code, the Java compiler creates machine code (called byte
code) for a hypothetical machine called Java Virtual Machine (JVM). The JVM is
supposed to execute the byte code. The JVM is created for overcoming the issue
of portability. The code is written and compiled for one machine and interpreted
on all machines. This machine is called Java Virtual Machine.

24
Introduction to Servlets

Servlets provide a Java(TM)-based solution used to address the problems currently


associated with doing server-side programming, including inextensible scripting
solutions, platform-specific APIs, and incomplete interfaces.

Servlets are objects that conform to a specific interface that can be plugged into a
Java-based server. Servlets are to the server-side what applets are to the client-side
-- object byte codes that can be dynamically loaded off the net. They differ from
applets in that they are faceless objects (without graphics or a GUI component).
They serve as platform-independent, dynamically loadable, plug gable helper byte
code objects on the server side that can be used to dynamically extend server-side
functionality.

What is a Servlet?

Servlets are modules that extend request/response-oriented servers, such as


Java-enabled web servers. For example, a servlet might be responsible for taking
data in an HTML order-entry form and applying the business logic used to
update a company’s order database.

Servlets are to servers what applets are to browsers. Unlike applets, however,
Servlets have no graphical user interface. Servlets can be embedded in many
different servers because the servlet API, which you use to write Servlets, assumes

25
nothing about the server's environment or protocol. Servlets have become most
widely used within HTTP servers; many web servers support the Servlet API.

Servlet Lifecycle

Each servlet has the same life cycle


 A server loads and initializes the servlet

 The servlet handles zero or more client requests

 The server removes the servlet

Initializing a Servlet

When a server loads a servlet, the server runs the servlet's init method.
Initialization completes before client requests are handled and before the
servlet is destroyed.

Even though most Servlets are run in multi-threaded servers, Servlets


have no concurrency issues during servlet initialization. The server calls
the init method once, when the server loads the servlet, and will not call
the init method again unless the server is reloading the servlet. The server
cannot reload a servlet until after the server has destroyed the servlet by
calling the destroy method.

26
JAVA SERVER PAGES

Java Server Pages technology lets you put snippets of servlet code directly into a
text-based document. A JSP page is a text-based document that contains two
types of text: static template data, which can be expressed in any text-based
format such as HTML, WML, and XML, and JSP elements, which determine how
the page constructs dynamic content.

Java Server Page™ (JSP): An extensible Web technology that uses template data,
custom elements, scripting languages, and server-side Java objects to return
dynamic content to a client. Typically the template data is HTML or XML
elements, and in many cases the client is a Web browser.

According to JSP model1 we can develop the application as,

According to above model the presentation logic has to be implemented in JSP


page and the business logic has to be implemented as part of Java bean This
model help us in separating the presentation and business logic. For large-scale
projects instead of using model1 it is better to use model2 (MVC). Struts
framework is based on model 2.

Java Server Pages (JSP) lets you separate the dynamic part of your pages from the
static HTML. You simply write the regular HTML in the normal manner, using

27
whatever Web-page-building tools you normally use. You then enclose the code
for the dynamic parts in special tags, most of which start with "<%" and end with
"%>". For example, here is a section of a JSP page that results in something like
"Thanks for ordering Core Web Programming

For URL of

http://host/OrderConfirmation.jsp?title=Core+Web+Programming:

Thanks for ordering

<I><%= request.getParameter("title") %></I>

You normally give your file a .jsp extension, and typically install it in any place
you could place a normal Web page. Although what you write often looks more
like a regular HTML file than a servlet, behind the scenes, the JSP page just gets
converted to a normal servlet, with the static HTML simply being printed to the
output stream associated with the servlet's service method. This is normally done
the first time the page is requested, and developers can simply request the page
themselves when first installing it if they want to be sure that the first real user
doesn't get a momentary delay when the JSP page is translated to a servlet and
the servlet is compiled and loaded. Note also that many Web servers let you
define aliases that so that a URL that appears to reference an HTML file really
points to a servlet or JSP page.

Aside from the regular HTML, there are three main types of JSP constructs that
you embed in a page: scripting elements, directives, and actions. Scripting
elements let you specify Java code that will become part of the resultant servlet,
directives let you control the overall structure of the servlet, and actions let you
specify existing components that should be used, and otherwise control the
behavior of the JSP engine. To simplify the scripting elements, you have access to
a number of predefined variables such as request in the snippet above.

28
MySql

Introduction

MySql is a relational database management system, which organizes data in the


form of tables. MySQL is one of many databases servers based on RDBMS model,
which manages a seer of data that attends three specific things-data structures,
data integrity and data manipulation. With MySQL cooperative server technology we
can realize the benefits of open, relational systems for all the applications. MySQL
makes efficient use of all systems resources, on all hardware architecture; to deliver
unmatched performance, price performance and scaleability.Any DBMS to be called
as RDBMS has to satisfy Dr.E.F.Codd’s rules.

Distinct Features of MySql:

 MYSQL IS PORTABLE:


The MySQL RDBMS is available on wide range of platforms ranging
from PCs to super computers and as a multi user loadable module for
Novel NetWare, if you develop application on system you can run the
same application on other systems without any modifications.


 MYSQL IS COMPATIBLE:


MySQL commands can be used for communicating with IBM DB2
mainframe RDBMS that is different from MySQL , that is MySQL
compatible with DB2 .MySQL RDBMS is a high performance fault
tolerant DBMS , which is specially designed for online transaction
processing and for handling large database applications.




 MULTITHREADED SERVER ARCHITECTURE:

29
MySQL adaptable multithreaded server architecture delivers scalable
high performance for very large number of users on all hardware
architecture including symmetric multiprocessors (sumps) and loosely
coupled multiprocessors. Performance is achieved by eliminating CPU,
I/O, memory and operating system bottlenecks and by optimizing the
MySQL DBMS server code to eliminate all internal bottlenecks.

FEATURES OF MYSQL

Most popular RDBMS in the market because of its ease of use

 Client/server architecture.

 Data independence.

 Ensuring data integrity and data security.

 Managing data concurrency.

 Parallel processing support for speed up data entry and online
transaction processing used for applications.

 DB procedures, functions and packages.

30
Project Module Description

Home page

 Admin Login

 Passenger Login

 Offer

 Services

 Contact Us

Admin Session
 Login

 Domestic Flight

 International flight

 View User registration

 Add flight

 One way, Round Trip, Multi City

31
Member Session
 Registration

 Login

 Ticket Booking

 Ticket Cancellation

 Billing

32
Home Page:-

It is first page of website where some option available toward Air


ticket booking Admin login, Passenger login, offer, Services, contact
options are available.

33
ADMIN LOGIN:-

One of the most important part of this website because every


website have a admin phase that manage website as well as add
Flight and many more.

34
ADD FLIGHT:-

After successful login admin can add flight, category; Category Helps
to choose class of flight ie. Economy, Business and start point and
departure of flight

35
DOMESTIC FLIGHT:-

36
INTERNATIONAL

37
PASSENGER REGISTRATION
It is a first step toward booking of Air ticket first user register yourself
in website via filling some basic personal detail then login for booking
ticket

38
TICKET BOOKING AND CANCELLATION

39
DOMESTICS FLIGHT BOOKING

40
AVAILABLE FLIGHT

41
BOOKING YOUR DOMESTIC FLIGHT

42
MAKE PAYMENT
After completing process of ticket you have to make a payment.

43
BILLING

44
DATABASE TABLE

It is a screenshot of mysql database and here admin can see details


flights and many more

45
CODING SAMPLE

Admin login
<html>
<head>
<title>JSP</title>
</head>
<body>
<form>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
Connection con=null;
Statement st=null;
ResultSet rs=null;
String sql="select * from adminlog where username='"+username+"'
AND password='"+password+"'";
try
{
con=databasecon.getconnection();
st=con.createStatement();
rs=st.executeQuery(sql);
if(rs.next())
{
session.setAttribute("username",username);
%>
<jsp:forward
page="adminflightform.jsp"/> <%

}
out.println("Oop's! you are not Authenticated Person");
}
catch(SQLException e1)
{

System.out.println(e1);

finally
{
st.close();
con.close();
}
%>
</form>
</body>
</html>

46
Booking ticket

<%@ page import="java.sql.*,databaseconnection.*"%>

<!DOCTYPE html>
<html lang="en">
<head>
<title>About</title>
<meta charset="utf-8">
<link rel="stylesheet" href="css/reset.css" type="text/css" media="all">
<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style5.css" type="text/css" media="all">

<link rel="stylesheet" href="css/validationEngine.jquery.css"


type="text/css" media="screen" title="no title" charset="utf-8" />

<script type="text/javascript" src="js/jquery-1.5.2.js" ></script>


<script type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-replace.js"></script>
<script type="text/javascript" src="js/Cabin_400.font.js"></script>
<script type="text/javascript" src="js/tabs.js"></script>
<script type="text/javascript" src="js/jquery.jqtransform.js" ></script>
<script type="text/javascript" src="js/jquery.nivo.slider.pack.js"></script>
<script type="text/javascript" src="js/atooltip.jquery.js"></script> <script
type="text/javascript" src="js/script.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"
type="text/javascript"></script>
<script src="js/jquery.validationEngine-en.js"
type="text/javascript"></script>
<script
src='js/jquery.validationEngine.js'type="text/javascript"></script>
<!-- AJAX SUCCESS TEST FONCTION
<script>function callSuccessFunction(){alert("success
executed")}
function callFailFunction(){alert("fail executed")}
</script>
-->

<script>
$(document).ready(function() {
// SUCCESS AJAX CALL, replace "success: false," by: succes
: function() { callSuccessFunction() }, s

$("#formID").validationEngine()

//$.validationEngine.loadValidation("#date")
//alert($("#formID").validationEngine({returnIsValid:true}))
//$.validationEngine.buildPrompt("#date","This is an
example","error") // Exterior prompt build example
// input prompt close example
//$.validationEngine.closePrompt(".formError",true)
// CLOSE ALL OPEN PROMPTS
});

47
// JUST AN EXAMPLE OF VALIDATIN CUSTOM FUNCTIONS
: funcCall[validate2fields]
function validate2fields(){
if($("#firstname").val() =="" || $("#lastname").val() ==
""){ return true;
}else{
return false;
}
}
</script>

</head>
<body id="page1">
<div class="main">

<!--header -->
<header>
<div class="wrapper">
<h1><a href="index.html" id="logo">Air lines</a></h1>

<span id="slogan"><font color="#660000">AIRLINE


RESERVATION SYSTEM</font></span>
<nav id="top_nav">
<ul>

<li><a href="index.html" class="nav1"><font


color="#660000">Home</font></a></li>

<li><a href="#" class="nav2"><font color="#660000">Sitemap</font></a></li>

<li><a href="Contacts.html" class="nav3"><font


color="#660000">Contact</font></a></li>
</ul>
</nav>
</div>
<nav>
<ul id="menu">

<li id="menu_active"><a href="index.html"><span><span><font


color="#FF0000">ABOUT</font></span></span></a></li>

<li><a href="checkflight.jsp"><span><span><font color="#FF0000">CHECK


DOMESTIC FLIGHT</font></span></span></a></li>

<li><a href="checkinterflight.jsp"><span><span><font
color="#FF0000">CHECK INTERNATIONAL FLIGHT</font></span></span></a></li>
</ul>
</nav>
</header><div class="ic">More <a
href="http://www.templatemonster.com/">Website Templates</a> at
TemplateMonster.com!</div>
<!-- / header -->
<!--content -->

<div class="wrapper pad1">


<article class="col1">
<div class="box1">

<h2 class="top"><font color="#FF0000">Available Flights</font></h2>

48
<div class="pad">

<p><strong><font size="3">AirIndia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


&nbsp; &nbsp; <img src="images/6.jpg"></font></strong></p>

<p><font size="3"><strong>Indian
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b
sp; <img src="images/10.jpg"></strong></font></p>

<p><font size="3"><strong>Deccan &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="images/11.gif"></strong></font></p>

<p><font size="3"><strong>KingFisher
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;<img src="images/2.gif"></strong></font></p>

<p><font size="3"><strong>Spicejet
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img
src="images/3.gif"></strong></font></p>

<p><font
size="3"><strong>JetLite&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="images/4.jpg"></strong></font></p>

<p><font size="3"><strong>Indigo
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b
sp;&nbsp; <img src="images/5.jpg"></strong></font></p>

<p><font size="3"><strong>JetAirways
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img
src="images/8.jpg"></strong></font></p>
</div>
</div>
</article>
<article class="col2">
<br><br>

<h3 align="center"><font color="#660000">Book Your International Flights


For Multicity</font></h3>

<div class="content" style="border:5px solid


#66CCCC"> <div class="tab-content" id="OneWay">
<form id="formID" action="bookinterrmultiinsert.jsp"
method="post" onsubmit="return valid();">

<%
String id=request.getQueryString();
System.out.println(id);
Connection con=null;
Statement st=null;
ResultSet rs=null;

try
{
con=databasecon.getconnection();
49
st=con.createStatement();
String sql="select * from intermulti where
id='"+id+"'"; rs=st.executeQuery(sql);

while(rs.next())
{
%>

<div>
<div class="row"><br>
<br>
<span class="left" >&nbsp;&nbsp;&nbsp;&nbsp;Passenger
Name</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input value="" name="passname" id="passname"
class="validate[required]" type="text" style="border:1px solid #3399FF" />

&nbsp;&nbsp;FlightName</span>&nbsp;&nbsp;&nbsp;
<input name="name" id="name" value="<%=rs.getString(2)%>"
type="text" style="border:1px solid #3399FF" />
</div>
<div class="row"><br>
<br>
<span class="left"
>&nbsp;&nbsp;&nbsp;&nbsp;FlightId</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
n
bsp;&nbsp;
<input name="flightid" id="flightid"
value="<%=rs.getString(3)%>" type="text" style="border:1px solid #3399FF" />

&nbsp;&nbsp;Class</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;
<input name="class" id="class" value="<%=rs.getString(4)%>"
type="text" style="border:1px solid #3399FF" />
</div>

<div class="row"><br>
<br>
<span class="left" >&nbsp;&nbsp;&nbsp;&nbsp;Starting
From</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;
<input name="start" id="start" value="<%=rs.getString(5)%>"
type="text" style="border:1px solid #3399FF" />

&nbsp;&nbsp;To</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="arrival" id="arrival" value="<%=rs.getString(6)%>"
type="text" style="border:1px solid #3399FF" />
</div>

<div class="row"><br>
<br>
<span class="left" >&nbsp;&nbsp;&nbsp;&nbsp;Starting
From</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;
<input name="start1" id="start1"
value="<%=rs.getString(7)%>" type="text" style="border:1px solid #3399FF" />

50
&nbsp;&nbsp;To</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="arrival1" id="arrival1"
value="<%=rs.getString(8)%>" type="text" style="border:1px solid #3399FF" />
</div>

<div class="row"><br>
<p align="right">(Travellers upto 9per Booking)</p>

<span class="left" >&nbsp;&nbsp;&nbsp;&nbsp;Departure


Date</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="depar" id="depar" value="<%=rs.getString(9)%>"
type="text" style="border:1px solid #3399FF" />

&nbsp;&nbsp;DepartureDate</span>
<input name="date" id="date" value="<%=rs.getString(10)%>"
type="text" style="border:1px solid #3399FF" />
</div>

<div class="row"><br>
<br>
<span class="left"
>&nbsp;&nbsp;&nbsp;&nbsp;Adult(12+)</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<select name="adult" class="validate[required]"
id="adult" style="font-family:verdana; border:1px solid #3399FF";/>
<option value="">Select Adult</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value=">6">>6</option></select>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Children(2-
11)</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<select name="child" class="validate[required]" id="child"
style="font-family:verdana; border:1px solid #3399FF";/>
<option value="">Select Children</option>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option></select>
</div>
<div class="row"><br>
<br>
<span class="left" >&nbsp;&nbsp;&nbsp;&nbsp;Infants(0-
2)</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<select name="infant" class="validate[required]"
id="infant" style="font-family:verdana; border:1px solid #3399FF";/>
<option value="">Select Infant</option>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option></select>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TotalFare</span>&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="price" id="price" value="<%=rs.getString(11)%>"
type="text" style="border:1px solid #3399FF" />
</div>
51
<br>
<br>
<div class="wrapper"> <span class="right relative">
<input name="submit" type="submit" class="button1"
value="MakePayment"/>
<input name="reset2" type="reset" class="button1" value="Clear"
/>
</span> </div>
</div>

<%
}

}catch(SQLException e1) {
System.out.println("Database error"+e1.getMessage()); }

finally
{
st.close();
con.close();
}
%>

</form>

</div>
</article>
</div>

</article>
</div>
</section>
<!--content end-->

</div>
</div>
<script type="text/javascript"> Cufon.now();
</script> <script>
$(document).ready(function() {
tabs.init();
});
jQuery(document).ready(function($) {
$('#form_1, #form_2,
#form_3').jqTransform({imgPath:'jqtransformplugin/img/'}); });

$(window).load(function() {
$('#slider').nivoSlider({
effect:'fade', //Specify sets like: 'fold,fade,sliceDown,
sliceDownLeft, sliceUp, sliceUpLeft, sliceUpDown, sliceUpDownLeft'
slices:15,
animSpeed:500,
pauseTime:6000,
startSlide:0, //Set starting Slide (0
index) directionNav:false, //Next & Prev
directionNavHide:false, //Only show on
hover controlNav:false, //1,2,3...
controlNavThumbs:false, //Use thumbnails for Control Nav

52
controlNavThumbsFromRel:false, //Use image rel for thumbs
controlNavThumbsSearch: '.jpg', //Replace this with...
controlNavThumbsReplace: '_thumb.jpg', //...this in thumb Image src
keyboardNav:true, //Use left & right arrows
pauseOnHover:true, //Stop animation while hovering
manualAdvance:false, //Force manual
transitions captionOpacity:1, //Universal
caption opacity beforeChange: function(){},
afterChange: function(){},
slideshowEnd: function(){} //Triggers after all slides have been
shown
});
});
</script>
</body>
</html>

HOME PAGE

<!DOCTYPE html>
<html lang="en">
<head>
<title>About</title>
<meta charset="utf-8">
<link rel="stylesheet" href="css/reset.css" type="text/css" media="all">
<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style.css" type="text/css" media="all">
<script type="text/javascript" src="js/jquery-1.5.2.js" ></script> <script
type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-replace.js"></script>
<script type="text/javascript" src="js/Cabin_400.font.js"></script>
<script type="text/javascript" src="js/tabs.js"></script>
<script type="text/javascript" src="js/jquery.jqtransform.js" ></script>
<script type="text/javascript" src="js/jquery.nivo.slider.pack.js"></script>
<script type="text/javascript" src="js/atooltip.jquery.js"></script> <script
type="text/javascript" src="js/script.js"></script> <script
language="JavaScript">
function valid()
{
var a = document.form_1.username.value;
var b = document.form_1.password.value;
if(a=="")
{
alert("Enter Your Name");
document.form_1.username.focus();

53
return false;
}
if(b=="")
{
alert("Enter Your Password");
document.form_1.password.focus();
return false;
}
}
</script>
<script language="JavaScript">
function validation()
{
var a = document.form_2.email.value;
var b = document.form_2.password.value;
if(a=="")
{
alert("Enter Your emailID");
document.form_2.email.focus();
return false;
}
if (a.indexOf("@", 0) < 0)
{
alert("Please enter a valid e-mail
address."); document.form_2.email.focus();
return false;
}
if (a.indexOf(".", 0) < 0)
{
alert("Please enter a valid e-mail
address."); document.form_2.email.focus();
return false;
}
if(b=="")
{
alert("Enter Your Password");
document.form_2.password.focus();
return false;
}

}
</script>

</head>
<body id="page1">
<div class="main">

<!--header -->
<header>
<div class="wrapper">
<h1><a href="index.html" id="logo">Air lines</a></h1>

<span id="slogan"><font color="#660000">AIRLINE


RESERVATION SYSTEM</font></span>
<nav id="top_nav">
<ul>

<li><a href="index.html" class="nav1"><font


color="#660000">Home</font></a></li>

<li><a href="#" class="nav2"><font color="#660000">Sitemap</font></a></li>

54
<li><a href="Contacts.html" class="nav3"><font
color="#660000">Contact</font></a></li>
</ul>
</nav>
</div>
<nav>
<ul id="menu">

<li id="menu_active"><a href="index.html"><span><span><font


color="#FF0000">ABOUT</font></span></span></a></li>

<li><a href="Offers.html"><span><span><font
color="#FF0000">OFFERS</font></span></span></a></li>

<li><a href="Services.html"><span><span><font
color="#FF0000">SERVICES</font></span></span></a></li>

<li><a href="Safety.html"><span><span><font
color="#FF0000">SAFETY</font></span></span></a></li>

<li class="end"><a href="Contacts.html"><span><span><font


color="#FF0000">CONTACTS</font></span></span></a></li>
</ul>
</nav>
</header><div class="ic">More <a
href="http://www.templatemonster.com/">Website Templates</a> at
TemplateMonster.com!</div>
<!-- / header -->
<!--content -->
<section id="content">
<div class="for_banners">
<article class="col1">

<div class="tabs">
<ul class="nav">
<li class="selected"><a href="#Flight">Admin Login</a></li>
<li><a href="#Hotel">Passenger Login</a></li>
</ul>
<div class="content">
<div class="tab-content" id="Flight">
<form name="form_1" action="admin.jsp" method="post" onsubmit="return
valid();">
<div>
<div class="row"> <br>
<br>
<span class="left"
>&nbsp;&nbsp;&nbsp;&nbsp;Username</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" name="username" id="adminuser"
class="input" style="border:1px solid #2E2E2e">
</div>
<br>
<br>
<div class="row"> <span
class="left">&nbsp;&nbsp;&nbsp;&nbsp;Password</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="password" name="password"
id="adminpass" class="input" style="border:1px solid #2E2E2e">

55
</div>
<br>
<br>
<div class="wrapper"> <span class="right relative">
<input name="submit" type="submit" class="button1" value="Login"
/>
<input name="reset" type="reset" class="button1" value="Clear"
/> </span> </div>
</div>
</form>
</div>
<div class="tab-content" id="Hotel">
<form name="form_2" action="passengerlogin.jsp"
method="post" onsubmit="return validation();">
<div>
<div class="row"> <br>
<span class="left"
>&nbsp;&nbsp;&nbsp;&nbsp;Username</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" name="email" id="adminuser"
class="input" style="border:1px solid #2E2E2e">
</div>
<br>
<br>
<div class="row"> <span
class="left">&nbsp;&nbsp;&nbsp;&nbsp;Password</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="password" name="password"
id="adminpass" class="input" style="border:1px solid #2E2E2e">
</div>
<br>
<div class="wrapper">
<p><span class="right relative">
<input name="submit" type="submit" class="button1"
value="Login" />
<input name="reset" type="reset" class="button1" value="Clear"
/>
</span> </p>
<br>
<br>
<p align="center"><a href="register.jsp"
class="link1"><strong><font size="+5">New
User?Register Here</font></strong></a>
</p> </div>
</div>
</form>
</div>
</div>
</div>
</article>
<div id="slider">

</div>
</div>
<div class="wrapper pad1">
<article class="col1">
<div class="box1">

<h2 class="top"><font color="#FF0000">Available


Flights</font></h2> <div
class="pad">

56
<p><strong><font size="3">AirIndia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp; &nbsp; <img src="images/6.jpg"></font></strong></p>

<p><font size="3"><strong>Indian
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b
sp; <img src="images/10.jpg"></strong></font></p>

<p><font size="3"><strong>Deccan &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="images/11.gif"></strong></font></p>

<p><font size="3"><strong>KingFisher
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;<img src="images/2.gif"></strong></font></p>

<p><font size="3"><strong>Spicejet
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img
src="images/3.gif"></strong></font></p>

<p><font
size="3"><strong>JetLite&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="images/4.jpg"></strong></font></p>

<p><font size="3"><strong>Indigo
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b
sp;&nbsp; <img src="images/5.jpg"></strong></font></p>

<p><font size="3"><strong>JetAirways
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img
src="images/8.jpg"></strong></font></p>
</div>
</div>
</article>
<article class="col2">
<h3>About Our Airlines</h3>
<div class="wrapper">
<article class="cols">
<figure><img
src="images/page1_img1.jpg" alt="" class="pad_bot2"></figure>
<p class="pad_bot1"><strong>With
Online Flight booking, the process has become much easier.
Air ticket booking online offers
plentiful benefits over in-person or over phone bookings.</strong></p>
<br>
<p><strong>Commission and
numerous airlines now charge service fees for phone bookings,
making reservations online can
be comparatively cheaper.</strong></p>
</article>
<article class="cols pad_left1">
<figure><img
src="images/page1_img2.jpg" alt=""
class="pad_b
ot2"></figur
e> <p
class="pad_bot1"><strong>Airline reservation systems are used to track
and maintain records of flight
schedules, passenger reservations and seat
57
assignments, aircraft loading,
flight inventory, ticket purchases and fare

tariffs. The modern airline


reservation system also serves customer needs
from the beginning to the end of
each customer's reserved flight, therefore
laying out management tasks for
each flight.

</strong></p>

</article>
</div>
<a href="#" class="button1"><strong>Read
More</strong></a>
</article>
</div>
</section>
<!--content end-->
<!--footer -->

<!--footer end-->
</div>
</div>
<script type="text/javascript"> Cufon.now();
</script> <script>
$(document).ready(function() {
tabs.init();
});
jQuery(document).ready(function($) {
$('#form_1, #form_2,
#form_3').jqTransform({imgPath:'jqtransformplugin/img/'}); });

$(window).load(function() {
$('#slider').nivoSlider({
effect:'fade', //Specify sets like: 'fold,fade,sliceDown,
sliceDownLeft, sliceUp, sliceUpLeft, sliceUpDown, sliceUpDownLeft'
slices:15,
animSpeed:500,
pauseTime:6000,
startSlide:0, //Set starting Slide (0
index) directionNav:false, //Next & Prev
directionNavHide:false, //Only show on
hover controlNav:false, //1,2,3...
controlNavThumbs:false, //Use thumbnails for Control Nav
controlNavThumbsFromRel:false, //Use image rel for thumbs
controlNavThumbsSearch: '.jpg', //Replace this with...
controlNavThumbsReplace: '_thumb.jpg', //...this in thumb Image src
keyboardNav:true, //Use left & right arrows
pauseOnHover:true, //Stop animation while hovering
manualAdvance:false, //Force manual
transitions captionOpacity:1, //Universal
caption opacity beforeChange: function(){},
afterChange: function(){},
slideshowEnd: function(){} //Triggers after all slides have been
shown
});
});
</script>
</body>

58
</html>

MAKE PAYMENT

<!DOCTYPE html>
<%@ page import="java.sql.*,databaseconnection.*"%>

<html lang="en">
<head>
<title>Airline Reservation
System</title> <meta charset="utf-8">
<link rel="stylesheet" href="css/reset.css" type="text/css" media="all">
<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style2.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style8.css" type="text/css" media="all">
<link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css"
media="screen" title="no title" charset="utf-8" />

<script type="text/javascript" src="js/jquery-1.5.2.js" ></script>


<script type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-replace.js"></script>
<script type="text/javascript" src="js/Cabin_400.font.js"></script>
<script type="text/javascript" src="js/tabs.js"></script>
<script type="text/javascript" src="js/jquery.jqtransform.js" ></script>
<script type="text/javascript" src="js/jquery.nivo.slider.pack.js"></script>
<script type="text/javascript" src="js/atooltip.jquery.js"></script> <script
type="text/javascript" src="js/script.js"></script>

</head>
<body id="page1">
<div class="main">

<!--header -->
<header>
<div class="wrapper">
<h1><a href="index.html" id="logo">Air lines</a></h1>

59
<span id="slogan"><font color="#660000">AIRLINE
RESERVATION SYSTEM</font></span>
<nav id="top_nav">
<ul>

<li><a href="index.html" class="nav1"><font


color="#660000">Home</font></a></li>

<li><a href="#" class="nav2"><font color="#660000">Sitemap</font></a></li>

<li><a href="Contacts.html" class="nav3"><font


color="#660000">Contact</font></a></li>
</ul>
</nav>
</div>
<nav>
<ul id="menu">

<li id="menu_active"><a href="index.html"><span><span><font


color="#FF0000">ABOUT</font></span></span></a></li>

<li><a href="checkflight.jsp"><span><span><font
color="#FF0000">CHECK DOMESTIC FLIGHT</font></span></span></a></li>

<li><a href="checkinterflight.jsp"><span><span><font
color="#FF0000">CHECK INTERNATIONAL FLIGHT</font></span></span></a></li>

</ul>
</nav>
</header><div class="ic">More <a
href="http://www.templatemonster.com/">Website Templates</a> at
TemplateMonster.com!</div>
<!-- / header -->
<!--content -->

<section id="content">

<div class="for_banners">
<article class="col1">
<img src="images/img11.jpg">

<div class="tabs" >


<div class="tab-content" id="OneWay">
<table>
<td width="600" height="35" bgcolor="#66CCFF"><font
color="#666600" size="7"><strong>Make
Your Payment</strong></font></td>
</table>
<br>
<table width="600" height="" style="border:1px solid #660000;"
bgcolor="#FFCC99">
<td width="600" height="30" bgcolor="#66CCFF"><font
color="#660000" size="7"><strong>Your
Total Billing Amount</strong> </font>
<td> <br> <br>
<tr>
<td width="600" height="40"><font size="7">Your Total Invoice
Amount :<%=session.getAttribute("price")%></font>
<%
String id=request.getQueryString();

60
System.out.println(id);
Connection con=null;
Statement st=null;

ResultSet rs=null;

try
{
con=databasecon.getconnection();
st=con.createStatement();
String sql="select price from oneway1 where
id='"+id+"'"; rs=st.executeQuery(sql);

while(rs.next())
{
%>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td>
</tr>
<%
}

}catch(SQLException e1) {
System.out.println("Database error"+e1.getMessage()); }

finally
{
st.close();
con.close();
}
%>
</table>
<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b sp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b sp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
b sp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="onewaypay.jsp"><img src="images/pay1.jpg"></a>
</div> </div>
</div>
</article>

</div>

</section>
<!--content end-->

</div>
</div>

61
</body>
</html>

62
Register

<!DOCTYPE html>
<html lang="en">
<head>
<title>Airline Reservation
System</title> <meta charset="utf-8">
<link rel="stylesheet" href="css/reset.css" type="text/css" media="all">
<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style2.css" type="text/css" media="all">
<link rel="stylesheet" href="css/template.css" type="text/css" media="all">

<link rel="stylesheet" href="css/validationEngine.jquery.css"


type="text/css" media="screen" title="no title" charset="utf-8" />

<script type="text/javascript" src="js/jquery-1.5.2.js" ></script>


<script type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-replace.js"></script>
<script type="text/javascript" src="js/Cabin_400.font.js"></script>
<script type="text/javascript" src="js/tabs.js"></script>
<script type="text/javascript" src="js/jquery.jqtransform.js" ></script>
<script type="text/javascript" src="js/jquery.nivo.slider.pack.js"></script>
<script type="text/javascript" src="js/atooltip.jquery.js"></script> <script
type="text/javascript" src="js/script.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"
type="text/javascript"></script>
<script src="js/jquery.validationEngine-en.js"
type="text/javascript"></script>
<script
src='js/jquery.validationEngine.js'type="text/javascript"></script>
<!-- AJAX SUCCESS TEST FONCTION
<script>function callSuccessFunction(){alert("success
executed")}
function callFailFunction(){alert("fail executed")}
</script>
-->

<script>
$(document).ready(function() {
// SUCCESS AJAX CALL, replace "success: false," by: succes
: function() { callSuccessFunction() }, s

$("#formID").validationEngine()

//$.validationEngine.loadValidation("#date")
//alert($("#formID").validationEngine({returnIsValid:true}))
//$.validationEngine.buildPrompt("#date","This is an
example","error" // Exterior prompt build example
) // input prompt close example

63
//$.validationEngine.closePrompt(".formError",true)
// CLOSE ALL OPEN PROMPTS
});

// JUST AN EXAMPLE OF VALIDATIN CUSTOM FUNCTIONS


: funcCall[validate2fields]
function validate2fields(){
if($("#firstname").val() =="" || $("#lastname").val() ==
""){ return true;
}else{
return false;
}
}
</script>
<style type="text/css">
#font
{
font-family:verdana;
font-size:12px;
font-color:green;
padding:3px 3px 3px 3px;
}
</style>
</head>

<body id="page6">
<div class="main">
<!--header -->
<header>
<div class="wrapper">
<h1><a href="index.html" id="logo">Air lines</a></h1>

<span id="slogan"><font color="#660000">AIRLINE


RESERVATION SYSTEM</font></span>
<nav id="top_nav">
<ul>

<li><a href="index.html" class="nav1"><font


color="#660000">Home</font></a></li>

<li><a href="#" class="nav2"><font color="#660000">Sitemap</font></a></li>

<li><a href="Contacts.html" class="nav3"><font


color="#660000">Contact</font></a></li>
</ul>
</nav>
</div>
<nav>
<ul id="menu">

<li id="menu_active"><a href="index.html"><span><span><font


color="#FF0000">ABOUT</font></span></span></a></li>

<li><a href="Offers.html"><span><span><font
color="#FF0000">OFFERS</font></span></span></a></li>

<li><a href="Services.html"><span><span><font
color="#FF0000">SERVICES</font></span></span></a></li>

64
<li><a href="Safety.html"><span><span><font
color="#FF0000">SAFETY</font></span></span></a></li>

<li class="end"><a href="Contacts.html"><span><span><font


color="#FF0000">CONTACTS</font></span></span></a></li>
</ul>
</nav>
</header><div class="ic">More <a
href="http://www.templatemonster.com/">Website Templates</a> at
TemplateMonster.com!</div>

<!-- / header -->


<!--content -->

<section id="content">

<div class="wrapper pad1">

<div>
<p><font color="#660000" size="7"><strong><font
color="#FF0000">REGISTRATION</font></strong></font></p>
<p><font color="#660000">Please note that the Registration Form must
be completed
accurately in accordance with your passport details.</font></p>
<form id="formID" class="formular" method="post"
action="registerinsert.jsp">
<fieldset>
<legend>THE PERSONAL DATA</legend>

<label>
<span>First Name (optional)</span>
<input value=""
class="validate[optional,custom[onlyLetter],length[0,100]] text-input"
type="text" name="firstname" id="firstname" style="border:1px solid #3399FF"
/> </label><br>
<label>
<span>Last Name : </span>
<input value=""
class="validate[required,custom[onlyLetter],length[0,100],funcCall[validate2field s]]
text-input" type="text" id="lastname" name="lastname" style="border:1px solid
#3399FF" />
</label><br>
<div>
<span>Gender</span>
<select name="gender" class="validate[required]"
id="gender" style="font-family:verdana; border:1px solid #3399FF";/>
<option value="">Choose a Gender</option>
<option value="Male">Male</option>
<option value="Female">Female</option>

</select>

</div><br>

<label>
<span>Date OF Birth(format YYYY-MM-
DD)</span> <input value="1988-12-10"
class="validate[required,custom[date]] text-input" type="text" name="date"
id="date" style="font-family:verdana; border:1px solid #3399FF"/>

65
</label>
<br>
<label>
<span>Country</span>
<select name="country" class="validate[required]"
id="country" style="font-family:verdana; border:1px solid #3399FF";/>
<option value="">Choose a Country</option>
<option value="America">America</option>
<option value="Australia">Australia</option>
<option value="Belgium">Belgium</option>
<option value="China">China</option>
<option value="India">India</option>
<option value="Germany">Germany</option>
<option value="Japan">Japan</option>
<option value="Korea">Korea</option>
<option value="Myanmar">Myanmar</option>
<option value="Newzland">Newzland</option>
<option value="Russia">Russia</option>
<option value="Others">Others</option>
</select>
</label>
<br>

<label>
<span>Telephone</span>
<input value="" style="border:1px solid #3399FF"
class="validate[required,custom[telephone]] text-input"
type="text" name="telephone" id="telephone" />
</label><br>
<label>
<span>Address </span>

<textarea value="" style="border:1px solid #3399FF"


class="validate[required,length[6,300]] text-input" name="address"
id="address" /> </textarea>
</label>
</fieldset>

<fieldset>
<legend>THE LOGIN DATA</legend>
<label>
<span>Create EmailID </span>
<input value="" style="border:1px solid #3399FF"
class="validate[required,custom[email]] text-input" type="text"
name="email" id="email" />
</label>
<label>
<span>Password : </span>
<input value="" style="border:1px solid #3399FF"
class="validate[required,length[6,11]] text-input"
type="password" name="password" id="password" />
</label>
<label>
<span>Confirm password : </span>
<input value="" style="border:1px solid #3399FF"
class="validate[required,confirm[password]] text-input"
type="password" name="password2" id="password2" />
</label>
</fieldset>
<fieldset>
<legend>PASSPORT DATA</legend>
66
<label>
<span>Citzenship</span>
<input value="" style="border:1px solid #3399FF"
class="validate[required] text-input" type="text"
name="citzenship" id="citzenship" />
</label><br>
<label>
<span>No Of The Document </span>
<input value="" style="border:1px solid #3399FF"
class="validate[required] text-input" type="text" id="document"
name="document" />
</label><br>
<label>
<span>Validity Period </span>
<input value="" style="border:1px solid #3399FF"
class="validate[required] text-input" type="text" id="validity"
name="validity" />
</label><br>

</fieldset>
<fieldset>
<legend>CONDITIONS</legend>
<div class="infos">Checking this box indicates that you
accept terms of use. If you do not accept these terms, do not use this website
: </div>
<label>
<span class="checkbox">I accept terms of use :
</span>
<input class="validate[required] checkbox"
style="border:1px solid #3399FF" type="checkbox" id="agree" name="agree"/>
</label>

</fieldset>
<input class="button1" type="submit" value="Registration!" style="font-
family:verdana;font-size:12px;color:red;border:1px solid green;"/>
<hr/>
</form>

</div>

</div>
</section>
<!--content end-->
<!--footer -->

</div>
</div>
<script type="text/javascript"> Cufon.now(); </script>
</body>
</html>

67
5.1 Hardware Requirement

 Processor : Pentium
 Keyboard : 104 Keys
 Floppy Drive : 1.44 MB MHz
 RAM : 128 MB
 Hard Disk : 10GB
 Monitor : 14” VGA COLOR
 Mouse : Logitech Serial Mouse
 Disk Space : 1 GB

5.2 Software Requirements

 Operating System : Win 2000/ XP


 Technologies used : Java, Servlets, JSP,
 JDK : Version 1.4
 Database : My SQL 5.0

68

You might also like