[pro29index.jsp]
<html>
<head>
<script language="javascript">
function valid_num()
{
e=event.keyCode;
//alert(e);
if( !(e>=48 && e<=57))
{
event.keyCode=0;
}
}
</script>
</head>
<body>
<table align=center cellpadding=10>
<tr>
<td><img src="logo.jpg"/>
</table>
<table align=center width=100% cellpadding=5>
<tr>
<td colspan=2 align="center"><h2><i>DATABASE DRIVEN OPERATIONS</i></h2>
<tr>
<td align="right" colspan=2><a href="http://master-gtu.blogspot.com">www.master-gtu.blogspot.com</a>
<tr>
<td valign=top>
<form name="f1" action="pro29">
<table>
<tr>
<td>Employee ID
<td><input type="text" name="empid">
<td><input type="submit" value="search" onclick="document.f1.flag.value=1;document.f1.fn.value='empid';document.f1.action='pro29index.jsp'">
<tr>
<td>Employee NAME
<td><input type="text" name="empname">
<td><input type="submit" value="search" onclick="document.f1.flag.value=2;document.f1.fn.value='empname';document.f1.action='pro29index.jsp'">
<tr>
<td>Employee DISIGNATION
<td><input type="text" name="emp_desig">
<td><input type="submit" value="search" onclick="document.f1.flag.value=3;document.f1.fn.value='emp_desig';document.f1.action='pro29index.jsp'">
<tr>
<td>Employee JOIN DATE
<td><input type="text" name="emp_j_date">
<tr>
<td>Employee SALARY
<td><input type="text" name="emp_salary">
<tr>
<td colspan=3>
<input type="submit" name="insert" value="INSERT" onclick="document.f1.flag.value=5">
<input type="submit" name="DELETE" value="DELETE" onclick="document.f1.flag.value=6">
<input type="submit" name="update" value="UPDATE" onclick="document.f1.flag.value=7">
<input type="submit" name="view" value="VIEW ALL" onclick="document.f1.action='pro29index.jsp'">
</table>
<input type="hidden" name="flag" value="">
<input type="hidden" name="fn" value="">
</form>
<%
String msg=request.getParameter("msg");
if(msg!=null)
out.println("<font color=red>"+msg+"</font>");
%>
<td>
<jsp:include page="/pro29showtable.jsp"/>
</table>
</body>
</html>
[pro29showtable.jsp]
<%@ page import="java.sql.*" %>
<table border=5><tr><td>
<table cellpadding=10>
<tr bgcolor="limegreen">
<th>Empid<th>Empname<th>emp_desig<th>emp_j_date<th>emp_salary
<%
String q;
boolean flag=false;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");
String fn=request.getParameter("fn");
String value=request.getParameter(fn);
if(fn=="" || fn==null)
{
q="select * from employee";
}
else
{
q="select * from employee where "+fn+" LIKE ?";
flag=true;
}
PreparedStatement ps=con.prepareStatement(q);
if(flag)
ps.setString(1,value);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
%>
<tr>
<td><%= rs.getInt(1) %>
<td><%= rs.getString(2) %>
<td><%= rs.getString(3) %>
<td><%= rs.getString(4) %>
<td><%= rs.getString(5) %>
<%
}
rs.close();
ps.close();
con.close();
}catch(Exception e){ out.println("error found:"+e);}
%>
</table></table>
[pro29.java]
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
@WebServlet("/pro29")
public class pro29 extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String q;
String msg="";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");
PreparedStatement ps=con.prepareStatement("select * from employee");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from employee");
String empid=req.getParameter("empid");
String empname=req.getParameter("empname");
String emp_desig=req.getParameter("emp_desig");
String emp_j_date=req.getParameter("emp_j_date");
String emp_salary=req.getParameter("emp_salary");
int flag=Integer.parseInt(req.getParameter("flag"));
if(empid.equals(""))
{
msg="Enter EmpID first";
flag=1;
}
switch(flag)
{
case 4:
out.println("4 selected");
break;
case 5:
rs=stmt.executeQuery("select * from employee where empid='"+empid+"'");
if(!rs.next())
{
q="insert into employee values(?,?,?,?,?)";
ps=con.prepareStatement(q);
ps.setString(1,empid);
ps.setString(2,empname);
ps.setString(3,emp_desig);
ps.setString(4,emp_j_date);
ps.setString(5,emp_salary);
msg="Insert Record Successfully...";
}
else
{
msg="Employee Id Already Exist...";
}
break;
case 6:
rs=stmt.executeQuery("select * from employee where empid='"+empid+"'");
if(rs.next())
{
q="delete from employee where empid=?";
ps=con.prepareStatement(q);
ps.setString(1,empid);
msg="Delete Record Successfully...";
}
else
{
msg="Employee Not Exist...";
}
break;
case 7:
rs=stmt.executeQuery("select * from employee where empid='"+empid+"'");
if(rs.next())
{
q="update employee set empname=?, emp_desig=?, emp_j_date=?, emp_salary=? where empid=?";
ps=con.prepareStatement(q);
ps.setString(1,empname);
ps.setString(2,emp_desig);
ps.setString(3,emp_j_date);
ps.setString(4,emp_salary);
ps.setString(5,empid);
msg="Update Record Successfully...";
}
else
{
msg="Employee Not Exist...";
}
break;
}
ps.executeQuery();
stmt.close();
ps.close();
con.close();
}catch(Exception e){}
res.sendRedirect("pro29index.jsp");
}
}
Thank you to tell us so much useful information. I’m glad to read it. for more details you can go to below link…
ReplyDeleteherbal incense for sale