ADVANCED JAVA
PROGRAMMING LAB
 1
Q 1: WAP to display a label on a frame using JFrame.
[SOURCE CODE]
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class JFrameDemo
{
public static void main(String s[])
{
JLabel l=new JLabel(" Hello! This is a Frame!");
JFrame frame = new JFrame("JFrame Source Demo");
frame.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
frame.add(l);
frame.setSize(200,100);
frame.setVisible(true);
}
}
 2
Q 1: WAP to display a label on a frame using JFrame.
[SCREENSHOTS]
 3
Q 2: WAP to display 6 buttons on a panel using JFrame.
[SOURCE CODE]
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class JButtonExample extends JFrame
{
public static void main(String arg[])
{
JFrame f=new JFrame("Frame Window");
JPanel p=new JPanel();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
p.add(new Label("Six Buttons:"));
for(int i=1;i<=6;i++)
p.add(new JButton(" "+i));
f.add(p);
f.setSize(50,200);
f.setVisible(true);
}
}
 4
Q 2: WAP to display 6 buttons on a panel using JFrame.
[SCREENSHOTS]
 5
Q 3: WAP to display an image and label on JFrame.
[SOURCE CODE]
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class PushMeButton extends JFrame
{
public static void main(String arg[])
{
JFrame f=new JFrame("Press Me?");
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
JPanel p=new JPanel();
ImageIcon icon = new ImageIcon("button.png");
JLabel copyLabel = new JLabel(icon);
JLabel l=new JLabel(" DO NOT PRESS THE BUTTON! ");
p.add(l);
p.add(copyLabel);
f.add(p);
f.setSize(250,300);
f.setVisible(true);
}
}
 6
Q 3: WAP to display an image and label on JFrame.
[SCREENSHOTS]
 7
Q 4: Write a program to design an application having three tab panes
[SOURCE CODE]
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
class Tabs extends JFrame implements ActionListener
{
JPanel p1,p2,p3;
JLabel l1,l2,l3,l4,l5;
JTextField tf1,tf2,tf3;
JComboBox jcb;
JCheckBox jb1,jb2;
JButton b1,b2,b3,b4;
public Tabs()
{
String arr[]={"Noida", "New Delhi", "Mohali", "Modinagar"};
p1= new JPanel();
p2= new JPanel();
p3= new JPanel();
l1 = new JLabel("Name of the Bank");
l2= new JLabel("Name of the Branch");
tf1= new JTextField(20);
jcb = new JComboBox(arr);
p1.add(l1);
p1.add(tf1);
p1.add(l2);
p1.add(jcb);
add(p1);
l3 = new JLabel("Name");
tf2 = new JTextField(20);
jb1 = new JCheckBox("Male");
jb2 = new JCheckBox("Female");
l4 = new JLabel("Gender");
l5 = new JLabel("Age");
b1=new JButton("Submit");
tf3 = new JTextField(10);
p2.add(l3);
p2.add(tf1);
p2.add(l5);
p2.add(tf3);
p2.add(l4);
p2.add(jb1);
p2.add(jb2);
p2.add(b1);
add(p2);
b2 = new JButton("Blue");
b3 = new JButton("Red");
b4 = new JButton("Green");
p3.add(b2);
p3.add(b3);
p3.add(b4);
b2.addActionListener(this);
 8
b3.addActionListener(this);
b4.addActionListener(this);
add(p3);
JTabbedPane jtp = new JTabbedPane();
jtp.addTab("Bank Info", p1);
jtp.addTab("Registeration", p2);
jtp.addTab("BackGround", p3);
add(jtp);
setSize(500,500);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b2)
setBackground(Color.BLUE);
if(e.getSource()==b3)
setBackground(Color.RED);
if(e.getSource()==b4)
setBackground(Color.GREEN);
}
public static void main(String arg[])
{
new Tabs();
}
}
 9
Q 4: Write a program to design an application having three tab panes
[SCREENSHOTS]
 10
Q 5: WAP to implement JTrees.
[SOURCE CODE]
import java.awt.*;
import java.awt.event.*;
import javax.swing.event.*;
import javax.swing.*;
import javax.swing.tree.*;
public class JTreeDemo extends JFrame
{
JTree tree;
JLabel jlab;
JTreeDemo()
{
addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
DefaultMutableTreeNode top = new DefaultMutableTreeNode("My Tree");
DefaultMutableTreeNode a = new DefaultMutableTreeNode("Parent Node 1");
top.add(a);
DefaultMutableTreeNode a1 = new DefaultMutableTreeNode("Child Node 1");
a.add(a1);
DefaultMutableTreeNode a11 = new DefaultMutableTreeNode("Sub Child Node 1");
a1.add(a11);
DefaultMutableTreeNode a2 = new DefaultMutableTreeNode("Child Node 2");
a.add(a2);
DefaultMutableTreeNode b = new DefaultMutableTreeNode("Parent node 2");
top.add(b);
DefaultMutableTreeNode b1 = new DefaultMutableTreeNode("Child node 1");
b.add(b1);
DefaultMutableTreeNode b2 = new DefaultMutableTreeNode("Child node 2");
b.add(b2);
DefaultMutableTreeNode b3 = new DefaultMutableTreeNode("Child node 3");
b.add(b3);
tree = new JTree(top);
 11
JScrollPane jsp = new JScrollPane(tree);
add(jsp);
jlab = new JLabel();
add(jlab, BorderLayout.SOUTH);
tree.addTreeSelectionListener(
new TreeSelectionListener()
{
public void valueChanged(TreeSelectionEvent tse)
{
jlab.setText("Selection is " + tse.getPath());
}
}
);
setSize(250,300);
setVisible(true);
}
public static void main(String args[])
{
JTreeDemo j=new JTreeDemo();
}
}
 12
Q 5: WAP to implement JTrees.
[SCREENSHOTS]
 13
Q 6: WAP to create a Client-Server App using RMI.
[SOURCE CODE]
// Interface Program
import java.rmi.*;
import java.rmi.server.*;
public interface remoInter extends Remote
{
public String message()throws RemoteException;
public int add(int a,int b)throws RemoteException;
}
// Server Program
import java.rmi.*;
import java.rmi.server.*;
import java.io.*;
public class remoserver extends UnicastRemoteObject implements remoInter
{
public remoserver()throws RemoteException
super();
public String message()throws RemoteException
return ("Hello World");
public int add(int a,int b)
return(a+b);
public static void main(String arg[])
{
try
{
remoserver r=new remoserver();
Naming.rebind("testserver",r);
System.out.println("the server is ready");
}
catch(Exception e)
{}
}
}
 14
// Client Program
import java.rmi.*;
import java.rmi.registry.*;
import java.io.*;
public class remoclient
{
public static void main(String arg[])
{
try
{
remoInter s=(remoInter)Naming.lookup("testserver");
System.out.println(s.message());
System.out.println("the addition of two no. is"+s.add(5,10));
}
catch(Exception e)
{}
}
}
 15
Q 6: WAP to create a Client-Server App using RMI.
[SCREENSHOTS]
 16
Q 7: WAP to access a table from MS-Access using Java code.
[SOURCE CODE]
import java.sql.*;
import java.io.*;
public class jdbcEx
{
public static String MakeItLookNice(String s)
{
String new_s;
new_s = s;
if(s.length() < 30)
{
for(int i=s.length(); i<=30; i++)
{
new_s = new_s + " ";
}
}
return new_s;
}
public static void main(String arg[])throws IOException
{
try
{
String url = "jdbc:odbc:NM_DB";
String login = "";
String pwd = "";
InputStreamReader Ir = new InputStreamReader(System.in);
BufferedReader Br = new BufferedReader(Ir);
Connection con = DriverManager.getConnection(url,login,pwd);
Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
//Specifies type, and concurrency.
//Here, insensitive makes it independent of changes made on the db,
//and concurrency sets it to readable only or updatable mode.
ResultSet rs;
int x=5;
while(x!=0)
{
System.out.println("\n MENU: Movie Database. ");
System.out.println("1. Display all movies on sale.");
System.out.println("2. Delete movies with ratings <= 2 stars.");
System.out.println("3. Increase ratings of 4.75 to 5.");
System.out.println("4. Display records using different scrollable result set methods.");
System.out.print(" Your Choice: ");
 17
x = Integer.parseInt(Br.readLine());
System.out.println("\n");
switch(x)
{
case 1:
String Query1 = "Select id, title_name, rating, price, quantity from table1";
rs = st.executeQuery(Query1);
System.out.println("ID"+" "+MakeItLookNice("Name of Movie")+"\t"+""+"Rating"+
"\t"+""+"Price"+"\t"+""+"Quantity");
while(rs.next())
{
System.out.println(rs.getString(1)+" "+MakeItLookNice(rs.getString(2))+"\t"+""+rs.getString(3)+
"\t"+""+rs.getString(4)+"\t"+""+rs.getString(5));
}
break;
case 2:
String Query2 = "Delete from table1 where rating <= 2";
int Row1 = st.executeUpdate(Query2);
System.out.println("Rows Deleted = "+Row1);
break;
case 3:
String Query3 = "Update table1 set rating = 5 where rating = 4.75";
int Row2 = st.executeUpdate(Query3);
System.out.println("Rows Updated = "+Row2);
break;
case 4:
String Query4 = "Select * from table1";
rs = st.executeQuery(Query4);
System.out.println("ID"+" "+MakeItLookNice("Name of Movie")+"\t"+""+"Rating"+
"\t"+""+"Price"+"\t"+""+"Quantity");
while(rs.next())
{
System.out.println(rs.getString(1)+" "+MakeItLookNice(rs.getString(2))+"\t"+""+rs.getString(3)+
"\t"+""+rs.getString(4)+"\t"+""+rs.getString(5));
}
 18
System.out.println("\n\t\tFIRST ROW-");
rs.first();
System.out.println(rs.getString(1)+" "+MakeItLookNice(rs.getString(2))+"\t"+""+rs.getString(3)+
"\t"+""+rs.getString(4)+"\t"+""+rs.getString(5));
System.out.println("\n\t\tLAST ROW-");
rs.last();
System.out.println(rs.getString(1)+" "+MakeItLookNice(rs.getString(2))+"\t"+""+rs.getString(3)+
"\t"+""+rs.getString(4)+"\t"+""+rs.getString(5));
break;
default:
System.out.println("Invalid Option!");
}
}
}
catch(SQLException e)
{
System.out.println("\nTHERE'S AN EXCEPTION! :( - "+e);
}
}
}
 19
Q 7: WAP to access a table from MS-Access using Java code.
[SCREENSHOTS] D:\Java\jdk1.6.0_30\bin\adv>java jdbcEx MENU: Movie Database. 1. Display all movies on sale. 2. Delete movies with ratings <= 2 stars. 3. Increase ratings of 4.75 to 5. 4. Display records using different scrollable result set methods. Your Choice: 1 ID Name of Movie Rating Price Quantity 1 The Ring 4.0 300 2 2 Iron Man 4.5 1000 4 3 The Dark Knight 4.5 250 1 4 Ted 3.5 400 2 5 The Fallen 5.0 60000 1 6 Thor 3.0 2000 4 7 Spawn 3.0 5000 2 8 Charlie Chaplin 4.0 2300 2 9 Avengers 4.2 4000 5 10 A Bad Movie 1.0 2000 2 11 An Awesome Movie 4.75 10002 5 -- MENU: Movie Database. 1. Display all movies on sale. 2. Delete movies with ratings <= 2 stars. 3. Increase ratings of 4.75 to 5. 4. Display records using different scrollable result set methods. Your Choice: 3 Rows Updated = 1 -- MENU: Movie Database. 1. Display all movies on sale. 2. Delete movies with ratings <= 2 stars. 3. Increase ratings of 4.75 to 5. 4. Display records using different scrollable result set methods. Your Choice: 2 Rows Deleted = 1
 20
-- MENU: Movie Database. 1. Display all movies on sale. 2. Delete movies with ratings <= 2 stars. 3. Increase ratings of 4.75 to 5. 4. Display records using different scrollable result set methods. Your Choice: 4 ID Name of Movie Rating Price Quantity 1 The Ring 4.0 300 2 2 Iron Man 4.5 1000 4 3 The Dark Knight 4.5 250 1 4 Ted 3.5 400 2 5 The Fallen 5.0 60000 1 6 Thor 3.0 2000 4 7 Spawn 3.0 5000 2 8 Charlie Chaplin 4.0 2300 2 9 Avengers 4.2 4000 5 11 An Awesome Movie 5.0 10002 5 FIRST ROW- 1 The Ring 4.0 300 2 LAST ROW- 11 An Awesome Movie 5.0 10002 5
 21
Q 8: WAP to create a form using HTML.
[SOURCE CODE – HTML]
<html><head><title> Neil's Form! </title></head>
<link rel="stylesheet" href="style.css">
<body><form id="contact" method="post">
<fieldset>
<label for="name">Name:</label>
<input type="text" name="name" required placeholder="Name" /><BR>
<label for="email">Email:</label>
<input type="email" name="email" required placeholder="email@example.com" /><BR>
<label for="website">Website:</label>
<input type="url" name="website" required placeholder="http://www.example.com" /><BR>
<label for="number">Number:</label>
<input type="number" name="number" min="0" max="10" step="2" required placeholder="Even num < 10"><BR>
<label for="range">Range:</label>
<input type="range" name="range" min="0" max="10" step="2" /><BR>
<label for="message">Message:</label>
<textarea name="message" required></textarea><BR>
<label for="date">Date:</label>
<input name="date" required type="date"/><BR>
<label>Are you employed?</label>
<input type="radio" name="profession" value="Unemployed">Unemployed</input><BR>
<input type="radio" name="profession" value="Employed">Employed</input><BR>
<marquee><a href="http://metalwihen.com"> Visit my website for more info! </a></marquee>
<input type="submit" name="submit" class="button" id="submit" value="Submit"/></fieldset></form></body></html>
 22
Q 8: WAP to create a form using HTML.
[SCREENSHOTS]
 23
Q 9: Write a Servlet program to create a form.
[SOURCE CODE]
package com.metalwihen.mms;
import java.io.IOException;
import java.io.PrintWriter;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ServletForm extends HttpServlet {
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title> Neil's Servlet </title></head>");
out.println("<link rel=\"stylesheet\" href=\"style.css\" >");
out.println("<body>");
out.println("<h1>Calculate how old you are!</h1><br>");
out.println("<form id=\"contact\" method=\"post\" action=\"\">");
out.println("<fieldset>");
out.println("<label for=\"name\">Name</label>");
out.println("<input type=\"text\" name=\"name\" placeholder=\"Full Name\" title=\"Enter your name\" class=\"required\">");
out.println("<br>");
out.println("<label for=\"email\">Date Of Birth</label>");
out.println("<input type=\"date\" name=\"dob\" placeholder=\"xx/xx/xxxx\">");
out.println("<br>");
out.println("<input type=\"submit\" name=\"submit\" class=\"button\" id=\"submit\" value=\"Submit\"/>");
out.println("</fieldset>");
out.println("</form>");
out.println("</body>");
out.println("</html>");
out.close();
}
 24
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
String dob = request.getParameter("dob");
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
long time_born;
Date d;
try {
d = sf.parse(dob);
time_born = d.getTime();
} catch (ParseException e) {
out.println("Error in parsing Date.");
return;
}
long time_now = System.currentTimeMillis();
long time_difference = time_now - time_born;
long yearMillisecondCount = 1000L * 60L * 60L * 24L * 365L;
int yearsOld = (int) (time_difference / yearMillisecondCount);
out.println("<html><head>");
out.println("<title> How Old are you? </title>");
out.println("<link rel=\"stylesheet\" href=\"style.css\" >");
out.println("</head><body>");
out.println("Hello " + request.getParameter("name") + "!");
out.println("<br>Since you were born on " + dob + ", you are "
+ yearsOld + " years old.");
out.println("</td></tr></table></body></html>");
}
}
 25
Q 9: Write a Servlet program to create a form.
[SCREENSHOTS]
 26
Q 10: Write a Servlet program to implement JDBC.
[SOURCE CODE]
package com.metalwihen.mms;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ServletDatabase extends HttpServlet {
Connection con;
Statement st;
ResultSet rs;
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:emp", " ", " ");
st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
// Show Table Contents:
rs = st.executeQuery("select * from emp");
out.println("<html>");
out.println("<head>");
out.println("<title>JDBCservlet</title>");
out.println("</head>");
out.println("<link rel=\"stylesheet\" href=\"style.css\" >");
out.println("<body>");
out.println("<p><h3>SELECT * FROM EMP</h3></p>");
out.println("<table border='2'>");
out.println("<tr>");
out.println("<th>" + "ID" + "</th>");
out.println("<th>" + "E Name" + "</th>");
out.println("<th>" + "EMP ID" + "</th>");
out.println("<th>" + "Designation" + "</th>");
out.println("<th>" + "Basic Sal" + "</th>");
out.println("<th>" + "HR" + "</th>");
out.println("<th>" + "DA" + "</th>");
out.println("</tr>");
 27
while (rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString(1) + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(3) + "</td>");
out.println("<td>" + rs.getString(4) + "</td>");
out.println("<td>" + rs.getString(5) + "</td>");
out.println("<td>" + rs.getString(6) + "</td>");
out.println("<td>" + rs.getString(7) + "</td>");
out.println("</tr>");
}
out.println("</table>");
// Update Table Contents:
out.println("<p><h3> UPDATE EMP SET DA = DA + 500</h3></p><br><br>");
out.println(st.executeUpdate("UPDATE EMP SET DA = DA + 500")
+ " rows updated!");
rs = st.executeQuery("select * from emp");
out.println("<table border='2'>");
out.println("<tr>");
out.println("<th>" + "ID" + "</th>");
out.println("<th>" + "E Name" + "</th>");
out.println("<th>" + "EMP ID" + "</th>");
out.println("<th>" + "Designation" + "</th>");
out.println("<th>" + "Basic Sal" + "</th>");
out.println("<th>" + "HR" + "</th>");
out.println("<th>" + "DA" + "</th>");
out.println("</tr>");
while (rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString(1) + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(3) + "</td>");
out.println("<td>" + rs.getString(4) + "</td>");
out.println("<td>" + rs.getString(5) + "</td>");
out.println("<td>" + rs.getString(6) + "</td>");
out.println("<td>" + rs.getString(7) + "</td>");
out.println("</tr>");
}
out.println("</table>");
} catch (SQLException e) {
e.printStackTrace();
out.println("A SQL error has occured!");
} catch (ClassNotFoundException e) {
out.println("Driver Not Found.");
} finally {
out.close();
} } }
 28
Q 10: Write a Servlet program to implement JDBC.
[SCREENSHOTS]
 29
Q 11: Write a Servlet program using Http Sessions API.
[SOURCE CODE]
package com.metalwihen.mms;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class ShowSession extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession(true);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String heading;
Integer accessCount = new Integer(0);
if (session.isNew()) {
heading = "Welcome, Newcomer";
} else {
heading = "Welcome Back";
Integer oldAccessCount =
(Integer) session.getValue("accessCount");
if (oldAccessCount != null) {
accessCount = new Integer(oldAccessCount.intValue() + 1);
} }
session.putValue("accessCount", accessCount);
out.println("<HTML><link rel=\"stylesheet\" href=\"style.css\" >");
out.println("<BODY>\n" + "<H1 ALIGN=\"CENTER\">" + heading + "</H1>\n");out.println("<center><H2>Information on Your Session:</H2></center> \n");
out.println("<TABLE ALIGN=CENTER>\n" );
out.println("<TR><TH>Info Type</TH><TH>Value<TH></TR>\n");
out.println("<TR><TD>ID</TD><TD>" + session.getId() + "</TD></TR>");
out.println("<TR><TD>Creation Time</TD><TD>" + new Date(session.getCreationTime()) + "</TD></TR>\n");
out.println("<TR><TD>Time of Last Access</TD><TD>"+ new Date(session.getLastAccessedTime()) + "</TD><TR>");
out.println("<TR><TD>Number of Previous Accesses</TD><TD>"+ accessCount + "\n" + "</TD></TR>");
out.println("</TABLE>\n" + "</BODY></HTML>");
} }
 30
Q 11: Write a Servlet program using Http Sessions API.
[SCREENSHOTS]
 31
Q 12: Write a JSP program to create a form.
[SOURCE CODE]
package com.metalwihen.mms;
<%@ page import="java.util.*,java.text.*"%>
<html>
<head>
<title>Neil's Servlet</title>
</head>
<link rel="stylesheet" href="style.css">
<body>
<h1>Calculate how old you are!</h1>
<br>
<%
if(request.getParameter("name")!=null)
{
String dob = request.getParameter("dob");
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
long time_born;
Date d;
try {
d = sf.parse(dob);
time_born = d.getTime();
} catch (ParseException e) {
// TODO Auto-generated catch block
return;
}
long time_now = System.currentTimeMillis();
long time_difference = time_now - time_born;
long yearMillisecondCount = 1000L * 60L * 60L * 24L * 365L;
int yearsOld = (int) (time_difference / yearMillisecondCount);
out.println("Hello " + request.getParameter("name") + "!"+
"<br>Since you were born on " + dob + ", you are "
+ yearsOld + " years old.");
return;
}
%>
<form id= "contact" method= "post" action="">
<fieldset>
<label for="name">Name</label> <input type= "text" name=
"name" placeholder= "Full Name" title= "Enter your
name" class="required"> <br> <label for="email">Date
Of Birth</label> <input type= "date" name= "dob" placeholder="xx/xx/xxxx">
<br> <input type="submit" name= "submit" class=
"button" id= "submit" value= "Submit"/>
</fieldset>
</form>
</body></html>
 32
Q 12: Write a JSP program to create a form.
[SCREENSHOTS]
 33
Q 13: Write a JSP program to implement JDBC.
[SOURCE CODE]
<%@ page import="java.sql.*"%>
<html><head><title>JDBCservlet</title></head>
<link rel="stylesheet" href="style.css"><body>
<%
try { Connection con; Statement st; ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:emp", " ", " ");
st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
// Show Table Contents:
rs = st.executeQuery("select * from emp");
out.println("<p><h3>SELECT * FROM EMP</h3></p>");
out.println("<table border='2'>");
out.println("<tr>");
out.println("<th>" + "ID" + "</th>");
out.println("<th>" + "E Name" + "</th>");
out.println("<th>" + "EMP ID" + "</th>");
out.println("<th>" + "Designation" + "</th>");
out.println("<th>" + "Basic Sal" + "</th>");
out.println("<th>" + "HR" + "</th>");
out.println("<th>" + "DA" + "</th>");
out.println("</tr>");
while (rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString(1) + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(3) + "</td>");
out.println("<td>" + rs.getString(4) + "</td>");
out.println("<td>" + rs.getString(5) + "</td>");
out.println("<td>" + rs.getString(6) + "</td>");
out.println("<td>" + rs.getString(7) + "</td>");
out.println("</tr>");
} out.println("</table>");
} catch (SQLException e) {
e.printStackTrace();
out.println("A SQL error has occured!");
} catch (ClassNotFoundException e) {
e.printStackTrace();
out.println("Driver Not Found.");
} finally { //out.close() gave error } %>
</body> </html>
 34
Q 13: Write a JSP program to implement JDBC.
[SCREENSHOTS]
 35
Q 14: Write a JSP program using Http Session API.
[SOURCE CODE]
<%@ page language="java" import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<title>JSP SESSIONS</title>
</head>
<%
String heading;
Integer accessCount = new Integer(0);
if (session.isNew()) {
heading = "Welcome, Newcomer";
} else {
heading = "Welcome Back";
Integer oldAccessCount = (Integer) session
.getValue("accessCount");
if (oldAccessCount != null) {
accessCount = new Integer(oldAccessCount.intValue() + 1);
}
}
session.putValue("accessCount", accessCount);
%>
<link rel="stylesheet" href="style.css">
<BODY>
<H1 ALIGN="CENTER"><%=heading %></H1>
<center> <H2>Information on Your Session:</H2> </center>
<TABLE ALIGN=CENTER>
<TR> <TH>Info Type</TH> <TH>Value </TH> </TR>
<TR> <TD>ID</TD> <TD><%=session.getId()%></TD> </TR>
<TR> <TD>Creation Time</TD> <TD><%=new Date(session.getCreationTime())%></TD>
</TR>
<TR> <TD>Time of Last Access</TD> <TD><%=new Date(session.getLastAccessedTime())%></TD>
<TR>
<TR>
<TD>Number of Previous Accesses</TD> <TD><%=accessCount%></TD>
</TR>
</TABLE>
</BODY>
</HTML>
 36
Q 14: Write a JSP program using Http Session API.
[SCREENSHOTS]
 37
Q 15: Write a Servlet program to implement Cookies.
[SOURCE CODE]
package com.metalwihen.mms;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class CookieTest extends HttpServlet {
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
Cookie c;
String Name = "[Nothing Saved]";
if (request.getParameterMap().containsKey("Name")) {
c = new Cookie("Name", request.getParameter("Name"));
response.addCookie(c);
Name = request.getParameter("Name");
} else {
Cookie[] Cs = request.getCookies();
if (Cs == null) {
Name = "Not in the cookies. Unknown. ";
} else {
for (int i = 0; i < Cs.length; i++)
if (Cs[i].getName().equalsIgnoreCase("Name")) {
Name = "(Retrieved)" + Cs[i].getValue();
}
}
}
out.println("<html><head>");
out.println("<title> Neil's Form! </title>");
out.println("</head>");
out.println("<link rel=\"stylesheet\" href=\"style.css\" >");
out.println("<body width=80% align=center>");
out.println("<table align=center valign=middle width=80%><tr><td>");
out.println("");
out.println("The Name is: " + Name);
out.println("</td></tr></table>");
}
}
 38
Q 15: Write a Servlet program to implement Cookies.
[SCREENSHOTS]
 39
Q 16: Write a JSP program to implement Cookies.
[SOURCE CODE]
package com.metalwihen.mms;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class CookieTest extends HttpServlet {
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
Cookie c;
String Name = "[Nothing Saved]";
if (request.getParameterMap().containsKey("Name")) {
c = new Cookie("Name", request.getParameter("Name"));
response.addCookie(c);
Name = request.getParameter("Name");
} else {
Cookie[] Cs = request.getCookies();
if (Cs == null) {
Name = "Not in the cookies. Unknown. ";
} else {
for (int i = 0; i < Cs.length; i++)
if (Cs[i].getName().equalsIgnoreCase("Name")) {
Name = "(Retrieved)" + Cs[i].getValue();
}
}
}
out.println("<html><head>");
out.println("<title> Neil's Form! </title>");
out.println("</head>");
out.println("<link rel=\"stylesheet\" href=\"style.css\" >");
out.println("<body width=80% align=center>");
out.println("<table align=center valign=middle width=80%><tr><td>");
out.println("");
out.println("The Name is: " + Name);
out.println("</td></tr></table>");
}
}
 40
Q 16: Write a JSP program to implement Cookies.
[SCREENSHOTS]
 41
Q 17: Write a JSP program using include directive.
[SOURCE CODE]
TopBurger.html
<html>
<body>
<p align="center"><img src="top.png"></p>
</body>
</html>
MidBurger.html
<html>
<body>
<p align="center"><img src="mid.png"></p>
</body>
</html>
BottomBurger.html
<html>
<body>
<p align="center"><img src="bottom.png"></p>
</body>
</html>
JSPinclude.jsp
<!-- Static include like a macro -->
<%@ include file="TopBurger.html" %>
<!-- Dynamic include like a function call -->
<jsp:include page="MidBurger.html" />
<%@ include file="BottomBurger.html" %>
 42
Q 17: Write a JSP program using include directive.
[SCREENSHOTS]