Week 10: Write a servlet program to display servlet name and date using Generic Servlet.
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.*;
import java.util.*;
public class NewServlet extends GenericServlet
{
public void service(ServletRequest request, ServletResponse response) throws
ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try
{
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet NewServlet</title>");
out.println("</head>");
out.println("<body>");
out.println("<p>Servlet Name " + getServletName() + "</p>");
Date d=new Date();
out.println("<font color=green><b>"+d+"</b></font>");
out.println("</body>");
out.println("</html>");
} finally {
out.close();
}
}}
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-
app_2_5.xsd">
<servlet>
<servlet-name>NewServlet</servlet-name>
<servlet-class>NewServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>NewServlet</servlet-name>
<url-pattern>/NewServlet</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>NewServlet</welcome-file>
</welcome-file-list>
</web-app>
Week 11. Write a servlet program for cookies and sessions.
1. Cookies
index.html
<form action="FirstServlet" method="post">
Name:<input type="text" name="userName"/><br/>
<input type="submit" value="go"/>
</form>
FirstServlet.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class FirstServlet extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response)
{
try
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String n=request.getParameter("userName");
out.print("Welcome "+n);
Cookie ck=new Cookie("uname",n);//creating cookie object
response.addCookie(ck);//adding cookie in the response
out.print("<form action='SecondServlet'>");
out.print("<input type='submit' value='go'>");
out.print("</form>");
out.close();
}catch(Exception e){System.out.println(e);}
}
}
SecondServlet.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class SecondServlet extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response)
{
try{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Cookie ck[]=request.getCookies();
out.print("Hello "+ck[0].getValue());
out.close();
}catch(Exception e){System.out.println(e);}
} }
web.xml
<?xml version="1.0"?>
<web-app>
<servlet>
<servlet-name>NewServlet1</servlet-name>
<servlet-class>NewServlet1</servlet-class>
</servlet>
<servlet>
<servlet-name>NewServlet2</servlet-name>
<servlet-class>NewServlet2</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>NewServlet1</servlet-name>
<url-pattern>/NewServlet1</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>NewServlet2</servlet-name>
<url-pattern>/NewServlet2</url-pattern>
</servlet-mapping>
</web-app>
2. Session
index.html
<form action="FirstServlet">
Name:<input type="text" name="userName"/><br/>
<input type="submit" value="go"/>
</form>
FirstServlet.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class FirstServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response){
try{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String n=request.getParameter("userName");
out.print("Welcome "+n);
HttpSession session=request.getSession();
session.setAttribute("uname",n);
out.print("<a href='SecondServlet'>visit</a>");
out.close();
}catch(Exception e){System.out.println(e);}
}
}
SecondServlet.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class SecondServlet extends HttpServlet
{
public void doGet(HttpServletRequest request, HttpServletResponse response){
try{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
HttpSession session=request.getSession(false);
String n=(String)session.getAttribute("uname");
out.print("Hello "+n);
out.close();
}catch(Exception e){System.out.println(e);}
} }
web.xml
<web-app>
<servlet>
<servlet-name>s1</servlet-name>
<servlet-class>FirstServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>s1</servlet-name>
<url-pattern>/FirstServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>s2</servlet-name>
<servlet-class>SecondServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>s2</servlet-name>
<url-pattern>/SecondServlet</url-pattern>
</servlet-mapping>
</web-app>
Week 12: Write a servlet program to retrieve data from derby database and display in a
table using JDBC.
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;
public class NewServlet1 extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><body>");
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con =
DriverManager.getConnection("jdbc:derby://localhost:1527/test", "neelu", "neelu");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from veg");
out.println("<table border=1 cellpadding=0 width=50% height=50%>");
out.println("<tr><th>Vegid</th><th>VegName</th><th>Price</th><tr>");
while (rs.next())
{
int i=rs.getInt("VEGID");
String n = rs.getString("VEGNAME");
int p=rs.getInt("PRICE");
out.println("<tr><td>" + i + "</td><td>" + n + "</td><td>" + p +
"</td></tr>");
}
out.println("</table>");
out.println("</html></body>");
con.close();
}
catch(Exception e)
{
} finally {
out.close();
} }
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{ } }
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{ processRequest(request, response);
} catch(Exception e)
{ } }
@Override
public String getServletInfo() {
return "Short description";
}}
Week 13: Write a servlet program to retrieve data from mysql database and display
in a table using JDBC.
Import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;
public class NewServlet extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException
{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><body>");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from emp");
out.println("<table border=1 cellpadding=0 width=50% height=50%>");
out.println("<tr><th>ename</th><th>location</th><tr>");
while(rs.next())
{
String n=rs.getString("ename");
String l=rs.getString("location");
out.println("<tr><td>" + n + "</td><td>" + l + "</td></tr>");
}
out.println("</table>");
out.println("</html></body>");
con.close();
}
catch(Exception e)
{ } finally {
out.close();
} }
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{ }
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{ } }
@Override
public String getServletInfo() {
return "Short description";
}}
Week 14: Write a servlet program to perform DML operations on mysql database
using JDBC.
1. insert
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;
public class NewServlet extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><body>");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
Statement stmt = con.createStatement();
out.println("successfully connected");
String accessDatabase = "insert into emp(empid, ename, location)
values(‘523’,'kiran','bangalore')";
int result = stmt.executeUpdate(accessDatabase);
if (result > 0) {
System.out.println("Record Inserted! Check your table now!");
}
ResultSet rs = stmt.executeQuery("select * from emp");
out.println("<table border=1 cellpadding=0 width=50% height=50%>");
out.println("<tr><th>empname</th><th>location</th><tr>");
while(rs.next())
{
out.println("hi");
String n=rs.getString("ename");
String l = rs.getString("location");
out.println("<tr><td>" + n + "</td><td>" + l + "</td></tr>");
}
out.println("</table>");
out.println("</html></body>");
con.close();
}
catch(Exception e)
{
} finally { out.close();
} }
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{ }
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{ } }
@Override
public String getServletInfo() {
return "Short description";
}}
2. Update
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;
public class NewServlet1 extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><body>");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
Statement stmt = con.createStatement();
out.println("successfully connected");
String accessDatabase = "update emp set location='hyd' where ename='kiran'";
int result = stmt.executeUpdate(accessDatabase);
if (result > 0) {
System.out.println("Record Inserted! Check your table now!");
}
ResultSet rs = stmt.executeQuery("select * from emp");
out.println("<table border=1 cellpadding=0 width=50% height=50%>");
out.println("<tr><th>empname</th><th>location</th><tr>");
while(rs.next())
{
out.println("hi");
String n=rs.getString("ename");
String l = rs.getString("location");
out.println("<tr><td>" + n + "</td><td>" + l + "</td></tr>");
}
out.println("</table>");
out.println("</html></body>");
con.close();
}
catch(Exception e)
{
} finally {
out.close();
} }
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{
} }
@Override
public String getServletInfo() {
return "Short description";
}}
3. Delete
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;
public class NewServlet1 extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><body>");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
Statement stmt = con.createStatement();
out.println("successfully connected");
String accessDatabase = "delete from emp where ename='kiran' ";
int result = stmt.executeUpdate(accessDatabase);
if (result > 0) {
System.out.println("Record deleted! Check your table now!");
}
ResultSet rs = stmt.executeQuery("select * from emp");
out.println("<table border=1 cellpadding=0 width=50% height=50%>");
out.println("<tr><th>empname</th><th>location</th><tr>");
while(rs.next())
{
out.println("hi");
String n=rs.getString("ename");
String l = rs.getString("location");
out.println("<tr><td>" + n + "</td><td>" + l + "</td></tr>");
}
out.println("</table>");
out.println("</html></body>");
con.close();
}
catch(Exception e)
{
} finally {
out.close();
} }
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{
} }
@Override
public String getServletInfo() {
return "Short description";
}}
Week 15. Write a program to insert data from form into mysql database using
servlets and JDBC
index.html
<!doctype html>
<body>
<form action="NewServlet1" method="post">
<fieldset style="width:40%; background-color:#ccffeb">
<h2 align="center">Registration form</h2><hr>
<table>
<tr>
<td>Name</td>
<td><input type="text" name="userName" required /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="userPass" required /></td>
</tr>
<tr>
<td>Email Id</td>
<td><input type="text" name="userEmail" required /></td>
</tr>
<tr>
<td>Mobile</td>
<td><input type="text" name="userMobile" required/></td>
</tr>
<tr>
<td>Date of Birth</td>
<td><input type="date" name="userDOB" required/></td>
</tr>
<tr>
<td>Gender</td>
<td><input type="radio" name="gender" value="male" checked> Male
<input type="radio" name="gender" value="female"> Female </td></tr>
<tr>
<td>Country</td>
<td><select name="userCountry" style="width:130px">
<option>Select a country</option>
<option>India</option>
<option>America</option>
<option>England</option>
<option>other</option></select>
</td>
</tr>
<tr>
<td><input type="reset" value="Reset"/></td>
<td><input type="submit" value="Register"/></td>
</tr>
</table>
</fieldset>
</form>
</body>
</html>
NewServlet1.java
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;
public class NewServlet1 extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException
{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String name = request.getParameter("userName");
String pwd = request.getParameter("userPass");
String email = request.getParameter("userEmail");
int mobile = Integer.parseInt(request.getParameter("userMobile"));
String dob = request.getParameter("userDOB");
String gender = request.getParameter("gender");
String country =request.getParameter("userCountry");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
PreparedStatement ps=con.prepareStatement("insert into registration values(?,?,?,?,?,?,?)");
ps.setString(1,name);
ps.setString(2,pwd);
ps.setString(3,email);
ps.setInt(4, mobile);
ps.setString(5,dob);
ps.setString(6,gender);
ps.setString(7,country);
int i = ps.executeUpdate();
if(i>0)
out.print("You are successfully registered...");
con.close();
}
catch(Exception e)
{ } finally {
out.close();
} }
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{ }
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
try
{
processRequest(request, response);
} catch(Exception e)
{
} }
@Override
public String getServletInfo() {
return "Short description";
}}
