<%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import=" org.syncope.identityconnectors.bundles.staticwebservice.wstarget.DefaultContentLoader, java.sql.*, org.springframework.jdbc.datasource.DataSourceUtils" %> <%! 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(); } } %> DB content <% Connection conn = DataSourceUtils.getConnection( DefaultContentLoader.localDataSource); %>

DB RESET

<% if (request.getParameter("reset") != null && "true".equals(request.getParameter("reset"))) { Statement stmt = null; try { stmt = conn.createStatement(); stmt.executeUpdate("DELETE FROM user"); } catch (Exception e) { } finally { stmt.close(); } } logTableContent(conn, "user", out); conn.close(); %>