• iconJava Online Training In Andhra Pradesh and Telangana
  • icon9010519704

Opening Hours :7AM to 9PM

Jsp


What is Jsp
JavaServer Pages (JSP) is a technology for building web-based applications that uses Java as the programming language. It allows developers to create dynamic, interactive web pages by embedding Java code in HTML pages, which are then compiled and executed on the server side. This makes it easy to build complex, data-driven web applications, as the developer can leverage the full power of the Java language to build the backend logic and connect to databases, while still using HTML to define the layout and presentation of the web page. JSP is often used in conjunction with other Java technologies, such as JavaBeans and servlets, to build complete web applications.

Key Points

  • Jsp
Image
Simple Jsp Program
Steps: click on your project
go to src
go to main
go to webapp
right click on webapp
new
jsp
FileName: first.jsp 
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>


<%

int x=10,y=10,z;
z=x+y;
out.print(z);


%>

</body>
</html>
Output:
20
Jsp Program with HTML
Step -1: Create html file
Second.html
Step -2: Create jsp file
Second.jsp
Second.html
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<form action="second.jsp" method="get">
First Number<input type="text" name="fno" ><br>
Second Number<input type="text" name="sno" ><br>
<input type="submit" value="add me">
</form>

</body>
</html>
Second.jsp
 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<%

int x,y,z;
x=Integer.parseInt(request.getParameter("fno"));
y=Integer.parseInt(request.getParameter("sno"));
z=x+y;
out.print(z);


%>

</body>
</html>

Output:
24
Jsp Program with HTML and Database
Step -1: Create html file
third.html
Step -2: Create jsp file
third.jsp
Step -3: Create table in Database:
create table calc (fno int,sno int,res int);

third.html 

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<form action="third.jsp" method="get">
First Number<input type="text" name="fno" ><br>
Second Number<input type="text" name="sno" ><br>
<input type="submit" value="add me">
</form>

</body>
</html>
third.jsp 
 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%
try
 {
    int x,y,z;;
    x=Integer.parseInt(request.getParameter("fno"));
    y=Integer.parseInt(request.getParameter("sno"));
    z=x+y;
    out.print(z);
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    String url="jdbc:oracle:thin:@localhost:1521:XE";
    Connection con = DriverManager.getConnection(url,"System","1234");
    Statement stmt = con.createStatement();
		
    String s= "insert into calc values('"+x+"','"+y+"','"+z+"')";
    stmt.executeUpdate(s);
 }
catch(Exception e)
{
	out.print(e);
}


%>

</body>
</html>

Output:
Jsp Program -4

Registration Form:


Step -1 : reg.html
Step -2 : reg.jsp
Step -3 : reg Table in Database
    
    
create table reg(
        username varchar(20),
        password varchar(20),
        gender varchar(20),
        location varchar(20),
        l1 varchar(20),
        l2 varchar(20),
        l3 varchar(20) ,
        address varchar(20)
        );
reg.html 
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="reg.jsp" method="post">

Username:<input type="text" name="uname" id="uname"><br>
Password:<input type="password" name="pass" id="pass"><br>
gender<input type="radio" name="gender" id="gender" value="male">Malee
<input type="radio" name="gender" id="gender" value="female">Femalee<br>

location:<select name="loc">

<option value="hyd">Hyderabad</option>
<option value="del">Delhi</option>
<option value="che">Chennai</option>

</select>
<br>
Languages:<input type="checkbox" name="telugu" value="telugu" id="telugu">Teluguu
<input type="checkbox" name="English" value="English" id="English">"English"
<input type="checkbox" name="hindi" value="hindi" id="hindi">hindi

Address:<textarea rows="20" cols="20" id="adder" name="addr"></textarea>
<br>
<input type="submit" value="sign up">
</form>

</body>
</html>
reg.jsp 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>


<%@page import="java.sql.*" %>
<%
String username="",password="",gender="",loc="",l1="",l2="",l3="",addr="";
username=(request.getParameter("uname"));
password=(request.getParameter("pass"));
gender=(request.getParameter("gender"));
loc=(request.getParameter("loc"));
l1=(request.getParameter("telugu"));
l2=(request.getParameter("english"));
l3=(request.getParameter("hindi"));
addr=(request.getParameter("addr"));
try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 Statement stmt = con.createStatement();

String s= "INSERT INTO reg VALUES ('"+username+"', '"+password+"', '"+gender+"','"+loc+"','"+l1+"','"+l2+"','"+l3+"','"+addr+"')";
stmt.executeUpdate(s);

out.println("Data Inserted successfully");
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}


%>

</body>
</html>
Output:
Jsp Program -5

Login Form(Without redirect)

Steps:
Step 1: login.html
Step 2: login.jsp
Login html 
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="login.jsp" method="post">

Username<input type="text" name="uname"><br>
Password<input type="password" name="pass"><br>
<input type="submit" value="login">



</form>
</body>
</html>
login.jsp 
    
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%
String x="",y="",dx="",dy="";
x=request.getParameter("uname");
y=request.getParameter("pass");




try
{
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	String url="jdbc:oracle:thin:@localhost:1521:XE";
	Connection con = DriverManager.getConnection(url,"System","1234");
	Statement stmt = con.createStatement();



String s="select * from reg where username='"+x+"' and password='"+y+"'";
ResultSet rs=stmt.executeQuery(s);
        if(rs.next())   
        {
            dx=rs.getString(1);
            dy=rs.getString(2);  
        }
        
        if(x.equals(dx) && y.equals(dy))
        {
        out.print("login success");
        	
        }
        else
        {
        	out.print("login failed");
        }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>


</body>
</html>
success.html 
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<h1>login success</h1>

Without Cookes and Sessions


<form action="view.jsp" method="post">

<input type="submit" value="view my details">
</form>

<form action="viewtable.jsp" method="post">

<input type="submit" value="view in table">
</form>

<form action="viewlist.jsp" method="post">

<input type="submit" value="view in list">
</form>

<form action="viewtext.jsp" method="post">

<input type="submit" value="view in textbox">
</form>

<form action="edit.jsp" method="post">

<input type="submit" value="edit my details">
</form>



With  Sessions


<form action="view1.jsp" method="post">

<input type="submit" value="view my details">
</form>

<form action="viewtable1.jsp" method="post">

<input type="submit" value="view in table">
</form>

<form action="viewlist1.jsp" method="post">

<input type="submit" value="view in list">
</form>

<form action="viewtext1.jsp" method="post">

<input type="submit" value="view in textbox">
</form>

<form action="edit1.jsp" method="post">

<input type="submit" value="edit my details">
</form>




With Sessions


<form action="view2.jsp" method="post">

<input type="submit" value="view my details">
</form>

<form action="viewtable2.jsp" method="post">

<input type="submit" value="view in table">
</form>

<form action="viewlist2.jsp" method="post">

<input type="submit" value="view in list">
</form>

<form action="viewtext2.jsp" method="post">

<input type="submit" value="view in textbox">
</form>

<form action="edit2.jsp" method="post">

<input type="submit" value="edit my details">
</form>


</body>
</html>
Output:
Jsp Program -6

Login Form(With redirect)

Steps:
Step 1: login.html
Step 2: success.html
Step 3: login.jsp
Step 1: login.html 
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="login.jsp" method="post">

Username<input type="text" name="uname"><br>
Password<input type="password" name="pass"><br>
<input type="submit" value="login">

</form>
</body>
</html>
Step 2: success.html
 
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<h1>login success</h1>

</body>
</html>
Step 3: login.jsp
 
    
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%
String x="",y="",dx="",dy="";
x=request.getParameter("uname");
y=request.getParameter("pass");

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 Statement stmt = con.createStatement();

 String s="select * from reg where username='"+x+"' and password='"+y+"'";
 ResultSet rs=stmt.executeQuery(s);
    if(rs.next())   
    {
     dx=rs.getString(1);
     dy=rs.getString(2);  
    }
        
    if(x.equals(dx) && y.equals(dy))
    {
     response.sendRedirect("success.html");
    }
    else
    {
        	out.print("login failed");
    }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>


</body>
</html>
Output:
Login Program(with using sessions)
Step 1: login.html 
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="login.jsp" method="post">

Username<input type="text" name="uname"><br>
Password<input type="password" name="pass"><br>
<input type="submit" value="login">

</form>
</body>
</html>
Step 2: success.html
 
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<h1>login success</h1>

</body>
</html>
Step 3: login.jsp
 
    
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%
String x="",y="",dx="",dy="";
x=request.getParameter("uname");
y=request.getParameter("pass");
// Session Creation

session.setAttribute("uname",x);
session.setAttribute("pass",y);

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 Statement stmt = con.createStatement();

 String s="select * from reg where username='"+x+"' and password='"+y+"'";
 ResultSet rs=stmt.executeQuery(s);
    if(rs.next())   
    {
     dx=rs.getString(1);
     dy=rs.getString(2);  
    }
        
    if(x.equals(dx) && y.equals(dy))
    {
     response.sendRedirect("success.html");
    }
    else
    {
        	out.print("login failed");
    }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>


</body>
</html>
Output:
Login Program(with using cookies)
Step 1: login.html 
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="login.jsp" method="post">

Username<input type="text" name="uname"><br>
Password<input type="password" name="pass"><br>
<input type="submit" value="login">

</form>
</body>
</html>
Step 2: success.html
 
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<h1>login success</h1>

</body>
</html>
Step 3: login.jsp
 
    
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%
String x="",y="",dx="",dy="";
x=request.getParameter("uname");
y=request.getParameter("pass");

Cookie ck1=new Cookie("uname",x);//creating cookie object  
response.addCookie(ck1);//adding cookie in the response  

Cookie ck2=new Cookie("pass",y);//creating cookie object  
response.addCookie(ck2);//adding cookie in the response 

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 Statement stmt = con.createStatement();

 String s="select * from reg where username='"+x+"' and password='"+y+"'";
 ResultSet rs=stmt.executeQuery(s);
    if(rs.next())   
    {
     dx=rs.getString(1);
     dy=rs.getString(2);  
    }
        
    if(x.equals(dx) && y.equals(dy))
    {
     response.sendRedirect("success.html");
    }
    else
    {
        	out.print("login failed");
    }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>


</body>
</html>
Output:

Jsp Program


Success Page

Key Points

  • What is jsp
  • What is Sessions
  • What is Cookies
Image
Jsp Program -7

Success.html

                                       
success.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<h1>Jsp login success</h1>


<form action="view.jsp" method="post">
<input type="submit" value="view my details">
</form>

<form action="viewtable.jsp" method="post">
<input type="submit" value="view in table">
</form>

<form action="viewlist.jsp" method="post">
<input type="submit" value="view in list">
</form>

<form action="viewtextbox.jsp" method="post">
<input type="submit" value="view in textbox">
</form>

<form action="edit.jsp" method="post">
<input type="submit" value="edit my details">
</form>



</body>
</html>
Output:
Jsp Program -8
view.jsp
View Data
View Program(without using sessions and cookies) 
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%

try
{
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	String url="jdbc:oracle:thin:@localhost:1521:XE";
	Connection con = DriverManager.getConnection(url,"System","1234");
    Statement stmt = con.createStatement();
    
    String s="select * from reg ";
    ResultSet rs=stmt.executeQuery(s);
   while(rs.next())
   {
	   out.print(rs.getString(1)+"  ");
	   out.print(rs.getString(2)+"  ");
	   out.print(rs.getString(3)+"  ");
	   out.print(rs.getString(4)+"  ");
	   out.print(rs.getString(5)+"  ");
	   out.print(rs.getString(6)+"  ");
	   out.print(rs.getString(7)+"  ");
	  out.print(rs.getString(8)+"  ");
	   out.println();
   }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
View Program(with using sessions)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;
x=(String)session.getAttribute("sname");
y=(String)session.getAttribute("spass");

try
{
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	String url="jdbc:oracle:thin:@localhost:1521:XE";
	Connection con = DriverManager.getConnection(url,"System","1234");
    Statement stmt = con.createStatement();
    
    String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
    ResultSet rs=stmt.executeQuery(s);
   while(rs.next())
   {
	   out.print(rs.getString(1)+"  ");
	   out.print(rs.getString(2)+"  ");
	   out.print(rs.getString(3)+"  ");
	   out.print(rs.getString(4)+"  ");
	   out.print(rs.getString(5)+"  ");
	   out.print(rs.getString(6)+"  ");
	   out.print(rs.getString(7)+"  ");
	  out.print(rs.getString(8)+"  ");
	   out.println();
	   
   }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}




%>

</body>
</html>
Output:
View Program(with using cookies)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;

Cookie ck[]=request.getCookies();
			
x=ck[0].getValue(); // or x=ck[1].getValue();
y=ck[1].getValue(); // or  y=ck[2].getValue();

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 
 Statement stmt = con.createStatement();
 String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
 ResultSet rs=stmt.executeQuery(s);
   while(rs.next())
   {
	   out.print(rs.getString(1)+"  ");
	   out.print(rs.getString(2)+"  ");
	   out.print(rs.getString(3)+"  ");
	   out.print(rs.getString(4)+"  ");
	   out.print(rs.getString(5)+"  ");
	   out.print(rs.getString(6)+"  ");
	   out.print(rs.getString(7)+"  ");
	   out.print(rs.getString(8)+"  ");
	   out.println();
   
   }
    
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
Jsp Program -9
viewtable.jsp
View Data in html Table
Company Contact Country
Alfreds Futterkiste Maria Anders Germany
Centro comercial Moctezuma Francisco Chang Mexico
View Data in html Table Program(without using sessions and cookies) 
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%

try
{
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String url="jdbc:oracle:thin:@localhost:1521:XE";
  Connection con = DriverManager.getConnection(url,"System","1234");
  Statement stmt = con.createStatement();
    
  String s="select * from reg  ";
  ResultSet rs=stmt.executeQuery(s);
  
   %>
   <table border=1>
   <%   
   while(rs.next())
    {
	%>
	   <tr>
	   <td><% out.print(rs.getString(1)); %></td>
	   <td><% out.print(rs.getString(2)); %></td>
	   <td><% out.print(rs.getString(3)); %></td>
	   <td><% out.print(rs.getString(4)); %></td>
	   <td><% out.print(rs.getString(5)); %></td>
	   <td><% out.print(rs.getString(6)); %></td>
	   <td><% out.print(rs.getString(7)); %></td>
	   <td><% out.print(rs.getString(8)); %></td>
	   </tr>
	   
	<%    
   }
  %>
   </table>
<%  

stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
View Data in html Table Program(with using sessions)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;
x=(String)session.getAttribute("sname");
y=(String)session.getAttribute("spass");

try
{
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	String url="jdbc:oracle:thin:@localhost:1521:XE";
	Connection con = DriverManager.getConnection(url,"System","1234");
    Statement stmt = con.createStatement();
    
    String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
    ResultSet rs=stmt.executeQuery(s);
 
   %>
   <table border=1>
   <%   
   while(rs.next())
    {
	%>
	   <tr>
	   <td><% out.print(rs.getString(1)); %></td>
	   <td><% out.print(rs.getString(2)); %></td>
	   <td><% out.print(rs.getString(3)); %></td>
	   <td><% out.print(rs.getString(4)); %></td>
	   <td><% out.print(rs.getString(5)); %></td>
	   <td><% out.print(rs.getString(6)); %></td>
	   <td><% out.print(rs.getString(7)); %></td>
	   <td><% out.print(rs.getString(8)); %></td>
	   </tr>
	   
	<%    
   }
  %>
   </table>
<%  

stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}




%>

</body>
</html>
Output:
View Data in html Table Program(with using cookies)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;

Cookie ck[]=request.getCookies();
			
x=ck[0].getValue(); // or x=ck[1].getValue();
y=ck[1].getValue(); // or  y=ck[2].getValue();

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 
 Statement stmt = con.createStatement();
 String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
 ResultSet rs=stmt.executeQuery(s);
  
   %>
   <table border=1>
   <%   
   while(rs.next())
    {
	%>
	   <tr>
	   <td><% out.print(rs.getString(1)); %></td>
	   <td><% out.print(rs.getString(2)); %></td>
	   <td><% out.print(rs.getString(3)); %></td>
	   <td><% out.print(rs.getString(4)); %></td>
	   <td><% out.print(rs.getString(5)); %></td>
	   <td><% out.print(rs.getString(6)); %></td>
	   <td><% out.print(rs.getString(7)); %></td>
	   <td><% out.print(rs.getString(8)); %></td>
	   </tr>
	   
	<%    
   }
  %>
   </table>
<%  

stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
Jsp Program -10
viewlist.jsp
View Data in html List
  • Coffee
  • Tea
  • Milk
View Data in html List Program(without using sessions and cookies) 
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%

try
{
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String url="jdbc:oracle:thin:@localhost:1521:XE";
  Connection con = DriverManager.getConnection(url,"System","1234");
  Statement stmt = con.createStatement();
    
  String s="select * from reg ";
  ResultSet rs=stmt.executeQuery(s);
  
 %>
 <%   
 while(rs.next())
   {
	%>
	   <ol type=1>
	   <li><% out.print(rs.getString(1)); %></li>
	   <li><% out.print(rs.getString(2)); %></li>
	   <li><% out.print(rs.getString(3)); %></li>
	   <li><% out.print(rs.getString(4)); %></li>
	   <li><% out.print(rs.getString(5)); %></li>
	   <li><% out.print(rs.getString(6)); %></li>
	   <li><% out.print(rs.getString(7)); %></li>
	   <li><% out.print(rs.getString(8)); %></li>
	   </ol>
	   
	<%    
   }
%>
<% 

stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
View Data in html List Program(with using sessions)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;
x=(String)session.getAttribute("sname");
y=(String)session.getAttribute("spass");

try
{
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	String url="jdbc:oracle:thin:@localhost:1521:XE";
	Connection con = DriverManager.getConnection(url,"System","1234");
    Statement stmt = con.createStatement();
    
    String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
    ResultSet rs=stmt.executeQuery(s);
 
 %>
 <%   
 while(rs.next())
   {
	%>
	   <ol type=1>
	   <li><% out.print(rs.getString(1)); %></li>
	   <li><% out.print(rs.getString(2)); %></li>
	   <li><% out.print(rs.getString(3)); %></li>
	   <li><% out.print(rs.getString(4)); %></li>
	   <li><% out.print(rs.getString(5)); %></li>
	   <li><% out.print(rs.getString(6)); %></li>
	   <li><% out.print(rs.getString(7)); %></li>
	   <li><% out.print(rs.getString(8)); %></li>
	   </ol>
	   
	<%    
   }
%>
<% 
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}




%>

</body>
</html>
Output:
View Data in html List Program(with using cookies)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;

Cookie ck[]=request.getCookies();
			
x=ck[0].getValue(); // or x=ck[1].getValue();
y=ck[1].getValue(); // or  y=ck[2].getValue();

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 
 Statement stmt = con.createStatement();
 String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
 ResultSet rs=stmt.executeQuery(s);
  
 %>
 <%   
 while(rs.next())
   {
	%>
	   <ol type=1>
	   <li><% out.print(rs.getString(1)); %></li>
	   <li><% out.print(rs.getString(2)); %></li>
	   <li><% out.print(rs.getString(3)); %></li>
	   <li><% out.print(rs.getString(4)); %></li>
	   <li><% out.print(rs.getString(5)); %></li>
	   <li><% out.print(rs.getString(6)); %></li>
	   <li><% out.print(rs.getString(7)); %></li>
	   <li><% out.print(rs.getString(8)); %></li>
	   </ol>
	   
	<%    
   }
%>
<% 




stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
Jsp Program -11
viewtextbox.jsp
View Data in html TextBox
  • Coffee
  • Tea
  • Milk
View Data in html TextBox Program(without using sessions and cookies) 
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%

try
{
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String url="jdbc:oracle:thin:@localhost:1521:XE";
  Connection con = DriverManager.getConnection(url,"System","1234");
  Statement stmt = con.createStatement();
    
  String s="select * from reg  ";
  ResultSet rs=stmt.executeQuery(s);
  
 %>
 <%    
  while(rs.next())
   {
	%>
	   Username<input type="text" name="uname" value="<%= rs.getString(1) %>"><br>
	   Password<input type="text" name="pass" value="<%= rs.getString(2) %>"><br>
	   Gender <input type="text" name="gender" value="<%= rs.getString(3) %>"><br>
	   location <input type="text" name="loc" value="<%= rs.getString(4) %>"><br>
	   Language -1<input type="text" name="l1" value="<%= rs.getString(5) %>"><br>
	   Language -2<input type="text" name="l2" value="<%= rs.getString(6) %>"><br>
	   Language -3 <input type="text" name="l3" value="<%= rs.getString(7) %>"><br>
	   Address <input type="text" name="addr" value="<%= rs.getString(8) %>"><br>
	 
	  <%    
   }
 %>
 <% 

stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
View Data in html TextBox Program(with using sessions)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;
x=(String)session.getAttribute("sname");
y=(String)session.getAttribute("spass");

try
{
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	String url="jdbc:oracle:thin:@localhost:1521:XE";
	Connection con = DriverManager.getConnection(url,"System","1234");
    Statement stmt = con.createStatement();
    
    String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
    ResultSet rs=stmt.executeQuery(s);
 
 %>
 <%    
  while(rs.next())
   {
	%>
	   Username<input type="text" name="uname" value="<%= rs.getString(1) %>"><br>
	   Password<input type="text" name="pass" value="<%= rs.getString(2) %>"><br>
	   Gender <input type="text" name="gender" value="<%= rs.getString(3) %>"><br>
	   location <input type="text" name="loc" value="<%= rs.getString(4) %>"><br>
	   Language -1<input type="text" name="l1" value="<%= rs.getString(5) %>"><br>
	   Language -2<input type="text" name="l2" value="<%= rs.getString(6) %>"><br>
	   Language -3 <input type="text" name="l3" value="<%= rs.getString(7) %>"><br>
	   Address <input type="text" name="addr" value="<%= rs.getString(8) %>"><br>
	 
	  <%    
   }
 %>
 <% 
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}




%>

</body>
</html>
Output:
View Data in html TextBox Program(with using cookies)
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
String x,y;

Cookie ck[]=request.getCookies();
			
x=ck[0].getValue(); // or x=ck[1].getValue();
y=ck[1].getValue(); // or  y=ck[2].getValue();

try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 
 Statement stmt = con.createStatement();
 String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
 ResultSet rs=stmt.executeQuery(s);
  
 %>
 <%    
  while(rs.next())
   {
	%>
	   Username<input type="text" name="uname" value="<%= rs.getString(1) %>"><br>
	   Password<input type="text" name="pass" value="<%= rs.getString(2) %>"><br>
	   Gender <input type="text" name="gender" value="<%= rs.getString(3) %>"><br>
	   location <input type="text" name="loc" value="<%= rs.getString(4) %>"><br>
	   Language -1<input type="text" name="l1" value="<%= rs.getString(5) %>"><br>
	   Language -2<input type="text" name="l2" value="<%= rs.getString(6) %>"><br>
	   Language -3 <input type="text" name="l3" value="<%= rs.getString(7) %>"><br>
	   Address <input type="text" name="addr" value="<%= rs.getString(8) %>"><br>
	 
	  <%    
   }
 %>
 <% 

stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
Jsp Program -12
edit.jsp
Edit Data in textBox
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%

String x,y;
x=(String)session.getAttribute("sname");
y=(String)session.getAttribute("spass");
try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 
 Statement stmt = con.createStatement();
 String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
 ResultSet rs=stmt.executeQuery(s);
 %>
 <%   
 while(rs.next())
   {
	%>
	<form action="update.jsp" method="post">
	Username<input type="text" name="uname" value="<%= rs.getString(1) %>"><br>
	Password<input type="text" name="pass" value="<%= rs.getString(2) %>"><br>
	Gender <input type="text" name="gender" value="<%= rs.getString(3) %>"><br>
	location <input type="text" name="loc" value="<%= rs.getString(4) %>"><br>
	Language -1<input type="text" name="l1" value="<%= rs.getString(5) %>"><br>
	Language -2<input type="text" name="l2" value="<%= rs.getString(6) %>"><br>
	Language -3 <input type="text" name="l3" value="<%= rs.getString(7) %>"><br>
	Address <input type="text" name="addr" value="<%= rs.getString(8) %>"><br>
	<input type="submit" value="update my details">
	</form> 
	   
	<%    
   }
 %>
 <%  
 
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output: 
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<%@page import="java.sql.*" %>
<%

String x,y;
Cookie ck[]=request.getCookies();

x=ck[0].getValue();  //  or x=ck[1].getValue();
y=ck[1].getValue();  //  or  y=ck[2].getValue();
try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 
 Statement stmt = con.createStatement();
 String s="select * from reg  where username='"+x+"' and password='"+y+"' ";
 ResultSet rs=stmt.executeQuery(s);
 %>
 <%   
 while(rs.next())
   {
	%>
	<form action="update.jsp" method="post">
	Username<input type="text" name="uname" value="<%= rs.getString(1) %>"><br>
	Password<input type="text" name="pass" value="<%= rs.getString(2) %>"><br>
	Gender <input type="text" name="gender" value="<%= rs.getString(3) %>"><br>
	location <input type="text" name="loc" value="<%= rs.getString(4) %>"><br>
	Language -1<input type="text" name="l1" value="<%= rs.getString(5) %>"><br>
	Language -2<input type="text" name="l2" value="<%= rs.getString(6) %>"><br>
	Language -3 <input type="text" name="l3" value="<%= rs.getString(7) %>"><br>
	Address <input type="text" name="addr" value="<%= rs.getString(8) %>"><br>
	<input type="submit" value="update my details">
	</form> 
	   
	<%    
   }
 %>
 <%  
 
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output:
Jsp Program -13
update.jsp
Update
                                    
 <%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>


<%@page import="java.sql.*" %>
<%
String x,y, gender="",loc="",l1="",l2="",l3="",addr="";

x=(String)session.getAttribute("sname");
y=(String)session.getAttribute("spass");
gender=(request.getParameter("gender"));
loc=(request.getParameter("loc"));
l1=(request.getParameter("l1"));
l2=(request.getParameter("l2"));
l3=(request.getParameter("l3"));
addr=(request.getParameter("addr"));
try
{
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String url="jdbc:oracle:thin:@localhost:1521:XE";
  Connection con = DriverManager.getConnection(url,"System","1234");
  Statement stmt = con.createStatement();

  String s= "update reg set gender='"+gender+"',location ='"+loc+"',l1='"+l1+"',l2='"+l2+"',l3='"+l3+"',address='"+addr+"' where username='"+x+"' and password='"+y+"' ";
  stmt.executeUpdate(s);

  out.println("Data updated successfully");
  stmt.close();
  con.close();
}
catch(Exception e)
{
 out.println(""+e);
}

%>

</body>
</html>
Output: 
                                    
 <%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>


<%@page import="java.sql.*" %>
<%
String x,y, gender="",loc="",l1="",l2="",l3="",addr="";
Cookie ck[]=request.getCookies();

x=ck[0].getValue(); // or x=ck[1].getValue();
y=ck[1].getValue(); // or  y=ck[2].getValue();
gender=(request.getParameter("gender"));
loc=(request.getParameter("loc"));
l1=(request.getParameter("l1"));
l2=(request.getParameter("l2"));
l3=(request.getParameter("l3"));
addr=(request.getParameter("addr"));
try
{
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 String url="jdbc:oracle:thin:@localhost:1521:XE";
 Connection con = DriverManager.getConnection(url,"System","1234");
 Statement stmt = con.createStatement();

 String s= "update reg set gender='"+gender+"',location ='"+loc+"',l1='"+l1+"',l2='"+l2+"',l3='"+l3+"',address='"+addr+"' where username='"+x+"' and password='"+y+"' ";
 stmt.executeUpdate(s);

out.println("Data updated successfully");
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}

%>

</body>
</html>
Output: