ossiejhmoore

Find Tables Somewhere For A Connection

Feb 24th, 2017
336
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.44 KB | None | 0 0
  1. package com.cnl.capoi;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DatabaseMetaData;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7.  
  8. public class CrawlConnection {
  9.  
  10.     private static final String[] filters = {"^.*DTREE.*$", "^.*DVERS.*$"};
  11.     private static Connection con;
  12.     private static DatabaseMetaData conMeta;
  13.  
  14.     public static void main(String[] args) throws Exception {
  15.         Class.forName("oracle.jdbc.OracleDriver");
  16.         con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "rmnausr", "opentext");
  17.         conMeta = con.getMetaData();
  18.         crawl();
  19.         con.close();
  20.     }
  21.  
  22.     private static void crawl() throws Exception {
  23.         ResultSet rsTables = conMeta.getTables(null, null, null, null);
  24.         while (rsTables.next()) {
  25.             String catalog = String.valueOf(rsTables.getObject("TABLE_CAT"));
  26.             String schema = String.valueOf(rsTables.getObject("TABLE_SCHEM"));
  27.             String name = String.valueOf(rsTables.getObject("TABLE_NAME"));
  28.             String type = String.valueOf(rsTables.getObject("TABLE_TYPE"));
  29.             for (String filter : filters) {
  30.                 if (name.matches(filter)) {
  31.                     System.out.printf("CATALOG: %s, SCHEMA: %S, NAME: %s, TYPE: %s%n",
  32.                             catalog, schema, name, type
  33.                     );
  34.                 }
  35.             }
  36.         }
  37.         rsTables.close();
  38.     }
  39. }
Advertisement
Add Comment
Please, Sign In to add comment