Project Report On Hotel Reservation
Project Report On Hotel Reservation
Project Report On Hotel Reservation
PROJECT REPORT
ON
“ONLINE HOTEL MANAGEMENT SYSTEM”
SUBMITTED IN THE PARTIAL FULFILLMENT OF THE REQUIREMENTS
OF
Session (2018-2021)
Primarily, I would like to thank my faculty members for giving me the opportunity to
fulfill my aspiration. With deep sense and regards, I am obliged to Mr. ASHISH
some way, in my motivation and gratefulness for being part of the responsible project
guide of the institute. I am very thankful to him for his valuable guidance and
I wish to thank my parents for their constant encouragement which is like snow, so
after when it falls and longer when it falls and longer when it dwells upon, the deeper
it sinks in mind.
I will be failing in my mission if I do not thank other people who directly or indirectly
So, my heart full thanks to all friends mainly who supported and encouraged me in
NITIN BALODI
ROLL NO. 180920106047
ABSTRACT
The purpose of the project entitled as “ONLINE HOTEL MANAGEMENT SYSTEM” is to
computerize the Front Office Management of Hospital to develop software which is user
friendly simple, fast, and cost – effective. It deals with the collection of patient’s information,
diagnosis details, etc. Traditionally, it was done manually. The main function of the system is
register and store patient details and doctor details and retrieves these details as and when
required, and also to manipulate these details meaningfully System input contains patient
details, diagnosis details, while system output is to get these details on to the screen. The
Hospital Management System can be entered using a username and password. It is accessible
either by an administrator or receptionist. Only they can add data into the database. The data
can be retrieved easily. The data are well protected for personal use and makes the data
OBJECTIVE
Manipulation and updation of data is easy through execution of simple
queries.
Less error.
User friendly interface.
More tasks done in a mouse click.
Final records are updated automatically.
To provide “better and efficient” services to members.
Reduce the workload of employee.
Faster retrieval of information of desired book.
Provide facility for proper monitoring, reduce paper work and provide
data security.
All details should be available on click.
CERTIFICATE
This is to be certify that this Project Report entitled “ONLINE HOTEL
in the partial fulfillment, for the award of degree of Bachelor of Computer Application in
The matter embodied in this Project Work has not been submitted earlier for award of
any degree or diploma in any university/institution to the best of our knowledge and
belief.
ASHISH AGARWAL
Date: __/__/____
TABLE OF CONTENTS
1. Introduction/Objectives………………………………………….......8-9
2. System Analysis
3. System Design
3.1 Modularisation………………………………………………..…33-36
3.4 Test Cases (Unit Test Cases and System Test Cases)…….……..44-45
4. Coding……………………………………………………………….46-48
5. Testing
5.2 Test Reports (Unit Test Cases and System Test Cases)…………58-59
7. Reports………………………………………………………………82-83
9. Bibliography…………………………………………………………….85
Introduction
R&B HOTEL MANAGEMENT SYSTEM is developed following system development
stages for smooth running and management of the hotel. The system was carefully designed
to ensure maximum efficiency of the system at the hotel. The system canskilfully and
The system will indeed help the hotel management and the esteemed staff members to
manage and steer the hotel’s functionality and transactions to realize its maximum potential
The objective of R&B Online hotel management system project is to provide online room
Due to huge losses suffered by the hotel due to the existing manual system, the hotel
management opted for a computerized system, which would provide the following facilities:
7. Enable fast and easy retrieval of guest records and data for fast reference activities.
SYSTEM ANALYSIS
Identification of Need:
The current manual system uses paperwork and direct human language communication by
mouth to manage the hotel. This delays information transmission in the hotel.
Booking is done through phone calls or through visit to the hotel booking office. The guest’s
personal details such as Name, Age, Nationality, and Duration of stay, are input during
booking in. The booking office orders for preparation of the guest’s room before his/ her
check in date.
The documents are transferred manually to the filling department for compilation of the
guest’s file. On the reporting date the file is transferred to the reception. On checking in the
guest is given the key to his allocated room, he also specify if he needs room service.
The receptionist hands over the guest’s file to the accountant on the next table. Here the guest
pays accommodation and meals fee. The guest’s file is updated on daily basis of his
expenditure costs. The accounts department generates the bills on daily basis and delivered to
the guests in their rooms at desk by the service maids. The guest pays at the accounts desk,
During checking out of guests, their expenditure outlines are generated a day before check
out date. The guests receive their outlines at the accounts desk as they check out, where they
1. Difficulty in location of guest files: due to the large number of guests’ files, location of guest
files during checking in, updating of daily expenditures, receipt generation and checking out is
2. Large storage space: the physical files occupy too much space of about two rooms full of
storage cabinets. This occupies the hotel’s space that could have otherwise been used for income
3. Human and computational errors: many errors enabled by the system due to tedious
computations required during data processing cost the hotel management heavily. Modification
4. Poorly generated records: poorly generated records encourage omission of some important
data by the employees. Such data as the guests’ luggage is omitted. This leads to security
5. Complains from guests: due to poor management of documents encouraged by the manual
system, several cases were reported where guests complained of overcharging, charging of
6. Poor communication: due to poor communication between the departments, guests are often
7. Difficulty in data analysis: The accountants usually found it difficult to analyse the guests’ data
1. The system enables easy and fast access to the guest files.
3. The system enable online booking of guests into the hotel hence international guests can
4. The system provides performance evaluation of the employees to ensure maximum output
5. The system provides security measures to access to the hotel’s information lowering data
security threats.
6. The system help reduce the congestion of guests ensuring best service output for
Preliminary Investigation
The project entitled Online Hotel Reservation is a web based system which facilitates online
reserve his accommodation he would to know the list of hotels in the city he wants to visit,
different amenities provided in each hotel the different types of rooms available, the rates of
those rooms, the constraints of the hotel and finally the availability of the desired rooms on
He may achieve all this through travel agencies, the guides available, by making enquiries in
person, by making enquiries through telephone. If he wants to make a choice between the
hotels he has to repeat the whole process for a number of hotels .After being satisfied with the
choice he has to confirm his reservation by paying the amount personally or through middle
So we found the necessity of providing all the information and the facility to reserve his
accommodation through the net so that maximum satisfaction is achieved by the customer
with least effort. The solution we are providing to this is to design a website that contains
information about various cities and the reputed hotels in each city along with the facilities,
types of rooms and their rates. The tourist can also choose the hotel of his interest
Feasibility Study
According to this feasibility study this report is integrated with some important points. Those
points are,
This report has written for a Hotel Reservation system. The main object of preparing this
document is to give the clear ideas about changes and modifications of their new system for
user.
system. In the other hand we can say that whether decision makers can implement the project
according to customer’s requirements or not. The feasibility study will include wide data
associated to financial and operational impact. It also consisted with advantages of new
The feasibility study is conducted to support the decision-makers in creating the decisions,
2. Whatever the decision that they take it should improve the quality of developing
system
According to the project feasibility study may be conducted by the Hotel reservation
Manager. The hotel reservation manager over and over again does not have the time required
to perform in detail analysis required to complete a feasibility study. Also, the director may
lack the knowledge essential for completing the study. Therefore, a specialist often is hired to
The individual conducting a feasibility study should have the following characteristics:
Should have the ability make decisions whatever the most suitable.
The feasibility study for a proposed reservation system will be widespread. There are several
components that should be included in the study, and each will be discussed.
Background Information
According to our investigation we have chosen one of the best business class hotels.
According to the IT manager’s idea they having some doubts with their reservation
Make one of the best and effective reservation system for company is main goal of
These are the most basic functionalities that appear in front end.
These are the basic functions that include in back end system.
FEASIBILITY STUDY
More commonly known as cost/benefit analysisthe procedure is to determine the benefit and
saving that are expected from asystem and compare them with costs, decisions is made to
design andimplement the system.This part of feasibility study gives the top management the
economicjustification for the new system. This is an important input to themanagement the
management, because very often the top management doesnot like to get confounded by the
various technicalities that bound to beassociated with a project of this kind. A simple
economic analysis that givesthe actual comparison of costs and benefits is much more
meaningful in suchcases.
In the system, the organization is most satisfied by economic feasibility.Because, if the
organization implements this system, it need not require anyadditional hardware resources as
and to what extent it can support the system.According to feasibility analysis procedure the
technical feasibility of thesystem is analysed and the technical requirements such as software
facilities,procedure, inputs are identified. It is also one of the important phases of the system
development activities.The system offers greater levels of user friendliness combined with
processing speed is very high and the work is reduced in the maintenancepoint of view
3) BEHAVIOURAL FEASIBILITY
People are inherently resistant to change and computer has been known tofacilitate changes.
An estimate should be made of how strong the user islikely to move towards the development
4) OPERATIONAL FEASIBILITY:
PROJECT SCHEDULING
PERT CHART
abbreviated PERT, is a model for project management designed to analyze and represent the
tasks involved in completing a given project. It is commonly used in conjunction with the
especially the time needed to complete each task, and identifying the minimum time needed
PERT was developed primarily to simplify the planning and scheduling of large and
complex projects. It was developed for the U.S. Navy Special Projects Office in 1957 to
support the U.S. Navy's Polaris nuclear submarine project. [1] It was able to incorporate
uncertainty by making it possible to schedule a project while not knowing precisely the
details and durations of all the activities. It is more of an event-oriented technique rather than
start- and completion-oriented, and is used more in projects where time, rather than cost, is
infrastructure and Research and Development projects. An example of this was for the 1968
Winter Olympics in Grenoble which applied PERT from 1965 until the opening of the 1968
Games.
This project model was the first of its kind, a revival for scientific management,
founded by Frederick Taylor and later refined by Henry Ford (Fordism). DuPont
corporation'scritical path method was invented at roughly the same time as PERT.
GANTT CHART:
A Gantt chart is a type of bar chart that illustrates a project schedule. Gantt charts
illustrate the start and finish dates of the terminal elements and summary elements of a
project. Terminal elements and summary elements comprise the work breakdown structure of
the project. Some Gantt charts also show the dependency (i.e., precedence network)
relationships between activities. Gantt charts can be used to show current schedule status
contributions, the Henry Laurence Gantt Medal is awarded for distinguished achievement in
management and in community service. This chart is used also in Information Technology to
A common error made by those who equate Gantt chart design with project design is
that they attempt to define the project work breakdown structure at the same time that they
define schedule activities. This practice makes it very difficult to follow the 100% Rule.
Instead the WBS should be fully defined to follow the 100% Rule, then the project schedule
can be designed.
Although a Gantt chart is useful and valuable for small projects that fit on a single
sheet or screen, they can become quite unwieldy for projects with more than about 30
activities. Larger Gantt charts may not be suitable for most computer displays. A related
criticism is that Gantt charts communicate relatively little information per unit area of
display. That is, projects are often considerably more complex than can be communicated
effectively with a Gantt chart. Gantt charts only represent part of the triple constraints (cost,
time and scope) of projects, because they focus primarily on schedule management.
Moreover, Gantt charts do not represent the size of a project or the relative size of work
communicated. If two projects are the same number of days behind schedule, the larger
project has a larger impact on resource utilization, yet the Gantt does not represent this
difference.
1.Initial Investigation
(30 hrs)
2.Feasibility Study
(30 hrs)
3.System Analysis
(60 hrs)
4.System Design
(100 hrs)
5.Coding
(160 hrs)
6.Testing
(30 hrs)
7.Implementation
(20 hrs)
8.Post Implementation
(30 hrs)
9.Finish
SOFTWARE REQUIREMENTS SPECIFICATION
1.1 Purpose
The Software Requirements Specification (SRS) will provide a detailed
descriptionof the requirements for the Hotel Reservation System (HRS). This SRS
constructed. The clear understanding of the HRS and its’ functionality will allow for
the correct software to be developed for the end user and will be used for the
development of the future stages of the project. This SRS will provide the foundation
for the project. From this SRS, the HRS can be designed, constructed, and finally
tested.
This SRS will be used by us for constructing the HRS and the hotel end users. We will use the SRS
to fully understand the expectations of this HRS to construct the appropriate software. The hotel end
users will be able to use this SRS as a “test” to see if the constructed system is up to their
expectations. If it is not to their expectations the end users can specify how it is not to their liking and
1.2 Scope
The software product to be produced is a Hotel Reservation System which will automate the major
hotel operations. The first subsystem is a Reservation and Booking System to keep track of
reservations and room availability. The second subsystem is the Tracking and Selling Food System
that charges the current room. The third subsystem is a General Management Services and
Automated Tasks System which generates reports to audit all hotel operations and allows
modification of subsystem information. These three subsystems’ functionality will be described in
The end users are the hotel staff (customer service representative) and hotel managers. Both user
types can access the Reservation and Booking System and the Food Tracking and Selling System
The Hotel Reservation System’s objective is to provide a system to manage a hotel that has increased
in size to a total of 100 rooms. Without automation the management of the hotel has become an
unwieldy task. The end users’ day-to-day jobs of managing a hotel will be simplified by a
considerable amount through the automated system. The system will be able to handle many services
to take care of all customers in a quick manner. The system should be user appropriate, easy to use,
provide easy recovery of errors and have an overall end user high subjective satisfaction.
End users – The people who will be actually using the system
1.4 Overview
The SRS is organized into two main sections. The first is The Overall Description and the
second is the Specific Requirements. The Overall Description will describe the requirements
of the HRS from a general high level perspective. The Specific Requirements section will
not state specific requirements. Instead it provides a background for those requirements,
include hotel rooms and customers information. These can be modified by the end users.
The room database will include the room numbers and if they are vacant or occupied. The
customers information database will contain all the information of the customer such as first
name, last name, number of occupants, assigned room, default room rate (may be changed),
phone number, whether or not the room is guaranteed, credit card number, confirmation
number, automatic cancellation date, expected check in date and time, actual check in date
and time, expected check out date and time, amount owed by customer, and abbreviated
customer feedback.
the database
When no rooms are available and a customer would like to extend their
reservation their information will be placed in a database and when there are
rooms available the first customer on the list will have the room
If the internal clock states that is a customer’s time to have checked out and
customer has not checked out, adds an extra night to amount owed and
provides a report
Records payment
combined with the system context diagram, use cases, and use case descriptions, is sufficient
to enable designers to design a system to satisfy those requirements, and testers to test that
Check-in Modify room stay (e.g., new credit card), check-in customer (with
or without a reservation), adjust room rate, special requests, accept
payment type/credit card
Room Service/Restaurant Create order, modify order, view order, cancel order, generate meal
bill
1. Reservation/Booking
1.6.1. The system shall allow the default room rate to be changed.
1.8. The system shall display whether or not the room is guaranteed.
1.9. The system shall generate a unique confirmation number for each reservation.
1.10. The system shall automatically cancel non-guaranteed reservations if the
customer has not provided their credit card number by 6:00 pm on the
check-in date.
1.11. The system shall record the expected check-in date and time.
1.12. The system shall record the expected checkout date and time.
1.14. The system shall allow reservations to be modified without having to renter
1.15.1. The system shall display the amount owed by the customer.
1.15.2. To retrieve customer information the last name or room number shall
be used
1.16. The system shall charge the customer for an extra night if they checkout
1.17. The system shall mark guaranteed rooms as “must pay” after 6:00 pm on the
check-in date.
2. Management
2.1. The system shall display the hotel occupancy for a specified period of time
2.2. The system shall display projected occupancy for a period of time (days).
2.3. The system shall display room revenue for a specified period of time (days).
2.4. The system shall display food revenue for a specified period of time (days).
2.5. The system shall display an exception report, showing where default room
2.6. The system shall allow for the addition of information, regarding rooms,
2.7. The system shall allow for the deletion of information, regarding rooms,
2.8. The system shall allow for the modification of information, regarding rooms,
The load time for user interface screens shall take no longer than two seconds.
list is not a complete list and is designed as a starting point for development.
Booking/Reservation System
Customer first name
Customer address
Number of occupants
Assigned room
Rate description
Guaranteed room (yes/no)
Confirmation number
Customer feedback
Payment type
Total Bill
3.3.4 Reliability
Specify the factors required to establish the required reliability of the software system at time
of delivery.
3.3.5 Availability
The system shall be available during normal hotel operating hours.
3.3.6 Security
Customer Service Representatives and Managers will be able to log in to the Hotel
Reservation/Booking and Food subsystems. Managers will have access to the Management
subsystem as well as the Reservation/Booking and Food subsystems. Access to the various
subsystems will be protected by a user log in screen that requires a user name and password.
3.3.7 Maintainability
The Hotel Management System is being developed in JSP-SERVLET.
3.3.8 Portability
The Hotel Reservation System shall run in any platform that contains Java Runtime.
.A software life cycle is the series of identifiable stages that a software product
undergoes during its lifetime .A software lifecycle model is a descriptive and diagrammatic
representation of the software life cycle .A life cycle model represents all the activities
required to make a software product transit through its lifecycle phases .It also captures the
There are various life cycle models to improve the software processes.
1. WATERFALL MODEL
2. PROTOTYPE MODEL
5. SPIRAL MODEL
Feasibility Study
Requirement Analysis
& Specification
System Design
Coding
Testing
Implementation
Feasibility study
The feasibility study activity involves the analysis of the problem and collection of
the relevant information relating to the product. The main aim of the feasibility
The goal of this phase is to understand the exact requirements of the customer and
The goal of this phase is to transform the requirement specification into a structure that is
Testing
During this phase the design is tested in small modules in isolation from rest of the software
product. Then all the modules are integrated together and tested.
Implementation
Release of software inaugurates the operation and life cycle phase of the operation.
Entities:
An entity is a person, place, thing or event of interest to the organization and about which
data are capture, stored or processed for example and employee is an entity.
Attribute:
Various type of data item that describe an entity are known as attributes.
Relationship:
entities.
While drawing the entity-relationship (E-R) diagram, entity names are represented by a
REPRESENT AN ATTRIBUTE
REPRESENT RELATIONSHIP
REPRESENT CARDINALITY
1. External Entity:
The producer or the consumer of information that resides outsides the bound of the
2. Process:
It is the agent that performs the transformation of information from one state to
or process. The arrows’ denote flow of intermediate data value within a computation.
does not generate any operations on its own but merely responds to requests to store
in. It manages, edit rooms, add new rooms, delete rooms, monitor reservation.
The first step in the user interface design activity focuses on the preparation of input
User interface design consists of two steps input design and output design.
5.3.1INPUT DESIGN
Input designing is a crucial part of any system design. Inaccurate input data are the
most common cause of error in data processing. Data entry can be control by input design.
Input design is the design phase; the expanded data flow diagram identifies logical data
flows, data stores, sources and destinations. The goal of designing input data is to make data
entry as easy as possible. In the case of “Room Reservation and billing System”
muchemphasis has been given to this phase. To reduce input errors, either the users are
provided with choices to choose from, or invalid inputs are restricted. Here the chances of
Keeping in view the user requirements, the inputs screens have been designed and
developed for easy and error free data entry. Based on the various types of inputs to be fed to
the computer in using the proposed system, all input screens have been designed in real mode
(GUI).
The details of all input screens are shown as follows:
Test Cases:
The test cases comprises of snapshots of both the unit test and system test cases.
CODING
Coding
The input to coding phase is the design document produced at the end of the design phase. During the
coding phase, different modules identified in the design document are coded according to their
The objective of the coding phase is to transform the design of a system into code in a high
The software development organizations formulate their own coding standard that suits them
most. The main advantages of adhering to a standard style of coding are as following:
(i) A coding standard gives a uniform appearance to the code written by different
engineers.
Good software development organizations develop their own coding standards and guidelines
depending on what suits their organization best and based on the specific types of product they
develop.
Coding guidelines provide only general suggestions regarding the coding style to be followed.
Unlike coding standards, the use of these guidelines is not mandatory. However, the programmer is
encouraged to review them and attempt to incorporate them into his programming style.
1. Rules for limiting the use of global:these rules list what types of data can be declared
in the headers of different modules should be standard for an organization. The exact
3. Naming conventions for global variables, local variables and constant identifiers: a
popular naming convention is that variables are named using mixed case lettering.
4. Conventions regarding error return values and exceptions handling mechanism: the
way error conditions are reported by different functions in a program and the way
1. Do not use a coding style that is too clever or too difficult to understand: code should
be easy to understand. Clever coding can obscure meaning of the code and hamper
understanding.
2. Avoid obscure side effects: obscure side effects make it difficult to understand a
piece of code. For example if a global variable is changed or some file I/O performed
obscurely in a called module, it becomes difficult to infer from the functions name
3. The code should be well documented: at least one comment line on the average for
4. The length of any function should not exceed 10 source lines: a lengthy function is
Admin_home.jsp
pageEncoding="ISO-8859-1"%>
<%
session=request.getSession();
if(session.getAttribute("username")==null)
response.sendRedirect("admin_index.jsp");
%>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<script type="text/javascript">
jQuery(window).bind("load", function() {
jQuery("div#slider1").codaSlider()
// jQuery("div#slider2").codaSlider()
// etc, etc. Beware of cross-linking difficulties if using multiple sliders on one page.
});
</script>
<style type="text/css">
#mytable {
padding: 0;
margin: 0 auto;
border-left-width: 2px;
border-top-width: 1px;
border-right-width: 1px;
border-bottom-width: 1px;
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: #0099FF;
border-right-color: #0099FF;
border-bottom-color: #0099FF;
border-left-color: #0099FF;
td {
background: #fff;
color: #3399CC;
font-size: 16px;
text-align: center;
#label{
background-color: #3399CC;
}
#apDiv15 {
position: absolute;
width: 265px;
height: 29px;
z-index: 1;
left: 19px;
top: 30px;
#apDiv16 {
position: absolute;
width: 261px;
height: 24px;
z-index: 2;
left: 24px;
top: 80px;
#apDiv17 {
position: absolute;
width: 169px;
height: 24px;
z-index: 3;
left: 0px;
top: 21px;
#apDiv18 {
position: absolute;
width: 170px;
height: 24px;
z-index: 4;
left: 118px;
top: 130px;
#apDiv19 {
position: absolute;
width: 43px;
height: 24px;
z-index: 5;
left: 86px;
top: 180px;
#apDiv7 {
position: absolute;
width: 455px;
height: 175px;
z-index: 7;
top: 202px;
left: 623px;
#form {
width: auto;
height: auto;
</style>
<style type="text/css">
</style>
jQuery(document).ready(function($) {
$('a[rel*=facebox]').facebox({
loadingImage : 'src/loading.gif',
closeImage : 'src/closelabel.png'
})
})
</script>
</head>
<body>
<div id="nav">
<tr>
</tr>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
%>
<%
while (rs3.next()) {
%>
<tr>
<td height="85"><%=rs3.getString("type")%></td>
<td><%=rs3.getString("rate")%></td>
<td><%=rs3.getString("description")%></td>
<td><%=rs3.getString("qty")%></td>
id=<%=rs3.getInt("room_id")%>>Delete</a></td>
</tr>
<% }%>
<%
rs3.close();
statement3.close();
connection3.close();
%>
</table>
<br>
<a style="color: #f00; text-align: center; font-weight: bold; font-size: 20px;"
</div>
</div>
</body>
</html>
Comments
<script>- The HTML script element is used to insert client side script code into a
document. This can be achieved in two ways: inserting the code directly as content of
this element or referring to an external file containing script code with the "src"
attribute. In the second case, user agents should ignore the content of the element.
The ScriptletA scriptlet can contain any number of JAVA language statements,
variable or method declarations, or expressions that are valid in the page scripting
language.
or methods that you can use in Java code later in the JSP file.
You must declare the variable or method before you use it in the
JSP file.
JSP Expression:
evaluated, converted to a String, and inserted where the expression appears in the JSP
file.
JSP Comments:
JSP comment marks text or statements that the JSP container should ignore. A JSP
comment is useful when you want to hide or "comment out" part of your JSP page.
JSP Directives:
A JSP directive affects the overall structure of the servlet class. It usually has the
following form:
JSP Actions:
JSP actions use constructs in XML syntax to control the behavior of the servlet engine.
You can dynamically insert a file, reuse JavaBeans components, forward the user to
There is only one syntax for the Action element, as it conforms to the XML standard:
<jsp:action_nameattribute="value"/>
Error Handling
Error handling using try and catch statement.
Although the default exception handler provided by the Java run-time system is useful
for debugging, you will usually want to handle an exception yourself. Doing so provides
two benefits. First, it allows you to fix the error. Second, it prevents the program from
automatically terminating. Most users would be confused (to say the least) if your
program stopped running and printed a stack trace whenever an error occurred!
To guard against and handle a run-time error, simply enclose the code that you want to
monitor inside a try block. Immediately following the try block, include a catch clause
Parameter Calling/Passing
GET method:
The GET method sends the encoded user information appended to the page request. The
This method packages the information in exactly the same way as GET methods, but
instead of sending it as a text string after a ? in the URL it sends it as a separate message.
This message comes to the backend program in the form of the standard input which you
JSP handles this type of requests using getParameter() method to read simple parameters.
<%=request.getParameter("first_name")%>
Validation Checks
JavaScript can be used to validate data in HTML forms before sending off the content
to a server.
Required Fields
The function below checks if a field has been left empty. If the field is blank, an alert
box alerts a message, the function returns false, and the form will not be submitted:
<script type="text/javascript">
functionvalidateForm()
var a=document.forms["form1"]["name"].value;
if (a==null || a=="")
returnfalse;
var c=document.forms["form1"]["message"].value;
if (c==null || c=="")
returnfalse;
varemailText = document.forms["form1"]["email"].value;
9]+)*)*\.[a-z]{2,4}$/;
if (pattern.test(emailText)) {
returntrue;
} else {
returnfalse;
</script>
The function above could be called when a form is submitted:
validateForm()" name="contact">
<p>Name:<br />
<br />
<br />
Messages:<br />
<br />
</p>
</form>
TESTING
Testing techniques and Testing strategies
TESTING
Software testing is a critical element of software quality assurance and represents the
ultimate review of specification, design and coding. In fact, testing is the one step in the
constructive.
A strategy for software testing integrates software test case design methods into a well-
planned series of steps that result in the successful construction of software. Testing is
the set of activities that can be planned in advance and conducted systematically. The
that can economically and effectively applied to both strategic to both large and small-
scale systems
engineering defines the role of software and leads to software requirement analysis
validation criteria for software are established. Moving inward along the spiral, we
come to design and finally to coding. To develop computer software we spiral in along
A strategy for software testing may also be viewed in the context of the spiral. Unit
testing begins at the vertex of the spiral and concentrates on each unit of the software as
implemented in source code. Testing progresses by moving outward along the spiral to
integration testing, where the focus is on the design and the construction of the software
validated against the software that has been constructed. Finally we arrive at system
testing, where the software and other system elements are tested as a whole.
Table Given below outlines the tests that were performed on the system to ensure
Testing Objectives
Phase
UNIT TESTING
Unit Testing will be done to test field validations, navigation, functionality of the
programs and its blocks. These tests are applied on various functions within each
MODULE TESTING
Module testing will be done to test the interaction between the various programs within
one module. It checks the functionality of each program with relation to other programs
within the same module. It then tests the overall functionality of each module.
INTEGRATION TESTING
Integration testing is done to test the functionality and interfacing between the modules.
The system is built up of various modules, which work together to automate the
activities of the hotel management system. These modules should work together in a
seamless way to achieve the desired results. Integration testing will test for this
property of the modules. The modules display a cause and effect relationship, if data in
one module is changed, then it affects the data to change in some other module also.
Integration testing needs to check if the modifications do not adversely affect some
other modules.
ACCEPTANCE TESTING
Acceptance testing was done after the implementation of the system. The acceptance
testing will check if the system works correctly in the user environment and if the entire
user specified functionalities are present. It also tests if the system adheres to the
Test Reports
Admin Module
User Module:
SYSTEM SECURITY MEASURES
Data Security:
Data Security or Database Security is a very essential operation needed to be done in order to
provide security for data items in the database.Database security allows or disallows user
actions on the database and objects within it. It protects a database from unintended activity.
The MD5 message-digest algorithm is a widely used cryptographic hash function producing a
128-bit (16-byte) hash value, typically expressed in text format as a 32 digit hexadecimal
number. MD5 has been utilized in a wide variety of cryptographic applications, and is also
<%@page import="java.sql.*,java.util.*"%>
<%@page import="javax.crypto.*"%>
<%@page import="java.security.MessageDigest"%>
<%try{
String username=request.getParameter("user");
String password=request.getParameter("pass");
String position=request.getParameter("posi");
String emailadd=request.getParameter("email");
String algorithm="";
MessageDigest md =null;
md = MessageDigest.getInstance("MD5");
md.reset();
md.update(unencodedPassword);
StringBufferbuf = newStringBuffer();
buf.append("0");
String passw=buf.toString();
Class.forName("com.mysql.jdbc.Driver");
"root", "123456");
Statement st=con.createStatement();
values('"+username+"','"+passw+"','"+position+"','"+emailadd+"')");
}catch(Exception e){}
response.sendRedirect("adduser.jsp");
%>
REPORTS
In this function reports are generated for the following entities:
a) Customer Details.
b) Requirements of the Customers
c) Rooms Details
d) Bill Details
e) Checkin Reports
f) Booking Details
g) Online Bookings
h) Checkout Details
vacation or weekend getaway. Online hotel bookings help you to plan your vacation or
business trip easier and more affordable. In olden days it was very difficult to find and select
a hotel far away from your home. The development of technology and internet simplified the
process and now-a-days it is very easy to book a room from you home computer. Online
hotel booking help you to find a hotel with the facilities you wish to have. Sometimes you
need a simple and affordable place to stay and sometimes you wish to stay in a luxurious
room, it doesn't matter. We can select and book any type of room you like via internet.
The internet has developed a revolution in the field of hotel booking services. It is now very
easy to find a hotel anywhere in the world within seconds. You can book your favourite room
any time of the day from anywhere in the world. The most important advantage of online
hotel booking is convenience; you can book your room by simply sitting in home. Internet
helps you to browse through the hotels around the world and compare the facilities and rates
easily. When you choose your favourite hotel for your accommodation, simply you can
complete your reservation when required. Some of the hotels also offer same day hotel
booking online. It is very helpful for those who plan their weekend getaway in last minute.
Most of the hotels offers competitive pricing because it is very easy to compare the prices of
one hotel to another. Some online booking service provider's websites even allow you to
compare the prices of multiple hotel when selecting your online hotel bookings. By this way
it is very easy to find well-equipped hotel rooms in cheap price. It is better to find a larger
online hotel booking service provider, if you are looking for a cheap hotel room. Some of the
service providers won't allow you to choose your hotel, they only allow you to select location
and quality of the hotel. Considerable discounts on hotels may be available in off-seasons.
Some may give great discount in season also due to the competition in the field. You will get
much greater discount, if you allow the online hotel booking service provider to select your
hotel and flight. You can save much by selecting the services of online hotel booking service
providers. You can definitely save on airline flights, car services, and even entertainment.
You will get considerable discounts if you allow them to select all services you need. It is
sure that you can save a considerable amount and have extra funds to enjoy on your trip.
There is no administrative cost for hotels to provide this service. The booking software can be
Customers can compare the prices and facilities from one hotel to another by utilizing this
facility. Planning a vacation has never been easier and more reasonable than now. Easiness,
affordable pricing, and simple comparison shopping make online hotel bookings accepted to
all.
BIBLIOGRAPHY
1. Wikipedia