String sql = "select * from athlete";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ResultSetMetaData rsm = null;
response.setContentType("text/html");
java.io.PrintWriter out = response.getWriter();
out.println("<html><head><title>Discover a ResultSet</title></head><body>");
out.println("<h2>Here is Info about the returned ResultSet</h2>");
out.println("<table border='1'><tr>");
try{
//Get a connection from the pool
conn = pool.getConnection();
//Create a Statement with which to run some SQL
stmt = conn.createStatement();
//Execute the SQL
rs = stmt.executeQuery(sql);
//Get a ResultSetMetaData object from the ResultSet
rsm = rs.getMetaData();
int colCount = rsm.getColumnCount();
//print column names
printMeta(rsm,"name",out,colCount);
//print column index
printMeta(rsm,"index",out,colCount);
//print column type
printMeta(rsm,"column type",out,colCount);
//print column display size
printMeta(rsm,"column display",out,colCount);
} catch (Exception e){
throw new ServletException(e.getMessage());
} finally {
try{
stmt.close();
conn.close();
} catch (SQLException sqle){ }
}
out.println("</table></body></html>");
out.close();
