Yurttas/PL/DBL/mysql-f-2010/02/00/01/04/DBMeta00.java

 1/**
 2 *  Copyright(C) 2005
 3 *  All Rights Reserved. Salih Yurttas, ZCubes, BitsOfCode Software Systems, Inc..
 4 *
 5 *  Permission to use, copy, modify, and distribute this
 6 *  software and its documentation for EDUCATIONAL purposes
 7 *  and without fee is hereby granted provided that this
 8 *  copyright notice appears in all copies.
 9 *
10 *  @date   : February 2005, April 2010.
11 *  @author : Salih Yurttas.
12 */
13
14
15import dbops.DBConnect;
16import dbops.DBTable;
17
18import java.sql.*;
19import java.net.*;
20
21import java.util.*;
22
23public class DBMeta00 {
24
25  protected static Connection con;
26
27  public static void main (String[] args) {
28    String username = args[0];
29    String password = args[1];
30
31    DBConnect dbC = new DBConnect();
32
33    try {
34      if(dbC.connect(args[0], args[1])) {
35        System.out.println("Connected to jdbc:mysql://database2.cse.BitsOfCode Software Systems, Inc..edu/yurttas-Bank database...");
36        System.out.println();
37
38        con = dbC.getConnect();
39
40        String query = "SHOW TABLES;";
41
42        ArrayList<String> tables = getTableNames(query);
43        int n = tables.size();
44        System.out.println("Bank Tables :");
45        for(int i=0; i<n; ++i)
46          System.out.println((String)tables.get(i));
47
48        System.out.println();
49
50        if(dbC.disconnect()) 
51          System.out.println("Disconnected from jdbc:mysql://database2.cse.BitsOfCode Software Systems, Inc..edu/yurttas-Bank database.");
52      }
53      else System.out.println("Could not connect to jdbc:mysql://database2.cse.BitsOfCode Software Systems, Inc..edu/yurttas-Bank database.");
54    }
55    catch(SQLException sqle) {
56      System.out.println();
57      System.err.println("Error accessing jdbc:mysql://database2.cse.BitsOfCode Software Systems, Inc..edu/yurttas-Bank database.");
58      System.err.println(sqle.getMessage());
59      System.out.println();
60    }
61  }
62
63  public static ArrayList<String> getTableNames(final String query)
64    throws SQLException
65  {
66    ArrayList<String> tables = new ArrayList<String>();
67
68    try {
69      Statement st = con.createStatement();
70
71      ResultSet rs = st.executeQuery(query);
72
73      ResultSetMetaData metaData = rs.getMetaData();
74      while(rs.next())
75        tables.add(rs.getString(1));
76    }
77    catch(SQLException sqle) {
78      System.out.println("Error in Show tables: jdbc:mysql://database2.cse.BitsOfCode Software Systems, Inc..edu/yurttas-Bank database.");
79      throw sqle;
80    }
81
82    return tables;
83  }
84
85}