Show Data through Servlet.
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class Show extends HttpServlet
{
Connection con;
ResultSet rs;
Statement pst;
public void init()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","navjyoti","jyoti7");
pst=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
System.out.println(""+pst);
}
catch(Exception e)
{
System.out.println(e);
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
try
{
PrintWriter pw=response.getWriter();
response.setContentType("text/html");
pw.println("<html><body>");
pw.println("<table border='1'>");
pw.println("<th>EMPID</th><th>NAME</th><th>PASSWORD</th><th>EMAIL</th><th>EDIT</th><th>ERASE</th>");
rs=pst.executeQuery("select *from employee");
System.out.println(""+rs);
int n=0;
while(rs.next())
{
pw.println("<tr>");
n=rs.getInt(1);
pw.println("<td>"+n+"</td>");
pw.println("<td>"+rs.getString(2)+"</td>");
pw.println("<td>"+rs.getString(3)+"</td>");
pw.println("<td>"+rs.getString(4)+"</td>");
pw.println("<td><a href='edit?id="+n+"'>Edit</td>");
pw.println("<td><a href='Del?id="+n+"'>Delete</a></td>");
pw.println("</tr>");
}
pw.println("</table>");
pw.println("</body></html>");
}
catch(Exception e)
{
System.out.println(e);
}
}
}
