showdatabasemetadata.java

此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作

package metadata;

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

public class ShowDatabaseMetaData {
  public static void main(String[] args) {
    try {
      Connection connection = ConnectionFactory.getConnection();
      DatabaseMetaData dbmd = connection.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 transactions=[" 
                         + dbmd.supportsTransactions() + "]");

      String s = "Supports transaction isolation level ";
      String value = "TRANSACTION_NONE";
      int level = Connection.TRANSACTION_NONE;
      System.out.println(s + value + "=[" 
                         + dbmd.supportsTransactionIsolationLevel(level) 
                         + "]");

      value = "TRANSACTION_READ_UNCOMMITTED";
      level = Connection.TRANSACTION_READ_UNCOMMITTED;
      System.out.println(s + value + "=[" 
                         + dbmd.supportsTransactionIsolationLevel(level) 
                         + "]");

      value = "TRANSACTION_READ_COMMITTED";
      level = Connection.TRANSACTION_READ_COMMITTED;
      System.out.println(s + value + "=[" 
                         + dbmd.supportsTransactionIsolationLevel(level) 
                         + "]");

      value = "TRANSACTION_REPEATABLE_READ";
      level = Connection.TRANSACTION_REPEATABLE_READ;
      System.out.println(s + value + "=[" 
                         + dbmd.supportsTransactionIsolationLevel(level) 
                         + "]");

      value = "TRANSACTION_SERIALIZABLE";
      level = Connection.TRANSACTION_SERIALIZABLE;
      System.out.println(s + value + "=[" 
                         + dbmd.supportsTransactionIsolationLevel(level) 
                         + "]");


      int dbLevel = connection.getTransactionIsolation();
      System.out.println("Default database isolation level is " + dbLevel);
      System.out.println(Connection.TRANSACTION_NONE 
                         + " is TRANSACTION_NONE");
      System.out.println(Connection.TRANSACTION_READ_UNCOMMITTED 
                         + " is TRANSACTION_READ_UNCOMMITTED");
      System.out.println(Connection.TRANSACTION_READ_COMMITTED 
                         + " is TRANSACTION_READ_COMMITTED");
      System.out.println(Connection.TRANSACTION_REPEATABLE_READ 
                         + " is TRANSACTION_REPEATABLE_READ");
      System.out.println(Connection.TRANSACTION_SERIALIZABLE 
                         + " is TRANSACTION_SERIALIZABLE");

    } catch (Exception e) {
      e.printStackTrace();
    } 
  } 
}