%@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 import="org.syncope.core.persistence.DefaultContentLoader"%> <%@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("
" + metaData.getColumnLabel(i + 1) + " | "); } out.println(""); out.println(""); while (rs.next()) { out.println("|
---|---|
DATA | "); } else { out.println("" + rs.getString(i + 1) + " | "); } } out.println("