Contents | Package | Class | Tree | Deprecated | Index | Help | Java 1.2 Beta 3 | ||
PREV | NEXT | SHOW LISTS | HIDE LISTS |
A SQL statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer then setInt should be used.
If arbitrary parameter type conversions are required then the setObject method should be used with a target SQL type.
Method Summary | |
void | addBatch()
|
void | clearParameters()
In general, parameter values remain in force for repeated use of a Statement. |
boolean | execute()
|
ResultSet | executeQuery()
|
int | executeUpdate()
|
void | setArrayLocator(int i,
ArrayLocator x)
|
void | setAsciiStream(int parameterIndex,
InputStream x,
int length)
|
void | setBigDecimal(int parameterIndex,
BigDecimal x)
|
void | setBinaryStream(int parameterIndex,
InputStream x,
int length)
|
void | setBlobLocator(int i,
BlobLocator x)
|
void | setBoolean(int parameterIndex,
boolean x)
|
void | setByte(int parameterIndex,
byte x)
|
void | setBytes(int parameterIndex,
byte[] x)
|
void | setCharacterStream(int parameterIndex,
Reader reader,
int length)
|
void | setClobLocator(int i,
ClobLocator x)
|
void | setDate(int parameterIndex,
Date x)
|
void | setDouble(int parameterIndex,
double x)
|
void | setFloat(int parameterIndex,
float x)
|
void | setInt(int parameterIndex,
int x)
|
void | setLong(int parameterIndex,
long x)
|
void | setNull(int parameterIndex,
int sqlType)
|
void | setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values. |
void | setObject(int parameterIndex,
Object x,
int targetSqlType)
|
void | setObject(int parameterIndex,
Object x)
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values. |
void | setRef(int i,
Ref x)
|
void | setShort(int parameterIndex,
short x)
|
void | setString(int parameterIndex,
String x)
|
void | setStructLocator(int i,
StructLocator x)
|
void | setTime(int parameterIndex,
Time x)
|
void | setTimestamp(int parameterIndex,
Timestamp x)
|
void | setUnicodeStream(int parameterIndex,
InputStream x,
int length)
|
Method Detail |
public ResultSet executeQuery() throws SQLException
public int executeUpdate() throws SQLException
public void setNull(int parameterIndex, int sqlType) throws SQLException
Note: You must specify the parameter's SQL type.
parameterIndex
- the first parameter is 1, the second is 2, ...
sqlType
- SQL type code defined by java.sql.Types
public void setBoolean(int parameterIndex, boolean x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setByte(int parameterIndex, byte x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setShort(int parameterIndex, short x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setInt(int parameterIndex, int x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setLong(int parameterIndex, long x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setFloat(int parameterIndex, float x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setDouble(int parameterIndex, double x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setString(int parameterIndex, String x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setBytes(int parameterIndex, byte[] x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setDate(int parameterIndex, Date x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setTime(int parameterIndex, Time x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the parameter value
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the java input stream which contains the ASCII parameter value
length
- the number of bytes in the stream
public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the java input stream which contains the
UNICODE parameter value
length
- the number of bytes in the stream
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the java input stream which contains the binary parameter value
length
- the number of bytes in the stream
public void clearParameters() throws SQLException
In general, parameter values remain in force for repeated use of a Statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling clearParameters.
public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
The given Java object will be converted to the targetSqlType before being sent to the database.
Note that this method may be used to pass datatabase- specific abstract data types. This is done by using a Driver- specific Java type and using a targetSqlType of java.sql.types.OTHER.
parameterIndex
- The first parameter is 1, the second is 2, ...
x
- The object containing the input parameter value
targetSqlType
- The SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type.
scale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored,
public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
public void setObject(int parameterIndex, Object x) throws SQLException
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument java object will be converted to the corresponding SQL type before being sent to the database.
Note that this method may be used to pass datatabase specific abstract data types, by using a Driver specific Java type.
parameterIndex
- The first parameter is 1, the second is 2, ...
x
- The object containing the input parameter value
public boolean execute() throws SQLException
public void addBatch() throws SQLException
public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex
- the first parameter is 1, the second is 2, ...
x
- the java reader which contains the UNICODE data
length
- the number of characters in the stream
public void setRef(int i, Ref x) throws SQLException
i
- the first parameter is 1, the second is 2, ...
x
- an object representing data of an SQL REF Type
public void setBlobLocator(int i, BlobLocator x) throws SQLException
i
- the first parameter is 1, the second is 2, ...
x
- an object representing data of a locator to a BLOB
public void setClobLocator(int i, ClobLocator x) throws SQLException
i
- the first parameter is 1, the second is 2, ...
x
- an object representing data of a locator to a CLOB
public void setStructLocator(int i, StructLocator x) throws SQLException
i
- the first parameter is 1, the second is 2, ...
x
- an object representing data of a locator to an instance
of a Structured Type
public void setArrayLocator(int i, ArrayLocator x) throws SQLException
i
- the first parameter is 1, the second is 2, ...
x
- an object representing data of a locator to an SQL array
Contents | Package | Class | Tree | Deprecated | Index | Help | Java 1.2 Beta 3 | ||
PREV | NEXT | SHOW LISTS | HIDE LISTS |