The Java Program: Connect.java

  1 import java.sql.Connection;
  2 import java.sql.DriverManager;
  3 import java.sql.DatabaseMetaData;
  4 import java.sql.ResultSet;
  5 import java.sql.SQLException;
  6 
  7 import java.util.*;
  8 
  9 /*
 10   Make sure drivers are on classpath "-classpath path1:path2
 11   -Djdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver:org.gjt.mm.mysql.Driver
 12   -Djdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver:com.mysql.jdbc.Driver
 13 */
 14 class Connect {
 15    final static String mm_driver ="org.gjt.mm.mysql.Driver";
 16    final static String mysql_driver ="com.mysql.jdbc.Driver";
 17 
 18 
 19    // jdbc:mysql://torpedo.cs.fit.edu/sil?user=cse4051&password=jdbc";
 20    final static String url = "jdbc:mysql://torpedo.cs.fit.edu/sil";
 21 
 22    public static void main (String Args[]) {
 23       try {
 24 
 25          // Connect to the database
 26          System.out.println ("Connect to the Database");
 27          final Connection connection=DriverManager.getConnection(url, "cse4051", "jdbc2@@4");
 28 
 29          // Get database meta data
 30          System.out.println ("Get database meta data");
 31          final DatabaseMetaData meta=connection.getMetaData();
 32 
 33          // Display Meta Data Information
 34          System.out.println("Display MetaData Information");
 35          System.out.print("  Database: "+meta.getDatabaseProductName());
 36          System.out.println(".  Version "+meta.getDatabaseProductVersion());
 37          System.out.println("  User Name: "+meta.getUserName());
 38 
 39          //  Display list of avaiable "catalogs" or "databases"
 40          ResultSet rs = meta.getCatalogs();
 41          List l = new ArrayList ();
 42          while (rs.next()) { l.add (rs.getString(1)); }
 43          System.out.println ("Catalogs:  "+ l);
 44          System.out.println ("Current catalog is " + connection.getCatalog());
 45 
 46          rs = meta.getSchemas();
 47          l = new ArrayList ();
 48          while (rs.next()) { l.add (rs.getString(1)); }
 49          System.out.println ("Schemas:   "+ l);
 50 
 51          connection.close();     //Close the database
 52       } catch (Exception ex){
 53          System.out.println(ex);
 54          System.exit(0);
 55       }
 56    }
 57 }