import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
import java.sql.*;
public class ShowTables extends HttpServlet {
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String login = req.getParameter("login");
String password = req.getParameter("password");
Connection con = null;
ResultSet rs = null;
try {
String url = "jdbc:oracle:thin:" + login + "/" + password + "@sol4:1521:stud";
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url);
rs = con.createStatement().executeQuery("Select * from cat");
} catch (Exception e) {
out.println("Failed to query database: " + e.getMessage());
return;
}
out.println("<HTML><HEAD><TITLE>User Tables</TITLE></HEAD>");
out.println("<BODY bgcolor='yellow'><H1>Hello " + login + ". </H1><H2>Your Tables: </H2>\n <ol>");
try {
while (rs.next())
out.println("<li>" + rs.getString("TABLE_NAME") + "</li>");
} catch (Exception e) {
out.println("Failed to query database: " + e.getMessage());
}
out.println("</ol></BODY></HTML>");
}
}
|