getresultsetmetadataone.java

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

package metadata;

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

public class GetResultSetMetaDataOne {
  public static void main(String[] args) {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;

    try {
      conn = ConnectionFactory.getConnection();
      stmt = conn.createStatement();
      String sql = 
        "select artistid, artistname, artistimagefilespec, artistbiotext from artistsandperformers";
      rset = stmt.executeQuery(sql);
      ResultSetMetaData rsmd = rset.getMetaData();

      int cols = rsmd.getColumnCount();
      for (int i = 1; i <= cols; i++) {
        System.out.println("Column " + i);
        System.out.println("Name: " + rsmd.getColumnName(i));
        System.out.println("Table Name: " + rsmd.getTableName(i));
        System.out.println("Schema Name: " + rsmd.getSchemaName(i));
        System.out.println("Class: " + rsmd.getColumnClassName(i));
        System.out.println("Type: " + rsmd.getColumnType(i));
        System.out.println("Type name: " + rsmd.getColumnTypeName(i));
        System.out.println("Auto increment: " + rsmd.isAutoIncrement(i));
        System.out.print("Is nullable: ");
        switch (rsmd.isNullable(i)) {
        case ResultSetMetaData.columnNoNulls:
          System.out.println("No Nulls");
          break;
        case ResultSetMetaData.columnNullable:
          System.out.println("Nullable");
          break;

        case ResultSetMetaData.columnNullableUnknown:
          System.out.println("Unknown");
          break;
        }
        System.out.println();
      } 
    } catch (Exception e) {
      e.printStackTrace();
    } 
    finally {
      ConnectionFactory.close(rset);
      ConnectionFactory.close(stmt);
      ConnectionFactory.close(conn);
    } 
  } 
}