<%@ page contentType="text/html; charset=Windows-31J" %> <%@ page import ="javax.sql.*, java.sql.*,java.util.*" %> <%@ page import ="sample.util.db.PostgresDataSourceManager, sample.util.db.A" %> <%@ page import ="org.apache.commons.dbutils.*, org.apache.commons.dbutils.handlers.*" %> <% String sql = request.getParameter("sql"); %>

SQL:

SQL:<%= sql %> <% if(sql == null || sql.equals("")) { sql = "select * from pg_tables"; } List list = null; try { DataSource ds = PostgresDataSourceManager.getDataSource(); QueryRunner qr = new QueryRunner(ds); ResultSetHandler rsh = new MapListHandler(); list = (List)qr.query(sql, rsh); if(list != null && list.size() != 0) { Map row = (Map)list.get(0); int columnCount = row.size(); Set keySet = null; if(row != null) { keySet = row.keySet(); } %> <% Iterator it = keySet.iterator(); while(it.hasNext()) { %> <% } %> <% for(int ii=0; ii <% Iterator it2 = keySet2.iterator(); while(it2.hasNext()) { %> <% } %> <% } %>

<%= it.next() %>
<%= record.get((String)it2.next()) %>

<% } } catch(Exception e) { request.setAttribute("exception",e); %> <% } %>