📄 oracle.sql.array.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.sql.ARRAY</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.sql.html">This Package</a> <a href="Package-oracle.sql.html">Previous</a> <a href="oracle.sql.ArrayDescriptor.html#_top_">Next</a> <a href="AllNames.html">Index</a></pre><hr><h1> Class oracle.sql.ARRAY</h1><pre>oracle.sql.ARRAY</pre><hr><dl> <dt> public class <b>ARRAY</b> <dt> implements Array</dl><hr><a name="index"></a><h2> <img src="images/constructor-index.gif" width=275 height=38 alt="Constructor Index"></h2><dl> <dt> <img src="images/yellow-ball-small.gif" width=6 height=6 alt=" o "> <a href="#ARRAY(oracle.sql.ArrayDescriptor, java.sql.Connection, java.lang.Object)"><b>ARRAY</b></a>(ArrayDescriptor, Connection, Object) <dd> Constructor.</dl><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="#getArray()"><b>getArray</b></a>() <dd> Implements Array interface methodRetrieve the contents of the SQL array designated by the object. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getArray(java.util.Dictionary)"><b>getArray</b></a>(Dictionary) <dd> Implements Array interface methodRetrieve the contents of the SQL array designated by thisobject. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getArray(long, int)"><b>getArray</b></a>(long, int) <dd> Implements Array interface methodLike getArray() above, but returns an array containing aslice of the SQL array, beginning with the given index andcontaining up to count successive elements of the SQL array. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getArray(long, int, java.util.Dictionary)"><b>getArray</b></a>(long, int, Dictionary) <dd> Implements Array interface methodLike getArray() above, but returns an array containing aslice of the SQL array, beginning with the given index andcontaining up to count successive elements of the SQL array. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBaseType()"><b>getBaseType</b></a>() <dd> Implements Array interface methodDetermine the code, from java.sql.Types, of the type ofthe elements of the array. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBaseTypeName()"><b>getBaseTypeName</b></a>() <dd> Implements Array interface methodReturns the SQL type name of the elements inthe array designated by this <code>Array</code> object. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getConnection()"><b>getConnection</b></a>() <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDescriptor()"><b>getDescriptor</b></a>() <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getOracleArray()"><b>getOracleArray</b></a>() <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getOracleArray(long, int)"><b>getOracleArray</b></a>(long, int) <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSet()"><b>getResultSet</b></a>() <dd> Implements Array interface methodReturns a result set that contains the elements of the arraydesignated by this <code>Array</code> object. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSet(java.util.Dictionary)"><b>getResultSet</b></a>(Dictionary) <dd> Implements Array interface method Returns a result set that contains the elements of the arraydesignated by this <code>Array</code> object and uses the given<code>map</code> to map the array elements. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSet(long, int)"><b>getResultSet</b></a>(long, int) <dd> Implements Array interface method Returns a result set holding the elements of the subarray thatstarts at index <code>index</code> and contains up to<code>count</code> successive elements. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSet(long, int, java.util.Dictionary)"><b>getResultSet</b></a>(long, int, Dictionary) <dd> Implements Array interface method Returns a result set holding the elements of the subarray thatstarts at index <code>index</code> and contains up to<code>count</code> successive elements. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSQLTypeName()"><b>getSQLTypeName</b></a>() <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#isConvertibleTo(java.lang.Class)"><b>isConvertibleTo</b></a>(Class) <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#length()"><b>length</b></a>() <dd> Oracle extension. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#toJdbc()"><b>toJdbc</b></a>() <dd> Oracle extension.</dl><a name="constructors"></a><h2> <img src="images/constructors.gif" width=231 height=38 alt="Constructors"></h2><a name="ARRAY"></a><a name="ARRAY(oracle.sql.ArrayDescriptor, java.sql.Connection, java.lang.Object)"><img src="images/yellow-ball.gif" width=12 height=12 alt=" o "></a><b>ARRAY</b><pre> public ARRAY(<a href="oracle.sql.ArrayDescriptor.html#_top_">ArrayDescriptor</a> type, Connection conn, Object elements) throws SQLException</pre><dl> <dd> Constructor.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> descriptor - an ArrayDescriptor describing the SQL Type <dd> elements - the contents of the array. These objects willbe converted to raw bytes of the appropriate SQL Type </dl></dd></dl><a name="methods"></a><h2> <img src="images/methods.gif" width=151 height=38 alt="Methods"></h2><a name="getBaseTypeName()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getBaseTypeName"><b>getBaseTypeName</b></a><pre> public String getBaseTypeName() throws SQLException</pre><dl> <dd> Implements Array interface methodReturns the SQL type name of the elements inthe array designated by this <code>Array</code> object.If the elements are a built-in type, it returnsthe database-specific type name of the elements.If the elements are a user-defined type (UDT),this method returns the fully-qualified SQL type name.<p> <dd><dl> <dt> <b>Returns:</b> <dd> a <code>String</code> that is the database-specificname for a built-in base type or the fully-qualified SQL typename for a base type that is a UDT <dt> <b>Throws:</b> SQLException <dd> if an error occurs while attemptingto access the type name </dl></dd></dl><a name="getBaseType()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getBaseType"><b>getBaseType</b></a><pre> public int getBaseType() throws SQLException</pre><dl> <dd> Implements Array interface methodDetermine the code, from java.sql.Types, of the type ofthe elements of the array.<p> <dd><dl> <dt> <b>Returns:</b> <dd> the type code of the elements of the array. <dt> <b>See Also:</b> <dd> Types, <a href="oracle.jdbc.driver.OracleTypes.html#_top_">OracleTypes</a> </dl></dd></dl><a name="getArray()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getArray"><b>getArray</b></a><pre> public Object getArray() throws SQLException</pre><dl> <dd> Implements Array interface methodRetrieve the contents of the SQL array designated by the object.Use the type-map associated with the connection for customizations ofthe type-mappings.<p> <dd><dl> <dt> <b>Returns:</b> <dd> a Java array containing the ordered elements of the SQLarray designated by this object. </dl></dd></dl><a name="getArray(java.util.Dictionary)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getArray"><b>getArray</b></a><pre> public Object getArray(Dictionary map) throws SQLException</pre><dl> <dd> Implements Array interface methodRetrieve the contents of the SQL array designated by thisobject. Use the given map for type-map customizations.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> map - contains mapping of SQL type names to Java classes <dt> <b>Returns:</b> <dd> a Java array containing the ordered elements of the SQLarray designated by this object. </dl></dd></dl><a name="getArray(long, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getArray"><b>getArray</b></a><pre> public Object getArray(long index, int count) throws SQLException</pre><dl> <dd> Implements Array interface methodLike getArray() above, but returns an array containing aslice of the SQL array, beginning with the given index andcontaining up to count successive elements of the SQL array.Use the type-map associated with the connection for customizationsof the type-mappings.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> index - the array-index of the first element to retrieve <dd> count - the number of successive SQL array elements to retrieve <dt> <b>Returns:</b> <dd> an array containing up to count elements of theSQL array, beginning with element index. </dl></dd></dl><a name="getArray(long, int, java.util.Dictionary)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="getArray"><b>getArray</b></a><pre> public Object getArray(long index, int count, Dictionary map) throws SQLException</pre><dl> <dd> Implements Array interface methodLike getArray() above, but returns an array containing aslice of the SQL array, beginning with the given index andcontaining up to count successive elements of the SQL array.Use the given map for type-map customizations.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> index - the array-index of the first element to retrieve <dd> count - the number of successive SQL array elements to retrieve <dd> map - contains mapping of SQL user-defined types to classes <dt> <b>Returns:</b> <dd> an array containing up to count elements of theSQL array, beginning with element index.⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -