infoofprocedures.java

来自「本套光盘提供了本书各章实例的所需的部分源程序文件以及数据库文件。读者 需要使用」· Java 代码 · 共 41 行

import java.sql.*;

public class infoofprocedures{
  public static void main(String[] args)
 {
    Connection conn = null;
    try{
      conn = ConnectionManager.getConnection();
      DatabaseMetaData dbmd = conn.getMetaData();

      System.out.println("数据库信息: ");
      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("\n关于存储过程的支持信息:");
      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: ");
      while (rs.next())
       {
        System.out.print(rs.getString("PROCEDURE_NAME") + "    ");
       } 
      System.out.println();
	}	
    catch (Exception e) 
    {
      e.printStackTrace();
    } 
  } 
}