Assignment No : 2
Name – PRATIK
MADDHESHIYA
Roll No -
2201330109027
SEC-C
1. Write asimple servlet that just generates plain
text.
Solution:
import jakarta.servlet.ServletException;
//
importjakarta.servlet.annotation.
WebServlet; import
jakarta.servlet.http.HttpServlet;
import
jakarta.servlet.http.HttpServletRe
quest;
importjakarta.servlet.http.HttpSer
vletResponse; import
java.io.IOException;
import java.io.PrintWriter;
/**
* ServletimplementationclassProgram8
*/
publicclassProgram8extends HttpServlet{
privatestaticfinal longserialVersionUID= 1L;
/**
* Default constructor.
*/
public Program8() {
// TODOAuto-generatedconstructorstub
}
/*** @see HttpServlet doGet(HttpServletRequest request, HttpServletResponse
response)
*/
protectedvoiddoGet(HttpServletRequest request,
HttpServletResponseresponse)throws ServletException, IOException {
charset=UTF-8");
// TODO Auto- response.getWriter().append("Served at: ").append(request.getContextPath());
generatedmet // Set theresponsemessage'sMIMEtype response.setContentType("text/plain;
hodstub
// Allocatea outputwriter to writetheresponsemessageinto
thenetwork socket PrintWriter out = response.getWriter();
// Writetheresponsemessage
out.println("Hello, thisisasimpleservletthatgenerates plain text.");
}/**
* @see HttpServlet doPost(HttpServletRequest request, HttpServletResponse response)
protectedvoiddoPost(HttpServletRequest request,
HttpServletResponseresponse)throws ServletException, IOException {
// TODO Auto-
generatedmethodstub
doGet(request,
response);
}
}
Output
2. Write a Program which displays cookie id.
Solution:
import java.io.*;
importjakarta.servlet.ServletExc
eption; import
jakarta.servlet.http.Cookie; import
jakarta.servlet.http.HttpServlet;
import
jakarta.servlet.http.HttpServletRe
quest;
importjakarta.servlet.http.HttpSer
vletResponse; public class
Program9 extends HttpServlet
{
/**
*
*/
privatestaticfinal longserialVersionUID= 1L;
publicvoiddoGet(HttpServletRequest request,
HttpServletResponseresponse) throws ServletException,
IOException {
// Get thecookies fromtherequest
Cookie[] cookies=
request.getCookies();
StringcookieId= "Notfound";
// If therearecookies, look for
theonenamed"cookieId" if (cookies !=
null) {
for (Cookiecookie: cookies){
if("cookieId".equals(cookie.getNa
me())){ cookieId = cookie.getValue();
break;
}
}
}
// Set the response message's
MIME type
response.setContentType("text/plain;ch
arset=UTF-8");
// Allocatea output writer to writetheresponsemessageinto
thenetwork socket PrintWriter out = response.getWriter();
// Write the response
message
out.println("CookieID:"+
cookieId);
}
}
Output
3. Write a Program to Update Customer
Information.
Solution:
importjava.sql.*; publicclass Program6 {
publicstaticvoid main(String[] args) throws Exception {
// TODO Auto-generated method stub
String url = "jdbc:mysql://localhost:3306/demo"; String userName =
"root"; String pass = "pratik@1111";
String query = "update employee set name = 'PRATIK ' where id
= 1";
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url,userName,pass);
Statement st = conn.createStatement(); st.executeUpdate(query);
System.out.println("Updated Successfully");
st.close();
conn.close();
}
Output
4. Create a table which should contain at
least the following fields: name,
password, email-id, phone number
Write ajava program/servlet/JSP to
connect to that database and extract
data from the tables and display them.
Insert the details of the users who
register with the web site, whenever a
new user clicks the submit button in
the registration page.
Solution:
Program16.java
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStateme
nt; importjava.sql.ResultSet;
importjava.sql.SQLException;
importjakarta.servlet.ServletException;
importjakarta.servlet.annotation.WebServlet;
importjakarta.servlet.http.HttpServlet;
importjakarta.servlet.http.HttpServletRequest;
importjakarta.servlet.http.HttpServletResponse;
@WebServlet("/Program16")
publicclass
Program16extendsHttpServlet{
privatestaticfinallongserialVer
sionUID = 1L;
protectedvoiddoGet(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
String name= request.getParameter("name");
Stringpassword= request.getParameter("password"); String
email = request.getParameter("email");
StringphoneNumber =request.getParameter("phone_number");
// Insert newuser into thedatabase
try {
Connectionconn= getConnection();
Stringsql = "INSERT INTO Users(name, password, email, phone_number)
VALUES (?, ?, ?, ?)"; PreparedStatementstatement=conn.prepareStatement(sql);
statement.setString(1, name);
statement.setString(2,
password);
statement.setString(3, email);
statement.setString(4,phoneNu
mber);
statement.executeUpdate();
conn.close();
}catch (SQLExceptione)
{ e.printStackTrace();
}
response.setContentType("text/html");
PrintWriterout= response.getWriter();
out.println("<html><body>");
out.println("<h1>User Registered Successfully!</h1>");
out.println("<ahref='Program162'>View RegisteredUsers</a>");
out.println("</body></html>");
}
privateConnectiongetConnection()throwsSQLException{
StringjdbcURL= "jdbc:mysql://localhost:3306/mydatabase";
String jdbcUsername = "root";
StringjdbcPassword = "pratik@1111";
returnDriverManager.getConnection(jdbcURL, jdbcUsername, jdbcPassword);
}
}
Program162.java
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStateme
nt; importjava.sql.ResultSet;
importjava.sql.SQLException;
importjakarta.servlet.ServletException;
importjakarta.servlet.annotation.WebServlet;
importjakarta.servlet.http.HttpServlet;
importjakarta.servlet.http.HttpServletRequest;
importjakarta.servlet.http.HttpServletResponse;
@WebServlet("/Program162")
publicclass
Program162extendsHttpServlet{
privatestaticfinallongserialVersi
onUID = 1L;
protectedvoiddoGet(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException
{ response.setContentType("text/html");
PrintWriterout= response.getWriter();
out.println("<html><body>");
out.println("<h1>RegisteredUsers:</h1>");
out.println("<table border='1'>");
out.println("<tr><th>Name</th><th>Email</th><th>Phone Number</th></tr>");
// Retrieveusers fromthedatabase
try {
Connection conn = getConnection();
PreparedStatementstatement =
conn.prepareStatement("SELECT name, email, phone_number
FROM Users"); ResultSetrs= statement.executeQuery();
while (rs.next()){
String name = rs.getString("name");
Stringemail= rs.getString("email");
String phoneNumber = rs.getString("phone_number");
out.println("<tr><td>" + name+ "</td><td>" + email + "</td><td>"+
phoneNumber + "</td></tr>");
}
out.println("</table>");
conn.close();
}catch (SQLExceptione)
{ e.printStackTrace();
}
out.println("</body></html>");
}
privateConnectiongetConnection()throwsSQLException{
StringjdbcURL= "jdbc:mysql://localhost:3306/mydatabase";
String jdbcUsername = "root";
StringjdbcPassword = “pratik@1111";
returnDriverManager.getConnection(jdbcURL, jdbcUsername, jdbcPassword);
}
}
OUTPUT:
PRATIK
12345
[email protected]
m
5. Design and implement asimple servlet
book query with the help of JDBC &
SQL. Create MS Access Database,
create on ODBC link, Compile &
Execute JAVA JDBC Socket.
Solution:
Program17.html
<!DOCTYPEhtml>
<html>
<head>
<title>InsertData</title>
</head>
<body>
<formaction="./InsertData"method="post">
<p>ID:</p>
<inputtype="text"name="id"/>
<br/>
<p>String:</p>
<inputtype="text"name="string"/>
<br/><br/><br/>
<inputtype="submit"/>
</form>
</body>
</html>
DatabaseConnectio
n.java
importjava.sql.Con
nection;
importjava.sql.Driver
Manager;
importjava.sql.SQLE
xception;
publicclassDatabaseConnection {
protectedstaticConnectioninitializeDatabase()throwsSQLException,
ClassNotFoundException { String dbDriver =
"com.mysql.jdbc.Driver"; StringdbURL=
"jdbc:mysql://localhost:3306/"; String dbName = "demoprj";
StringdbUsername=
"root"; StringdbPassword
= "pratik1111";
// Load the JDBC driver Class.fiorName(dbDriver);
// Establishtheconnection
Connectionconnection = DriverManager.getConnection(dbURL+ dbName,
dbUsername, dbPassword);
returnconnection;
}
}
InsertData.java
importjava.io.IOException;
importjava.sql.Connection;
importjava.sql.PreparedStateme
nt;
importjakarta.servlet.ServletException; importjakarta.servlet.http.HttpServlet;
importjakarta.servlet.http.HttpServletRequest;
importjakarta.servlet.http.HttpServletResponse;
publicclassInsertDataextendsHttpServlet {
protectedvoiddoPost(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
intid = Integer.parseInt(request.getParameter("id"));
StringdataString= request.getParameter("string");
try {
Connectionconnection= DatabaseConnection.initializeDatabase();
PreparedStatementpreparedStatement =connection.prepareStatement("INSERTINTO demo
VALUES (?, ?)"); preparedStatement.setInt(1, id); preparedStatement.setString(2,
dataString);
preparedStatement.executeUpdate();
connection.close();
}catch (Exceptione){
e.printStackTrace();
}
// Redirect toasuccess pageor displaya confirmation message
response.sendRedirect("success.html");
}
}
OUTPUT:
6. Design a simple application program
using Servlet and Database 1. Simple
login form 2. Customer Feedback Form
3. Admission Form 4. Student Mark Sheet
Solution:
Program18Login.html
<!DOCTYPEhtml>
<html>
<head>
<metacharset="UTF-8">
<title>LoginForm</title>
</head>
<body>
<formaction="Program18Login"method="post">
<labelfor="username">Username:</label>
<inputtype="text"id="username"name="username"required><br>
<labelfor="password">Password:</label>
<inputtype="password"id="password"name="password"required><br>
<inputtype="submit"value="Login">
</form>
</body>
</html>
Program18Login.java
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStateme
nt; importjava.sql.ResultSet;
importjakarta.servlet.RequestDispatcher; importjakarta.servlet.ServletException;
importjakarta.servlet.http.HttpServlet;
importjakarta.servlet.http.HttpServletRequest;
importjakarta.servlet.http.HttpServletResponse;
publicclassProgram18LoginextendsHttpServlet {
protectedvoiddoPost(HttpServletRequestrequest,
HttpServletResponseresponse) throwsServletException, IOException
{ response.setContentType("text/html"); PrintWriterout=
response.getWriter();
Stringusername= request.getParameter("username"); String password =
request.getParameter("password");
try { Class.fiorNx»c("com.mysql.jdbc.Driver");
Connection con =
DriverManager.qc"Conncc"ion("jdbc:mysql://localhost:3306/registration_form",
"root", "pratik@1111");
PreparedStatementps= con.prepareStatement("SELECT * FROMuser_register
WHERE UserName=? AND Password=?");
ps.setString(1, username);
ps.setString(2, password);
ResultSetrs=ps.executeQuery();
if (rs.next()){
// Valid credentials, redirect to welcome page
RequestDispatcherrd= request.getRequestDispatcher("Welcome");
rd.forward(request, response);
} else {
// Invalid credentials, display error message out.print("Sorry,
usernameor passworderror");
RequestDispatcherrd=request.getRequestDispatcher("index.html"); rd.include(request,
response);
}
con.close();
}catch (Exceptione){
e.printStackTrace();
}
out.close();
}
}
Welcome.java
importjava.io.IOException;
importjava.io.PrintWriter;
importjakarta.servlet.ServletException; importjakarta.servlet.http.HttpServlet;
importjakarta.servlet.http.HttpServletRequest;
importjakarta.servlet.http.HttpServletResponse;
publicclassWelcomeextendsHttpServlet {
protectedvoiddoPost(HttpServletRequestrequest,
HttpServletResponseresponse) throwsServletException, IOException
{ response.setContentType("text/html"); PrintWriterout=
response.getWriter();
Stringusername= request.getParameter("username"); out.print("Welcome, " +
username);
out.close();
}
}
OUTPUT :
7. Write a JSP program to show and
display at least 3 active control.
Solution:
<%@pagelanguage="jxvx"contentType=""cx"/h"»l;chxrsc"=UTF-
8"pageEncoding="UTF- 8"%>
<!DOCTYPEhtml>
<html>
<head>
<metacharset="UTF-8">
<title>ActiveControlsExample</title>
</head>
<body>
<h2>ActiveControlsExample</h2>
<formaction="proccssDx"x.jsp"method="pos"">
<!-- Text Input -->
<labelfor=""cx"Inpu"">Enter Text:</label>
<inputtype=""cx""id=""cx"Inpu""name=""cx"Inpu""required>
<br>
<!--DropdownMenu-->
<labelfor="dropdownMcnu">Select Option:</label>
<selectid="dropdownMcnu"name="dropdownMcnu">
<optionvalue="op"ion1">Option 1</option>
<optionvalue="op"ion2">Option 2</option>
<optionvalue="op"ion3">Option 3</option>
</select>
<br>
<!-- Submit Button-->
<inputtype="sub»i""value="Sub»i"">
</form>
</body>
Output :
8. Write a JSP program to upload file into server.
Solution:
<%@pagelanguage="jxvx"contentType=""cx"/h"»l;chxrsc"=UTF-8"pageEncoding="UTF-
8"%>
<!DOCTYPEhtml>
<html>
<head>
<metacharset="UTF-8">
<title>FileUploadExample</title>
</head>
<body>
<h2>FileUploadExample</h2>
<formaction="Proqrx»24"method="pos""enctype="»ul"ipxr"/fior»-dx"x">
<labelfor="fiilc">Chooseafile:</label>
<inputtype="fiilc"name="fiilc"id="fiilc"required><br>
<inputtype="sub»i""value="Uploxd Filc">
</form>
<p>${message}</p>
</body>
</html>
Program24.java
importjava.io.File;
importjava.io.IOException;
importjava.io.InputStream;
importjava.nio.file.Files;
importjava.nio.file.Path;
importjava.nio.file.StandardCopy
Option;
importjakarta.servlet.ServletException;
importjakarta.servlet.annotation.MultipartConfig;
importjakarta.servlet.annotation.WebServlet;
importjakarta.servlet.http.HttpServlet;
importjakarta.servlet.http.HttpServletRequest;
importjakarta.servlet.http.HttpServletResponse;
importjakarta.servlet.http.Part;
@WebServlet("Program24")
@MultipartConfig
publicclass Program24 extendsHttpServlet {
privatestaticfinallongserialVersionUID = 1L;
protectedvoiddoPost(HttpServletReq
uestrequest,
HttpServletResponseresponse)
throwsServletException, IOException
{
String uploadDir = getServletContext().getRealPath("/") + "uploads";
File directory = new
File(uploadDir); if(!directory.exists()){
directory.mkdir();
}
PartfilePart= request.getPart("file"); String
fileName = getFileName(filePart);
try (InputStreamfileContent= filePart.getInputStream())
{ Path filePath = Path.ofi(uploadDir,
fileName);
Files.couy(fileContent, filePath, StandardCopyOption.REPLACE_EXISTING);
}
request.setAttribute("message", "Fileuploadedsuccessfully!");
request.getRequestDispatcher("program24.jsp").forward(request, response);
}
private String getFileName(final Part part) { for (String content
:part.getHeader("content- disposition").split(";")) {
if (content.trim().startsWith("filename")) {
returncontent.substring(content.indexOf('=')+ 1).trim().replace("\"", "");
}
}
returnn
ull;
}
}
OUTPUT :
9. Write a JSP program toretrieve data from
HTML into JSP page and display on
browser.
Solution:
HTML FILE:
<!DOCTYPE html>
<html lang="cn">
<head>
<meta charset="UTF-8">
<meta name="vicwuor"" content="wid"h=dcvicc-wid"h, ini"ixl-scxlc=1.0">
<title>DataRetrieval Example</title>
</head>
<body>
<h1>DataRetrieval Example</h1>
<form action="uroqrx»29.jsu" method="uos"">
<labelfor="nx»c">Name:</label>
<input type=""cx""id="nx»c"name="nx»c"required>
<br>
<labelfor="xqc">Age:</label>
<input type="nu»bcr"id="xqc"name="xqc"required>
<br>
<input type="sub»i""value="Sub»i"">
</form>
</body>
</html>
JSP FILE:
<%@ page language="jxvx"contentType=""cx"/h"»l; chxrsc"=UTF-8"pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html lang="cn">
<head>
<meta charset="UTF-8">
<meta name="vicwuor"" content="wid"h=dcvicc-wid"h, ini"ixl-scxlc=1.0">
<title>DataDisplayPage</title>
</head>
<body>
<h1>DataDisplayPage</h1>
<%
// Retrieve data from the request
object String name=
request.getParameter("name");
String ageStr =
request.getParameter("age");
// Convert agetoan integer (youmight want toadd error handling for better robustness)
int age= Integer.parseInt(ageStr);
%>
<p>Name: <%= name%></p>
<p>Age: <%= age%></p>
</body>
</html>
Output :
10. Write a JSP program to demonstrate JSP implicit
object.
Solution:
<%@ page language="jxvx"contentType=""cx"/h"»l; chxrsc"=UTF-8"pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html lang="cn">
<head>
<meta charset="UTF-8">
<meta name="vicwuor"" content="wid"h=dcvicc-wid"h, ini"ixl-scxlc=1.0">
<title>ImplicitObjectExample</title>
</head>
<body>
<h1>ImplicitObjectExample</h1>
<p>Usingvariousimplicit objects:</p>
<ul>
<li>Request Parameter (name): <%= request.getParameter("name") %></li>
<li>Session Attribute (user): <%= session.getAttribute("user") %></li>
<li>Application Attribute (counter): <%= application.getAttribute("counter") %></li>
</ul>
<p>Usingimplicit objectsdirectly:</p>
<ul>
<li>RequestURI:<%= request.getRequestURI()%></li>
<li>ServerName:<%= request.getServerName()%></li>
<li>ServerPort:<%= request.getServerPort() %></li>
<li>ClientIPAddress:<%= request.getRemoteAddr()%></li>
</ul>
</body>
</html>
Output :
