CONTENTS

HOTEL MANAGEMENT
PURPOSE OF HOTEL MANAGEMENT SYSTEMS
BENEFITS OF HOTEL MANAGEMENT TECHNOLOG
WHAT IS NetBeans?
WHAT IS MYSQL?
CODES FOR WEBSITE CREATION
HOTEL MANAGEMENT SYSTEM
Hotel management software is technology that allows hotel
operators and owners to streamline their administrative
tasks while also increasing their bookings in both the short-
and long-term
Your hotel management system is not only important for
your own day-to-day operations, but it's a vital part of the
overall guest experience. From the beginning of your guests
online booking journey until the completion of their stay and
their feedback once they return home, it is necessary for
your hotel management technology to enhance their
experience with your brand.
THE PURPOSE OF HOTEL MANAGEMENT
SYSTEM
Management systems serve several purposes for both hotel
operators who manage large chains as well as independent
hoteliers. These include:
1. Managing bookings:-
Your property management system should help you
efficiently and effectively manage your bookings. Neither
you, nor your staff, should be tasked with manually inputting
bookings and managing those across all your distribution
channels: A property management system should automate
the booking process for you, allowing you to escape the back
office and focus more on interacting with your guests.
2. Direct bookings:
It should allow you to actively drive direct bookings to your
website. Travellers today are more apt to book online than
they are to call to finalise bookings or partner with a travel
agent. Direct bookings allow you to maximise the revenue
that you generate per booking. You should only consider
software that integrates with an online booking engine.
3. Channel Management Hotel:
Management technology should allow you to easily
implement your distribution strategy. Creating partnerships
with different types of agents in the industry, such as OTAS
and GDSS, is necessary to survive in a competitive, global
climate.
BENEFITS OF HOTEL MANAGEMENT
TECHNOLOGY
When you are selecting hotel management technology for
your property, you should consider the many benefits that
this system will offer you, including
1. Reduce time spent on administrative tusks
You can mirumise the amount of time spent on
administrative tasks. The right hotel management system will
do a lot of the work for you, allowing you to focus your
efforts and your energy on the big picture. The wimology
should also provide you with valuable data on how your
employees perform then duties and how this affects
emplovee retention, satisfaction and productivity.
2. Increase your online presence:
You caratcave умот brand presence online. Management
soitwat that is integrated with your website builder will allow
you to accept direct online bookings and develop a user
friendly website. Naturally, this will increase your relevance
in the search engine results and allow more travellers to
discover your property during theit online boulang journey.
3. Build relationships with guests
You will develop a better rapport with your target market
segment.
whale su lendying new markets to tap mio. The types of
travellers who have always loved staving at your property will
appreciate the improved experience
4. Manage your distribution
You will prove your vale coughout the industry. With a
peppert management system in place that integrates with a
channel manager, you will be able to advertise across many
channels whilst maintaining rate parity
 NETBEANS
NetBeans is an integrated development environment (IDE)
for Java. NetBeans allows applications to be developed from
a set of modular software components called modules.
NetBeans runs on Windows, Mac OS. Linux and Solaris. In
addition to Java development, it has extensions for other
languages like PHP. C. C++ HTML5 and Java Script.
 MYSQL
MySQL (Structured Query Language) is an open source
relational database management system (RDBMS). It is free
and open-source software under the terms of the GNU
(General Public License), and is also available under a variety
of proprietary licenses. It is a component of the LAMP web
application software stack (and others). It is used by many
database-driven web applications, including phpBB, and
Word Press. It is also used by many popular websites,
Including Facebook.
Flickr MediaWiki, Twitter, and YouTube.
MYSQL WORKBENCH :-
MySQL Workbench is a unified visual tool for database
architects, developers, and DBAs. It provides data modelling.
SQL development, and comprehensive administration tools
for server configuration, user administration, backup, and
much more. It is available on Windows, Linux and Mac OS X.
It delivers visual tools for creating, executing, and optimizing
SQL queries. The SQL Editor provides colour syntax
highlighting, auto-complete, reuse of SQL snippets, and
execution history of SQL The Database Connections Panel
enables developers to easily manage standard database
connections, including MySQL Fabric. The Object Browser
provides instant access to database schema and objects.

CODE
import [Link];
import [Link];
import [Link];
import [Link];
public class ManageRoom Form extends [Link] (
Rooms room new Rooms();
Public ManageRoomForm(){
initComponents():
[Link]/ComboBox(comboRoomType):
[Link](Table1);
ButtonGroup bg= new ButtonGroup();
[Link](jRadioButtonYes);
[Link](jRadioButtonNo):)
@SuppressWarnings("unchecked")
//<editor-fold defaultstate="collapsed" desc="Generated
Code">
private void initComponents() {
jPanel1 = new [Link]();
¡Panel2 = new [Link]();
jlabel1 = new [Link]();
jlabel2 = new [Link]();
txtRoomNo= new [Link]();
jLabel3 = new [Link]();
txtphone = new [Link]();
jLabel5 new [Link]():
jScrollPanel = new [Link]();
Table1 = new [Link]();
btnAddClient = new [Link]();
btnEditClient = new [Link]();
btnRemoveClient = new [Link]();
btnClrClient = new [Link]();
btnrefresh new [Link]();
comboRoomType = new [Link]<>();
btnShowType = new [Link];
jLabel6= new [Link]();
jPanel3 = new [Link]();
jRadioButtonYes = new [Link]();
JRadioButton No = new [Link]();
setDefaultClose
Operation([Link]. WindowConstantd.EXIT_ON_close);
setPreferredSize (new [Link] (854, 520));
[Link](new [Link](153, 0, 0));
[Link](new [Link](0, 0, 204));
[Link](new [Link]("Tahoma", 0, 24)); //
NOI18N
[Link](new [Link](255, 255, 255));
[Link]("Manage Room");
[Link] jPanel2 Layout = new
[Link](jPanel2);
[Link](jPanel2Layout);
[Link] Group
([Link]
([Link])
.addGroup ([Link]()
.addGap(341,341,341)
.addComponent(jLabel1,
[Link].PREFERRED_SIZE, 171,
[Link].PREFERRED_SIZE)
.addContainerGap([Link].DEFAULT_SIZE,
Short.MAX_VALUE)));
[Link](
[Link] ([Link]
Alignment
.LEADING)
.addGroup([Link] Group)
.addContainer Gap()
.addComponents(jLabel1)
.addContainer Gap(35, Short.MAX_VALUE)));
[Link](new [Link]("Tahoma", 0, 18)); //
NOI18N
[Link](new [Link](255, 255, 255));
[Link]("Number");
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
{
txtRoomNoAction Performed (evt);}});
[Link](new [Link]("Tahoma", 0, 18)); //
NOI18N
[Link](new [Link](255, 255, 255)):
[Link]("Type");
[Link](new
[Link]() {
public void Action Performed ([Link]
evt) {
txtphone Action Performed (evt);}});
[Link](new [Link]("Tahoma", 0, 18)); //
NOI18N
[Link](new [Link](255, 255, 255));
[Link]("Phone No:");
¡[Link](new [Link]. Default Table
Model(
new Object()
new String[]{
"Number", "Type", "Phone", "ReservationStatus"}) (public
Boolean isCellEditable (int row, int column){return false;}});
Table [Link] Mouse Listener(new
[Link]()
{ public void mouse Clicked ([Link] evt)
(Table 1 Mouse Clicked(evt);}});
12
[Link] (jTable1);
[Link]("Add Room");
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
(
btnAddClientActionPerformed (evt);}});
[Link]("Edit");
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
{
btnEditClientAction Performed (evt):}}};
[Link]("Remove");
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
{
btnRemoveClientActionPerformed(evt);}});
[Link]("Clear Field");
[Link](new
[Link]() {
public void actionPerformed([Link] evt)
{
btnClrClientActionPerformed (evt);}});
[Link]("Refresh");
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
{
btnrefreshActionPerformed(evt);}});
[Link](new [Link]("Tahoma", 0,
14)); //NOI18N
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
{
combo RoomTypeAction Performed (evt);}});
[Link]("Show Types");
[Link](new
[Link]() {
public void actionPerformed ([Link] evt)
{
btnShowTypeActionPerformed (ext);}});
[Link](new [Link]("Tahoma", 0, 18));
//NOI18N
[Link](new [Link](255, 255, 255));
[Link]("Reserve");
JRadioButton [Link]("Yes");
[Link] jPanel 1 Layout = new
[Link](jPanel1);
[Link](jPanel1Layout);
jPanel 1 [Link] Group
([Link]
([Link] [Link])
.addComponent(jPanel2,
[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup (jPanel 1 [Link] Group()
.addGap(44, 44, 44)
.addGroup ([Link]
([Link] [Link])
.addGroup ([Link] Group()
addGroup(jPanell
[Link]([Link]
[Link])
.addComponent(btnClrClient,
[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup [Link] LEADING,
[Link] Group()
.addComponent(btnAddClient)
.addPreferredGap([Link]
[Link]
TED, 27, Short.MAX_VALUE)
.addComponent(btnEditClient)
.addGap(18, 18, 18)
.addComponent(btnRemoveClient)))
.addGap(53, 53, 53))
.addGroup ([Link]()
.addGroup([Link]
([Link]
[Link])
.addGroup([Link]([Link]
oupLayout
[Link])
.addGroup ([Link] Group()
.addGroup([Link]([Link]
oupLayou
[Link])
.addComponent(jl.abel2)
.addComponent(jLabel3))
.addPreferredGap([Link]
[Link]
LATED)
.addGroup
([Link]([Link]
[Link], false)
.addComponent(txtRoomNo,
[Link].PREFFERED_SIZE, 170,
[Link].PREFFERED_SIZE)
.addGroup ([Link] Group()
.addComponent(comboRoomType,
[Link].PREFFERED_SIZE,72,
[Link].PREFFERED_SIZE)
.addPreferredGap([Link]
[Link]
ed, [Link].DEFAULT_SIZE,
Short.MAX_VALUE)
.addComponent(btnShowType))))
.addGroup ([Link] Group()
.addComponent(jLabel5)
.addPrefferedGap([Link]
[Link] LATED)
.addComponent(txtphone,
[Link].PREFFERED_SIZE, 170,
[Link].PREFFERED_SIZE))) .addGroup(jPan
el 1 [Link] Group()
.addComponent(jLabel6)
.addPrefferedGap([Link]
[Link] LATED)
.addComponent(jPanel3,
[Link].PREFFERED_SIZE,
[Link].DEFAULT_SIZE,
[Link].PREFFERED_SIZE)))
.addPrefferedGap([Link]
[Link] TED, [Link].DEFAULT_SIZE,
Short.MAX_VALUE)))
.addGroup([Link]
([Link] [Link])
.addGroup([Link] Group()
addComponent(ScrollPane1,
[Link].PREFFERD_SIZE, 466,
[Link].PREFFERED_SIZE)
addGap(19, 19, 19))
addGroup([Link],
[Link] Group()
.addComponent(btnrefresh)
.addGap(216, 216, 216)))));
jPanel1 [Link](
¡[Link]([Link].
Alignment LEADING)
.addGroup (jPanel [Link]()
.addComponent(jPanel2,
[Link].PREFFERED_SIZE,
[Link].DEFAULT_SIZE, [Link]
Layout.PREFFERED_SIZE)
.addGroup(jPanel [Link]
([Link] [Link], false)
.addGroup([Link] Group()
.addGap(18, 18, 18)
.addGroup([Link]
([Link] [Link])
.addComponent(jLabel2)
.addComponent(txtRoomNo,
[Link].PREFFERED_SIZE,
[Link].DEFAULT_SIZE,
[Link].PREFERRED_SIZE)) .addPreferredGa
p([Link]
LATED)
.addGroup
([Link]([Link]
[Link])
.addComponent(jLabel3)
.addComponent(comboRoomType,
[Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,
[Link].PREFERRED_SIZE)
.addComponent(btnShowType))
.addGap(18, 18, 18)
.addGroup(jPanel [Link]
([Link] [Link])
.addComponent(jLabel5)
private void
txtRoomNoActionPerformed([Link]
evt) {}
private void txtphoneAction
Performed([Link] evt) {}
privatevoid jTable 1 Mouse Clicked
([Link] evt) { DefaultTableModel model
= (DefaultTableModel)[Link]();
int rIndex =jTable [Link] Row();
[Link]([Link](rIndex,0).toString());
String n = [Link](rIndex, 1).toString();
[Link]([Link](n));
[Link]([Link](rIndex,2).toString());
String is Reserved = [Link](rIndex,3).toString();
if([Link]("Yes")) {
[Link](true); } else{
[Link](true);}}
private void btnAddClientActionPerformed
([Link]
evt) {
try {
int roomNumber = [Link]([Link]());
int roomType =
[Link]([Link]().toString
());
.addGap(37, 37, 37)
.addGroup
([Link]([Link]
[Link])
.addComponent(btnClrClient)
.addComponent(btnrefresh))
.addGap(0, 48, Short.MAX_VALUE)));
[Link] layout = new
[Link](getContentpane());
getContentPane().setLayout(layout);
[Link] Group(
[Link]([Link]
[Link] NG)
.addComponent(jPanel 1,
[Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,
[Link].PREFERRED_SIZE));
[Link](
[Link]([Link]
[Link] NG)
.addComponent(jPanel1,
[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE,
Short.MAX_VALUE));
pack();
}//</editor-fold>
.addComponent(txtphone,
[Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,
[Link].PREFERRED_SIZE))
.addgap (18, 18, 18)
.addGroup ([Link]
([Link] [Link])
.addComponent(jLabel6)
.addComponent(jPanel3,
[Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,
[Link].PREFERRED_SIZE))
.addGap(114, 114, 114)
.addGroup([Link]([Link]
oupLayou
[Link])
.addComponent(btnAddClient)
.addComponent(btnEditClient)
.addComponent(btnRemoveClient))
.addGroup([Link],
[Link] Group()
.addPreferredGap([Link]
[Link]
TED, [Link].DEFAULT_SIZE,
Short.MAX_VALUE)
.addComponent(jScrollPane 1,
[Link].PREFERRED_SIZE, 293,
[Link]. PREFERRED_SIZE)))
[Link](false);
jRadioButton [Link](false);
[Link](0);}
private void btnrefresh Action
Performed([Link] evt) {
// TODO add your handling code here:
[Link](new DefaultTableModel(null, new Object[]
{"Number","Type","Phone", "Reservation Status"}));
[Link](Table1);}
private void btnShowTypeAction
Performed([Link] evt) (
ALL_ROOM_TYPES roomTypesForm = new
ALL_ROOM_TYPES(); [Link](true);
roomTypes [Link]():
[Link] RelativeTo(null):
[Link](JFrame.DISPOSE_
ON_CLOSE );}
private void
comboRoomTypeAction
Performed([Link] evt) {}
public static void main(String args[]) {
//<editor-fold defaultstate="collapsed" desc=" Look and feel
setting code(optional)">try{
for ([Link] info:
else{
[Link](rootPane, "Unable to
update
details");
}}catch(Exception ex) {
[Link]();}}
private void
btnRemoveClientAction Performed
([Link]
evt){
try {
int roomNumber=[Link]([Link]());
if ([Link] Rooms (room Number)){
[Link](rootPane, "Details
Removed Successfully");}
else{
[Link](rootPane, "Unable to
delete");}}
catch(Exception ex){
[Link]();}}
private void btnClrClientActionPerformed
([Link] evt) {
// TODO add your handling code here:
[Link]("");
[Link]("");
[Link]([Link]().toString
());
String phone = [Link]();
if([Link] (roomNumber, roomType, phone(){
[Link](rootPane, "Added
Successfully");}
else{
[[Link](rootPane, "Unable to add
details");}}
catch(Exception ex){
[Link]();}}
private void btnEditClientAction Performed
([Link]
evt) {
try{
int roomNumber = [Link]([Link]());
int roomType=
[Link]([Link]().toString
());
Stringphone = [Link]();
String is Reserved = "No";
if([Link]()){
isReserved = "Yes";}
if([Link] (roomNumber, roomType, phone,
isReserved)){
[Link](rootPane, "Information
Updated Succesfully");}
[Link] LookAndFeels()) {
if ("Nimbus".equals([Link]())) {
[Link]([Link]())
; break;}}
} catch (ClassNotFoundException ex) {
[Link]([Link].g
etName()).
log([Link], null, ex);
} catch (InstantiationException ex) {
[Link]([Link].g
etName()). log([Link], null, ex);
} catch (IllegalAccessException ex) {
[Link]([Link].g
etName()).
log([Link], null, ex); } catch
([Link]. UnsupportedLookAndFeel Exception ex) {
[Link]([Link].g
etName()).
log([Link], null, ex);}
[Link](new Runnable() {
public void run() {
new Manage RoomForm().setVisible(true);}});}
private [Link] btnAddClient;
private [Link] btnClrClient;
private [Link] btnEditClient;
private [Link] btnRemoveClient;
private [Link] btnShowType;
private [Link] btnrefresh;
private [Link]<String> comboRoomType;
private [Link] jLabel1;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jLabel5;
private [Link] jLabel6;
private [Link] jPanel1;
private [Link] jPanel2;
private [Link] jPanel3;
private [Link] jRadioButtonNo;
private [Link] jRadioButtonYes;
private [Link] jScrollPane1;
private [Link] jTable1;
private [Link] txtRoomNo;
private [Link] txtphone;
// End of variables declaration }

BIBLIOGRAPHY
[Link]
[Link]