Advanced Java Programming (3160707) 220220131013

A Laboratory Manual for

Advanced Java Programming

(3160707)

B.E. Semester 6th

(Computer Science and Engineering)

Directorate of Technical Education,

Gandhinagar, Gujarat
Advanced Java Programming (3160707) 220220131013

Government Engineering college, Patan

Certificate

This is to certify that Mr. Barot Sneh Sanjaykumar Enrollment No.

220220131013 Of B.E. Semester 6th from Computer Science and Engineering
of this Institute (GTU Code: 022) has satisfactorily completed the Practical
work for the subject Advanced Java Programming (3160707) for the
academic year 2024-25.

Place: __________________
Date: __________________

Name and Sign of Faculty member

Head of the Department

Advanced Java Programming (3160707) 220220131013

Index (Progressive
Assessment Sheet)

Sr. Objective(s) of Experiment Page Date of Date of Assessme Sign. of Remar

No. No. perform submiss nt Teacher ks
ance ion Marks with date
Implement TCP Server and client for
01 transferring files using Socket and 07
ServerSocket.
Implement UDP Server and client for
02 transferring files using DatagramSocket and 09
DatagramPacket.
03 Write code to Connect Java Application with
MySQL database. 11

Implement cookies to store firstname and 12

04 lastname using Java server pages.
Implement the shopping cart for users for the
05 online shooping. Apply the concept of session. 14
Implement student registration form with
06 enrolment number, firstname, lastname,
semester, contact number. Store the detail in 19
database. Also implement search,delete and
modify faculty for student records.
Design a Web project which demonstrate the
07 CRUD operations using servlet technology. 28
Design a web Page that takes the username from
08 user and if it is a valid username from user and
if it is a valid username prints “Welcome 33
Username”,Use JSF to implement.
Design a JAVA/Web application to demonstrate
09 hibernate framework. 36
Design a JAVA/Web applications to
10 demonstrate spring framework use of MVC 50
architecture is optional.
Total
Advanced Java Programming (3160707) 220220131013

Experiment No: 0

1. Vision & Mission

1.1.1 Vision of DTE

 To facilitate quality technical and professional education having relevance for

both industry and society,with moral and ethical values,giving equal
opportunity and access,aiming to prepare globally competent technocrats.

1.1.2 Mission of DTE

 Quality technical and professional education with continuous improvement of

all the resources and personnel
 To promote conducive ecosystem for Academic, Industry, Research,
Innovations and Startups
 To provide affordable quality professional education with moral values, equal
opportunities, accessibility and accountability
 To allocate competent and dedicated human resources and infrastructure to the
institutions for providing world-class professional education to become a
Global Leader (“Vishwa Guru”)

1.2.1 Vision of Government Engineering College, Patan

 To prepare Human Resource with value based competency for technical

advancements and growth of society.

1.2.2 Mission of Government Engineering College, Patan

 Deliver technical programs and services to cater the current needs of society
and industry, and to contribute in sustainable growth of society.

1.3.1 Vision of Computer science and engineering Department, Government

Engineering College, Patan

 To achieve excellence by providing value-based education in Computer

Science and Engineering through innovation, teamwork and ethical practices.

1.3.2 Mission of Computer science and engineering Department, Government

Engineering College, Patan
 To train graduates according to the needs of industry, government, society and
scientific community.
Advanced Java Programming (3160707) 220220131013

2. Program outcomes as prescribed by NBA

Engineering Graduates will be able to:

1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering

fundamentals, and an engineering specialization to the solution of complex engineering
problems.

2. Problem analysis: Identify, formulate, review research literature, and analyze complex
engineering problems reaching substantiated conclusions using first principles of mathematics,
natural sciences, and engineering sciences.

3. Design/development of solutions: Design solutions for complex engineering problems

and design system components or processes that meet the specified needs with appropriate
consideration for the public health and safety, and the cultural, societal, and environmental
considerations.

4. Conduct investigations of complex problems: Use research-based knowledge and

research methods including design of experiments, analysis and interpretation of data, and
synthesis of the information to provide valid conclusions.

5. Modern tool usage: Create, select, and apply appropriate techniques, resources, and
modern engineering and IT tools including prediction and modeling to complex
engineering activities with an understanding of the limitations.

6. The engineer and society: Apply reasoning informed by the contextual knowledge to
assess societal, health, safety, legal and cultural issues and the consequent responsibilities
relevant to the professional engineering practice.

7. Environment and sustainability: Understand the impact of the professional engineering

solutions in societal and environmental contexts, and demonstrate the knowledge of, and
need for sustainable development.

8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities
and norms of the engineering practice.

9. Individual and team work: Function effectively as an individual, and as a member or

leader in diverse teams, and in multidisciplinary settings.

10. Communication: Communicate effectively on complex engineering activities with the

engineering community and with society at large, such as, being able to comprehend and
write effective reports and design documentation, make effective presentations, and give
and receive clear instructions.

11. Project management and finance: Demonstrate knowledge and understanding of the
engineering and management principles and apply these to one’s own work, as a member
and leader in a team, to manage projects and in multidisciplinary environments.
Advanced Java Programming (3160707) 220220131013

12. Life-long learning: Recognize the need for, and have the preparation and ability to
engage in independent and life-long learning in the broadest context of technological
change.

3. PSOs of the Computer science and engineering Department, Government Engineering

College, Patan

1. Graduates will be able to explore and propose effective solutions to the problems in the area of
Computer Engineering as per the needs of society and industry.
2. Graduates will be able to apply standard practice and strategies to develop quality software
products using modern techniques, programming skills, tools & an open ended programming
environment and work in a team.
3. Graduates will manifest the skills of continuous learning in the fast changing field of
Computer Engineering.

4. Course outcomes of Advanced Java Programming course

CO-1: Implement Networking and Data base connectivity in Java for given application.

CO-2: Implement webpage with dynamic content and server side web application using Servlet and
JSP.

CO-3: Use web application framework JSF to build user interfaces.

CO-4: Use Object Relation Mapping using Hibernate to build database dependent applications.

CO-5: Apply Model-View-Controller architecture to build complex client-server applicatio

Advanced Java Programming (3160707) 220220131013

Practical – 1
Aim:-Implement TCP Server and client for transferring files using Socket and ServerSocket.

Code :-

TCP SERVER :-
import [Link].*;
import [Link].*;
class Pract1Server{
public static void main(String args[]) throws Exception {
ServerSocket ss = new ServerSocket(7777);
Socket s = [Link]();
[Link]("connected..........");
FileInputStream fin = new FileInputStream("[Link]");
DataOutputStream dout = new DataOutputStream([Link]());
int r;
while ((r = [Link]()) != -1) {
[Link](r);

}
[Link]("\nFiletranfer Completed");
[Link]();
[Link]();
}
}

TCP CLIENT :-
import [Link].*;
import [Link].*;
public class Pract1Client{
public static void main(String[] args) throws Exception {
Socket s = new Socket("[Link]", 7777);
if ([Link]()) {
[Link]("Connected to server");
}
FileOutputStream fout = new FileOutputStream("[Link]");
DataInputStream din = new DataInputStream([Link]());
int r;
while ((r = [Link]()) != -1) {
[Link]((char) r);
}
[Link]();
}
}

7
Advanced Java Programming (3160707) 220220131013

Output:-

8
Advanced Java Programming (3160707) 220220131013

Practical - 2
Aim:- Implement UDP Server and client for transferring files using DatagramSocket and DatagramPacket.

Code :-

UDP SERVER :-
import [Link];
import [Link];
import [Link];
import [Link];

public class Pract2Server{

public static void main(String[] args) {
final int PORT = 9876;
byte[] buffer = new byte[1024];

try (DatagramSocket serverSocket = new DatagramSocket(PORT)) {

DatagramPacket receivePacket = new DatagramPacket(buffer, [Link]);
[Link](receivePacket);

String fileName = new String([Link]()).trim();

[Link]("File name received: " + fileName);

FileOutputStream fileOutputStream = new FileOutputStream("received_" + fileName);

while (true) {
[Link](receivePacket);
buffer = [Link]();
[Link](buffer, 0, [Link]());

if ([Link]() < [Link]) {

break;
}
}

[Link]();
[Link]("File received successfully.");

} catch (IOException e) {
[Link]();
}
}
}

UDP CLIENT :-
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class Pract2Client {

public static void main(String[] args) {
final String SERVER_IP = "localhost";
final int SERVER_PORT = 9876;
byte[] buffer = new byte[1024];

try (DatagramSocket clientSocket = new DatagramSocket()) {

9
Advanced Java Programming (3160707) 220220131013

InetAddress serverAddress = [Link](SERVER_IP);

String fileName = "[Link]";

DatagramPacket sendPacket = new DatagramPacket([Link](), [Link](), serverAddress, SERVER_PORT);
[Link](sendPacket);

try (FileInputStream fileInputStream = new FileInputStream(fileName)) {

int bytesRead;

while ((bytesRead = [Link](buffer)) != -1) {

DatagramPacket packet = new DatagramPacket(buffer, bytesRead, serverAddress, SERVER_PORT);
[Link](packet);
}
}
[Link]("File sent successfully.");

} catch (IOException e) {
[Link]();
} }}

Output:-

10
Advanced Java Programming (3160707) 220220131013

Practical - 3
Aim:- Write code to Connect Java Application with MySQL database.

Code :-

package Pract3;
import [Link].*;
public class Pract3 {
public Connection con;

public static void main(String[] args) {

try{
[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/getconnect","root","Alankar@@1976");
if(con!=null){
[Link]("Successfully Connected");}
}catch(Exception e){
[Link]("Not Connected");
}}}

Output:-

11
Advanced Java Programming (3160707) 220220131013

Practical - 4
Aim:- Implement cookies to store firstname and lastname using Java server pages.

Code :-

[Link] :-
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Setting Cookies</title>
</head>
<body>
<h1>Setting Cookies</h1>
<form action="[Link]" method="GET">
First Name: <input type="text" name="first_name"><br /><br/>
Last Name: <input type="text" name="last_name" /><br/><br/><input type="submit" value="Submit" />
</form>
</body>
</html>

[Link] :-
<%
Cookie firstName = new Cookie("first_name", [Link]("first_name"));
Cookie lastName = new Cookie("last_name", [Link]("last_name"));
[Link](60 * 60);
[Link](60 * 60);
[Link](firstName);
[Link](lastName);
%>
<html>

<body>
<h1>Setting Cookies</h1>
<ul>
<b>First Name:</b>
<%=[Link]("first_name")%><br /><br/>
<b>Last Name:</b>
<%=[Link]("last_name")%>
</body>
</html>

12
Advanced Java Programming (3160707) 220220131013

Output:-

13
Advanced Java Programming (3160707) 220220131013

Practical-5
Aim:- Implement the shopping cart for users for the online shopping. Apply the concept of session.

Code :-

[Link]
<html>
<head>
<metacharset="ISO-8859-1">
<title>OnlineShoppingCart</title>
<linkrel="stylesheet"href="./[Link]">
</head>
<body>
<divclass="head">
<h1>LaptopStore</h1>
<hr>
</div>
<formaction="ShoppingCartServlet"method="post">
<divclass="body">
<divclass="card">
<div
class="hd">&nbsp;&nbsp;Mac
book
</div>
<divclass="img1">
</div>
<divclass="desc">
Description:AppleMacBookPro14M1ProchipmacOSMonterey
Laptop (16GB RAM, 512GB SSD)
<br><br>
<b>price:&#8377;189900</b>
<br><br>
<spanclass="crt"><inputtype="checkbox"name="laptop"
value="Macbook"> Add to cart </span><br><br>
</div>
</div>
<divclass="card">
<div
class="hd">&nbsp;&nbsp;Len
ovo
</div>
<divclass="img2">
</div>
<divclass="desc">
Description:LenovoLegion710thGenIntelCorei715.6inchFull HD
Gaming Laptop (16GB/1TB SSD)
<br><br>
<b>price:&#8377;143999</b>
<br><br>
<spanclass="crt"><inputtype="checkbox"name="laptop"
value="Lenovo"> Add to cart </span><br><br>
</div>
</div>
<divclass="card">
<div
class="hd">&nbsp;&nbsp;AS
14
Advanced Java Programming (3160707) 220220131013

US
</div>
<divclass="img3">
</div>
<divclass="desc">
Description:ASUSTUFGamingF15,15.6-inchFHD144Hz,IntelCore i5-
10300H 10th Gen (8GB RAM/512GB SSD)
<br><br>
<b>price:&#8377;63990</b>
<br><br>
<spanclass="crt"><inputtype="checkbox"name="laptop"
value="ASUS"> Add to cart </span><br><br>
</div>
</div>
</div>
<inputtype="submit"value="ViewCart">
</form>
</body>
</html>
[Link]
<html>
<head>
<metacharset="ISO-8859-1">
<title>OnlineShoppingCart</title>
<linkrel="stylesheet"href="./[Link]">
</head>
<body>
<divclass="head">
<h1>LaptopStore</h1>
<hr>
</div>
<formaction="ShoppingCartServlet"method="post">
<divclass="body">
<divclass="card">
<div
class="hd">&nbsp;&nbsp;Mac
book
</div>
<divclass="img1">
</div>
<divclass="desc">
Description:AppleMacBookPro14M1ProchipmacOSMonterey
Laptop (16GB RAM, 512GB SSD)
<br><br>
<b>price:&#8377;189900</b>
<br><br>
<spanclass="crt"><inputtype="checkbox"name="laptop"
value="Macbook"> Add to cart </span><br><br>
</div>
</div>
<divclass="card">
<div class="hd">&nbsp;&nbsp;Lenovo
15
Advanced Java Programming (3160707) 220220131013

</div>
<divclass="img2">
</div>
<divclass="desc">
Description:LenovoLegion710thGenIntelCorei715.6inchFull HD
Gaming Laptop (16GB/1TB SSD)
<br><br>
<b>price:&#8377;143999</b>
<br><br>
<spanclass="crt"><inputtype="checkbox"name="laptop"
value="Lenovo"> Add to cart </span><br><br>
</div>
</div>
<divclass="card">
<div
class="hd">&nbsp;&nbsp;AS
US
</div>
<divclass="img3">
</div>
<divclass="desc">
Description:ASUSTUFGamingF15,15.6-inchFHD144Hz,IntelCore i5-
10300H 10th Gen (8GB RAM/512GB SSD)
<br><br>
<b>price:&#8377;63990</b>
<br><br>
<spanclass="crt"><inputtype="checkbox"name="laptop"
value="ASUS"> Add to cart </span><br><br>
</div>
</div>
</div>
<inputtype="submit"value="ViewCart">
</form>
</body>
</html>

[Link]
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
[Link];
import [Link];
import [Link];
[Link];
@WebServlet("/Cart")
publicclassShoppingCartServletextendsHttpServlet{
private static final long serialVersionUID = 1L;
/**
*@see HttpServlet#HttpServlet()
16
 Advanced Java Programming (3160707) 220220131013

publicShoppingCartServlet(){
super();
//TODOAuto-generatedconstructorstub
}
/**
* @paramrequest
* @paramresponse
* @[Link]
* @[Link]
* @seeHttpServlet#doGet(HttpServletRequestrequest,
HttpServletResponse response)
*/
@Override
protectedvoiddoGet(HttpServletRequestrequest,
HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
[Link]().append("Servedat:").append([Link]());
[Link]("text/html");
Map<String,Integer>map=newHashMap<String,Integer>();
[Link]("Macbook", 189900);
[Link]("Lenovo",143999);
[Link]("ASUS",63990);
Stringnames[]=[Link]("laptop");
PrintWriter out = [Link]();
[Link]("<h1>Cart</h1>");
for(inti=0;i<[Link];i++){
int value = [Link](names[i]);
[Link](names[i]+"&emsp;"+value+"<br>");
}
intans=0;
for(inti=0;i<[Link];i++){
ans = ans + [Link](names[i]);
}
[Link](" <br>");
[Link]("Total&emsp;"+ans);
}
/**
* @paramresponse
* @[Link]
* @[Link]
* @see
* @paramrequestHttpServlet#doPost(HttpServletRequestrequest,
HttpServletResponse response)
*/

@Override
protected void doPost(HttpServletRequest
request,HttpServletResponseresponse)throwsServletException,IOExcep
tion{
//TODOAuto-generatedmethodstub
doGet(request, response);
}
}

17
Advanced Java Programming (3160707) 220220131013

Output:-

18
Advanced Java Programming (3160707) 220220131013

Practical-6
Aim:- Implement student registration form with enrolment number, firstname, lastname, semester,
contact number. Store the details in database. Also implement search, delete and modify facility for
student records.

Code:-
[Link]
import [Link];
[Link];
import [Link];
import [Link];
[Link];
import [Link];
import [Link];
import [Link];

/*
* Clicknbfs://nbhost/SystemFileSystem/Templates/Licenses/[Link]
* Clicknbfs://nbhost/SystemFileSystem/Templates/GUIForms/[Link]
*/

/**
*
* @authoradmin
*/
[Link]{
Connection con;
ResultSet rs;
PreparedStatementpst;
Stringurl="jdbc:mysql://localhost:3306/student_data";
String user="root";
Stringpass="Alankar@@1976";
public NewJFrame() {
initComponents();
try {
[Link]("[Link]");
con=[Link](url,user,pass);
pst=[Link]("select * from data");
rs=[Link]();
if([Link]()){
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
}
}
catch (ClassNotFoundException | SQLException e) {
[Link](this,"ErrorInConnectivity");
}
}

@SuppressWarnings("unchecked")
//<editor-folddefaultstate="collapsed"desc="GeneratedCode">
private void initComponents() {
19
Advanced Java Programming (3160707) 220220131013

jLabel1 = new [Link]();

jLabel2 = new [Link]();
jLabel3 = new [Link]();
lname=[Link]();
fname=[Link]();
enrollment=[Link]();
jButton1 = new [Link]();
jButton2 = new [Link]();
jButton3 = new [Link]();
jButton4 = new [Link]();
jLabel4 = new [Link]();
jLabel5 = new [Link]();
semester = new [Link]();
jLabel6 = new [Link]();
contact = new [Link]();

setDefaultCloseOperation([Link].EXIT_ON_CLOSE);
setFont(new [Link]("Arial", 1, 14)); // NOI18N
setForeground([Link](204,0,255));

[Link]("Enrollment Number");

[Link]("Last Name");

[Link]("First Name");

[Link](new [Link]() {
publicvoidactionPerformed([Link]){
lnameActionPerformed(evt);
}
});

[Link]([Link](){
public void actionPerformed([Link] evt) {
enrollmentActionPerformed(evt);
}
});

[Link]("Insert");
[Link]([Link](){
public void actionPerformed([Link] evt) {
jButton1ActionPerformed(evt);
}
});

[Link]("Search");
[Link]([Link](){
public void actionPerformed([Link] evt) {
jButton2ActionPerformed(evt);
}
});

[Link]("Update");
[Link]([Link](){
public void actionPerformed([Link] evt) {
jButton3ActionPerformed(evt);
}
20
Advanced Java Programming (3160707) 220220131013

});
[Link]("Delete");
[Link]([Link](){
public void actionPerformed([Link] evt) {
jButton4ActionPerformed(evt);
}
});

[Link]([Link]("SegoeUI",3,24));//NOI18N
[Link](new [Link](0, 102, 204));
[Link]("Student Registration Form");

[Link]("Semester");

[Link]("ContactNumber");

[Link]=[Link](getContentPane());
getContentPane().setLayout(layout);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGap(115,115,115)
.addGroup([Link]([Link])
.addGroup([Link]([Link],false)
.addComponent(jLabel1,[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel5,[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel2,[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel3,[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel6,[Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup([Link]()
.addComponent(jButton1)
.addGap(18,18,18)
.addComponent(jButton2)))
.addGroup([Link]([Link])
.addGroup([Link]()
.addPreferredGap([Link],
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup([Link]([Link],false)
.addComponent(contact)
.addComponent(semester)
.addComponent(enrollment,[Link].DEFAULT_SIZE,186,Short.MAX_VALUE)
.addComponent(fname)
.addComponent(lname))

.addGap(363,363,363))
.addGroup([Link]()
.addGap(18,18,18)
.addComponent(jButton3)
.addGap(18,18,18)
.addComponent(jButton4)
.addContainerGap([Link].DEFAULT_SIZE,Short.MAX_VALUE))))
21
Advanced Java Programming (3160707) 220220131013

.addGroup([Link]()
.addGap(130,130,130)
.addComponent(jLabel4,[Link].PREFERRED_SIZE,312,
[Link].PREFERRED_SIZE)
.addGap(0,0,Short.MAX_VALUE))
);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGap(22,22,22)
.addComponent(jLabel4)
.addGap(18,18,18)
.addGroup([Link]([Link])
.addComponent(jLabel1,[Link].PREFERRED_SIZE,22,
[Link].PREFERRED_SIZE)
.addComponent(enrollment, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,[Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel3,[Link].PREFERRED_SIZE,22,
[Link].PREFERRED_SIZE)
.addComponent(fname, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,[Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(lname, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,[Link].PREFERRED_SIZE)
.addComponent(jLabel2,[Link].PREFERRED_SIZE,22,
[Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel5)
.addComponent(semester, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,[Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel6)
.addComponent(contact, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE,[Link].PREFERRED_SIZE))
.addGap(18,18,18)
.addGroup([Link]([Link])
.addComponent(jButton2)
.addComponent(jButton1)
.addComponent(jButton3)
.addComponent(jButton4))
.addContainerGap(123,Short.MAX_VALUE))
);

pack();
setLocationRelativeTo(null);
}//</editor-fold>

privatevoidenrollmentActionPerformed([Link]){
//TODOaddyourhandlingcodehere:
}

privatevoidlnameActionPerformed([Link]){
22
Advanced Java Programming (3160707) 220220131013

//TODOaddyourhandlingcodehere:
}
privatevoidjButton4ActionPerformed([Link]){
//TODOaddyourhandlingcodehere:
try{
pst=[Link]("deletefromdatawhereenrollment=?");
[Link](1, [Link]());
[Link]();
[Link](this,"Success");
} catch (SQLException ex) {
[Link]([Link]()).log([Link],null,ex);
}
}
privatevoidjButton1ActionPerformed([Link]){
//TODOaddyourhandlingcodehere:
try{
pst=[Link]("insertintodata(enrollment,firstname,lastname,semester,contact)values(?,?,?,?,?)");
[Link](1,[Link]());
[Link](2,[Link]());
[Link](3,[Link]());
[Link](4,[Link]());
[Link](5,[Link]());
[Link]();
[Link](this,"Success");
} catch (SQLException ex) {
[Link]([Link]()).log([Link],null,ex);
}

}
privatevoidjButton2ActionPerformed([Link]){
//TODOaddyourhandlingcodehere:
Strings=[Link](this,"EnterEnrollmentforsearch");

try{
//TODOaddyourhandlingcodehere:

pst=[Link]("select*fromdatawhereenrollment=?");
[Link](1, s);
rs=[Link]();
if([Link]()){
[Link]([Link](1));

[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link](this,"Success");
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link],null,ex);
}
}

privatevoidjButton3ActionPerformed([Link]){
//TODOaddyourhandlingcodehere:
try{
pst=[Link]("updatedatasetfirstname=?,lastname=?,semester=?,contact=?whereenrollment=?");

23
Advanced Java Programming (3160707) 220220131013

[Link](1, [Link]());
[Link](2, [Link]());
[Link](3, [Link]());
[Link](4, [Link]());
[Link](5,[Link]());
[Link]();
[Link](this,"Success");
} catch (SQLException ex) {
[Link]([Link]()).log([Link],null,ex);
}
}

/**
*@paramargsthecommandlinearguments
*/
publicstaticvoidmain(Stringargs[]){
/*SettheNimbuslookandfeel*/
//<editor-folddefaultstate="collapsed"desc="Lookandfeelsettingcode(optional)">
/*IfNimbus(introducedinJavaSE6)isnotavailable,staywiththedefaultlookandfeel.
*Fordetailssee[Link]
*/
try{
for([Link]:[Link]()){ if
("Nimbus".equals([Link]())) {
[Link]([Link]());
break;
}
}
} catch (ClassNotFoundException ex) {
[Link]([Link]()).log([Link],null,ex);
} catch (InstantiationException ex) {
[Link]([Link]()).log([Link],null,ex);
} catch (IllegalAccessException ex) {
[Link]([Link]()).log([Link],null,ex);
} catch ([Link] ex) {
[Link]([Link]()).log([Link],null,ex);
}
//</editor-fold>
/* Create and display the form */
[Link](newRunnable(){
publicvoidrun(){
newNewJFrame().setVisible(true);
}
});
}

// Variables declaration - do not modify

private [Link] contact;
[Link];
private [Link] fname;
private [Link] jButton1;
private [Link] jButton2;
private [Link] jButton3;
private [Link] jButton4;
private [Link] jLabel1;private
[Link] jLabel2;private
[Link] jLabel3;

24
Advanced Java Programming (3160707) 220220131013

private [Link] jLabel4;

private [Link] jLabel5;
private [Link] jLabel6;
private [Link] lname;
[Link];
}

Output:-

25
Advanced Java Programming (3160707) 220220131013

26
Advanced Java Programming (3160707) 220220131013

27
Advanced Java Programming (3160707) 220220131013

Practical-7
Aim:- Design a web project which demonstrate the CRUD operations using servlet technology.

Code :-

Create Reservation OR Add Reservation Code:

package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class AddReservationServlet extends HttpServlet {

//private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

[Link]("text/html");
PrintWriter out = [Link]();

String userName=[Link]("user_name");
String guestName = [Link]("guest_name");
int roomNumber = [Link]([Link]("room_number"));
String contactNumber = [Link]("contact_number");
String checkIn = [Link]("check_in");
String checkOut = [Link]("check_out");
try {
Connection conn = [Link]();
String sql = "INSERT INTO reservations (user_name,guest_name,room_number,contact_number,check_in, check_out)
VALUES (?, ?, ?, ? ,?,?)";
PreparedStatement ps = [Link](sql);
[Link](1, userName);
[Link](2, guestName);
[Link](3, roomNumber);
[Link](4, contactNumber);
[Link](5, checkIn);
[Link](6, checkOut);

int rowsInserted = [Link]();

[Link]("<html><body>");
if (rowsInserted > 0) {
[Link]("<h2>Reservation Added Successfully!</h2>");
} else {
[Link]("<h2>Failed to Add Reservation.</h2>");
}
[Link]("</body></html>");
} catch (Exception e) {
[Link]();
[Link]("<h2>Error: " + [Link]() + "</h2>");
}
28
Advanced Java Programming (3160707) 220220131013

}
}

Read Reservation OR View Reservation Code:

package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class ViewReservationServlet extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

[Link]("text/html");
PrintWriter out = [Link]();

HttpSession session = [Link](false);

if (session == null || [Link]("username") == null) {
[Link]("[Link]"); // Redirect if not logged in
return;
}

String username = (String) [Link]("username");

String role = (String) [Link]("role"); // Assuming role is stored in session as "admin" or "customer"

try (Connection con = [Link]()) {

String query;
PreparedStatement ps;

if ("admin".equals(role)) {
// Admin: Fetch all reservations
query = "SELECT * FROM reservations";
ps = [Link](query);
} else {
// Customer: Fetch only their reservations
query = "SELECT * FROM reservations WHERE user_name = ?";
ps = [Link](query);
[Link](1, username);
}

ResultSet rs = [Link]();

[Link]("<html><head><title>View Reservations</title></head><body>");
[Link]("<h2>Reservation List</h2>");
[Link]("<table border='1'>");
[Link]("<tr><th>ID</th><th>Username</th><th>Room Number</th><th>Check-In</th><th>Check-Out</th></tr>");

boolean hasData = false;

while ([Link]()) {
hasData = true;
[Link]("<tr>");
[Link]("<td>" + [Link]("id") + "</td>");
[Link]("<td>" + [Link]("user_name") + "</td>");
[Link]("<td>" + [Link]("room_number") + "</td>");
29
Advanced Java Programming (3160707) 220220131013

[Link]("<td>" + [Link]("check_in") + "</td>");

[Link]("<td>" + [Link]("check_out") + "</td>");
[Link]("</tr>");
}

if (!hasData) {
[Link]("<tr><td colspan='5'>No reservations found.</td></tr>");
}

[Link]("</table>");

if ("admin".equals(role)) {
[Link]("<br><a href='[Link]'>Back to Dashboard</a>");
} else {
[Link]("<br><a href='[Link]'>Back to Dashboard</a>");
}

[Link]("</body></html>");

} catch (Exception e) {
[Link]();
[Link]("<h3>Error: " + [Link]() + "</h3>");
}
}
}

Update Reservation Code:

package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class UpdateReservationServlet extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
[Link]("text/html");
PrintWriter out = [Link]();

int reservationId = [Link]([Link]("id"));

int roomNumber= [Link]([Link]("room_number"));

String checkIn = [Link]("check_in");
String checkOut = [Link]("check_out");

try {

Connection conn = [Link]();

String sql = "UPDATE reservations SET room_number=?, check_in=?, check_out=? WHERE id=?";
PreparedStatement ps = [Link](sql);
[Link](1,roomNumber);
[Link](2, checkIn);
[Link](3, checkOut);
[Link](4, reservationId);

int rowsInserted= [Link]();

30
Advanced Java Programming (3160707) 220220131013

[Link]("<html><body>");
if (rowsInserted > 0) {
[Link]("<h2>Reservation Updated Successfully!</h2>");
} else {
[Link]("<h2>Failed to Update Reservation.</h2>");
}
[Link]("</body></html>");
} catch (Exception e) {
[Link]();
[Link]("<h2>Error: " + [Link]() + "</h2>");
}
}
}

Delete Reservation Code:

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class DeleteReservationServlet extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
[Link]("text/html");
PrintWriter out= [Link]();
int reservationId = [Link]([Link]("id"));

try {
Connection conn = [Link]();
String sql = "DELETE FROM reservations WHERE id=?";
PreparedStatement ps = [Link](sql);
[Link](1, reservationId);
int rowsInserted= [Link]();
[Link]("<html><body>");
if (rowsInserted > 0) {
[Link]("<h2>Reservation Deleted Successfully!</h2>");
} else {
[Link]("<h2>Failed to Delete Reservation.</h2>");
}
[Link]("</body></html>");
} catch (Exception e) {
[Link]();
[Link]("<h2>Error: " + [Link]() + "</h2>");
}
}
}

31
Advanced Java Programming (3160707) 220220131013

Output:

32
Advanced Java Programming (3160707) 220220131013

Practical-8
Aim:- Design a web page that takes the Username from user and if it is a valid username from user and if it
is a valid username prints “Welcome Username”. Use JSF to implement.

Code :-
[Link]
<?xmlversion='1.0'encoding='UTF-8'?>
<!DOCTYPEhtml>
<htmlxmlns="[Link]
<h:head>
<title>login</title>
</h:head>
<h:body>
<h2>210220131103-Prac8</h2>
<hr>
<h:form>
<h3>JSFLoginLogout</h3>
<h:outputTextvalue="Username"/>
<h:inputTextid="username"value="#{[Link]}"></h:inputText>
<h:messagefor="username"></h:message>
<br></br><br></br>

<h:outputTextvalue="Password"/>
<h:inputSecretid="password"value="#{[Link]}"></h:inputSecretinputSecret><h:message
for="password"></h:message>
<br></br><br></br>

<h:commandButtonaction="#{[Link]}"value="Login"></h:commandButton>
</h:form>
</h:body>
</html>

[Link]
[Link];
[Link];
[Link];
import [Link];
import [Link]
import [Link];
import [Link];
import [Link];
[Link];

@ManagedBean@SessionScoped
publicclassLoginimplementsSerializable{
privatestaticfinallongserialVersionUID=1094801825228386363L;
private String pwd;
privateStringmsg;
privateStringuser;

publicStringgetPwd(){returnpwd;}
public void setPwd(String pwd) {
[Link] = pwd; }
publicStringgetMsg(){returnmsg;}
publicvoidsetMsg(Stringmsg){[Link]=msg;}
33
Advanced Java Programming (3160707) 220220131013

publicStringgetUser(){returnuser;}
publicvoidsetUser(Stringuser){[Link]=user;}
//validate login public String
validateUsernamePassword(){
booleanvalid=[Link](user,pwd);if(valid){
HttpSessionsession=[Link]();[Link]("username",user); return
"admin";
}else{
[Link]().add Message( null,
newFacesMessage(FacesMessage.SEVERITY_WARN,
"Incorrect Username and Passowrd",
"PleaseentercorrectusernameandPassword")); return
"login";
}
}
//logoutevent,invalidatesessionpublicStringlogout(){
HttpSessionsession=[Link]();[Link]();return"login";
}
}

[Link]
package [Link];
[Link];importj
[Link]; import
[Link];
[Link];
[Link];
public class LoginDAO {
publicstaticbooleanvalidateStringuser,Stringpassword)
Connection con = null;
PrearedStatementPS=null;
try {
con= [Link]();
ps=[Link]("Selectuname,passwordfromUserswhereuname =?andpassword=?");[Link](1, user);
[Link](2, password);
ResultSetrs=[Link](); if
([Link]()) {
//resultfound,meansvalidinputsreturntrue;
}
returnfalse;
}catch(SQLExceptionex){
[Link]("Loginerror"+[Link]());returnfalse;[Link](con);
}
}

[Link]
<?xmlversion='1.0'encoding='UTF-8'?>
<faces-config version="2.2" xmlns="[Link]
xmlns:xsi="[Link]
[Link]
<navigation-rule>
<from-view-id>/[Link]</from-view-id>
<navigation-case>
<from-outcome>admin</from-outcome>
<to-view-id>/[Link]</to-view-id>
</navigation-case>
</navigation-rule>
</faces-config>
34
Advanced Java Programming (3160707) 220220131013

[Link]
[Link];
import [Link];
import [Link];
public class DataConnect {
public static Connection getConnection() { try {
[Link]("[Link]"); Connection con =
[Link]("jdbc:mysql://localhost:3306/jsfdemo",
"root", " Alankar@@1976");
returncon;
}catch(Exceptionex){[Link]("[Link]()Error"
+[Link]());
return null;
}
}
publicstaticvoidclose(Connectioncon){try{ [Link]();
}catch(Exceptionex){[Link](ex);}
}
}

Output:-

35
Advanced Java Programming (3160707) 220220131013

Practical-9
Aim:- Design a Java/Web application to demonstrate hibernate framework.

Code:-

[Link]

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"[Link]

<hibernate-configuration>
<session-factory>
<property name="[Link].driver_class">[Link]</property>
<property name="[Link]">jdbc:mysql://localhost:3306/hotel_db</property>
<property name="[Link]">root</property>
<property name="[Link]">UTsav@9975</property>
<property name="[Link]">[Link].MySQL8Dialect</property>
<property name="hibernate.show_sql">true</property>
<property name="[Link]">update</property>

<mapping class="[Link]"/>
<mapping class="[Link]"/>
<mapping resource="[Link]"/>
<mapping resource="[Link]"/>
</session-factory>
</hibernate-configuration>

[Link]

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"[Link]

<hibernate-configuration>
<session-factory>
<property name="[Link].driver_class">[Link]</property>
<property name="[Link]">jdbc:mysql://localhost:3306/hotel_db</property>
<property name="[Link]">root</property>
<property name="[Link]">UTsav@9975</property>
<property name="[Link]">[Link].MySQL8Dialect</property>
<property name="hibernate.show_sql">true</property>
<property name="[Link]">update</property>

<mapping class="[Link]"/>
<mapping class="[Link]"/>
<mapping resource="[Link]"/>
<mapping resource="[Link]"/>
</session-factory>
</hibernate-configuration>

36
Advanced Java Programming (3160707) 220220131013

[Link]
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"[Link]

<hibernate-mapping>
<class name="[Link]" table="reservations">

<!-- Primary Key -->

<id name="id" column="id">
<generator class="identity"/>
</id>

<!-- Properties (MUST MATCH `[Link]`) -->

<property name="userName" column="userName" />
<property name="guestName" column="guestName" />
<property name="roomNumber" column="roomNumber" />
<property name="contactNumber" column="contactNumber" />
<property name="checkIn" column="checkIn" />
<property name="checkOut" column="checkOut" />

</class>
</hibernate-mapping>

[Link]

package [Link];

import [Link];
import [Link];

public class HibernateUtil {

private static final SessionFactory sessionFactory;

static {
try {
// Load [Link] and build SessionFactory
sessionFactory = new Configuration().configure("[Link]").buildSessionFactory();
} catch (Throwable ex) {
[Link]("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
}

public static SessionFactory getSessionFactory() {

return sessionFactory;
}
}

37
Advanced Java Programming (3160707) 220220131013

[Link]

package [Link];

/**
*
* @author DISHITA
*/
public class Users {
private int id;
private String username;
private String password;
private String role; // Changed from Role enum to String

// Default constructor
public Users() {}

// Constructor
public Users(int id, String username, String password, String role) {
[Link] = id;
[Link] = username;
[Link] = password;
[Link] = role;
}

// Getters and Setters

public int getId() {
return id;
}

public void setId(int id) {

[Link] = id;
}

public String getUsername() {

return username;
}

public void setUsername(String username) {

[Link] = username;
}

public String getPassword() {

return password;
}

public void setPassword(String password) {

[Link] = password;
}

public String getRole() {

return role;
}

public void setRole(String role) {

[Link] = role; // Directly setting the role as a string
}

@Override
public String toString() {
return "User{id=" + id + ", username='" + username + "', role=" + role + "}";
}
}
38
Advanced Java Programming (3160707) 220220131013

[Link]

package [Link];

public class Reservations {

private int id;

private String userName;
private String guestName;
private String roomNumber;
private String contactNumber;
private String checkIn;
private String checkOut;

public Reservations() {}

public int getId() {

return id;
}

public void setId(int id) {

[Link] = id;
}

public String getUserName() {

return userName;
}

public void setUserName(String userName) {

[Link] = userName;
}

public String getGuestName() {

return guestName;
}

public void setGuestName(String guestName) {

[Link] = guestName;
}

public String getRoomNumber() {

return roomNumber;
}

public void setRoomNumber(String roomNumber) {

[Link] = roomNumber;
}

public String getContactNumber() {

return contactNumber;
}

public void setContactNumber(String contactNumber) {

[Link] = contactNumber;
}

public String getCheckIn() {

return checkIn;
}

39
Advanced Java Programming (3160707) 220220131013

public void setCheckIn(String checkIn) {

[Link] = checkIn;
}

public String getCheckOut() {

return checkOut;
}

public void setCheckOut(String checkOut) {

[Link] = checkOut;
}
}

[Link]

package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

/**
*
* @author DISHITA
*/
public class UserDAO {

public String saveUser(Users user) {

Transaction transaction = null;
try (Session session = [Link]().openSession()) {
transaction = [Link]();

Query<Users> query = [Link]("FROM Users WHERE username = :username", [Link]);

[Link]("username", [Link]());
Users existingUser = [Link]();

if (existingUser != null) {
return "Username already exists! Choose another one.";
}

[Link](user);
[Link]();
return "Registration successful! Redirecting to login...";
} catch (Exception e) {
if (transaction != null) [Link]();
[Link]();
return "Registration failed due to an error!";
}
}

public Users validateUser(String username, String password) {

try (Session session = [Link]().openSession()) {
String hql = "FROM Users WHERE username = :username AND password = :password";
Query<Users> query = [Link](hql, [Link]);
[Link]("username", username);

40
Advanced Java Programming (3160707) 220220131013

[Link]("password", password);
return [Link](); // Returns a single result or null
} catch (Exception e) {
[Link]();
return null;
}
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

public class ReservationDAO {

private SessionFactory sessionFactory;

public void setSessionFactory(SessionFactory sessionFactory) {

[Link] = sessionFactory;
}

public void addReservation(Reservations reservation) {

try (Session session = [Link]()) {
[Link]();
[Link](reservation);
[Link]().commit();
}
}

public Reservations getReservationById(int id) {

try (Session session = [Link]()) {
return [Link]([Link], id);
}
}

public List<Reservations> getAllReservations() {

try (Session session = [Link]()) {
return [Link]("FROM Reservations", [Link]).list();
}
}

public List<Reservations> getReservationsByUsername(String username) {

try (Session session = [Link]()) {
Query<Reservations> query = [Link]("FROM Reservations WHERE userName = :username",
[Link]);
[Link]("username", username);
return [Link]();
}
}

public void updateReservation(Reservations reservation) {

try (Session session = [Link]()) {
[Link]();
[Link](reservation); // safer than update
[Link]().commit();
}

41
Advanced Java Programming (3160707) 220220131013

public boolean deleteReservation(int id) {

try (Session session = [Link]()) {
[Link]();
Reservations r = [Link]([Link], id);
if (r != null) {
[Link](r);
[Link]().commit();
return true;
}
[Link]().commit();
return false;
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link].*;

import [Link];
import [Link];

public class AddReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {
reservationDAO = new ReservationDAO();
[Link]([Link]());
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

HttpSession session = [Link](false);

String username = (session != null) ? (String) [Link]("username") : null;
String role = (session != null) ? (String) [Link]("role") : null;

if (username == null || role == null) {

[Link]("error", "You must be logged in to add a reservation.");
[Link]("[Link]").forward(request, response);
return;
}

try {
Reservations reservation = new Reservations();
[Link](username);
[Link]([Link]("guestName"));
[Link]([Link]("roomNumber"));
[Link]([Link]("contactNumber"));
42
Advanced Java Programming (3160707) 220220131013

[Link]([Link]("checkIn"));
[Link]([Link]("checkOut"));

[Link](reservation);
[Link]("message", "Reservation added successfully!");

} catch (Exception e) {
[Link]("error", "Failed to add reservation: " + [Link]());
}

List<Reservations> reservations = "ADMIN".equalsIgnoreCase(role)

? [Link]()
: [Link](username);

[Link]("reservations", reservations);
[Link]("[Link]").forward(request, response);
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link].*;

import [Link];

public class DeleteReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {
reservationDAO = new ReservationDAO();
[Link]([Link]());
}

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String idStr = [Link]("id");

if (idStr == null || [Link]()) {

[Link]("error", "Reservation ID is missing.");
[Link]("[Link]").forward(request, response);
return;
}

try {
int id = [Link](idStr);
Reservations reservation = [Link](id);
if (reservation == null) {
[Link]("error", "Reservation not found.");
} else {
[Link]("reservation", reservation);
}
43
Advanced Java Programming (3160707) 220220131013

} catch (NumberFormatException e) {
[Link]("error", "Invalid reservation ID format.");
} catch (Exception e) {
[Link]("error", "Error retrieving reservation: " + [Link]());
}

[Link]("[Link]").forward(request, response);
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String idStr = [Link]("id");

HttpSession session = [Link](false);
String role = (session != null) ? (String) [Link]("role") : null;

if (idStr == null || [Link]()) {

[Link]("error", "Reservation ID is required.");
redirectToDashboard(role, request, response);
return;
}

try {
int id = [Link](idStr);
boolean success = [Link](id);

if (success) {
[Link]("message", "Reservation deleted successfully.");
} else {
[Link]("error", "Reservation not found or already deleted.");
}
} catch (NumberFormatException e) {
[Link]("error", "Invalid reservation ID format.");
} catch (Exception e) {
[Link]("error", "Failed to delete reservation: " + [Link]());
}

redirectToDashboard(role, request, response);

}

private void redirectToDashboard(String role, HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {
if ("ADMIN".equalsIgnoreCase(role)) {
[Link]("[Link]").forward(request, response);
} else {
[Link]("[Link]").forward(request, response);
}
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
44
Advanced Java Programming (3160707) 220220131013

import [Link];

public class LoginReservationServlet extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String username = [Link]("username");

String password = [Link]("password");

UserDAO userDAO = new UserDAO();

Users user = [Link](username, password);

if (user != null) {
// Create session and store user info
HttpSession session = [Link]();
[Link]("username", [Link]());
[Link]("role", [Link]());

if ([Link]().equalsIgnoreCase("ADMIN")) {
[Link]("[Link]");
} else {
[Link]("[Link]");
}

} else {
[Link]("error", "Invalid username or password.");
[Link]("[Link]").forward(request, response);
}
}
}

[Link]

package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class LogoutServlet extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

HttpSession session = [Link](false);

if (session != null) {
[Link]("user"); // Optional: Remove specific session attribute
[Link](); // Invalidate the session
}
[Link]("[Link]?message=You have been logged out successfully.");
}
}

45
Advanced Java Programming (3160707) 220220131013

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class RegisterReservationServlet extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String username = [Link]("username");

String password = [Link]("password");
String role = [Link]("role");

Users user = new Users();

[Link](username);
[Link](password);
[Link](role);

UserDAO dao = new UserDAO();

String resultMessage = [Link](user);

[Link]("message", resultMessage);

[Link]("[Link]").forward(request, response);
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link].*;

import [Link];

public class UpdateReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {
reservationDAO = new ReservationDAO();
[Link]([Link]()); // important
}

@Override

46
Advanced Java Programming (3160707) 220220131013

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String idStr = [Link]("id");

HttpSession session = [Link](false);

try {
int id = [Link](idStr);
Reservations reservation = [Link](id);

if (reservation != null) {
[Link]([Link]("guestName"));
[Link]([Link]("roomNumber"));
[Link]([Link]("contactNumber"));
[Link]([Link]("checkIn"));
[Link]([Link]("checkOut"));

[Link](reservation);

}
} catch (Exception e) {

[Link]("ViewReservationsServlet");
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link].*;

import [Link];
import [Link];

public class ViewReservationsServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {

reservationDAO = new ReservationDAO();

[Link]([Link]());
}

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

HttpSession session = [Link](false);

if (session == null || [Link]("username") == null || [Link]("role") == null) {

[Link]("[Link]");
return;
47
Advanced Java Programming (3160707) 220220131013

String username = (String) [Link]("username");

String role = (String) [Link]("role");

String action = [Link]("action");

String idParam = [Link]("id");

try {

if ("edit".equalsIgnoreCase(action) && idParam != null) {

int id = [Link](idParam);
Reservations reservation = [Link](id);

if (reservation != null) {
[Link]("reservation", reservation);
[Link]("[Link]").forward(request, response);
return;
} else {
[Link]("error", "Reservation not found.");
[Link]("[Link]").forward(request, response);
return;
}
}

List<Reservations> reservations;
if ("ADMIN".equalsIgnoreCase(role)) {
reservations = [Link]();
} else {
reservations = [Link](username);
}

[Link]("reservations", reservations);
[Link]("[Link]").forward(request, response);

} catch (Exception e) {
[Link]("error", "Error fetching reservations: " + [Link]());
[Link]("[Link]").forward(request, response);
}
}
}

Output:

48
Advanced Java Programming (3160707) 220220131013

49
 Advanced Java Programming (3160707) 220220131013

Practical-10
Aim:- Design a Java/Web application to demonstrate spring framework. Use of MVC
architecture is optional.

Code:-
[Link]

<beans xmlns="[Link]
xmlns:xsi="[Link]
xsi:schemaLocation="[Link]
[Link]

<!-- DataSource Bean -->

<bean id="dataSource" class="[Link]">
<property name="driverClassName" value="[Link]"/>
<property name="url" value="jdbc:mysql://localhost:3306/hotel_db"/>
<property name="username" value="root"/>
<property name="password" value="UTsav@9975"/>
</bean>

<!-- JdbcTemplate Bean -->

<bean id="jdbcTemplate" class="[Link]">
<property name="dataSource" ref="dataSource"/>
</bean>

<!-- Reservation DAO Bean -->

<bean id="reservationDAO" class="[Link]">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>

<!-- User DAO Bean -->

<bean id="userDAO" class="[Link]">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>

</beans>

[Link]

package [Link];

/**
*
* @author DISHITA
*/
public class User {
private int id;
private String username;
private String password;
private String role;

50
Advanced Java Programming (3160707) 220220131013

// Getters and setters

public int getId() { return id; }
public void setId(int id) { [Link] = id; }

public String getUsername() { return username; }

public void setUsername(String username) { [Link] = username; }

public String getPassword() { return password; }

public void setPassword(String password) { [Link] = password; }

public String getRole() { return role; }

public void setRole(String role) { [Link] = role; }
}

[Link]

package [Link];

public class Reservation {

private int id;
private String userName;
private String guestName;
private String roomNumber;
private String contactNumber;
private String checkIn;
private String checkOut;

public int getId() {

return id;
}

public void setId(int id) {

[Link] = id;
}

public String getUserName() {

return userName;
}

public void setUserName(String userName) {

[Link] = userName;
}

public String getGuestName() {

return guestName;
}

public void setGuestName(String guestName) {

[Link] = guestName;
}

public String getRoomNumber() {

return roomNumber;
}

public void setRoomNumber(String roomNumber) {

[Link] = roomNumber;
}

51
Advanced Java Programming (3160707) 220220131013

public String getContactNumber() {

return contactNumber;
}

public void setContactNumber(String contactNumber) {

[Link] = contactNumber;
}

public String getCheckIn() {

return checkIn;
}

public void setCheckIn(String checkIn) {

[Link] = checkIn;
}

public String getCheckOut() {

return checkOut;
}

public void setCheckOut(String checkOut) {

[Link] = checkOut;
}
}

[Link]

package [Link];

import [Link];
import [Link];

public class UserDAO {

private JdbcTemplate jdbcTemplate;

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {

[Link] = jdbcTemplate;
}

public boolean validateUser(String username, String password) {

String query = "SELECT COUNT(*) FROM users WHERE username = ? AND password = ?";
int count = [Link](query, [Link], username, password);
return count > 0;
}

public String getRoleByUsername(String username) {

String sql = "SELECT role FROM users WHERE username = ?";
try {
return [Link](sql, [Link], username);
} catch (Exception e) {
return null;
}
}

52
Advanced Java Programming (3160707) 220220131013

public boolean saveUser(User user) {

String sql = "INSERT INTO users (username, password, role) VALUES (?, ?, ?)";
int rows = [Link](sql, [Link](), [Link](), [Link]());
return rows > 0;
}

public boolean userExists(String username) {

String sql = "SELECT COUNT(*) FROM users WHERE username = ?";
int count = [Link](sql, [Link], username);
return count > 0;
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];

public class ReservationDAO {

private JdbcTemplate jdbcTemplate;

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {

[Link] = jdbcTemplate;
}

public Reservation getReservationById(int id) {

String sql = "SELECT * FROM reservations WHERE id = ?";
try {
return [Link](sql, new Object[]{id}, new ReservationRowMapper());
} catch (EmptyResultDataAccessException e) {
return null; // Return null if no reservation is found
}
}

public void addReservation(Reservation reservation) {

String sql = "INSERT INTO reservations (userName, guestName, roomNumber, contactNumber,
checkIn, checkOut) VALUES (?, ?, ?, ?, ?, ?)";
[Link](sql,
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link]()
);
}

53
Advanced Java Programming (3160707) 220220131013

public List<Reservation> getAllReservations() {

String sql = "SELECT * FROM reservations";
return [Link](sql, new ReservationRowMapper());
}

public List<Reservation> getReservationsByUser(String username) {

String sql = "SELECT * FROM reservations WHERE userName = ?";
return [Link](sql, new ReservationRowMapper(), username);
}

public void updateReservation(Reservation reservation) {

String sql = "UPDATE reservations SET guestName = ?, roomNumber = ?, contactNumber = ?,
checkIn = ?, checkOut = ? WHERE id = ?";
[Link](sql,
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link]() // Corrected: Update by 'id' instead of 'username'
);
}

public void deleteReservation(int id) {

String sql = "DELETE FROM reservations WHERE id = ?";
[Link](sql, id);
}

private static class ReservationRowMapper implements RowMapper<Reservation> {

@Override
public Reservation mapRow(ResultSet rs, int rowNum) throws SQLException {
Reservation r = new Reservation();
[Link]([Link]("id"));
[Link]([Link]("userName"));
[Link]([Link]("guestName"));
[Link]([Link]("roomNumber"));
[Link]([Link]("contactNumber"));
[Link]([Link]("checkIn"));
[Link]([Link]("checkOut"));
return r;
}
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

54
Advanced Java Programming (3160707) 220220131013

import [Link].*;
import [Link];

public class AddReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {

ApplicationContext context = new ClassPathXmlApplicationContext("[Link]");

reservationDAO = (ReservationDAO) [Link]("reservationDAO");
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

HttpSession session = [Link]();

String username = (String) [Link]("username");

if (username == null) {
[Link]("error", "You must be logged in to add a reservation.");
[Link]("[Link]").forward(request, response);
return;
}

String guestName = [Link]("guestName");

String roomNumber = [Link]("roomNumber");
String contactNumber = [Link]("contactNumber");
String checkIn = [Link]("checkIn");
String checkOut = [Link]("checkOut");

Reservation reservation = new Reservation();

[Link](username);
[Link](guestName);
[Link](roomNumber);
[Link](contactNumber);
[Link](checkIn);
[Link](checkOut);

[Link](reservation);

[Link]("message", "Reservation\n" +
" // Inform the user and forward to the view reservations page\n" +
" added successfully!");
[Link]("[Link]").forward(request, response);
}
}

55
Advanced Java Programming (3160707) 220220131013

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link].*;

import [Link];

public class DeleteReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {
reservationDAO = new ReservationDAO();
[Link]([Link]());
}

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String idStr = [Link]("id");

if (idStr == null || [Link]()) {

[Link]("error", "Reservation ID is missing.");
[Link]("[Link]").forward(request, response);
return;
}

try {
int id = [Link](idStr);
Reservations reservation = [Link](id);
if (reservation == null) {
[Link]("error", "Reservation not found.");
} else {
[Link]("reservation", reservation);
}
} catch (NumberFormatException e) {
[Link]("error", "Invalid reservation ID format.");
} catch (Exception e) {
[Link]("error", "Error retrieving reservation: " + [Link]());
}

[Link]("[Link]").forward(request, response);
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String idStr = [Link]("id");

HttpSession session = [Link](false);
String role = (session != null) ? (String) [Link]("role") : null;

56
Advanced Java Programming (3160707) 220220131013

if (idStr == null || [Link]()) {

[Link]("error", "Reservation ID is required.");
redirectToDashboard(role, request, response);
return;
}

try {
int id = [Link](idStr);
boolean success = [Link](id);

if (success) {
[Link]("message", "Reservation deleted successfully.");
} else {
[Link]("error", "Reservation not found or already deleted.");
}
} catch (NumberFormatException e) {
[Link]("error", "Invalid reservation ID format.");
} catch (Exception e) {
[Link]("error", "Failed to delete reservation: " + [Link]());
}

redirectToDashboard(role, request, response);

}

private void redirectToDashboard(String role, HttpServletRequest request, HttpServletResponse

response)
throws ServletException, IOException {
if ("ADMIN".equalsIgnoreCase(role)) {
[Link]("[Link]").forward(request, response);
} else {
[Link]("[Link]").forward(request, response);
}
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];

import [Link];
import [Link].*;

import [Link];

public class LoginServlet extends HttpServlet {

private UserDAO userDAO;

@Override
public void init() {
ApplicationContext context = new ClassPathXmlApplicationContext("[Link]");
userDAO = (UserDAO) [Link]("userDAO");
}

57
Advanced Java Programming (3160707) 220220131013

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String username = [Link]("username");

String password = [Link]("password");

if ([Link](username, password)) {
String role = [Link](username);

// Create session and store username and role

HttpSession session = [Link]();
[Link]("username", username);
[Link]("role", role);

// Redirect based on role

if ("ADMIN".equalsIgnoreCase(role)) {
[Link]("[Link]");
} else if ("CUSTOMER".equalsIgnoreCase(role)) {
[Link]("[Link]");
} else {
[Link]();
[Link]("error", "Invalid role assigned to user.");
[Link]("[Link]").forward(request, response);
}
} else {
[Link]("error", "Invalid username or password.");
[Link]("[Link]").forward(request, response);
}
}
}

[Link]

package [Link];

import [Link];
import [Link].*;
import [Link];

public class LogoutServlet extends HttpServlet {

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

HttpSession session = [Link](false);

if (session != null) {
[Link]();
}

[Link]("message", "You have been logged out successfully.");

[Link]("[Link]").forward(request, response);
}
}

58
Advanced Java Programming (3160707) 220220131013

[Link]

package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class RegisterServlet extends HttpServlet {

private UserDAO userDAO;

@Override
public void init() {
ApplicationContext context = new ClassPathXmlApplicationContext("[Link]");
userDAO = (UserDAO) [Link]("userDAO");
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String username = [Link]("username");

String password = [Link]("password");

User user = new User();

[Link](username);
[Link](password);
[Link]("customer"); // Default role for registered users

if ([Link](user)) {
[Link]("[Link]");
} else {
[Link]().println("Registration Failed!");
}
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link].*;
import [Link];
import [Link];

59
Advanced Java Programming (3160707) 220220131013

public class UpdateReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

@Override
public void init() {
ApplicationContext context = new ClassPathXmlApplicationContext("[Link]");
reservationDAO = (ReservationDAO) [Link]("reservationDAO");
}

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String idParam = [Link]("id");

if (idParam == null || [Link]().isEmpty()) {

[Link]("[Link]?error=" + [Link]("Missing
reservation ID", "UTF-8"));
return;
}

try {
int id = [Link]([Link]());
Reservation reservation = [Link](id);

if (reservation != null) {
[Link]("reservation", reservation);
[Link]("[Link]").forward(request, response);
} else {
[Link]("error", "Reservation not found.");
[Link]("[Link]").forward(request, response);
}
} catch (NumberFormatException e) {
[Link]("error", "Invalid reservation ID.");
[Link]("[Link]").forward(request, response);
}
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String idParam = [Link]("id");

if (idParam == null || [Link]().isEmpty()) {

[Link]("[Link]?error=" + [Link]("Missing
reservation ID", "UTF-8"));
return;
}

try {
int id = [Link]([Link]());
Reservation existingReservation = [Link](id);
if (existingReservation == null) {
[Link]("[Link]?error=" + [Link]("Reservation
not found", "UTF-8"));
return;
}

60
Advanced Java Programming (3160707) 220220131013

// Get updated form values

String guestName = [Link]("guestName");
String roomNumber = [Link]("roomNumber");
String checkIn = [Link]("checkIn");
String checkOut = [Link]("checkOut");

if (guestName == null || [Link]().isEmpty()

|| roomNumber == null || [Link]().isEmpty()
|| checkIn == null || [Link]().isEmpty()
|| checkOut == null || [Link]().isEmpty()) {
[Link]("[Link]?error=" + [Link]("All fields must
be filled out", "UTF-8"));
return;
}

[Link](guestName);
[Link](roomNumber);
[Link](checkIn);
[Link](checkOut);

[Link](existingReservation);

[Link]("[Link]?success=" + [Link]("Reservation
updated successfully", "UTF-8"));

} catch (NumberFormatException e) {
[Link]("[Link]?error=" + [Link]("Invalid
reservation ID", "UTF-8"));
} catch (Exception e) {
[Link]();
[Link]("[Link]?error=" + [Link]("Update failed",
"UTF-8"));
}
}
}

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class ViewReservationServlet extends HttpServlet {

private ReservationDAO reservationDAO;

61
Advanced Java Programming (3160707) 220220131013

@Override
public void init() throws ServletException {

ApplicationContext context = new ClassPathXmlApplicationContext("[Link]");

reservationDAO = (ReservationDAO) [Link]("reservationDAO");
}

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

HttpSession session = [Link]();

String username = (String) [Link]("username");
String role = (String) [Link]("role");

if (username == null) {

[Link]("[Link]");
return;
}

List<Reservation> reservations;
if ("admin".equals(role)) {

reservations = [Link]();
} else {

reservations = [Link](username);
}

[Link]("reservations", reservations);
[Link]("[Link]").forward(request, response);
}
}

Output:

62
Advanced Java Programming (3160707) 220220131013

63
Advanced Java Programming (3160707) 220220131013

64