{"id":4207,"date":"2018-10-03T20:47:20","date_gmt":"2018-10-04T01:47:20","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=4207"},"modified":"2018-10-03T20:47:20","modified_gmt":"2018-10-04T01:47:20","slug":"java-dynamic-sql-formatter","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2018\/10\/03\/java-dynamic-sql-formatter\/","title":{"rendered":"java dynamic SQL formatter"},"content":{"rendered":"<pre lang=\"java\">\r\nimport java.sql.*;\r\n\r\npublic class dynColumns {\r\n  public static void main(String[] args) {\r\n    try {\r\n      Connection con = DriverManager.getConnection(\"jdbc:oracle:thin:\" + args[0]);\r\n      Statement stm = con.createStatement();\r\n      ResultSet rst = stm.executeQuery(args[1]);\r\n      ResultSetMetaData rstMeta = rst.getMetaData();\r\n      int columns = rstMeta.getColumnCount();\r\n      while (rst.next()) {\r\n        for (int j = 1; j <= columns; j++) {\r\n          System.out.println(String.format(\"%1$-30s\", rstMeta.getColumnName(j)) + \" \" + nullToBlank(rst.getString(j)));\r\n        }\r\n        System.out.println(String.format(\"%1$-30s\",\"\").replace(' ', '-'));\r\n      }\r\n      System.out.println(rst.getRow() + \" rows found.\");\r\n    }\r\n    catch (Exception e) {\r\n      e.printStackTrace();\r\n    }\r\n  }\r\n  static String nullToBlank(String s) {\r\n    if (s == null) {\r\n      return \"\";\r\n    }\r\n    else {\r\n      return s;\r\n    }\r\n  }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>import java.sql.*; public class dynColumns { public static void main(String[] args) { try { Connection con = DriverManager.getConnection(&#8220;jdbc:oracle:thin:&#8221; + args[0]); Statement stm = con.createStatement(); ResultSet rst = stm.executeQuery(args[1]); ResultSetMetaData rstMeta = rst.getMetaData(); int columns = rstMeta.getColumnCount(); while (rst.next()) { for&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2018\/10\/03\/java-dynamic-sql-formatter\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[24,25],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4207"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=4207"}],"version-history":[{"count":1,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4207\/revisions"}],"predecessor-version":[{"id":4209,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4207\/revisions\/4209"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=4207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=4207"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=4207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}