Sample servlet

import java.sql.*; //import oracle.jdbc.*; import oracle.jdbc.pool.OracleDataSource; import javax.servlet.http.*; import java.io.*; public class GetTableNames extends HttpServlet { protected void doGet(HttpServletRequest req, HttpServletResponse resp) { PrintWriter output=null; try{ // create an OracleDataSource instance OracleDataSource ods = new OracleDataSource(); // Oracle connection string String url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=guess.rutgers.edu)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=prediction.rutgers.edu)(PORT=1521))(LOAD_BALANCE=on))(CONNECT_DATA=(SERVICE_NAME=stud.rutgers.edu)))"; // make the connection ods.setURL(url); ods.setUser("yourUSername"); // replace with your username ods.setPassword("yourPassword"); // replace with your password> Connection conn = ods.getConnection(); //Create a statement Statement stmt = conn.createStatement(); //Get the value of parameter "owner" String owner=req.getParameter("owner"); //Execute sql query. ResultSet rset = stmt.executeQuery("select table_name, num_rows from all_tables where owner= '" + owner.toUpperCase() + "'"); resp.setContentType("text/html"); output=resp.getWriter(); //Iterate through the result and return the result to users. if(! rset.next()){ output.println("The user " + owner +" has no tables." ); } else { output.println("Sample servlet"); output.println("User " + owner + " has: \n"); output.println(""); output.println(""); do{ output.println(""); } while(rset.next()); output.println("

Table_Name	NUMBER_ROWS
"+rset.getString(1)+"	"+ rset.getInt(2)+"

>"); } rset.close(); stmt.close(); conn.close(); } catch (Exception ex) { if(output != null) ex.printStackTrace(output); } } }