Filename-input.jsp
<html>
<title>
Enter data
</title>
<body>
<form
action="http://localhost:8090/wtad/def28/conn.jsp"
align="center">
<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>
</body>
</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/def28/select.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
<input
type="submit"/>
</form>
<%
}
else
if(sel.equals("insert"))
{
%>
<form
action="http://localhost:8090/wtad/def28/insert.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
Name:
<input
type="text"
name="name"/>
<br>
desg:
<input
type="text"
name="desg"/>
<br>
Join_date:
<input
type="text" name="jdate"/>
<br>
Salary:
<input
type="text" name="sal"/>
<br>
<input
type="submit"/>
</form>
<%
}
else
if(sel.equals("update"))
{
%>
<form
action="http://localhost:8090/wtad/def28/update.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
Name:
<input
type="text"
name="name"/>
<br>
desg:
<input
type="text" name="desg"/>
<br>
Join_date:
<input
type="text" name="jdate"/>
<br>
Salary:
<input
type="text" name="sal"/>
<br>
<input
type="submit"/>
</form>
<%
}
else
if(sel.equals("delete"))
{
%>
<form
action="http://localhost:8090/wtad/def28/delete.jsp"/>
ID:
<input
type="text" name="id"/>
<br>
<input
type="submit"/>
</form>
<%
}
%>
</body>
</html>
Filename-select.jsp
<html>
<title>
Selecting data
</title>
<body>
<%@
page import="java.sql.*" %>
<%@
page import="java.io.*" %>
<%
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 id,name,desg,jdate,sal from employee
where id="+id+"");
ResultSet
rs=ps.executeQuery();
while(rs.next())
{
out.println("Id:"+"
"+rs.getInt(1)+"<br>");
out.println("Name:"+"
"+rs.getString(2)+"<br>");
out.println("Designation:"+"
"+rs.getString(3)+"<br>");
out.println("Date:"+"
"+rs.getDate(4)+"<br>");
out.println("Salary:"+"
"+rs.getInt(5)+"<br>");
}
}
catch(Exception
e)
{
out.println(e);
}
%>
</body>
</html>
Filename-insert.jsp
<%
int
id=Integer.parseInt(request.getParameter("id"));
String
name=request.getParameter("name");
String
desg=request.getParameter("desg");
String
sdt=request.getParameter("jdate");
int
sal=Integer.parseInt(request.getParameter("sal"));
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("insert into employee
values("+id+",'"+name+"','"+desg+"','"+sdt+"',"+sal+")");
ResultSet
rs=ps.executeQuery();
out.println("Your
Record is inserted"+"<br>");
}
catch(Exception
e)
{
out.println(e);
}
Filename-update.jsp
<%
int
id=Integer.parseInt(request.getParameter("id"));
String
name=request.getParameter("name");
String
desg=request.getParameter("desg");
String
sdt=request.getParameter("jdate");
int
sal=Integer.parseInt(request.getParameter("sal"));
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("update employee set
name='"+name+"',desg='"+desg+"',jdate='"+sdt+"',sal="+sal+"
where id="+id+"");
ResultSet
rs=ps.executeQuery();
out.println("Your
Record is Update"+"<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 employee where
id="+id+"");
ResultSet
rs=ps.executeQuery();
out.println("Record
is delete id="+id+"<br><br>");
%>
Output
Select Which Query u want to FIRE.
Select
Insert
Update
Delete
Insert
Update
Delete
Enter Data for select
ID:
Id: 101
Name: krunal
Designation: manager
Date: 1989-07-30
Salary: 100000
Name: krunal
Designation: manager
Date: 1989-07-30
Salary: 100000
No comments:
Post a Comment