rdbmspropertyextractor.java

这是外国一个开源推理机

		System.out.println("Catalog separator                       : " + metaData.getCatalogSeparator());
		System.out.println("Numeric functions                       : " + metaData.getNumericFunctions());
		System.out.println("String functions                        : " + metaData.getStringFunctions());
		System.out.println("System functions                        : " + metaData.getSystemFunctions());
		System.out.println("Time-date functions                     : " + metaData.getTimeDateFunctions());
		System.out.println();
		System.out.println("Stores lower case identifiers           : " + metaData.storesLowerCaseIdentifiers());
		System.out.println("Stores lower case quoted identifiers    : " + metaData.storesLowerCaseQuotedIdentifiers());
		System.out.println("Stores mixed case identifiers           : " + metaData.storesMixedCaseIdentifiers());
		System.out.println("Stores mixed case quoted identifiers    : " + metaData.storesMixedCaseQuotedIdentifiers());
		System.out.println("Stores upper case identifiers           : " + metaData.storesUpperCaseIdentifiers());
		System.out.println("Stores upper case quoted identifiers    : " + metaData.storesUpperCaseQuotedIdentifiers());
		System.out.println("Supports mixed case identifiers         : " + metaData.supportsMixedCaseIdentifiers());
		System.out.println("Supports mixed case quoted identifiers  : " + metaData.supportsMixedCaseQuotedIdentifiers());
		System.out.println();
		System.out.println("NULL + NON-NULL = NULL                  : " + metaData.nullPlusNonNullIsNull());
		System.out.println("Nulls are sorted at end                 : " + metaData.nullsAreSortedAtEnd());
		System.out.println("Nulls are sorted at start               : " + metaData.nullsAreSortedAtStart());
		System.out.println("Nulls are sorted high                   : " + metaData.nullsAreSortedHigh());
		System.out.println("Nulls are sorted low                    : " + metaData.nullsAreSortedLow());
		System.out.println();
		System.out.println("Supports ANSI92 entry level SQL         : " + metaData.supportsANSI92EntryLevelSQL());
		System.out.println("Supports ANSI92 full SQL                : " + metaData.supportsANSI92FullSQL());
		System.out.println("Supports ANSI92 intermediate SQL        : " + metaData.supportsANSI92IntermediateSQL());
		System.out.println();
		System.out.println("Supports ODBC Minimum SQL grammar       : " + metaData.supportsMinimumSQLGrammar());
		System.out.println("Supports ODBC Core SQL grammar          : " + metaData.supportsCoreSQLGrammar());
		System.out.println("Supports ODBC Extended SQL grammar      : " + metaData.supportsExtendedSQLGrammar());
		System.out.println();
		System.out.println("Supports ALTER TABLE with ADD COLUMN    : " + metaData.supportsAlterTableWithAddColumn());
		System.out.println("Supports ALTER TABLE with DROP COLUMN   : " + metaData.supportsAlterTableWithDropColumn());
		System.out.println("Supports CONVERT                        : " + metaData.supportsConvert());
		System.out.println("Supports GROUP BY                       : " + metaData.supportsGroupBy());
		System.out.println("Supports GROUP BY beyond SELECT         : " + metaData.supportsGroupByBeyondSelect());
		System.out.println("Supports GROUP BY unrelated             : " + metaData.supportsGroupByUnrelated());
		System.out.println("Supports LIKE escape clause             : " + metaData.supportsLikeEscapeClause());
		System.out.println("Supports ORDER BY unrelated             : " + metaData.supportsOrderByUnrelated());
		System.out.println("Supports SELECT FOR UPDATE              : " + metaData.supportsSelectForUpdate());
		System.out.println("Supports UNION                          : " + metaData.supportsUnion());
		System.out.println("Supports UNION ALL                      : " + metaData.supportsUnionAll());
		System.out.println();
		System.out.println("Supports correlated subqueries          : " + metaData.supportsCorrelatedSubqueries());
		System.out.println("Supports subqueries in comparisons      : " + metaData.supportsSubqueriesInComparisons());
		System.out.println("Supports subqueries in EXISTS           : " + metaData.supportsSubqueriesInExists());
		System.out.println("Supports subqueries in INs              : " + metaData.supportsSubqueriesInIns());
		System.out.println("Supports subqueries in quantifieds      : " + metaData.supportsSubqueriesInQuantifieds());
		System.out.println("Supports limited outer joins            : " + metaData.supportsLimitedOuterJoins());
		System.out.println("Supports outer joins                    : " + metaData.supportsOuterJoins());
		System.out.println("Supports full outer joins               : " + metaData.supportsFullOuterJoins());
		System.out.println("Supports get generated keys             : " + metaData.supportsGetGeneratedKeys());
		System.out.println("Supports integrity enhancement facility : " + metaData.supportsIntegrityEnhancementFacility());
		System.out.println("Supports multiple open results          : " + metaData.supportsMultipleOpenResults());
		System.out.println("Supports multiple result sets           : " + metaData.supportsMultipleResultSets());
		System.out.println();
		System.out.println("Supports column aliasing                : " + metaData.supportsColumnAliasing());
		System.out.println("Supports batch updates                  : " + metaData.supportsBatchUpdates());
		System.out.println("Supports transactions                   : " + metaData.supportsTransactions());
		System.out.println("Default transaction isolation           : " + isolationLevel2String(metaData.getDefaultTransactionIsolation()));
		System.out.println("Supports TRANSACTION_NONE               : " + metaData.supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE));
		System.out.println("Supports TRANSACTION_READ_UNCOMMITTED   : " + metaData.supportsTransactionIsolationLevel(Connection.TRANSACTION_READ_UNCOMMITTED));
		System.out.println("Supports TRANSACTION_READ_COMMITTED     : " + metaData.supportsTransactionIsolationLevel(Connection.TRANSACTION_READ_COMMITTED));
		System.out.println("Supports TRANSACTION_REPEATABLE_READ    : " + metaData.supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ));
		System.out.println("Supports TRANSACTION_SERIALIZABLE       : " + metaData.supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE));
		System.out.println("Supports multiple transactions          : " + metaData.supportsMultipleTransactions());
		System.out.println("Supports named parameters               : " + metaData.supportsNamedParameters());
		System.out.println("Supports non-nullable columns           : " + metaData.supportsNonNullableColumns());
		System.out.println("Supports open cursors across commit     : " + metaData.supportsOpenCursorsAcrossCommit());
		System.out.println("Supports open cursors across rollback   : " + metaData.supportsOpenCursorsAcrossRollback());
		System.out.println("Supports open statements across commit  : " + metaData.supportsOpenStatementsAcrossCommit());
		System.out.println("Supports open statements across rollback: " + metaData.supportsOpenStatementsAcrossRollback());
		System.out.println("Supports positioned DELETE              : " + metaData.supportsPositionedDelete());
		System.out.println("Supports positioned UPDATE              : " + metaData.supportsPositionedUpdate());
		System.out.println("Supports statement pooling              : " + metaData.supportsStatementPooling());
		System.out.println("Supports stored procedures              : " + metaData.supportsStoredProcedures());
		System.out.println("Supports table correlation names        : " + metaData.supportsTableCorrelationNames());

		System.out.println();
		System.out.println("SQL types supported by this database:");

		ResultSet rs = metaData.getTypeInfo();
		ResultSetMetaData rsMetaData = rs.getMetaData();

		int columnCount = rsMetaData.getColumnCount();
		for (int i = 1; i <= columnCount; i++) {
			if (i > 1) {
				System.out.print('\t');
			}
			System.out.print(rsMetaData.getColumnName(i));
		}
		System.out.println();

		while (rs.next()) {
			System.out.print(rs.getString(1)); System.out.print('\t');
			System.out.print(rs.getInt(2)); System.out.print('\t');
			System.out.print(rs.getInt(3)); System.out.print('\t');
			System.out.print(rs.getString(4)); System.out.print('\t');
			System.out.print(rs.getString(5)); System.out.print('\t');
			System.out.print(rs.getString(6)); System.out.print('\t');
			System.out.print(rs.getShort(7)); System.out.print('\t');
			System.out.print(rs.getBoolean(8)); System.out.print('\t');
			System.out.print(rs.getShort(9)); System.out.print('\t');
			System.out.print(rs.getBoolean(10)); System.out.print('\t');
			System.out.print(rs.getBoolean(11)); System.out.print('\t');
			System.out.print(rs.getBoolean(12)); System.out.print('\t');
			System.out.print(rs.getString(13)); System.out.print('\t');
			System.out.print(rs.getShort(14)); System.out.print('\t');
			System.out.print(rs.getShort(15)); System.out.print('\t');
			System.out.print(rs.getInt(16)); System.out.print('\t');
			System.out.print(rs.getInt(17)); System.out.print('\t');
			System.out.print(rs.getInt(18)); System.out.println();
		}
		rs.close();
	}

	public static String isolationLevel2String(int transaction) {
		switch (transaction) {
			case Connection.TRANSACTION_NONE: return "TRANSACTION_NONE";
			case Connection.TRANSACTION_READ_UNCOMMITTED: return "TRANSACTION_READ_UNCOMMITTED";
			case Connection.TRANSACTION_READ_COMMITTED: return "TRANSACTION_READ_COMMITTED";
			case Connection.TRANSACTION_REPEATABLE_READ: return "TRANSACTION_REPEATABLE_READ";
			case Connection.TRANSACTION_SERIALIZABLE: return "TRANSACTION_SERIALIZABLE";
			default: return "unknown transaction isolation";
		}
	}
}