|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
public interface PreparedStatement
This interface provides a mechanism for executing pre-compiled statements. This provides greater efficiency when calling the same statement multiple times. Parameters are allowed in a statement, providings for maximum reusability.
Note that in this class parameter indices start at 1, not 0.
| Field Summary |
|---|
| Fields inherited from interface java.sql.Statement |
|---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
| Method Summary | |
|---|---|
void |
addBatch()
This method adds a set of parameters to the batch for JDBC 2.0. |
void |
clearParameters()
This method clears all of the input parameter that have been set on this statement. |
boolean |
execute()
This method executes a prepared SQL query. |
ResultSet |
executeQuery()
This method executes a prepared SQL query and returns its ResultSet. |
int |
executeUpdate()
This method executes an SQL INSERT, UPDATE or DELETE statement. |
ResultSetMetaData |
getMetaData()
This method returns meta data for the result set from this statement. |
ParameterMetaData |
getParameterMetaData()
Returns information about the parameters set on this PreparedStatement (see ParameterMetaData for a
detailed description of the provided information). |
void |
setArray(int index,
Array value)
This method sets the specified parameter from the given Java Array value. |
void |
setAsciiStream(int index,
InputStream stream,
int count)
This method sets the specified parameter from the given Java ASCII InputStream value. |
void |
setBigDecimal(int index,
BigDecimal value)
This method sets the specified parameter from the given Java java.math.BigDecimal value. |
void |
setBinaryStream(int index,
InputStream stream,
int count)
This method sets the specified parameter from the given Java binary InputStream value. |
void |
setBlob(int index,
Blob value)
This method sets the specified parameter from the given Java Blob value. |
void |
setBoolean(int index,
boolean value)
This method sets the specified parameter from the given Java boolean value. |
void |
setByte(int index,
byte value)
This method sets the specified parameter from the given Java byte value. |
void |
setBytes(int index,
byte[] value)
This method sets the specified parameter from the given Java byte array value. |
void |
setCharacterStream(int index,
Reader reader,
int count)
This method sets the specified parameter from the given Java character Reader value. |
void |
setClob(int index,
Clob value)
This method sets the specified parameter from the given Java Clob value. |
void |
setDate(int index,
Date value)
This method sets the specified parameter from the given Java java.sql.Date value. |
void |
setDate(int index,
Date value,
Calendar cal)
This method sets the specified parameter from the given Java java.sql.Date value. |
void |
setDouble(int index,
double value)
This method sets the specified parameter from the given Java double value. |
void |
setFloat(int index,
float value)
This method sets the specified parameter from the given Java float value. |
void |
setInt(int index,
int value)
This method sets the specified parameter from the given Java int value. |
void |
setLong(int index,
long value)
This method sets the specified parameter from the given Java long value. |
void |
setNull(int index,
int sqlType)
This method populates the specified parameter with a SQL NULL value for the specified type. |
void |
setNull(int index,
int sqlType,
String typeName)
This method populates the specified parameter with a SQL NULL value for the specified type. |
void |
setObject(int index,
Object value)
This method sets the specified parameter from the given Java Object value. |
void |
setObject(int index,
Object value,
int sqlType)
This method sets the specified parameter from the given Java Object value. |
void |
setObject(int index,
Object value,
int sqlType,
int scale)
This method sets the specified parameter from the given Java Object value. |
void |
setRef(int index,
Ref value)
This method sets the specified parameter from the given Java Ref value. |
void |
setShort(int index,
short value)
This method sets the specified parameter from the given Java short value. |
void |
setString(int index,
String value)
This method sets the specified parameter from the given Java String value. |
void |
setTime(int index,
Time value)
This method sets the specified parameter from the given Java java.sql.Time value. |
void |
setTime(int index,
Time value,
Calendar cal)
This method sets the specified parameter from the given Java java.sql.Time value. |
void |
setTimestamp(int index,
Timestamp value)
This method sets the specified parameter from the given Java java.sql.Timestamp value. |
void |
setTimestamp(int index,
Timestamp value,
Calendar cal)
This method sets the specified parameter from the given Java java.sql.Timestamp value. |
void |
setUnicodeStream(int index,
InputStream stream,
int count)
Deprecated. |
void |
setURL(int index,
URL value)
This method sets the specified parameter from the given Java java.net.URL value. |
| Method Detail |
|---|
ResultSet executeQuery()
throws SQLException
SQLException - If an error occurs.
int executeUpdate()
throws SQLException
SQLException - If an error occurs.
void setNull(int index,
int sqlType)
throws SQLException
index - The index of the parameter to set.sqlType - The SQL type identifier of the parameter from
Types
SQLException - If an error occurs.
void setBoolean(int index,
boolean value)
throws SQLException
boolean value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setByte(int index,
byte value)
throws SQLException
byte value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setShort(int index,
short value)
throws SQLException
short value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setInt(int index,
int value)
throws SQLException
int value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setLong(int index,
long value)
throws SQLException
long value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setFloat(int index,
float value)
throws SQLException
float value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setDouble(int index,
double value)
throws SQLException
double value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setBigDecimal(int index,
BigDecimal value)
throws SQLException
java.math.BigDecimal value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setString(int index,
String value)
throws SQLException
String value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setBytes(int index,
byte[] value)
throws SQLException
byte array value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setDate(int index,
Date value)
throws SQLException
java.sql.Date value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setTime(int index,
Time value)
throws SQLException
java.sql.Time value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setTimestamp(int index,
Timestamp value)
throws SQLException
java.sql.Timestamp value.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
void setAsciiStream(int index,
InputStream stream,
int count)
throws SQLException
InputStream value.
index - The index of the parameter value to set.stream - The stream from which the parameter value is read.count - The number of bytes in the stream.
SQLException - If an error occurs.
void setUnicodeStream(int index,
InputStream stream,
int count)
throws SQLException
InputStream value.
index - The index of the parameter value to set.stream - The stream from which the parameter value is read.count - The number of bytes in the stream.
SQLException - If an error occurs.
void setBinaryStream(int index,
InputStream stream,
int count)
throws SQLException
InputStream value.
index - The index of the parameter value to set.stream - The stream from which the parameter value is read.count - The number of bytes in the stream.
SQLException - If an error occurs.
void clearParameters()
throws SQLException
SQLException - If an error occurs.
void setObject(int index,
Object value,
int sqlType,
int scale)
throws SQLException
Object value. The specified SQL object type will be used.
index - The index of the parameter value to set.value - The value of the parameter.sqlType - The SQL type to use for the parameter, from
Typesscale - The scale of the value, for numeric values only.
SQLException - If an error occurs.Types
void setObject(int index,
Object value,
int sqlType)
throws SQLException
Object value. The specified SQL object type will be used.
index - The index of the parameter value to set.value - The value of the parameter.sqlType - The SQL type to use for the parameter, from
Types
SQLException - If an error occurs.Types
void setObject(int index,
Object value)
throws SQLException
Object value. The default object type to SQL type mapping
will be used.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
boolean execute()
throws SQLException
SQLException - If an error occurs.
void addBatch()
throws SQLException
SQLException - If an error occurs.
void setCharacterStream(int index,
Reader reader,
int count)
throws SQLException
Reader value.
index - The index of the parameter value to set.reader - The reader from which the parameter value is read.count - The number of characters in the stream.
SQLException - If an error occurs.
void setRef(int index,
Ref value)
throws SQLException
Ref value. The default object type to SQL type mapping
will be used.
index - The index of the parameter value to set.value - The Ref used to set the value of the parameter.
SQLException - If an error occurs.
void setBlob(int index,
Blob value)
throws SQLException
Blob value. The default object type to SQL type mapping
will be used.
index - The index of the parameter value to set.value - The Blob used to set the
value of the parameter.
SQLException - If an error occurs.
void setClob(int index,
Clob value)
throws SQLException
Clob value. The default object type to SQL type mapping
will be used.
index - The index of the parameter value to set.value - The Clob used to set the
value of the parameter.
SQLException - If an error occurs.
void setArray(int index,
Array value)
throws SQLException
Array value. The default object type to SQL type mapping
will be used.
index - The index of the parameter value to set.value - The value of the parameter.
SQLException - If an error occurs.
ResultSetMetaData getMetaData()
throws SQLException
SQLException - If an error occurs.
void setDate(int index,
Date value,
Calendar cal)
throws SQLException
java.sql.Date value.
index - The index of the parameter value to set.value - The value of the parameter.cal - The Calendar to use for timezone and locale.
SQLException - If an error occurs.
void setTime(int index,
Time value,
Calendar cal)
throws SQLException
java.sql.Time value.
index - The index of the parameter value to set.value - The value of the parameter.cal - The Calendar to use for timezone and locale.
SQLException - If an error occurs.
void setTimestamp(int index,
Timestamp value,
Calendar cal)
throws SQLException
java.sql.Timestamp value.
index - The index of the parameter value to set.value - The value of the parameter.cal - The Calendar to use for timezone and locale.
SQLException - If an error occurs.
void setNull(int index,
int sqlType,
String typeName)
throws SQLException
index - The index of the parameter to set.sqlType - The SQL type identifier of the parameter from
TypestypeName - The name of the data type, for user defined types.
SQLException - If an error occurs.
void setURL(int index,
URL value)
throws SQLException
java.net.URL value.
index - The index of the parameter to set.value - The value of the parameter.
SQLException - If an error occurs.
ParameterMetaData getParameterMetaData()
throws SQLException
PreparedStatement (see ParameterMetaData for a
detailed description of the provided information).
SQLExceptionParameterMetaData
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||