metadataexample.java

来自「java 完全探索的随书源码」· Java 代码 · 共 60 行

import java.sql.*;

public class MetaDataExample
{

  // Default Constructor
  public MetaDataExample()
  {
    super();
  }

  // Just a convenience print method
  public void print( String txt )
  {
    System.out.println( txt );
  }

  // Main method for this example
  public static void main(String[] args)
  {
    try
    {
      // Acquire a connection from the DatabaseManager
      Connection conn = DatabaseManager.getConnection();

      MetaDataExample example = new MetaDataExample();
      // Get the MetaData
      DatabaseMetaData metaData = conn.getMetaData();

      // Get driver information
      example.print( "Driver Informaion" );
      example.print( metaData.getDriverName() );
      example.print( metaData.getDriverVersion() );
      example.print( "" );

      // Get schema information
      example.print( "Schemas" );
      ResultSet schemas  = metaData.getSchemas();
      while( schemas.next() )
      {
        example.print( schemas.getString(1) );
      }
      example.print( "" );

      // Get table information
      example.print( "Tables" );
      ResultSet tables  = metaData.getTables( "", "", "", null );
      while( tables.next() )
      {
        example.print( tables.getString(3) );
      }
      // Always close the open resources
      conn.close();
    }
    catch( Exception ex )
    {
      ex.printStackTrace();
    }
  }
}