import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class DBServlet extends HttpServlet
{
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter pw=response.getWriter();
try
{
String qry=request.getParameter("table");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("driver loaded");
Connection con=DriverManager.
getConnection("jdbc:oracle:thin:@localhost:1521:SATHYA","scott","tiger");
System.out.println("connection established");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from "+qry);
ResultSetMetaData rsmd=rs.getMetaData();
int columncount=rsmd.getColumnCount();
System.out.println(columncount);
pw.println("<html>");
pw.println("<body bgcolor=yellow>");
pw.println("<center>the details of the table"+qry);
pw.println("<table border=1 width=100%>");
pw.println("<tr bgcolor=cyan>");
for(int col=1;col<=columncount;col++)
pw.println("<th>"+rsmd.getColumnLabel(col)+" </th>");
pw.println("</tr>");
while(rs.next())
{
pw.println("<tr bgcolor=green>");
for(int i=1;i<=columncount;i++)
pw.println("<td>"+rs.getString(i)+"</td>");
pw.println("</tr>");
}
rs.close();
st.close();
con.close();
pw.println("</table></body></html>");
}
catch(Exception e)
{
pw.println("<html><body bgcolor=blue >");
pw.println("<b>table doesnt exist");
}
}
}
No comments:
Post a Comment