Posts: 50
Threads: 30
Joined: Jul 2009
Reputation:
0
[attachment=15560]
Code: import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class add extends HttpServlet
{
String Error,str,str1,fno,end,s1,cap;
int end1,end2,cap1;
Connection con;
Statement st;
ResultSet rst;
public void init(ServletConfig config)throws ServletException
{
super.init(config);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:DSN","scott","tiger");
}
catch(Exception e)
{
Error="Exception in init:"+e;
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
PrintWriter out=res.getWriter();
res.setContentType("text/html");
fno=req.getParameter("flight_no");
end=req.getParameter("ending_seatno");
end1=Integer.parseInt(end);
end2=end1+1;
cap=req.getParameter("capacity");
out.println("<html><body>");
out.println("<script>");
out.println("function nam()");
out.println("{");
out.println("var a=document.forms[0].cat.value;");
out.println("if(a.length == 0)");
out.println("{");
out.println("alert(\"Null field\");");
out.println("document.forms[0].cat.focus();");
out.println("return;");
out.println("}");
out.println("else");
out.println("{");
out.println("for(i=0;i<a.length;i++)");
out.println("{");
out.println("var b=a.substring(i,i+1);");
out.println("if(!(b >='a' && b <= 'z' b >='A' && b <= 'Z'))");
out.println("{");
out.println("alert(\"Enter alphabets only\");");
out.println("document.forms[0].cat.focus();");
out.println("document.forms[0].cat.value=\"\";");
out.println("return;");
out.println("}");
out.println("}");
out.println("}");
out.println("document.forms[0].cat.value=a;");
out.println("}");
out.println("function total()");
out.println("{");
out.println("var a=document.forms[0].ticket.value;");
out.println("if(a.length == 0)");
out.println("{");
out.println("alert(\"Null field\");");
out.println("document.forms[0].ticket.focus();");
out.println("return;");
out.println("}");
out.println("else");
out.println("{");
out.println("for(i=0;i<a.length;i++)");
out.println("{");
out.println("var b=a.substring(i,i+1);");
out.println("if(!(b >=0 b <= 9))");
out.println("{");
out.println("alert(\"Enter the valid number only\");");
out.println("document.forms[0].ticket.focus();");
out.println("document.forms[0].ticket.value=\"\";");
out.println("return;");
out.println("}");
out.println("}");
out.println("}");
out.println("document.forms[0].ticket.value=a;");
out.println("}");
out.println("function check(){");
out.println("var p= document.forms[0].end.value");
out.println("if(p.length == 0)");
out.println("{");
out.println("alert(\"Null field\");");
out.println("document.forms[0].end.focus();");
out.println("document.forms[0].end.value=\"\";");
out.println("return;");
out.println("}");
out.println("else");
out.println("{");
out.println("var x=parseInt(document.forms[0].start.value);");
out.println("x.toString();");
out.println("var y=parseInt(document.forms[0].end.value);");
out.println("y.toString();");
out.println("if(y<=x)");
out.println("{");
out.println("alert(\"ending seat no is less than starting seat no verify!\");");
out.println("document.forms[0].end.focus();");
out.println("document.forms[0].end.value=\"\";");
out.println("}");
out.println("var a="+cap);
out.println("a.toString();");
out.println("var b=parseInt(document.forms[0].end.value);");
out.println("b.toString();");
out.println("if(b>a){");
out.println("alert(\"ending seat no is greater than total capacity\");");
out.println("document.forms[0].end.focus();");
out.println("document.forms[0].end.value=\"\";");
out.println("}");
out.println("else");
out.println("{");
out.println("for(i=0;i<p.length;i++)");
out.println("{");
out.println("var b=p.substring(i,i+1);");
out.println("if(!(b >=0 && b <=9))");
out.println("{");
out.println("alert(\"Enter numbers only\");");
out.println("document.forms[0].end.focus();");
out.println("document.forms[0].end.value=\"\";");
out.println("return;");
out.println("}");
out.println("}");
out.println("}");
out.println("}");
out.println("return;}");
out.println("</script>");
out.println("<h2><center><u>Add Flight Details </u></center></h2>");
try
{
st=con.createStatement();
out.println("<center><form method=post action=\"http://localhost:8080/servlet/insert2\">");
out.println("<table>");
out.println("<tr><td><label>Flight No:</label></td><td><input size=20 name=fno value="+fno+" readonly></td>");
out.println("<td><label>Category:</label></td><td><input size=20 name=cat></td></tr>");
out.println("<tr><td><label>Cost Of Tickets:</label></td><td><input size=20 name=ticket onfocus=\"nam()\"></td>");
out.println("<td><label>Start Seat No:</label></td><td><input size=20 name=start value="+end2+" readonly onfocus=\"total()\"></td></tr>");
out.println("<tr><td><label>Ending Seat No:</label></td><td><input size=20 name=end onblur=\"check()\"></td></tr></table>");
out.println("<input type=hidden name=cap value="+cap+">");
out.println("<input type=submit value=submit>");
out.println("</form></center>");
}
catch(Exception e1)
{
out.println("Exception in connection:"+e1);
}
out.println("</body></html>");
}
}
Posts: 56
Threads: 28
Joined: Jun 2009
Reputation:
0
Airline Reservation System
[attachment=18163]
AIRLINE RESERVATION SYSTEM (ARS)
Background
This project deals with the development of a Software Requirements Specification (SRS) document that specifies what an airline reservation system should and should not do. The SRS document is divided into five sections namely
1. System Objectives
This section lists all the goals and objectives of the system categorized based on the viewpoint of the airline company and the customer (passenger). These are higher-level goals which are somewhat broad in nature. They help in a top-down development of the SRS.
2. System Context
This section clearly depicts the environment and boundaries of the ARS and the entities with which it interacts. It helps us see how the system fits into the existing scheme of things. What the system will do by itself and what it expects other entities to do is clearly delineated.
3. Functional Requirements
This section is the bulk of the document and precisely states the functions of the system what it should do and what it should not. This section is split into subsections modeled after the real world activities like reserving tickets, rescheduling tickets etc. Freedom from ambiguity and navigability were kept in mind while documentation. A consistent terminology has been followed throughout and the terms are explained in the appendix. The subsections follow a logical sequence that reflects the real world. For example, a customer cannot reschedule a ticket unless he has bought one earlier and cannot buy one unless he has checked its availability.
4. Non-functional Requirements
These are quality requirements that stipulate the performance levels required of the system for various kinds of activities. Numerical lower and upper limits set conditions on the response times, access times etc of the system. Sometimes, tradeoffs are necessary among various non-functional requirements.
5. Future Requirements
These are the specifications which are not provided for now in the current version of ARS but which could be incorporated into future versions. Some of these need advanced technologies and interfaces with other systems. The ARS could be designed in future to enhance the existing capabilities or add entirely new ones.
The assumptions and limitations of the ARS have been interspersed in the SRS to present the same in their proper context.
1. System Objectives
1.1 The Airline Reservation System (ARS) is a software application to assist an airline with transactions related to making ticket reservations, which includes blocking, reserving, canceling and rescheduling tickets.
1.2 From the viewpoint of the airline -
1.2.1 Minimize repetitive work done by the system administrator and reservation clerks.
1.2.2 Maintain consistency among different access modes, e.g. by phone, by web, at the information desk and across different physical locations. The users should be basically taken through the same steps by the system as they go through in conventional desk-reservation systems.
1.2.3 Maintain customer information in case of emergency, e.g. flight cancellation due to inclement weather. The profile can also be used by the airline company to track user preferences and travel patterns to serve them better, plan routes, for better marketing and efficient scheduling of flights.
1.2.4 Maximize the revenue of the airline company by various means:
1.2.4.1 Increase awareness among frequent travelers about various special offers and discounts.
1.2.4.2 Minimize the number of vacant seats on a flight and maximize flight capacity utilization.
Posts: 53
Threads: 33
Joined: Jul 2009
Reputation:
0
Airline Reservations Systems contain airline schedules, fare tariffs, passenger reservations and ticket records.An airline s inventory contains all flights with their available seats. The inventory of an airline is generally divided into service classes (e.g. First, Business or Economy class) and up to 26 booking classes, for which different prices and booking conditions apply. Inventory data is imported and maintained through a Schedule Distribution System over standardized interfaces. One of the core functions of the inventory management is the inventory control. Inventory control steers how many seats are available in the different booking classes, by opening and closing individual booking classes for sale. In combination with the fares and booking conditions stored in the Fare Quote System the price for each sold seat is determined.
Users access an airline s inventory through an availability display. It contains all offered flights for a particular city-pair with their available seats in the different booking classes. This display contains flights, which are operated by the airline itself as well as code share flights which are operated in co-operation with another airline. The availability of seats of other airlines is updated through standard industry interfaces. Depending on the type of co-operation it supports access to the last seat (Last Seat Availability) in real-time. Reservations for individual passengers or groups are stored in a so-called Passenger Name Record (PNR). Among other data, the PNR contains personal information such as name, contact information or special services requests (SSRs) e.g. for a vegetarian meal, as well as the flights (segments) and issued tickets. Some reservation systems also allow to store customer data in profiles to avoid data re-entry each time a new reservation is made for a known passenger. In addition most systems have interfaces to CRM systems or Customer Loyalty applications (aka Frequent Traveler Systems). Before a flight departs the so-called Passenger Name List (PNL) is handed over to the Departure Control System that is used to check-in passengers and baggage. Reservation data such as the number of booked passengers and special service requests is also transferred to Flight Operations Systems, Crew Management and Catering Systems. Once a flight has departed the reservation system is updated with a list of the checked-in passengers (e.g. passengers who had a reservation but did not check in (No Shows) and passengers who checked in, but didn t have a reservation (Go Shows)). Finally data needed for revenue accounting and reporting is handed over to the administrative systems
Posts: 62
Threads: 23
Joined: Jul 2009
Reputation:
0
[attachment=6487]
AIRLINE RESERVATION SYSTEM
INTRODUCTION
PROBLEM STATEMENT
The web based airline reservation system project is an attempt to stimulate the basic concepts of airline reservation system. The system enables the customer to do the things such as search for airline flights for two travel cities on a specified date, choose a flight based on the details, reservation of flight and cancellation of reservation.
The system allows the airline passenger to search for flights that are available between the two travel cities, namely the Departure city and Arrival city for a particular departure and arrival dates. The system displays all the flight s details such as flight no, name, price and duration of journey etc.
After search the system display list of available flights and allows customer to choose a particular flight. Then the system checks for the availability of seats on the flight. If the seats are available then the system allows the passenger to book a seat. Otherwise it asks the user to choose another flight.
To book a flight the system asks the customer to enter his details such as name, address, city, state, credit card number and contact number. Then it checks the validity of card and book the flight and update the airline database and user database. The system also allows the customer to cancel his/her reservation, if any problem occurs.
System Requirements Specification
HARDWARE:
PROCESSOR : PENTUIUM IV 2.6 GHz
RAM : 512MB DD RAM
MONITOR : 15 COLOR
HARD DISK :250 GB
CDDRIVE : LG52X
KEYBOARD : STANDARD 102 KEYS
MOUSE :OPTICAL MOUSE
SOFTWARE:
FORNT END :JAVA,HTML,SERVLETS
BACKEND : ORACLE 10i
OPERATING SYSTEM : WINDOWS XP
IDENTIFICATION OF ACTORS
Actors are not part of system.
Actors represent anyone or anything that interacts with (input to receive output from) the system.
An actor is someone or something that:
Interacts with or uses the system.
Provides input tot and receives information from the system.
Is external to the system and has no control over the use cases.
Actors are discovered by examining:
Who directly uses the system?
Who is responsible for maintaining the system?
External hardware used by the system.
Other systems that need to interact with the system.
The need of the actor are used to develop use cases. This insures that the system will be what the user expected.
Posts: 54
Threads: 20
Joined: Jul 2009
Reputation:
0
Airline Reservation System
[attachment=17373]
SYSTEM DESIGN
In this phase initially I had designed E-R diagram of the processes , in order to identify various entities and relation ship set ,entity set ,attributers, page link attributes The Diagram of this process as under.
After this step We had tried design the data base for the new system and normalized it
The tables motivated in data dictionaries enclosed as annex II is an out come of this step
ALGORITHM
In this phase further I had designed algorithms for various technical sub problem a few than are enclosed here with.
RESERVATION
A PERSON COME TO RESERVED ATICKET.
CANCELLATION
A PASSENGER COME TO CANCEL THE TICKET
THEN THE SYSTEM OPEN THE DELET FORM
THEN CLICK SHOE COMMAND
IT DISPLAY ALL THE PASSENGER LIST
THEN SELECT THE PNR NUMBER AND CLICK DELET OPTION
THE SYSTEM SHOW RECORD IS DELETED.
WHEN PASSENGER COME TO RESERVED A TICKET THEN SYSTEM FIND OUT THE FLIGHT DETAILS.
SYSTEM CLICK FLIGHT DETAILS OPTION THEN THE FLIGHT DETAILS FORM OPEN
THOSE SYSTEM ARE FOLLOWED .
FLIGHT_DETALS:-
. IN FLIGHT DEAILS WE FIRST CREATE A FORM.
. THEN WE MAKE ALL TEXT BOX.
. WE CREATE COMMAN BOX..
. IN THIS FORM WE ARE USE VARIOUS COMMAND BOX THOSE ARE
PREVIOUS,FIRST,NEXT, ADD,NEW,UPDATE, DELETE, SAVE
. IN THIS FORM WE ADD NEW FLIGHT RECORD AND UPDATE IT THEN THE
VALU IS GO TO THE DATABASE.
.WHEN WE CLICK NEXT , LAST , PREVIOUS, FIRST COMMAND BUTTON
THEN IT SHOW VARIOUS THING SERIALLY.
THEN HE GIVES HIS FULL DETAILS
IN CUSTOMER FORM THOSE DETAILS WERE WRITTEN.
THEN COMPUTER CHEQUE THE DATE WHAT DATE THE PERSON RESER VED
DATE WISE IT CHEQUE THE FLIGHTS
IF THE FLIGHT IS FLING THAT DAY
THEN SYSTEM JUSTIFY THE SPECIFIC FLIGHT ID
IT CHEQUE ITS SEAT CLASS.
Posts: 55
Threads: 30
Joined: Jul 2009
Reputation:
0
[attachment=5426]
Introduction
The Airline Reservations System (ARS) was one of the earliest changes to improve efficiency. ARS eventually evolved into the Computer Reservations System (CRS). A Computer Reservation System is used for the reservations of a particular airline and interfaces with a Global Distribution System which supports travel agencies and other distribution channels in making reservations for most major airlines in a single system.
Airline Reservations Systems contain airline schedules, fare tariffs, passenger reservations and ticket records. An airline's direct distribution works within their own reservation system, as well as pushing out information to the GDS. A second type of direct distribution channel are consumers who use the internet or mobile applications to make their own reservations.
There are 5 modules in this project.
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. Reservation Agent Module.
Allows the airlines reservation agents to make and modify reservations on the LAN or over the internet. The reservation agents could be stationed at any airline office location.
3. Passenger Module.
This module enables online customers to make reservations, view their bookings, make special service requests and define their preferences over the web.
4.Payment.
Provides the airline with the ability to set up various travel agents and give them reservations capabilities over the Internet. The travel agents are able to display and offer discounted fares to passengers.
5.Cancellation.
The system should allow the user to cancel the existing booking. In this cancellation very helpful in all the travelers.
Posts: 52
Threads: 21
Joined: Oct 2009
Reputation:
0
[attachment=14688]
FEASIBILITY STUDY
Feasibility study is to check the viability of the project under consideration. Theoretically various
types of feasibilities are conducted, but we have conducted three type of feasibilities explained as
under.
ECONOMIC FEASIBILITY
With the manual system the operating cost of the system is about 60 Lacks P.A.. This cost
comprises salary of 25 people, stationary, building rent, electricity, water, telephone etc. But with
the new system this reoccurring cost comes out to be about 20 Lacks P.A. Hence the new system is
economically feasible.
TECHNICAL FEASIBILITY
The new system requires only 6 trained person to work with the system and in overall 10 people
per office are sufficient. So we will identify 6 best people from existing system and train them.
As our existing system is purely manual, so we need a one time investment of Rs 4 Laks for the
purchase of 7 computers, 5 Ticket printers, a laser printer, AC and networking etc. It requires 20
Lacks PA as a operating cost.
With the above details our system is technically feasible as after investing 24 Lacks in a year, the
company is still saving Rs 25 Lacks PA.
OPERATIONAL FEASIBILITY
The new solution is feasible in all sence but operationally it is not. The new system demands the
expulsion of at least 15 people from the company. It creates an environment of joblessness and fear
among the employees. It can lead to an indefinite strike in the company also. So the management
must take corrective actions prior in advance in order to start the further proceedings.
Posts: 51
Threads: 25
Joined: Jul 2009
Reputation:
0
AIRLINE RESERVATION SYSTEM PROJECT
PROBLEM DEFINITION
The aim of the system is to automate the system of airline ticket reservation. The manual system is very time consuming and lazy. This system is more prone to errors.
The Need of Airlines system:
The major attraction of the system lies in its advantages such as
-Faster System
-Accuracy
-Reliability
-Informative
-Reservations and cancellations from any where to any place
SYSTEM ANALYSIS
The block diagram of the system is given in the report . It contains the AIRLINE RESERVATION SYSTEM in the centre. The booking department is connected to it. It sends the customer request to the system, flight maintenance, bookaing and cancellation etc. The block called the reports is also there. It does the functions such as the PASSENGER LIST, CONFIRMED LIST, WAITING LIST, CANCELLATION LIST etc. The database stores all the data. The system requests and writes data from the database. The accessed data may include the information such as the Passenger list,Fleet info, concession, Flight information,Fare details etc. The stored data may include Ticket reservation, Cancellation,Request for inquiry etc.
Full details of the project is available here:
http://scribddoc/12809826/Airline-Reservation-SystemVb
Posts: 50
Threads: 24
Joined: Jul 2009
Reputation:
0
[attachment=6248]
PROBLEM DEFINITION
The definition of our problem lies in manual system and a fully automated system.
Manual system : The system is very time consuming and lazy. This system is more prone to
errors and sometimes the approach to various problems is unstructured.
Technical system : With the advent of latest technology if we do not update our system then
our business result in losses gradually with time. The technical systems contains the tools of latest
trend i.e. computers printers, fax, Internet etc. The systems with this technology are very fast,
accurate, user-friendly and reliable.
.
Need of Airlines system
A few factors that directs us to develop a new system are given below -:
1) Faster System
2) Accuracy
3) Reliability
4) Informative
5) Reservations and cancellations from any where to any place
Posts: 54
Threads: 21
Joined: Jun 2009
Reputation:
0
|
