Servlet Program
Servlet Program
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Hello")
public class Hello extends HttpServlet {
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Welcome page</title>
<style>
h1{
text-align: center;
font-size: 60px;
font-family: cursive;
background-color: darkred;
color: white;
font-style: italic;
padding: 20px;
margin: 20px;
border-radius: 30px 0px 30px 0px;
box-shadow: 0px 0px 15px blue;
}
</style>
</head>
<body>
<h1>Welcome to sevlet classes....</h1>
</body>
</html>
Greeting.java(Servlet)
package com.gqt;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Greeting")
public class Greeting extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
// TODO Auto-generated method stub
response.sendRedirect("/03-html-eg/Welcome.html");
} }
Output:
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
</body>
</html>
Greetings.java(Servlet)
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/GetResult")
public class GetResult extends HttpServlet {
String url = "jdbc:mysql://localhost:3306/college";
String userName = "root";
String password = "sushmita";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet res = null;
res = pstmt.executeQuery();
while(res.next()) {
usn = res.getString(1);
name = res.getString(2);
marks1 = res.getInt(3);
marks2 = res.getInt(4);
marks3 = res.getInt(5);
percent = res.getFloat(6);
}
PrintWriter pw = response.getWriter();
pw.println(usn);
pw.println(name);
pw.println(marks1);
pw.println(marks2);
pw.println(marks3);
pw.println(percent);
} catch (Exception e) {
e.printStackTrace();
}
}
public void destroy() {
try {
res.close();
pstmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
} } }
Output
Eg4: Accessing data using JSP
Result.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
GetResult.jsp
<%!
public void jspInit() {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
con = DriverManager.getConnection(url, userName,
password);
} catch (Exception e) {
e.printStackTrace();
}
}
%>
<%
try {
pstmt = con.prepareStatement("SELECT * FROM student WHERE
usn = ?");
String temp = request.getParameter("usn");
pstmt.setString(1, temp);
res = pstmt.executeQuery();
while(res.next()) {
usn = res.getString(1);
name = res.getString(2);
marks1 = res.getInt(3);
marks2 = res.getInt(4);
marks3 = res.getInt(5);
percent = res.getFloat(6);
}
out.println(usn+" "+name+" "+marks1+" "+marks2+"
"+marks3+" "+percent);
} catch (Exception e) {
e.printStackTrace();
}
%>
<%!
public void jspDestroy() {
try {
res.close();
pstmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
%>
</body>
</html>
Output
Eg:5 performing basic validation of USN entered
Result.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
GetResult.java(servlet)
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/GetResult")
public class GetResult extends HttpServlet {
String url = "jdbc:mysql://localhost:3306/college";
String userName = "root";
String password = "sushmita";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet res = null;
PrintWriter pw = null;
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Error.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<p class="h1 text-success m-5 text-center">Invalid USN.. Try again!!</p>
<div class="m-auto bg-secondary p-2 col-md-4 rounded-4">
<form action="/07-better-validation/GetResult" method="post">
<h1 class = "text-center text-white">Result</h1>
<hr>
<div class = "mt-2">
<input type="text" name="usn" placeholder="Enter your usn"
class="form-control">
</div>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Getresult.java(Servlet)
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/GetResult")
public class GetResult extends HttpServlet {
String url = "jdbc:mysql://localhost:3306/college";
String userName = "root";
String password = "sushmita";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet res = null;
PrintWriter pw = null;
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Errror.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<p class="h1 text-success m-5 text-center">Invalid USN.. Try again!!</p>
<div class="m-auto bg-secondary p-2 col-md-4 rounded-4">
<form action="/08-One-level-servlet-chaining/Validation" method="post">
<h1 class = "text-center text-white">Result</h1>
<hr>
<div class = "mt-2">
<input type="text" name="usn" placeholder="Enter your usn"
class="form-control">
</div>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Validation.java(servlet)
package com.gqt;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Validation")
public class Validation extends HttpServlet {
request.getServletContext().getRequestDispatcher("/GetResult").forward(request,
response);
} }
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
} }
Getresult.java(servlet)
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/GetResult")
public class GetResult extends HttpServlet {
String url = "jdbc:mysql://localhost:3306/college";
String userName = "root";
String password = "sushmita";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet res = null;
PrintWriter pw = null;
if (res.next()) {
usn = res.getString(1);
name = res.getString(2);
marks1 = res.getInt(3);
marks2 = res.getInt(4);
marks3 = res.getInt(5);
percent = res.getFloat(6);
pw.println("<html><body>");
pw.println("<h2>USN: " + usn + "</h2>");
pw.println("<h2>Name: " + name + "</h2>");
pw.println("<h2>Marks: " + marks1 + ", " + marks2 + ", " +
marks3 + "</h2>");
pw.println("<h2>Percentage: " + percent + "</h2>");
pw.println("</body></html>");
} else {
pw.println("<h2>No record found for USN: " + temp + "</h2>");
}
} catch (Exception e) {
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
public void destroy() {
try {
res.close();
pstmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
} } }
Output
Eg:8 Two level servlet chaining
Result.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Error.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<p class="h1 text-success m-5 text-center">Invalid USN.. Try again!!</p>
<div class="m-auto bg-secondary p-2 col-md-4 rounded-4">
<form action="/09-two-level-servlet-chaining/Validation" method="post">
<h1 class = "text-center text-white">Result</h1>
<hr>
<div class = "mt-2">
<input type="text" name="usn" placeholder="Enter your usn"
class="form-control">
</div>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Validation.java(Servlet)
package com.gqt;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Validation")
public class Validation extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
String temp = request.getParameter("usn");
if(temp.length() != 10) {
response.sendRedirect("/09-two-level-servlet-chaining/error.html");
} else {
request.getServletContext().getRequestDispatcher("/GetResult").forward(request,
response);
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
GetResult.java
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
@WebServlet("/GetResult")
public class GetResult extends HttpServlet {
String url = "jdbc:mysql://localhost:3306/college";
String userName = "root";
String password = "sushmita";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet res = null;
PrintWriter pw = null;
request.getServletContext().getRequestDispatcher("/PrintPercentage").include(request,
response);
} catch (Exception e) {
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
} }
Percentage.java(Servlet)
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
@WebServlet("/PrintPercentage")
public class PrintPercentage extends HttpServlet {
}
Output
Eg:9: Cookie Program
Result.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Error.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>Result Page</title>
<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css
" rel="stylesheet">
</head>
<body>
<p class="h1 text-success m-5 text-center">Invalid USN.. Try again!!</p>
<div class="m-auto bg-secondary p-2 col-md-4 rounded-4">
<form action="/10-cookies/Validation" method="post">
<h1 class = "text-center text-white">Result</h1>
<hr>
<div class = "mt-2">
<input type="text" name="usn" placeholder="Enter your usn"
class="form-control">
</div>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.mi
n.js"></script>
</body>
</html>
Validation.java(servlet)
package com.gqt;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Validation")
public class Validation extends HttpServlet {
request.getServletContext().getRequestDispatcher("/GetResult").forward(request,
response);
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
GetResult.java(servlet)
package com.gqt;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.servlet.http.Cookie;
@WebServlet("/GetResult")
public class GetResult extends HttpServlet {
String url = "jdbc:mysql://localhost:3306/college";
String userName = "root";
String password = "sushmita";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet res = null;
PrintWriter pw = null;
String usn = null;
String name = null;
int marks1 = 0;
int marks2 = 0;
int marks3 = 0;
float percent = 0.0f;
} catch (Exception e) {
e.printStackTrace();
}
}