showdatabasemetadata.java

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· Java 代码 · 共 53 行

package metadata;

import java.sql.*;
import connections.*;

public class ShowDatabaseMetaData {
  public static void main(String[] args) {
    Connection conn = null;

    try {
      conn = ConnectionFactory.getConnection();
      DatabaseMetaData dbmd = conn.getMetaData();

      System.out.println("Information about the database: ");
      System.out.println("Database name=[" + dbmd.getDatabaseProductName() 
                         + "]");
      System.out.println("Database version=[" 
                         + dbmd.getDatabaseProductVersion() + "]");
      System.out.println("Driver name=[" + dbmd.getDriverName() + "]");
      System.out.println("Driver version=[" + dbmd.getDriverVersion() 
                         + "]");

      System.out
        .println("Supports forward only ResultSet=[" 
                 + dbmd.supportsResultSetType(ResultSet.TYPE_FORWARD_ONLY) 
                 + "]");
      System.out
        .println("Supports scroll sensitive ResultSet=[" 
                 + dbmd.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE) 
                 + "]");
      System.out
        .println("Supports scroll insensitive ResultSet=[" 
                 + dbmd.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE) 
                 + "]");

      System.out
        .println("Supports updatable ResultSet=[" 
                 + dbmd.supportsResultSetConcurrency(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE) 
                 + "]");
      System.out.println("Supports ANSI92 entry=[" 
                         + dbmd.supportsANSI92EntryLevelSQL() + "]");
      System.out.println("Supports ANSI92 intermediate=[" 
                         + dbmd.supportsANSI92IntermediateSQL() + "]");
      System.out.println("Supports ANSI92 full=[" 
                         + dbmd.supportsANSI92FullSQL() + "]");
    } catch (Exception e) {
      e.printStackTrace();
    } 
    finally {
      ConnectionFactory.close(conn);
    } 
  } 
}