oracle.jdbc.driver.oraclepreparedstatement.html

Oracle JDBC 的javaDoc

  </dl></dd>
</dl>
<a name="setARRAY(int, oracle.sql.ARRAY)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setARRAY"><b>setARRAY</b></a>
<pre>
 public synchronized void setARRAY(int paramIndex,
                                   <a href="oracle.sql.ARRAY.html#_top_">ARRAY</a> arr) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.ARRAY.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setSTRUCT(int, oracle.sql.STRUCT)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setSTRUCT"><b>setSTRUCT</b></a>
<pre>
 public synchronized void setSTRUCT(int paramIndex,
                                    <a href="oracle.sql.STRUCT.html#_top_">STRUCT</a> struct) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.STRUCT.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setRAW(int, oracle.sql.RAW)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setRAW"><b>setRAW</b></a>
<pre>
 public synchronized void setRAW(int paramIndex,
                                 <a href="oracle.sql.RAW.html#_top_">RAW</a> raw) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.RAW.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setCHAR(int, oracle.sql.CHAR)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setCHAR"><b>setCHAR</b></a>
<pre>
 public synchronized void setCHAR(int paramIndex,
                                  <a href="oracle.sql.CHAR.html#_top_">CHAR</a> ch) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.CHAR.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setDATE(int, oracle.jdbc.driver.DATE)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setDATE"><b>setDATE</b></a>
<pre>
 public synchronized void setDATE(int paramIndex,
                                  DATE date) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.DATE.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setNUMBER(int, oracle.jdbc.driver.NUMBER)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setNUMBER"><b>setNUMBER</b></a>
<pre>
 public synchronized void setNUMBER(int paramIndex,
                                    NUMBER num) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.NUMBER.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setBLOB(int, oracle.sql.BLOB)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setBLOB"><b>setBLOB</b></a>
<pre>
 public synchronized void setBLOB(int paramIndex,
                                  <a href="oracle.sql.BLOB.html#_top_">BLOB</a> lob) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.BLOB.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setBlob(int, oracle.jdbc2.Blob)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setBlob"><b>setBlob</b></a>
<pre>
 public synchronized void setBlob(int paramIndex,
                                  Blob lob) throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0.
Sets the designated parameter to a Blob value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setCLOB(int, oracle.sql.CLOB)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setCLOB"><b>setCLOB</b></a>
<pre>
 public synchronized void setCLOB(int paramIndex,
                                  <a href="oracle.sql.CLOB.html#_top_">CLOB</a> lob) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.CLOB.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setClob(int, oracle.jdbc2.Clob)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setClob"><b>setClob</b></a>
<pre>
 public synchronized void setClob(int paramIndex,
                                  Clob lob) throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0.
Sets the designated parameter to a Clob value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setBFILE(int, oracle.sql.BFILE)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setBFILE"><b>setBFILE</b></a>
<pre>
 public synchronized void setBFILE(int paramIndex,
                                   <a href="oracle.sql.BFILE.html#_top_">BFILE</a> file) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.BFILE value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setBfile(int, oracle.sql.BFILE)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setBfile"><b>setBfile</b></a>
<pre>
 public synchronized void setBfile(int paramIndex,
                                   <a href="oracle.sql.BFILE.html#_top_">BFILE</a> file) throws SQLException
</pre>
<dl>
  <dd> Oracle specific.
Sets the designated parameter to a oracle.sql.BFILE value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setBytes(int, byte[])"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setBytes"><b>setBytes</b></a>
<pre>
 public synchronized void setBytes(int paramIndex,
                                   byte x[]) throws SQLException
</pre>
<dl>
  <dd> Sets the designated parameter to a Java array of bytes.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setDate(int, java.sql.Date)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setDate"><b>setDate</b></a>
<pre>
 public synchronized void setDate(int paramIndex,
                                  Date x) throws SQLException
</pre>
<dl>
  <dd> Sets the designated parameter to a java.sql.Date value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setTime(int, java.sql.Time)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setTime"><b>setTime</b></a>
<pre>
 public synchronized void setTime(int paramIndex,
                                  Time x) throws SQLException
</pre>
<dl>
  <dd> Sets the designated parameter to a java.sql.Time value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setTimestamp(int, java.sql.Timestamp)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setTimestamp"><b>setTimestamp</b></a>
<pre>
 public synchronized void setTimestamp(int paramIndex,
                                       Timestamp x) throws SQLException
</pre>
<dl>
  <dd> Sets the designated parameter to a java.sql.Timestamp value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the parameter value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setAsciiStream(int, java.io.InputStream, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setAsciiStream"><b>setAsciiStream</b></a>
<pre>
 public synchronized void setAsciiStream(int paramIndex,
                                         InputStream istream,
                                         int length) throws SQLException
</pre>
<dl>
  <dd> Sets the designated parameter to the given input stream, which will have 
the specified number of bytes.
When a very large ASCII value is input to a LONG
parameter, it may be more practical to send it via a
java.io.InputStream. JDBC will read the data from the stream
as needed, until it reaches end-of-file.  The JDBC driver will
do any necessary conversion from ASCII to the database char format.
<P><B>Note:</B> There are restrictions to use this method for CLOBs.
Please see details in Oracle JDBC documents or Readme to avoid
data lossage.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> istream - the Java input stream that contains the ASCII parameter value
    <dd> length - the number of bytes in the stream
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setBinaryStream(int, java.io.InputStream, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setBinaryStream"><b>setBinaryStream</b></a>
<pre>
 public synchronized void setBinaryStream(int paramIndex,
                                          InputStream istream,
                                          int length) throws SQLException
</pre>
<dl>
  <dd> Sets the designated parameter to the given input stream, which will have 
the specified number of bytes.
When a very large binary value is input to a LONG RAW
parameter, it may be more practical to send it via a
java.io.InputStream. JDBC will read the data from the stream
as needed, until it reaches end-of-file.
<P><B>Note:</B> There are restrictions to use this method for BLOBs.
Please see details in Oracle JDBC documents or Readme to avoid
data lossage.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> parameterIndex - the first parameter is 1, the second is 2, ...
    <dd> x - the java input stream which contains the binary parameter value
    <dd> length - the number of bytes in the stream
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setUnicodeStream(int, java.io.InputStream, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setUnicodeStream"><b>setUnicodeStream</b></a>
<pre>
 public synchronized void setUnicodeStream(int paramIndex,
                                           InputStream istream,
                                           int length) throws SQLException
</pre>