A Project Report - New
A Project Report - New
A Project Report - New
On
SUBMITTED BY
GUIDED BY
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.
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
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
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
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
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
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 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.
17
<FORM>...</FORM> Encloses a fill-out form
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
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
JavaScript statements
</Script>
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 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.
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
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.
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 .Class
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
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 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 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
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.
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.
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:
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 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
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:-
33
ADMIN LOGIN:-
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
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
<!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">
<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>
<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 -->
48
<div class="pad">
<p><font size="3"><strong>Indian
&n
b
sp; <img src="images/10.jpg"></strong></font></p>
<p><font size="3"><strong>KingFisher
<img src="images/2.gif"></strong></font></p>
<p><font size="3"><strong>Spicejet
<img
src="images/3.gif"></strong></font></p>
<p><font
size="3"><strong>JetLite &nb
sp; <img src="images/4.jpg"></strong></font></p>
<p><font size="3"><strong>Indigo
&n
b
sp; <img src="images/5.jpg"></strong></font></p>
<p><font size="3"><strong>JetAirways
<img
src="images/8.jpg"></strong></font></p>
</div>
</div>
</article>
<article class="col2">
<br><br>
<%
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" > Passenger
Name</span>
<input value="" name="passname" id="passname"
class="validate[required]" type="text" style="border:1px solid #3399FF" />
FlightName</span>
<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"
> FlightId</span>  
; &
n
bsp;
<input name="flightid" id="flightid"
value="<%=rs.getString(3)%>" type="text" style="border:1px solid #3399FF" />
Class</span> &nb
sp;
<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" > Starting
From</span> &nbs
p;
<input name="start" id="start" value="<%=rs.getString(5)%>"
type="text" style="border:1px solid #3399FF" />
To</span>
<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" > Starting
From</span> &nbs
p;
<input name="start1" id="start1"
value="<%=rs.getString(7)%>" type="text" style="border:1px solid #3399FF" />
50
To</span>
<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>
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"
> Adult(12+)</span> &nb
sp;
<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>
Children(2-
11)</span>
<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" > Infants(0-
2)</span>
<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>
TotalFare</span>  
;
<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>
54
<li><a href="Contacts.html" class="nav3"><font
color="#660000">Contact</font></a></li>
</ul>
</nav>
</div>
<nav>
<ul id="menu">
<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>
<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"
> Username</span>  
;
<input type="text" name="username" id="adminuser"
class="input" style="border:1px solid #2E2E2e">
</div>
<br>
<br>
<div class="row"> <span
class="left"> Password</span>  
;
<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"
> Username</span>  
;
<input type="text" name="email" id="adminuser"
class="input" style="border:1px solid #2E2E2e">
</div>
<br>
<br>
<div class="row"> <span
class="left"> Password</span>  
;
<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">
56
<p><strong><font size="3">AirIndia
<img src="images/6.jpg"></font></strong></p>
<p><font size="3"><strong>Indian
&n
b
sp; <img src="images/10.jpg"></strong></font></p>
<p><font size="3"><strong>KingFisher
<img src="images/2.gif"></strong></font></p>
<p><font size="3"><strong>Spicejet
<img
src="images/3.gif"></strong></font></p>
<p><font
size="3"><strong>JetLite &nb
sp; <img src="images/4.jpg"></strong></font></p>
<p><font size="3"><strong>Indigo
&n
b
sp; <img src="images/5.jpg"></strong></font></p>
<p><font size="3"><strong>JetAirways
<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
</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" />
</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="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">
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())
{
%>
 
;
 
; </td>
</tr>
<%
}
}catch(SQLException e1) {
System.out.println("Database error"+e1.getMessage()); }
finally
{
st.close();
con.close();
}
%>
</table>
<br>
<br>
&n
b sp;
&n
b sp;
&n
b sp;
<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">
<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
});
<body id="page6">
<div class="main">
<!--header -->
<header>
<div class="wrapper">
<h1><a href="index.html" id="logo">Air lines</a></h1>
<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>
<section id="content">
<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>
<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
68