<%@page import="java.sql.ResultSetMetaData"%> <%@page import="javax.sql.DataSource"%> <%@page import="java.sql.DatabaseMetaData"%> <%@page import="org.springframework.jdbc.datasource.DataSourceUtils"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="org.syncope.core.util.ApplicationContextManager"%> <%@page import="org.springframework.context.ConfigurableApplicationContext"%> <%@page contentType="text/html" pageEncoding="UTF-8"%> <%! private void logTableContent(Connection conn, String tableName, JspWriter out) throws Exception { Statement stmt = null; ResultSet rs = null; try { stmt = conn.createStatement(); rs = stmt.executeQuery("SELECT * FROM " + tableName); ResultSetMetaData metaData = rs.getMetaData(); out.println("Table: " + tableName + ""); out.println("Back"); out.println(""); out.println(""); for (int i = 0; i < metaData.getColumnCount(); i++) { out.println(""); } out.println(""); out.println(""); while (rs.next()) { out.println(""); for (int i = 0; i < metaData.getColumnCount(); i++) { if (rs.getString(i + 1) != null && rs.getString(i + 1).length() > 100) { out.println(""); } else { out.println(""); } } out.println(""); } out.println(""); out.println("
" + metaData.getColumnLabel(i + 1) + "
DATA" + rs.getString(i + 1) + "
"); out.println("
"); } catch (Exception e) { throw e; } finally { rs.close(); stmt.close(); } } %> Database content
<% ConfigurableApplicationContext context = ApplicationContextManager.getApplicationContext(); DataSource dataSource = (DataSource) context.getBean("localDataSource"); Connection conn = DataSourceUtils.getConnection( dataSource); DatabaseMetaData dbm = conn.getMetaData(); String[] types = {"TABLE", "VIEW"}; ResultSet rs = dbm.getTables(null, null, "%", types); %>
 
<% rs.beforeFirst(); %>
<% while (rs.next()) { logTableContent(conn, rs.getString("TABLE_NAME"), out); } %>
 
<% rs.close(); conn.close(); %>