jdbc_dmd.java

jdbc 的实例源码

/*
 * Copyright 1996 John Wiley & Sons, Inc. All Rights Reserved. Reproduction
 * or translation of this work beyond that permitted in Section 117 of the 1976
 * United States Copyright Act without the express written permission of the
 * copyright owner is unlawful. Requests for further information should be 
 * addressed to Permissions Department, John Wiley & Sons, Inc. The 
 * purchaser may make back-up copies for his/her own use only and not for 
 * distribution or resale. The Publisher assumes no responsibility for errors, 
 * omissions, or damages, caused by the use of this  software or from the use
 * of the information contained herein.
 *
 */
import java.net.URL;
import java.sql.*;

class jdbc_dmd {

  public static void main(String argv[]) {

    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); // JDBC-ODBC bridge
      Class.forName("com.sybase.jdbc.SybDriver").newInstance();    // Sybase
    } catch (Exception e) {
      e.printStackTrace();
    }

    try {

      // the url, userid, and password come in from argv, so error out if
      // they weren't passed.
      //
      if (argv.length < 3) {
         System.err.println("Usage:");
         System.err.println("");
         System.err.println("java jdbc_dmd URL userid password");
         System.err.println("");
         System.err.println("  Examples:");
         System.err.println(
           "  java jdbc_dmd jdbc:odbc:MSSQL javadb javadb");
         System.err.println(
           "  java jdbc_dmd jdbc:sybase:Tds:localhost:4000 javadb javadb");
         System.exit(0);
      }

      String url  = argv[0];
      String user = argv[1];
      String pwd  = argv[2];

      // make a connection to the specified URL
      //
      Connection con = DriverManager.getConnection(url, user, pwd);

      DatabaseMetaData dmd = con.getMetaData();

      System.out.println( "     Schemas, aka: " +  dmd.getSchemaTerm() );
      System.out.println( "    Catalogs, aka: " + dmd.getCatalogTerm() );
      System.out.println( "Catalog Separator: " +
                            dmd.getCatalogSeparator() );
      System.out.println( "" );

      ResultSet rs = dmd.getProcedures(null, null, "%");
      ResultSetMetaData rm = rs.getMetaData();

      while (rs.next()) {

        String row = "";
        for (int i = 1; i <= rm.getColumnCount(); i++) {
          row += rs.getString(i) + "  ";
        }
        System.out.println(row);

      }
        
      ResultSet rscols = dmd.getProcedureColumns
        (null, null, "max_price", "%");
      ResultSetMetaData rmcols = rscols.getMetaData();

      while (rscols.next()) {

        String row = "";
        for (int i = 1; i <= rmcols.getColumnCount(); i++) {
          row += rscols.getString(i) + "  ";
        }
        System.out.println(row);

      }
   
      con.close();

    }
    catch( Exception e ) {
      System.out.println(e.getMessage());
      e.printStackTrace();
    }
  }

}