Filename-Input.jsp
<html>
<form
action="http://localhost:8090/wtad/def34/conn.jsp">
<h3>JSP Pages</h3>
<h2>
Select Which Query u want to FIER.
</h2>
Select
<input type="radio"
name="select" value="select" />
<br>
Insert
<input type="radio"
name="select" value="insert"/>
<br>
Update
<input type="radio"
name="select" value="update"/>
<br>
Delete
<input type="radio"
name="select" value="delete"/>
<br>
<input type="submit"/>
</form>
</html>
Filename-conn.jsp
<html>
<title>
Jsp Conn Example
</title>
<body>
<%! String sel; %>
<%
sel=request.getParameter("select");
%>
<%
out.println("<b>"+"Enter Data for
"+sel+"<br>"); %>
<%
if(sel.equals("select"))
{
%>
<form
action="http://localhost:8090/wtad/def34/select.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
<input
type="submit"/>
</form>
<%
}
else
if(sel.equals("insert"))
{
%>
<form
action="http://localhost:8090/wtad/def34/insert.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
Name:
<input
type="text"
name="name"/>
<br>
ddress:
<input
type="text"
name="add"/>
<br>
Result:
<input
type="text"
name="result"/>
<br>
<input
type="submit"/>
</form>
<%
}
else
if(sel.equals("update"))
{
%>
<form
action="http://localhost:8090/wtad/def34/update.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
Name:
<input
type="text"
name="name"/>
<br>
Address:
<input
type="text"
name="add"/>
<br>
Result:
<input
type="text"
name="result"/>
<br>
<input
type="submit"/>
</form>
<%
}
else
if(sel.equals("delete"))
{
%>
<form
action="http://localhost:8090/wtad/def34/delete.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
<input
type="submit"/>
</form>
<%
}
%>
</body>
</html>
Filename-select.jsp
<%
<%
int
id=Integer.parseInt(request.getParameter("id"));
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("select stdid,name,address,result from student
where stdid="+id+"");
ResultSet
rs=ps.executeQuery();
while(rs.next())
{
out.println("Id:"+"
"+rs.getInt(1)+"<br>");
out.println("Name:"+"
"+rs.getString(2)+"<br>");
out.println("Address:"+"
"+rs.getString(3)+"<br>");
out.println("Result:"+"
"+rs.getString(1)+"<br>");
}
}
catch(Exception
e)
{
out.println(e);
}
%>
Filename-insert.jsp
<%
int
id=Integer.parseInt(request.getParameter("id"));
String
name=request.getParameter("name");
String
add=request.getParameter("add");
String
result=request.getParameter("result");
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("insert into student
values("+id+",'"+name+"','"+add+"','"+result+"')");
ResultSet
rs=ps.executeQuery();
out.println("Your
Record is inserted"+"<br>");
PreparedStatement
ps1=conn.prepareStatement("select stdid,name,address,result from student
where stdid="+id+"");
ResultSet
rs1=ps1.executeQuery();
while(rs1.next())
{
out.println("Id:"+"
"+rs1.getInt(1)+"<br>");
out.println("Name:"+"
"+rs1.getString(2)+"<br>");
out.println("Address:"+"
"+rs1.getString(3)+"<br>");
out.println("Result:"+"
"+rs1.getString(4)+"<br>");
}
}
catch(Exception
e)
{
out.println(e);
}
%>
Filename-update.jsp
<%
int
id=Integer.parseInt(request.getParameter("id"));
String
name=request.getParameter("name");
String
add=request.getParameter("add");
String
result=request.getParameter("result");
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("update student set
name='"+name+"',address='"+add+"',result='"+result+"'
where stdid="+id+"");
ResultSet
rs=ps.executeQuery();
out.println("Your
Record is Updated"+"<br>");
PreparedStatement
ps1=conn.prepareStatement("select stdid,name,address,result from student
where stdid="+id+"");
ResultSet
rs1=ps1.executeQuery();
while(rs1.next())
{
out.println("<br>");
out.println("<br>"+"Id:"+"
"+rs1.getInt(1)+"<br>");
out.println("Name:"+"
"+rs1.getString(2)+"<br>");
out.println("Address:"+"
"+rs1.getString(3)+"<br>");
out.println("Result:"+"
"+rs1.getString(4)+"<br>");
out.println("<br>"+"<br>");
}
}
catch(Exception
e)
{
out.println(e);
}
%>
Filename-delete.jsp
<%
int
id=Integer.parseInt(request.getParameter("id"));
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("delete student where
stdid="+id+"");
ResultSet
rs=ps.executeQuery();
out.println("Record
is delete id="+id+"<br><br>");
PreparedStatement
ps1=conn.prepareStatement("select * from student");
ResultSet
rs1=ps1.executeQuery();
while(rs1.next())
{
out.println("Id:"+"
"+rs1.getInt(1)+"<br>");
out.println("Name:"+"
"+rs1.getString(2)+"<br>");
out.println("Address:"+"
"+rs1.getString(3)+"<br>");
out.println("Result:"+"
"+rs1.getString(4)+"<br>");
}
}
catch(Exception
e)
{
out.println(e);
}
%>
Output
JSP Pages
Select
Which Query u want to FIER.
Select
Insert
Update
Delete
Insert
Update
Delete
Enter Data for select
ID:
Id: 1001
Name: ccd
Address: bbb
Result: pass
Name: ccd
Address: bbb
Result: pass
good program,this help me.
ReplyDeleteThanks