📄 oracle.jdbc.driver.oracleresultsetmetadata.html

📁 Oracle JDBC 的javaDoc
💻 HTML
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><!--NewPage--><html><head><!-- Generated by javadoc on Thu Dec 02 03:30:11 PST 1999 --><title>  Class oracle.jdbc.driver.OracleResultSetMetaData</title></head><body><a name="_top_"></a><pre><a href="packages.html">All Packages</a>  <a href="tree.html">Class Hierarchy</a>  <a href="Package-oracle.jdbc.driver.html">This Package</a>  <a href="oracle.jdbc.driver.OracleResultSet.html#_top_">Previous</a>  <a href="oracle.jdbc.driver.OracleStatement.html#_top_">Next</a>  <a href="AllNames.html">Index</a></pre><hr><h1>  Class oracle.jdbc.driver.OracleResultSetMetaData</h1><pre>java.lang.Object   |   +----oracle.jdbc.driver.OracleResultSetMetaData</pre><hr><dl>  <dt> public class <b>OracleResultSetMetaData</b>  <dt> extends Object  <dt> implements ResultSetMetaData</dl><hr><a name="index"></a><h2>  <img src="images/method-index.gif" width=207 height=38 alt="Method Index"></h2><dl>  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getCatalogName(int)"><b>getCatalogName</b></a>(int)  <dd> What's a column's table's catalog name?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnClassName(int)"><b>getColumnClassName</b></a>(int)  <dd> <p>Returns the fully-qualified name of the Java class whose instances are manufactured if the method<code>ResultSet.getObject</code> is called to retrieve a value from the column.  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnCount()"><b>getColumnCount</b></a>()  <dd> What's the number of columns in the ResultSet?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnDisplaySize(int)"><b>getColumnDisplaySize</b></a>(int)  <dd> What's the column's normal max width in chars?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnLabel(int)"><b>getColumnLabel</b></a>(int)  <dd> What's the suggested column title for use in printouts anddisplays?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnName(int)"><b>getColumnName</b></a>(int)  <dd> What's a column's name?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnType(int)"><b>getColumnType</b></a>(int)  <dd> What's a column's SQL type?<p>The DBType structure holds the ORACLE type number (VARCHAR is 1) and weneed to convert it to the Java type number (VARCHAR is 12).  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getColumnTypeName(int)"><b>getColumnTypeName</b></a>(int)  <dd> What's a column's data source specific type name?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getPrecision(int)"><b>getPrecision</b></a>(int)  <dd> What's a column's number of decimal digits?The semantic of get precision on non NUMERIC columns isweirdly defined by the JDBC test suite.  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getScale(int)"><b>getScale</b></a>(int)  <dd> What's a column's number of digits to right of decimal?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getSchemaName(int)"><b>getSchemaName</b></a>(int)  <dd> What's a column's table's schema?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#getTableName(int)"><b>getTableName</b></a>(int)  <dd> What's a column's table name?   <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isAutoIncrement(int)"><b>isAutoIncrement</b></a>(int)  <dd> Is the column automatically numbered, thus read-only?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isCaseSensitive(int)"><b>isCaseSensitive</b></a>(int)  <dd> Does a column's case matter?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isCurrency(int)"><b>isCurrency</b></a>(int)  <dd> Is the column a cash value?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isDefinitelyWritable(int)"><b>isDefinitelyWritable</b></a>(int)  <dd> Will a write on the column definitely succeed?	  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isNullable(int)"><b>isNullable</b></a>(int)  <dd> Can you put a NULL in this column?		  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isReadOnly(int)"><b>isReadOnly</b></a>(int)  <dd> Is a column definitely not writable?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isSearchable(int)"><b>isSearchable</b></a>(int)  <dd> Can the column be used in a where clause?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isSigned(int)"><b>isSigned</b></a>(int)  <dd> Is the column a signed number?  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">	<a href="#isWritable(int)"><b>isWritable</b></a>(int)  <dd> Is it possible for a write on the column to succeed?</dl><a name="methods"></a><h2>  <img src="images/methods.gif" width=151 height=38 alt="Methods"></h2><a name="getColumnCount()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnCount"><b>getColumnCount</b></a><pre> public int getColumnCount() throws SQLException</pre><dl>  <dd> What's the number of columns in the ResultSet?<p>  <dd><dl>    <dt> <b>Returns:</b>    <dd> the number  </dl></dd></dl><a name="isAutoIncrement(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isAutoIncrement"><b>isAutoIncrement</b></a><pre> public boolean isAutoIncrement(int column) throws SQLException</pre><dl>  <dd> Is the column automatically numbered, thus read-only?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="isCaseSensitive(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isCaseSensitive"><b>isCaseSensitive</b></a><pre> public boolean isCaseSensitive(int column) throws SQLException</pre><dl>  <dd> Does a column's case matter?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="isSearchable(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isSearchable"><b>isSearchable</b></a><pre> public boolean isSearchable(int column) throws SQLException</pre><dl>  <dd> Can the column be used in a where clause?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="isCurrency(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isCurrency"><b>isCurrency</b></a><pre> public boolean isCurrency(int column) throws SQLException</pre><dl>  <dd> Is the column a cash value?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="isNullable(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isNullable"><b>isNullable</b></a><pre> public int isNullable(int column) throws SQLException</pre><dl>  <dd> Can you put a NULL in this column?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> columnNoNulls, columnNullable or columnNullableUnknown  </dl></dd></dl><a name="isSigned(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isSigned"><b>isSigned</b></a><pre> public boolean isSigned(int column) throws SQLException</pre><dl>  <dd> Is the column a signed number?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="getColumnDisplaySize(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnDisplaySize"><b>getColumnDisplaySize</b></a><pre> public int getColumnDisplaySize(int column) throws SQLException</pre><dl>  <dd> What's the column's normal max width in chars?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> max width  </dl></dd></dl><a name="getColumnLabel(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnLabel"><b>getColumnLabel</b></a><pre> public String getColumnLabel(int column) throws SQLException</pre><dl>  <dd> What's the suggested column title for use in printouts anddisplays?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="getColumnName(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnName"><b>getColumnName</b></a><pre> public String getColumnName(int column) throws SQLException</pre><dl>  <dd> What's a column's name?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> column name  </dl></dd></dl><a name="getSchemaName(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getSchemaName"><b>getSchemaName</b></a><pre> public String getSchemaName(int column) throws SQLException</pre><dl>  <dd> What's a column's table's schema?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> schema name or "" if not applicable  </dl></dd></dl><a name="getPrecision(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getPrecision"><b>getPrecision</b></a><pre> public int getPrecision(int column) throws SQLException</pre><dl>  <dd> What's a column's number of decimal digits?The semantic of get precision on non NUMERIC columns isweirdly defined by the JDBC test suite.<p></dl><a name="getScale(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getScale"><b>getScale</b></a><pre> public int getScale(int column) throws SQLException</pre><dl>  <dd> What's a column's number of digits to right of decimal?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> scale  </dl></dd></dl><a name="getTableName(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getTableName"><b>getTableName</b></a><pre> public String getTableName(int column) throws SQLException</pre><dl>  <dd> What's a column's table name?<p>  <dd><dl>    <dt> <b>Returns:</b>    <dd> table name or "" if not applicable  </dl></dd></dl><a name="getCatalogName(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getCatalogName"><b>getCatalogName</b></a><pre> public String getCatalogName(int column) throws SQLException</pre><dl>  <dd> What's a column's table's catalog name?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> column name or "" if not applicable.  </dl></dd></dl><a name="getColumnType(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnType"><b>getColumnType</b></a><pre> public int getColumnType(int column) throws SQLException</pre><dl>  <dd> What's a column's SQL type?<p>The DBType structure holds the ORACLE type number (VARCHAR is 1) and weneed to convert it to the Java type number (VARCHAR is 12).<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> SQL type    <dt> <b>See Also:</b>    <dd> Types, DBType  </dl></dd></dl><a name="getColumnTypeName(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnTypeName"><b>getColumnTypeName</b></a><pre> public String getColumnTypeName(int column) throws SQLException</pre><dl>  <dd> What's a column's data source specific type name?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> type name  </dl></dd></dl><a name="isReadOnly(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isReadOnly"><b>isReadOnly</b></a><pre> public boolean isReadOnly(int column) throws SQLException</pre><dl>  <dd> Is a column definitely not writable?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="isWritable(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isWritable"><b>isWritable</b></a><pre> public boolean isWritable(int column) throws SQLException</pre><dl>  <dd> Is it possible for a write on the column to succeed?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="isDefinitelyWritable(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="isDefinitelyWritable"><b>isDefinitelyWritable</b></a><pre> public boolean isDefinitelyWritable(int column) throws SQLException</pre><dl>  <dd> Will a write on the column definitely succeed?<p>  <dd><dl>    <dt> <b>Parameters:</b>    <dd> column - the first column is 1, the second is 2, ...    <dt> <b>Returns:</b>    <dd> true if so  </dl></dd></dl><a name="getColumnClassName(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getColumnClassName"><b>getColumnClassName</b></a><pre> public String getColumnClassName(int column) throws SQLException</pre><dl>  <dd> <p>Returns the fully-qualified name of the Java class whose instances are manufactured if the method<code>ResultSet.getObject</code> is called to retrieve a value from the column.  <code>ResultSet.getObject</code> may returna subclass of the class returned by this method.<p>  <dd><dl>    <dt> <b>Returns:</b>    <dd> the fully-qualified name of the class that<code>ResultSet.getObject</code> to retrieve the value in the specified column. This is the class name used for custom mapping.    <dt> <b>Throws:</b> SQLException    <dd> if a database access error occurs  </dl></dd></dl><hr><pre><a href="packages.html">All Packages</a>  <a href="tree.html">Class Hierarchy</a>  <a href="Package-oracle.jdbc.driver.html">This Package</a>  <a href="oracle.jdbc.driver.OracleResultSet.html#_top_">Previous</a>  <a href="oracle.jdbc.driver.OracleStatement.html#_top_">Next</a>  <a href="AllNames.html">Index</a></pre></body></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -