📄 array.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Frameset//EN""http://www.w3.org/TR/REC-html40/frameset.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc on Thu Apr 27 23:36:17 PDT 2000 --><TITLE>Java 2 Platform SE v1.3: Interface Array</TITLE><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"></HEAD><BODY BGCOLOR="white"><!-- ========== START OF NAVBAR ========== --><A NAME="navbar_top"><!-- --></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0"><TR><TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"><A NAME="navbar_top_firstrow"><!-- --></A><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3"> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/Array.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM><b>Java<sup><font size=-2>TM</font></sup> 2 Platform<br>Std. Ed. v1.3</b></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> PREV CLASS <A HREF="../../java/sql/Blob.html"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../index.html" TARGET="_top"><B>FRAMES</B></A> <A HREF="Array.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: INNER | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><!-- =========== END OF NAVBAR =========== --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">java.sql</FONT><BR>Interface Array</H2><HR><DL><DT>public interface <B>Array</B></DL><P><p> The mapping in the Java programming language for the SQL type <code>ARRAY</code>. By default, an <code>Array</code> object is a transaction-duration reference to an SQL <code>ARRAY</code> value. By default, an <code>Array</code> object is implemented using an SQL LOCATOR(array) internally, which means that an <code>Array</code> object contains a logical pointer to the data in the SQL <code>ARRAY</code> value on the server rather than containing the <code>ARRAY</code> value's data. <p> The <code>Array</code> interface provides methods for bringing an SQL <code>ARRAY</code> value's data to the client as either an array or a <code>ResultSet</code> object. <p> If the elements of the SQL <code>ARRAY</code> are a UDT, they may be custom mapped. To create a custom mapping, a programmer must do two things: <ul> <li>create a class that implements the <A HREF="../../java/sql/SQLData.html"><CODE>SQLData</CODE></A> interface for the UDT to be custom mapped. This will typically be done using a tool. <li>make an entry in a type map that contains <ul> <li>the fully-qualified SQL type name of the UDT <li>the <code>Class</code> object for the class implementing <code>SQLData</code> </ul> </ul> <p> When a type map with an entry for the base type is supplied to the methods <code>getArray</code> and <code>getResultSet</code>, the mapping it contains will be used to map the elements of the <code>ARRAY</code> value. If no type map is supplied, which would typically be the case, the connection's type map is used by default. If the connection's type map or a type map supplied to a method has no entry for the base type, the elements are mapped according to the standard mapping. <p> <b>NOTE:</b> This interface is new in the JDBC 2.0 API.<P><HR><P><!-- ======== INNER CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><!-- ======== CONSTRUCTOR SUMMARY ======== --><!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/Object.html">Object</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getArray()">getArray</A></B>()</CODE><BR> Retrieves the contents of the SQL <code>ARRAY</code> value designated by this <code>Array</code> object in the form of an array in the Java programming language.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/Object.html">Object</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getArray(long, int)">getArray</A></B>(long index, int count)</CODE><BR> Returns an array containing a slice of the SQL <code>ARRAY</code> value designated by this <code>Array</code> object, beginning with the specified <code>index</code> and containing up to <code>count</code> successive elements of the SQL array.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/Object.html">Object</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getArray(long, int, java.util.Map)">getArray</A></B>(long index, int count, <A HREF="../../java/util/Map.html">Map</A> map)</CODE><BR> Returns an array containing a slice of the SQL array object designated by this <code>Array</code> object, beginning with the specified <code>index</code> and containing up to <code>count</code> successive elements of the SQL array.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/Object.html">Object</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getArray(java.util.Map)">getArray</A></B>(<A HREF="../../java/util/Map.html">Map</A> map)</CODE><BR> Retrieves the contents of the SQL array designated by this <code>Array</code> object.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getBaseType()">getBaseType</A></B>()</CODE><BR> Returns the JDBC type of the elements in the array designated by this <code>Array</code> object.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getBaseTypeName()">getBaseTypeName</A></B>()</CODE><BR> Returns the SQL type name of the elements in the array designated by this <code>Array</code> object.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getResultSet()">getResultSet</A></B>()</CODE><BR> Returns a result set that contains the elements of the SQL <code>ARRAY</code> value designated by this <code>Array</code> object.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getResultSet(long, int)">getResultSet</A></B>(long index, int count)</CODE><BR> Returns a result set holding the elements of the subarray that starts at index <code>index</code> and contains up to <code>count</code> successive elements.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getResultSet(long, int, java.util.Map)">getResultSet</A></B>(long index, int count, <A HREF="../../java/util/Map.html">Map</A> map)</CODE><BR> Returns a result set holding the elements of the subarray that starts at index <code>index</code> and contains up to <code>count</code> successive elements.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Array.html#getResultSet(java.util.Map)">getResultSet</A></B>(<A HREF="../../java/util/Map.html">Map</A> map)</CODE><BR> Returns a result set that contains the elements of the SQL <code>ARRAY</code> value designated by this <code>Array</code> object.</TD></TR></TABLE> <P><!-- ============ FIELD DETAIL =========== --><!-- ========= CONSTRUCTOR DETAIL ======== --><!-- ============ METHOD DETAIL ========== --><A NAME="method_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=1><FONT SIZE="+2"><B>Method Detail</B></FONT></TD></TR></TABLE><A NAME="getBaseTypeName()"><!-- --></A><H3>getBaseTypeName</H3><PRE>public <A HREF="../../java/lang/String.html">String</A> <B>getBaseTypeName</B>() throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE><DL><DD>Returns the SQL type name of the elements in the array designated by this <code>Array</code> object. If the elements are a built-in type, it returns the 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.<DD><DL><DT><B>Returns:</B><DD>a <code>String</code> that is the database-specific name for a built-in base type or the fully-qualified SQL type name for a base type that is a UDT<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if an error occurs while attempting to access the type name<DT><B>Since: </B><DD>1.2</DD><DT><B>See Also: </B><DD><a href="package-summary.html#2.0 API">What Is in the JDBC 2.0 API</a></DL></DD></DL><HR><A NAME="getBaseType()"><!-- --></A><H3>getBaseType</H3><PRE>public int <B>getBaseType</B>() throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE><DL><DD>Returns the JDBC type of the elements in the array designated by this <code>Array</code> object.<DD><DL><DT><B>Returns:</B><DD>a constant from the class <A HREF="../../java/sql/Types.html"><CODE>Types</CODE></A> that is the type code for the elements in the array designated by this <code>Array</code> object.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if an error occurs while attempting to access the base type<DT><B>Since: </B><DD>1.2</DD><DT><B>See Also: </B><DD><a href="package-summary.html#2.0 API">What Is in the JDBC 2.0 API</a></DL></DD>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -