callablestatement.html

API資料大全

<DL>
<DD>Gets the value of a JDBC <code>BIT</code> parameter as a <code>boolean</code> 
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is <code>false</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getByte(int)"><!-- --></A><H3>
getByte</H3>
<PRE>
public byte <B>getByte</B>(int&nbsp;parameterIndex)
             throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>TINYINT</code> parameter as a <code>byte</code> 
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is 0.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getShort(int)"><!-- --></A><H3>
getShort</H3>
<PRE>
public short <B>getShort</B>(int&nbsp;parameterIndex)
               throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>SMALLINT</code> parameter as a <code>short</code>
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is 0.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getInt(int)"><!-- --></A><H3>
getInt</H3>
<PRE>
public int <B>getInt</B>(int&nbsp;parameterIndex)
           throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>INTEGER</code> parameter as an <code>int</code>
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is 0.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getLong(int)"><!-- --></A><H3>
getLong</H3>
<PRE>
public long <B>getLong</B>(int&nbsp;parameterIndex)
             throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>BIGINT</code> parameter as a <code>long</code>
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is 0.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getFloat(int)"><!-- --></A><H3>
getFloat</H3>
<PRE>
public float <B>getFloat</B>(int&nbsp;parameterIndex)
               throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>FLOAT</code> parameter as a <code>float</code>
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is 0.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getDouble(int)"><!-- --></A><H3>
getDouble</H3>
<PRE>
public double <B>getDouble</B>(int&nbsp;parameterIndex)
                 throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>DOUBLE</code> parameter as a <code>double</code>
 in the Java programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2,
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is 0.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getBigDecimal(int, int)"><!-- --></A><H3>
getBigDecimal</H3>
<PRE>
public <A HREF="../../java/math/BigDecimal.html">BigDecimal</A> <B>getBigDecimal</B>(int&nbsp;parameterIndex,
                                int&nbsp;scale)
                         throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I></I>&nbsp;
<P>
<DD>Gets the value of a JDBC <code>NUMERIC</code> parameter as a 
 <code>java.math.BigDecimal</code> object with scale digits to
 the right of the decimal point.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DD><CODE>scale</CODE> - the number of digits to the right of the decimal point<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result is
 <code>null</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getBytes(int)"><!-- --></A><H3>
getBytes</H3>
<PRE>
public byte[] <B>getBytes</B>(int&nbsp;parameterIndex)
                throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>BINARY</code> or <code>VARBINARY</code> 
 parameter as an array of <code>byte</code> values in the Java
 programming language.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result is 
  <code>null</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getDate(int)"><!-- --></A><H3>
getDate</H3>
<PRE>
public <A HREF="../../java/sql/Date.html">Date</A> <B>getDate</B>(int&nbsp;parameterIndex)
             throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>DATE</code> parameter as a 
 <code>java.sql.Date</code> object.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is <code>null</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getTime(int)"><!-- --></A><H3>
getTime</H3>
<PRE>
public <A HREF="../../java/sql/Time.html">Time</A> <B>getTime</B>(int&nbsp;parameterIndex)
             throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Get the value of a JDBC <code>TIME</code> parameter as a 
 <code>java.sql.Time</code> object.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is <code>null</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getTimestamp(int)"><!-- --></A><H3>
getTimestamp</H3>
<PRE>
public <A HREF="../../java/sql/Timestamp.html">Timestamp</A> <B>getTimestamp</B>(int&nbsp;parameterIndex)
                       throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>TIMESTAMP</code> parameter as a 
 <code>java.sql.Timestamp</code> object.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>the parameter value.  If the value is SQL <code>NULL</code>, the result 
 is <code>null</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs</DL>
</DD>
</DL>
<HR>

<A NAME="getObject(int)"><!-- --></A><H3>
getObject</H3>
<PRE>
public <A HREF="../../java/lang/Object.html">Object</A> <B>getObject</B>(int&nbsp;parameterIndex)
                 throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a parameter as an <code>Object</code> in the Java 
 programming language.
 <p>
 This method returns a Java object whose type corresponds to the JDBC
 type that was registered for this parameter using the method
 <code>registerOutParameter</code>.  By registering the target JDBC
 type as <code>java.sql.Types.OTHER</code>, this method can be used
 to read database-specific abstract data types.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2, 
 and so on<DT><B>Returns:</B><DD>A <code>java.lang.Object</code> holding the OUT parameter value.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs<DT><B>See Also: </B><DD><A HREF="../../java/sql/Types.html"><CODE>Types</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getBigDecimal(int)"><!-- --></A><H3>
getBigDecimal</H3>
<PRE>
public <A HREF="../../java/math/BigDecimal.html">BigDecimal</A> <B>getBigDecimal</B>(int&nbsp;parameterIndex)
                         throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Gets the value of a JDBC <code>NUMERIC</code> parameter as a 
 <code>java.math.BigDecimal</code> object with as many digits to the
 right of the decimal point as the value contains.<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parameterIndex</CODE> - the first parameter is 1, the second is 2,
 and so on<DT><B>Returns:</B><DD>the parameter value in full precision.  If the value is 
 SQL <code>NULL</code>, the result is <code>null</code>.<DT><B>Throws:</B><DD><CODE><A HREF="../../java/sql/SQLException.html">SQLException</A></CODE> - if a database access error occurs<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="getObject(int, java.util.Map)"><!-- --></A><H3>
getObject</H3>
<PRE>
public <A HREF="../../java/lang/Object.html">Object</A> <B>getObject</B>(int&nbsp;i,
                        <A HREF="../../java/util/Map.html">Map</A>&nbsp;map)
                 throws <A HREF="../../java/sql/SQLException.html">SQLException</A></PRE>
<DL>
<DD>Returns an object representing the value of OUT parameter