Contents

Objectives of the projec:t ......................................................................... 4

Features of Java: ....................................................................................... 6
INTRODUCTION TO MySQL.................................................................. 19
Screenshot of MySQL ........................................................................... 20
Bibliography ............................................................................................... 21
Objectives of The Project
The objective of the software project is to develop a
computerized system to ease the functions of a Hotel. This
software project is also aimed to enhance the current record
keeping system, which will help managers to retrieve the up-to-
date information at right time in right shape.

The proposed software system is expected to do the following

functionality-
To provide a user friendly, Graphical User Interface (GUI) based
integrated and centralized environment.
The proposed system should maintain all the records and should
generate the required reports and information when required.
To provide user-friendly interface to interact with a centralized
database based on client-server architecture.
In its current scope, the software enables user to retrieve and
update the information from centralized database designed with
MySQL During the development of Hotel Management System
project, Java NetBeans IDE, a powerful, open source event-driven
form-based development environment is used for modular
design and future expandability of the system.
INTRODUCTION TO JAVA
Java is a computer programming language that is concurrent, class-
based, object-oriented, and specifically designed to have as few
implementation dependencies as possible. It is intended to let
application developers "write once, run anywhere" (WORA),
meaning that code that runs on one platform does not need to be
recompiled to run on another. Java applications are typically
compiled to bytecode that can run on any Java virtual machine {JVM)
regardless of computer architecture. Java is, as of 2015, one of the
most popular programming languages in use, particularly for client-
server web applications, with a reported 9 million developers.
Java was originally developed by James Gosling at Sun Microsystems
(which has since merged into Oracle Corporation) and released in
1995 as a core component of Sun Microsystems' Java platform. The
language derives much of its syntax from c and C++, but it has
fewer low-level facilities than either of them.
Features of Java:
1. Simple
2. Object-Oriented
3. Platform Independent
4. Secured
5. Robust
6. Open product
7. Portable
8. WORA (Write once Run anywhere)
• src Code for SIGN UP

Import Java.sq!.";
Import Javax.swlngJOptionPane;
Connection con;
PreparedStatement pstmt;
Statement stmt;
ResultSet rs;
public Sign_upO I
initComponentsO;
try
(
Class.forName(""java.sql.Driver");

con=DrlverManager.getConnection("jdbc:mysql://loc:alhost/HOTEL_MANAGEMENT",'.
root","root'");
stmt = con.createStatementO;
)catch(Exceptlon ell(}
I

private void jButton1ActionPerforrned(java.awt.event.ActionEvent evt) (

try
I
pstmt = con.prepareStatement("insert SIGN_UP values('" +t1.getTextO + "',"' +
12.getTextO + ··:· + t3.getTextO + ··:· + t4.getText0 + ··:· + tS.getTextO +
'","' +t6.getTextO+ "')");
pstmtexecuteUpdateO;
JOptionPane.showMessageDialog(this,
"success"," MyDialog",JOptionPane.lNFORMATION_MESSAGE );
new loglnO.showO;
this.h ide();
)catch(Exception e2s )

public static void maln(Strlng argsO) (

 java.awt.EventQueue.invokelater(new RunnableO {
public void runO {
new Sign_upQ.setVisible(true);
)
});
)
• II src code for Login
import java.sql. •;
import javax.swingJOptionPane;
public class Login extends javax.swingJFrame I
Connection con;
PreparedStatement pstmt;
Statement stmt;
ResultSet rs;
public Logi n0 {
initComponents0;
try
I
Class.forNamef1ava.sql.Driver");

con=DriverManager.getComection("jdbc:mysql://localhost/HOTEL_MANAGEM ENT","
root" ."root");
stmt = con.createStatement0;
}catch(Exception el)0
}
private void JButtonlActionPerformedijava.awt.eventActionEvent evt) (
try
I
ResultSet rs=stmt.executeQuery("select • from SIGN_UP where
LOGIN_ID='" +jTextFieldl.getText0+• .• +" and
PASSWORD= '" +jPa.sswordFieldl.getTextQ+"'");
if(rs.nextO)new CUSTOMER_DITAIL50.showO;
else JOptionPane.showMessageDialog(this,
"Invalid.","MyDialog" ,JOptionPane. ERROR_MESSAGE );
}catch(Exception e2)0
}
• I I src code for Room Detail
import java.sql.•;
import javax.swingJOptionPane;
public class Room_DETAILS extends javax.swingJFrame {
Connection con;
PreparedStatement pstmt;
Statement stmt;
ResultSet rs;
public Room_DETAILS0 {
initComponents0;
try
{
Class.forName("'java.sql.Driver");

con=DriverManager.getComection("jdbc:mysql://localhosVHOTEL_MANAGEMENT","
.
roof' · root")· .
stmt = con.createStatement0;
}catch(Exception e1)0
I
)
private void t2ActionPerformed(java.awt.evenlActionEvent evt}
private void
jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
pstmt = con.prepareStatement("insert ROOM_DETAILS values("'+ tl.getText0 + "'',"'
+ t2.getSelectedltem() + "'',"' + t3.getSelectedltem0 + "',"' + tS.getText{) + "'',"' +
t4.getSelectedltem() + "')");
pstmt.executeUpdate();
JOptionPane.showMes.sageOialog(this,
"'success•, "MyDialog• JOptionPane.lNFORMATION_MESSAGE );
}catch(Exception e2)0 // TODO add your handing oode here:
I
 private void jButton2ActionPerformed(java.awt.eventActionEvent evt) {
try
(
pstmt = con.prepareStatement{"update ROOM_OETAILS set ROOM TYPE = ·• +
12.getSelectedltemO + ••, AC FACILITY= .• + t3.getSelectedltemO + '",ROOM FARE =
'" +tS.getTextO + •· where ROOM_NO = ·• ♦ tl.getTextO + ··• );
pstmt.executeUpdateO;
JOptionPane.showMessageOialog(this,
"success•,"MyOialog• )OptionPane.lNFORMATION_MESSAGE );
}catch(Exception e2)0
)
 Screenshot!!! Room details
C

Hotel Room Detail

Room No.

Room Type 100.ux 1•1

AC Facility IAC 1·1
Room Fare

Bed Type lsi•ou l·I

Save Update
• I I src code for consumer detail

Import Java.sq!.•;
Import javax.swlngJOptlonPane;
public class CUSTOMER. DETAILS extends javax.swlngJFrame (
Connection con;
PreparedStatement pstmt;
Statement stmt;
ResultSet rs;
public CUSTOMER. DETAILS() {
initComponentsO;
try
{
Class.forName("java.sql.Driver");

con=DriverManager.getConneclion("jdbc:rny,ql://localhosl/HOTEL_MANAGEMENT","
root· •"root'")••
stmt = con.createStatementO;
}catch(Exception et)O
}
private void JButtontActionPerformed(java.awt.event.ActionEvent evt) {
try
lf(JTextFleld1.getText0.length0 = = 0)
(
JOptlonPane.showMessageDialog(thls, ·text field cannot left
blank","MyDialog".JOptlonPane.lNFORMATION_MESSAGE );
I
else if(jTextField2.getTextO.lengthO ==OJ
(
JOptlonPane.showMessageDialog(this, ·text field cannot left
blank", "MyDialog".JOptionPane.lNFORMATION_MESSAGE );
)
else if(jTextAreat.getText().length() == 0)
 {
JOptionPane.showMessageOialog(this, "text field cannot left
blank", "MyOialog")OptionPane.lNFORMATION_MESSAGE );
}
else if(jTextField3.getTextO.lengthO = = 0)
I
JOptionPane.showMessageOialog(this, ·text field cannot left
blank",• MyOialog")OptionPane.lNFORMATION_M ESSAGE );
}
else if(jTextField4.getTextO.lengthO = = 0)
{
JOptionPane.showMessageOialog(this, "text field cannot left
blank", "MyOialog•)OptionPane.lNFORMATION_MESSAGE );
}
else if(jTextFieldS.getTextO.lengthO = = 0)
I
JOptionPane.showMessageOialog(this, ·text field cannot left
bl;,nk"."MyOialog".JOptionPane.lfll'ORMATION_MESSAGE);
)
else if(jTextField6.getTextO.lengthO = = 0)
{
JOptionPane.showMessageOialog(this, "text field cannot left
blank", "MyOialog•)OptionPane.lNFORMATION_MESSAGE );
}
else if(jTextField3.getTextO.length0 != 10)
I
JOptionPane.showMessageOialog(this, "MOBILE NO. IS
INVAUD","MyDialog",JOptionPane.lNFORMATION_MESSAGE );
}
else
{
try
{
pstmt = con.prepareStatement("insert customer_details values
("' +jTextFieldl.getTextO + ··:· + jTextfield2.getText0 + ··:· + J'TextArea1.getTextO
+'","' • jTextField3.getTextO • ··:· + jTextAeld4.getTextO • ··:· •
cbl.getSelectedltem()+ •·•·• + cb2.getSelectedltemO• •·. ·• • jTextFleld5.getText()
• '","' • jTextFleld6.getTextO• "')");
pstmt.executeUpdateO;
JOptionPane.showMessageDialog(this,
"success","MyDialog",JOptionPane.lNFORMATION_MESSAGE );
}

catch(Exception e2)0
}
}

private void jlabel9MouseClicked(java.awt.event.MouseEvent evt) {

new Room_DETAILSO.showO;
this.hide();
I
 INTRODUCTION TO MySQL
MySQL is (as of March 2014) the world's second most widely used
open-source relational database management system (RDBMS).
It is named after co-founder Michael Widenius's daughter, My.
The SQL phrase stands for Structured Query Language.

The MySQL development project has made its source code

available under the terms of the GNU General Public License, as
well as under a variety of proprietary agreements. MySQL was
owned and sponsored by a single for-profit firm, the Swedish
company MySQL AB, now owned by Oracle Corporation.

MySQL is a popular choice of database for use in web

applications, and is a central component of the widely used LAMP
open source web application software stack (and other 'AMP'
stacks). LAMP is an acronym for "Linux, Apache, MySQL,
Perl/PHP/Python." Free-software-open source projects that
require a full-featured database management system often use
MySQL.

MySQL is a query language that provide several DDL, DML, DCL

and TCL commands that helps us in feeding, manipulating,
updating the information stored in tabular form.
It allows us to store and retrieve inter-related information.
Connectivity is a tool that enables us to retrieve, update, delete
data from MySQL tables using java program.
Screenshot of MySQL
 Bibliography

1. NetBeans IDE 7.1.2

2. Informatics Practises by Sumita Arora
3. www.icbse.com
4. www.wikipedia.org