showdatabasemetadata.java

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

package metadata;

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

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

    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("\nInformation about stored procedure support:");
      System.out.println("Vendors name for \'procedure\'=[" 
                         + dbmd.getProcedureTerm() + "]");
      System.out.println("All procedures are callable: [" 
                         + dbmd.allProceduresAreCallable() + "]");
      System.out.println("Supports stored procedures: [" 
                         + dbmd.supportsStoredProcedures() + "]");
      ResultSet rs = dbmd.getProcedures(null, null, null);
      System.out.println("Procedures stored in the database: ");
      int count = 0;
      while (rs.next()) {
        System.out.print(rs.getString("PROCEDURE_NAME") + " ");
        if (count++ > 25) {
          break;
        } 
      } 
      System.out.println();

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