You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Catalog

null

Database

存储组全名,如 root.sg


Schema

存储组全名,如 root.sg


Table


  • 默认的设备数据表:_defaultDeviceTable
  • 每个设备类型一个表
  • deviceType1
  • deviceType2
  • 宽表:_defaultWideTable


Column


  • 默认的设备数据表:time,device,s1,s2, ...
  •  一个设备类型表:time,device,s1,s2, ...
  • 宽表:time,root.sg.d1.s1, root.sg.d1.s2, ...


Primary key


  • 默认的设备数据表:time,device
  • 一个设备类型表:time,device
  • 宽表:time


SQL Example:


SELECT *, ‘1’ FROM "root.sg"._defaultDeviceTable
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;

SELECT *, ‘1’ FROM "root.sg".devicetype1
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;

SELECT *, ‘1’ FROM "root.sg".devicetype2
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;

SELECT *, ‘1’ FROM "root.sg"._defaultWideTable
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;



Survey for JDBC Metadata 


metadataModifier and TypeMethodDescriptionTest on MySQLDesign in IoTDB
DatabaseMetaDatabooleanallProceduresAreCallable​()Retrieves whether the current user can call all the procedures returned by the method getProcedures.FALSE
booleanallTablesAreSelectable​()Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.TRUE
booleanautoCommitFailureClosesAllResultSets​()Retrieves whether a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable.需要确认结果集是否关闭(mysql返回false),itodb返回false
booleandataDefinitionCausesTransactionCommit​()Retrieves whether a data definition statement within a transaction forces the transaction to commit.FALSE
booleandataDefinitionIgnoredInTransactions​()Retrieves whether this database ignores a data definition statement within a transaction.FALSE
booleandeletesAreDetected​(int type)Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.TRUE
booleandoesMaxRowSizeIncludeBlobs​()Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.FALSE
booleangeneratedKeyAlwaysReturned​()Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.TRUE
ResultSetgetAttributes​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.mysql返回TYPE_CAT
TYPE_SCHEM
TYPE_NAME
ATTR_NAME
DATA_TYPE
ATTR_TYPE_NAME
ATTR_SIZE
DECIMAL_DIGITS
NUM_PREC_RADIX
NULLABLE
REMARKS
ATTR_DEF
SQL_DATA_TYPE
SQL_DATETIME_SUB
CHAR_OCTET_LENGTH
ORDINAL_POSITION
IS_NULLABLE
SCOPE_CATALOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE
TYPE_CAT

ResultSetgetBestRowIdentifier​(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)Retrieves a description of a table's optimal set of columns that uniquely identifies a row.null(需要确认) 
ResultSetgetCatalogs​()Retrieves the catalog names available in this database.mysql 返回数据库列表相当于show databases
java.lang.StringgetCatalogSeparator​()Retrieves the String that this database uses as the separator between a catalog and table name.返回表或者数据库的分隔符mysql返回.
java.lang.StringgetCatalogTerm​()Retrieves the database vendor's preferred term for "catalog".mysql 返回database
ResultSetgetClientInfoProperties​()Retrieves a list of the client info properties that the driver supports.需要确认iotdb,mysql 返回
4
NAME
MAX_LEN
DEFAULT_VALUE
DESCRIPTION

ResultSetgetColumnPrivileges​(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern)Retrieves a description of the access rights for a table's columns.确认访问权限
ResultSetgetColumns​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)Retrieves a description of table columns available in the specified catalog.获取表内的字段的名字、类型、长度
ConnectiongetConnection​()Retrieves the connection that produced this metadata object.Connection
ResultSetgetCrossReference​(java.lang.String parentCatalog, java.lang.String parentSchema, java.lang.String parentTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).返回null
intgetDatabaseMajorVersion​()Retrieves the major version number of the underlying database.mysql主版本号5.6 返回5
intgetDatabaseMinorVersion​()Retrieves the minor version number of the underlying database.mysql次版本号5.6返回6
java.lang.StringgetDatabaseProductName​()Retrieves the name of this database product.IOTdb
java.lang.StringgetDatabaseProductVersion​()Retrieves the version number of this database product.产品版本好5.6.1
intgetDefaultTransactionIsolation​()Retrieves this database's default transaction isolation level.返回事物隔离级别(默认脏读)、返回其他数值
intgetDriverMajorVersion​()Retrieves this JDBC driver's major version number.主版本号5.1返回5
intgetDriverMinorVersion​()Retrieves this JDBC driver's minor version number.次版本号5.1返回1
java.lang.StringgetDriverName​()Retrieves the name of this JDBC driver.驱动名称
java.lang.StringgetDriverVersion​()Retrieves the version number of this JDBC driver as a String. 驱动版本号5.1.1
ResultSetgetExportedKeys​(java.lang.String catalog, java.lang.String schema, java.lang.String table)Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).null
java.lang.StringgetExtraNameCharacters​()Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).根据返回值,调整为iotdb可以用的字符
ResultSetgetFunctionColumns​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern)Retrieves a description of the given catalog's system or user function parameters and return type.返回用户函数参数和返回类型
ResultSetgetFunctions​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern)Retrieves a description of the system and user functions available in the given catalog.返回用户函数的描述,返回值正在确认
java.lang.StringgetIdentifierQuoteString​()Retrieves the string used to quote SQL identifiers.检索用于引用SQL标识符的字符串
ResultSetgetImportedKeys​(java.lang.String catalog, java.lang.String schema, java.lang.String table)Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).返回null
ResultSetgetIndexInfo​(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)Retrieves a description of the given table's indices and statistics.获取索引信息
intgetJDBCMajorVersion​()Retrieves the major JDBC version number for this driver.jdbc 主版本号
intgetJDBCMinorVersion​()Retrieves the minor JDBC version number for this driver.jdbc次版本号
intgetMaxBinaryLiteralLength​()Retrieves the maximum number of hex characters this database allows in an inline binary literal.interger.maxvalue
intgetMaxCatalogNameLength​()Retrieves the maximum number of characters that this database allows in a catalog name.数据库表最大字符长度
intgetMaxCharLiteralLength​()Retrieves the maximum number of characters this database allows for a character literal.interger.maxvalue,mysal返回16777208
intgetMaxColumnNameLength​()Retrieves the maximum number of characters this database allows for a column name.列名长度(确认)
intgetMaxColumnsInGroupBy​()Retrieves the maximum number of columns this database allows in a GROUP BY clause.group by 个数(确认)
intgetMaxColumnsInIndex​()Retrieves the maximum number of columns this database allows in an index.确认最大索引个数
intgetMaxColumnsInOrderBy​()Retrieves the maximum number of columns this database allows in an ORDER BY clause.返回0
intgetMaxColumnsInSelect​()Retrieves the maximum number of columns this database allows in a SELECT list.select最大列数(确认)
intgetMaxColumnsInTable​()Retrieves the maximum number of columns this database allows in a table.表最大列(确认)
intgetMaxConnections​()Retrieves the maximum number of concurrent connections to this database that are possible.最大链接(确认)
intgetMaxCursorNameLength​()Retrieves the maximum number of characters that this database allows in a cursor name.返回0
intgetMaxIndexLength​()Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.integer.maxvalue
default longgetMaxLogicalLobSize​()Retrieves the maximum number of bytes this database allows for the logical size for a LOB.integer.maxvalue
intgetMaxProcedureNameLength​()Retrieves the maximum number of characters that this database allows in a procedure name.返回0
intgetMaxRowSize​()Retrieves the maximum number of bytes this database allows in a single row.一条记录最大字符串(确认)
intgetMaxSchemaNameLength​()Retrieves the maximum number of characters that this database allows in a schema name.数据库名称最大字符串数
intgetMaxStatementLength​()Retrieves the maximum number of characters this database allows in an SQL statement.integer.maxvalue
intgetMaxStatements​()Retrieves the maximum number of active statements to this database that can be open at the same time.确认
intgetMaxTableNameLength​()Retrieves the maximum number of characters this database allows in a table name.确认表名最大长度
intgetMaxTablesInSelect​()Retrieves the maximum number of tables this database allows in a SELECT statement.确认select 中最大表数量
intgetMaxUserNameLength​()Retrieves the maximum number of characters this database allows in a user name.确认最大长度
java.lang.StringgetNumericFunctions​()Retrieves a comma-separated list of math functions available with this database.

返回函数mysql返回ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,

COS,COT,DEGREES,

EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,

ROUND,SIN,SQRT,TAN,TRUNCATE**
DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,

LAST_INSERT_ID,VERSION


ResultSetgetPrimaryKeys​(java.lang.String catalog, java.lang.String schema, java.lang.String table)Retrieves a description of the given table's primary key columns.等表定义出来
ResultSetgetProcedureColumns​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern)Retrieves a description of the given catalog's stored procedure parameter and result columns.null
ResultSetgetProcedures​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern)Retrieves a description of the stored procedures available in the given catalog.null
java.lang.StringgetProcedureTerm​()Retrieves the database vendor's preferred term for "procedure".null
ResultSetgetPseudoColumns​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.

返回null,伪列,例如oracle 中sysdate, systimestamp,RowNum ,RowID, CURRVAL,

NEXTVAL,UID, USER,Level,ORA_ROWSCN。

返回null

intgetResultSetHoldability​()Retrieves this database's default holdability for ResultSet objects.

返回2
ResultSet的可保持性确定使用commit()Connection接口的方法提交事务

(包含 游标/ ResultSet对象)时是否应关闭ResultSet对象

(光标)或使其保持打开状态。DatabaseMetaData接口的

getResultSetHoldability() 方法检索基础数据库的ResultSet对象的默认可保存性。

此方法返回一个表示默认ResultSet可保存性的整数值,该值将为1或2,其中,

1表示值HOLD_CURSORS_OVER_COMMIT。如果ResultSet对象的可保存性设置为此值。

每当使用commit()Connection接口的方法提交/保存事务时,

在当前事务中创建的ResultSet对象(已打开)将保持打开状态。

2表示值CLOSE_CURSORS_AT_COMMIT。如果ResultSet对象的可保存性设置为此值。

每当您使用commit()Connection接口的方法提交/保存事务时,

在当前事务中创建的ResultSet对象(已打开)将被关闭。

1
RowIdLifetimegetRowIdLifetime​()Indicates whether this data source supports the SQL ROWID type, and the lifetime for which a RowId object remains valid.FALSE
ResultSetgetSchemas​()Retrieves the schema names available in this database.null
ResultSetgetSchemas​(java.lang.String catalog, java.lang.String schemaPattern)Retrieves the schema names available in this database.null
java.lang.StringgetSchemaTerm​()Retrieves the database vendor's preferred term for "schema".返回""
java.lang.StringgetSearchStringEscape​()Retrieves the string that can be used to escape wildcard characters.确认返回值,此方法返回一个字符串参数,表示用于转义通配符的值,mysql返回一个\
java.lang.StringgetSQLKeywords​()Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.输出sql关键字如:database
intgetSQLStateType​()Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.返回0,返回数字表示false,mysql返回2
java.lang.StringgetStringFunctions​()Retrieves a comma-separated list of string functions available with this database.

确认,返回函数列表例如:ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,

CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,

EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,

LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,

MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,

REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,

SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,

SUBSTRING_INDEX,TRIM,UCASE,UPPER

ResultSetgetSuperTables​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)Retrieves a description of the table hierarchies defined in a particular schema in this database.null
ResultSetgetSuperTypes​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.null
java.lang.StringgetSystemFunctions​()Retrieves a comma-separated list of system functions available with this database.返回内置函数mysql返回DATABASE
USER
PASSWORD

ResultSetgetTablePrivileges​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)Retrieves a description of the access rights for each table available in a catalog.

确认返回值
获取可在类别中使用的每个表的访问权的描述。注意,

表特权可用于表中的一个或多个列。假定此特权可用于所有列是错误的

(对于某些系统可能是正确的,但并非所有的系统都如此)。
仅返回与模式和表名称标准匹配的特权。它们根据 table_cat、

table_schem、table_name 和 privilege 进行排序。

每个特权描述都有以下列:

table_cat string => 表类别(可为 null)
table_schem string => 表模式(可为 null)
table_name string => 表名称
grantor string => 访问权的授权人(可为 null)
grantee string => 访问权的被授权人
privilege string => 访问权的名称(select、insert、update、refrences 等)
is_grantable string => 如果允许被授权人将权利授予他人,则为 "yes";

如果不允许,则为 "no";如果未知,则为 null


ResultSetgetTables​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types)Retrieves a description of the tables available in the given catalog.获取表
ResultSetgetTableTypes​()Retrieves the table types available in this database.返回表的类型mysql返回TABLE
VIEW
LOCAL TEMPORARY

java.lang.StringgetTimeDateFunctions​()Retrieves a comma-separated list of the time and date functions available with this database.

返回日期函数mysql返回如下DAYOFWEEK,WEEKDAY,DAYOFMONTH,

DAYOFYEAR,MONTH,DAYNAME,

MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,

PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,

TIME_FORMAT,CURDATE,CURRENT_DATE,

CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,

UNIX_TIMESTAMP,

FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,

ENCRYPT,LAST_INSERT_ID,VERSION


ResultSetgetTypeInfo​()Retrieves a description of all the data types supported by this database.检索当前数据库支持的所有标准 SQL 类型的说明,返回null
ResultSetgetUDTs​(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types)Retrieves a description of the user-defined types (UDTs) defined in a particular schema.null
java.lang.StringgetURL​()Retrieves the URL for this DBMS.返回urlmysql返回jdbc:mysql://8.131.67.59:3306/gonghui_data?useSSL=false
java.lang.StringgetUserName​()Retrieves the user name as known to this database.返回用户名username@219.142.240.74
ResultSetgetVersionColumns​(java.lang.String catalog, java.lang.String schema, java.lang.String table)Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.null
booleaninsertsAreDetected​(int type)Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.FALSE
booleanisCatalogAtStart​()Retrieves whether a catalog appears at the start of a fully qualified table name.FALSE
booleanisReadOnly​()Retrieves whether this database is in read-only mode.TRUE
booleanlocatorsUpdateCopy​()Indicates whether updates made to a LOB are made on a copy or directly to the LOB.FALSE
booleannullPlusNonNullIsNull​()Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.FALSE
booleannullsAreSortedAtEnd​()Retrieves whether NULL values are sorted at the end regardless of sort order.返回false,把null排在结尾无论顺序如何,如果排在结尾为true,否则为false。
booleannullsAreSortedAtStart​()Retrieves whether NULL values are sorted at the start regardless of sort order.返回false,把null排在开头无论顺序如何,如果排在开头为true,否则为false。
booleannullsAreSortedHigh​()Retrieves whether NULL values are sorted high.返回false,把null排在最前面,true排在最前面,否则为false
booleannullsAreSortedLow​()Retrieves whether NULL values are sorted low.返回false,把null排在最后面,true排在最后面,否则为false
booleanothersDeletesAreVisible​(int type)Retrieves whether deletes made by others are visible.TRUE
booleanothersInsertsAreVisible​(int type)Retrieves whether inserts made by others are visible.TRUE
booleanothersUpdatesAreVisible​(int type)Retrieves whether updates made by others are visible.FALSE
booleanownDeletesAreVisible​(int type)Retrieves whether a result set's own deletes are visible.TRUE
booleanownInsertsAreVisible​(int type)Retrieves whether a result set's own inserts are visible.TRUE
booleanownUpdatesAreVisible​(int type)Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.FALSE
booleanstoresLowerCaseIdentifiers​()Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.FALSE
booleanstoresLowerCaseQuotedIdentifiers​()Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.FALSE
booleanstoresMixedCaseIdentifiers​()Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.TRUE
booleanstoresMixedCaseQuotedIdentifiers​()Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.TRUE
booleanstoresUpperCaseIdentifiers​()Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.TRUE
booleanstoresUpperCaseQuotedIdentifiers​()Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.TRUE
booleansupportsAlterTableWithAddColumn​()Retrieves whether this database supports ALTER TABLE with add column.TRUE
booleansupportsAlterTableWithDropColumn​()Retrieves whether this database supports ALTER TABLE with drop column.TRUE
booleansupportsANSI92EntryLevelSQL​()Retrieves whether this database supports the ANSI92 entry level SQL grammar.FALSE
booleansupportsANSI92FullSQL​()Retrieves whether this database supports the ANSI92 full SQL grammar supported.FALSE
booleansupportsANSI92IntermediateSQL​()Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.FALSE
booleansupportsBatchUpdates​()Retrieves whether this database supports batch updates.FALSE
booleansupportsCatalogsInDataManipulation​()Retrieves whether a catalog name can be used in a data manipulation statement.TRUE
booleansupportsCatalogsInIndexDefinitions​()Retrieves whether a catalog name can be used in an index definition statement.FALSE
booleansupportsCatalogsInPrivilegeDefinitions​()Retrieves whether a catalog name can be used in a privilege definition statement.FALSE
booleansupportsCatalogsInProcedureCalls​()Retrieves whether a catalog name can be used in a procedure call statement.FALSE
booleansupportsCatalogsInTableDefinitions​()Retrieves whether a catalog name can be used in a table definition statement.是否可以使用数据库名称false
booleansupportsColumnAliasing​()Retrieves whether this database supports column aliasing.TRUE
booleansupportsConvert​()Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another.FALSE
booleansupportsConvert​(int fromType, int toType)Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType.FALSE
booleansupportsCoreSQLGrammar​()Retrieves whether this database supports the ODBC Core SQL grammar.FALSE
booleansupportsCorrelatedSubqueries​()Retrieves whether this database supports correlated subqueries.FALSE
booleansupportsDataDefinitionAndDataManipulationTransactions​()Retrieves whether this database supports both data definition and data manipulation statements within a transaction.FALSE
booleansupportsDataManipulationTransactionsOnly​()Retrieves whether this database supports only data manipulation statements within a transaction.TRUE
booleansupportsDifferentTableCorrelationNames​()Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.FALSE
booleansupportsExpressionsInOrderBy​()Retrieves whether this database supports expressions in ORDER BY lists.TRUE
booleansupportsExtendedSQLGrammar​()Retrieves whether this database supports the ODBC Extended SQL grammar.FALSE
booleansupportsFullOuterJoins​()Retrieves whether this database supports full nested outer joins.FALSE
booleansupportsGetGeneratedKeys​()Retrieves whether auto-generated keys can be retrieved after a statement has been executedFALSE
booleansupportsGroupBy​()Retrieves whether this database supports some form of GROUP BY clause.TRUE
booleansupportsGroupByBeyondSelect​()Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.TRUE
booleansupportsGroupByUnrelated​()Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.TRUE
booleansupportsIntegrityEnhancementFacility​()Retrieves whether this database supports the SQL Integrity Enhancement Facility.FALSE
booleansupportsLikeEscapeClause​()Retrieves whether this database supports specifying a LIKE escape clause.FALSE
booleansupportsLimitedOuterJoins​()Retrieves whether this database provides limited support for outer joins.TRUE
booleansupportsMinimumSQLGrammar​()Retrieves whether this database supports the ODBC Minimum SQL grammar.FALSE
booleansupportsMixedCaseIdentifiers​()Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.TRUE
booleansupportsMixedCaseQuotedIdentifiers​()Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.TRUE
booleansupportsMultipleOpenResults​()Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.FALSE
booleansupportsMultipleResultSets​()Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.FALSE
booleansupportsMultipleTransactions​()Retrieves whether this database allows having multiple transactions open at once (on different connections).TRUE
booleansupportsNamedParameters​()Retrieves whether this database supports named parameters to callable statements.FALSE
booleansupportsNonNullableColumns​()Retrieves whether columns in this database may be defined as non-nullable.FALSE
booleansupportsOpenCursorsAcrossCommit​()Retrieves whether this database supports keeping cursors open across commits.FALSE
booleansupportsOpenCursorsAcrossRollback​()Retrieves whether this database supports keeping cursors open across rollbacks.FALSE
booleansupportsOpenStatementsAcrossCommit​()Retrieves whether this database supports keeping statements open across commits.FALSE
booleansupportsOpenStatementsAcrossRollback​()Retrieves whether this database supports keeping statements open across rollbacks.FALSE
booleansupportsOrderByUnrelated​()Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.TRUE
booleansupportsOuterJoins​()Retrieves whether this database supports some form of outer join.TRUE
booleansupportsPositionedDelete​()Retrieves whether this database supports positioned DELETE statements.需确认(true)
booleansupportsPositionedUpdate​()Retrieves whether this database supports positioned UPDATE statements.需确认(true)
default booleansupportsRefCursors​()Retrieves whether this database supports REF CURSOR.FALSE
booleansupportsResultSetConcurrency​(int type, int concurrency)Retrieves whether this database supports the given concurrency type in combination with the given result set type.FALSE
booleansupportsResultSetHoldability​(int holdability)Retrieves whether this database supports the given result set holdability.

返回true
ResultSet的可保持性确定使用commit()Connection接口

的方法提交事务

(包含上述游标/ ResultSet对象)时是关闭还是

保持ResultSet对象(光标)打开。

ResultSet接口提供两个值来指定ResultSet的可保存性,即-

CLOSE_CURSORS_AT_COMMIT:如果ResultSet对象的可

保存性设置为此值。

每当您使用commit()Connection接口的方法提交/保存事务时,

在当前事务中创建

的ResultSet对象(已打开)将被关闭。

HOLD_CURSORS_OVER_COMMIT:如果ResultSet对象的

可保存性设置为此值。

每当使用commit()Connection接口的方法提交/保存事务时,

在当前事务中创建的ResultSet对象(已打开)将保持打开状态。


booleansupportsResultSetType​(int type)Retrieves whether this database supports the given result set type.TRUE
booleansupportsSavepoints​()Retrieves whether this database supports savepoints.FALSE
booleansupportsSchemasInDataManipulation​()Retrieves whether a schema name can be used in a data manipulation statement.FALSE
booleansupportsSchemasInIndexDefinitions​()Retrieves whether a schema name can be used in an index definition statement.FALSE
booleansupportsSchemasInPrivilegeDefinitions​()Retrieves whether a schema name can be used in a privilege definition statement.FALSE
booleansupportsSchemasInProcedureCalls​()Retrieves whether a schema name can be used in a procedure call statement.FALSE
booleansupportsSchemasInTableDefinitions​()Retrieves whether a schema name can be used in a table definition statement.FALSE
booleansupportsSelectForUpdate​()Retrieves whether this database supports SELECT FOR UPDATE statements.FALSE
default booleansupportsSharding​()Retrieves whether this database supports sharding.FALSE
booleansupportsStatementPooling​()Retrieves whether this database supports statement pooling.FALSE
booleansupportsStoredFunctionsUsingCallSyntax​()Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.FALSE
booleansupportsStoredProcedures​()Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.FALSE
booleansupportsSubqueriesInComparisons​()Retrieves whether this database supports subqueries in comparison expressions.FALSE
booleansupportsSubqueriesInExists​()Retrieves whether this database supports subqueries in EXISTS expressions.FALSE
booleansupportsSubqueriesInIns​()Retrieves whether this database supports subqueries in IN expressions.FALSE
booleansupportsSubqueriesInQuantifieds​()Retrieves whether this database supports subqueries in quantified expressions.FALSE
booleansupportsTableCorrelationNames​()Retrieves whether this database supports table correlation names.FALSE
booleansupportsTransactionIsolationLevel​(int level)Retrieves whether this database supports the given transaction isolation level.FALSE
booleansupportsTransactions​()Retrieves whether this database supports transactions.FALSE
booleansupportsUnion​()Retrieves whether this database supports SQL UNION.FALSE
booleansupportsUnionAll​()Retrieves whether this database supports SQL UNION ALL.FALSE
booleanupdatesAreDetected​(int type)Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.FALSE
booleanusesLocalFilePerTable​()Retrieves whether this database uses a file for each table.FALSE
booleanusesLocalFiles​()Retrieves whether this database stores tables in a local file.FALSE
ResultSetMetaDatajava.lang.StringgetCatalogName​(int column)Gets the designated column's table's catalog name.

java.lang.StringgetColumnClassName​(int column)Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.

intgetColumnCount​()Returns the number of columns in this ResultSet object.

intgetColumnDisplaySize​(int column)Indicates the designated column's normal maximum width in characters.

java.lang.StringgetColumnLabel​(int column)Gets the designated column's suggested title for use in printouts and displays.

java.lang.StringgetColumnName​(int column)Get the designated column's name.

intgetColumnType​(int column)Retrieves the designated column's SQL type.

java.lang.StringgetColumnTypeName​(int column)Retrieves the designated column's database-specific type name.

intgetPrecision​(int column)Get the designated column's specified column size.

intgetScale​(int column)Gets the designated column's number of digits to right of the decimal point.

java.lang.StringgetSchemaName​(int column)Get the designated column's table's schema.

java.lang.StringgetTableName​(int column)Gets the designated column's table name.

booleanisAutoIncrement​(int column)Indicates whether the designated column is automatically numbered.

booleanisCaseSensitive​(int column)Indicates whether a column's case matters.

booleanisCurrency​(int column)Indicates whether the designated column is a cash value.

booleanisDefinitelyWritable​(int column)Indicates whether a write on the designated column will definitely succeed.

intisNullable​(int column)Indicates the nullability of values in the designated column.

booleanisReadOnly​(int column)Indicates whether the designated column is definitely not writable.

booleanisSearchable​(int column)Indicates whether the designated column can be used in a where clause.

booleanisSigned​(int column)Indicates whether values in the designated column are signed numbers.

booleanisWritable​(int column)Indicates whether it is possible for a write on the designated column to succeed.

RowSetMetaDatavoidsetAutoIncrement​(int columnIndex, boolean property)Sets whether the designated column is automatically numbered, The default is for a RowSet object's columns not to be automatically numbered.

voidsetCaseSensitive​(int columnIndex, boolean property)Sets whether the designated column is case sensitive.

voidsetCatalogName​(int columnIndex, java.lang.String catalogName)Sets the designated column's table's catalog name, if any, to the given String.

voidsetColumnCount​(int columnCount)Sets the number of columns in the RowSet object to the given number.

voidsetColumnDisplaySize​(int columnIndex, int size)Sets the designated column's normal maximum width in chars to the given int.

voidsetColumnLabel​(int columnIndex, java.lang.String label)Sets the suggested column title for use in printouts and displays, if any, to the given String.

voidsetColumnName​(int columnIndex, java.lang.String columnName)Sets the name of the designated column to the given String.

voidsetColumnType​(int columnIndex, int SQLType)Sets the designated column's SQL type to the one given.

voidsetColumnTypeName​(int columnIndex, java.lang.String typeName)Sets the designated column's type name that is specific to the data source, if any, to the given String.

voidsetCurrency​(int columnIndex, boolean property)Sets whether the designated column is a cash value.

voidsetNullable​(int columnIndex, int property)Sets whether the designated column's value can be set to NULL.

voidsetPrecision​(int columnIndex, int precision)Sets the designated column's number of decimal digits to the given int.

voidsetScale​(int columnIndex, int scale)Sets the designated column's number of digits to the right of the decimal point to the given int.

voidsetSchemaName​(int columnIndex, java.lang.String schemaName)Sets the name of the designated column's table's schema, if any, to the given String.

voidsetSearchable​(int columnIndex, boolean property)Sets whether the designated column can be used in a where clause.

voidsetSigned​(int columnIndex, boolean property)Sets whether the designated column is a signed number.

voidsetTableName​(int columnIndex, java.lang.String tableName)Sets the designated column's table name, if any, to the given String.

ParameterMetaDatajava.lang.StringgetParameterClassName​(int param)Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject.

intgetParameterCount​()Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object contains information.

intgetParameterMode​(int param)Retrieves the designated parameter's mode.

intgetParameterType​(int param)Retrieves the designated parameter's SQL type.

java.lang.StringgetParameterTypeName​(int param)Retrieves the designated parameter's database-specific type name.

intgetPrecision​(int param)Retrieves the designated parameter's specified column size.

intgetScale​(int param)Retrieves the designated parameter's number of digits to right of the decimal point.

intisNullable​(int param)Retrieves whether null values are allowed in the designated parameter.

booleanisSigned​(int param)Retrieves whether values for the designated parameter can be signed numbers.



  • No labels