|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface IDbPreparedStatement
Method Summary | |
---|---|
void |
close()
Close this statement. |
void |
execute()
|
java.lang.Object |
executeAndGetScalarValue()
Get the value of the first column in the first row of the result set. |
java.lang.Object |
executeAndGetScalarValue(java.lang.Object p_valueFallback)
Get the value of the first column in the first row of the result set. |
IValueHolder<?> |
executeAndGetScalarValueHolder()
Get the value of the first column in the first row of the result set. |
DbResultSet |
executeQuery()
|
int |
executeUpdate()
|
void |
setBigDecimal(int p_iIdx,
java.lang.Object p_value)
|
void |
setBoolean(int p_iIdx,
java.lang.Object p_value)
|
void |
setByte(int p_iIdx,
java.lang.Object p_value)
|
void |
setCharacterStream(int p_iIdx,
java.lang.Object p_value)
|
void |
setDate(int p_iIdx,
java.lang.Object p_value)
|
void |
setDate(int p_iIdx,
java.lang.Object p_value,
java.util.Calendar p_cal)
|
void |
setDate(int p_iIdx,
java.lang.Object p_value,
java.util.TimeZone p_tz)
|
void |
setDouble(int p_iIdx,
java.lang.Object p_value)
|
void |
setFloat(int p_iIdx,
java.lang.Object p_value)
|
void |
setInt(int p_iIdx,
java.lang.Object p_value)
|
void |
setLong(int p_iIdx,
java.lang.Object p_value)
|
void |
setShort(int p_iIdx,
java.lang.Object p_value)
|
void |
setString(int p_iIdx,
java.lang.Object p_value)
|
void |
setTime(int p_iIdx,
java.lang.Object p_value)
|
void |
setTime(int p_iIdx,
java.lang.Object p_value,
java.util.Calendar p_cal)
|
void |
setTime(int p_iIdx,
java.lang.Object p_value,
java.util.TimeZone p_tz)
|
void |
setTimestamp(int p_iIdx,
java.lang.Object p_value)
|
void |
setTimestamp(int p_iIdx,
java.lang.Object p_value,
java.util.Calendar p_cal)
|
void |
setTimestamp(int p_iIdx,
java.lang.Object p_value,
java.util.TimeZone p_tz)
|
Method Detail |
---|
void execute() throws java.sql.SQLException
java.sql.SQLException
int executeUpdate() throws java.sql.SQLException
java.sql.SQLException
DbResultSet executeQuery() throws java.sql.SQLException
java.sql.SQLException
IValueHolder<?> executeAndGetScalarValueHolder() throws java.sql.SQLException
If the result set is empty, null
is returned.
null
if the result set is empty.
java.sql.SQLException
java.lang.Object executeAndGetScalarValue(java.lang.Object p_valueFallback) throws java.sql.SQLException
If the result set is empty, or the value is null
,
p_valueIfNull
is returned.
p_valueFallback
- The return value if the query returns an empty result
set or null
.
p_valueIfNull
if the result set is empty, or the value
is null
.
java.sql.SQLException
java.lang.Object executeAndGetScalarValue() throws java.sql.SQLException
If the result set is empty, null
is returned.
null
if the result set is empty.
java.sql.SQLException
void setBoolean(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setInt(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setLong(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setShort(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setByte(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setBigDecimal(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setFloat(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setDouble(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setTimestamp(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setTimestamp(int p_iIdx, java.lang.Object p_value, java.util.TimeZone p_tz) throws java.sql.SQLException
java.sql.SQLException
void setTimestamp(int p_iIdx, java.lang.Object p_value, java.util.Calendar p_cal) throws java.sql.SQLException
java.sql.SQLException
void setTime(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setTime(int p_iIdx, java.lang.Object p_value, java.util.TimeZone p_tz) throws java.sql.SQLException
java.sql.SQLException
void setTime(int p_iIdx, java.lang.Object p_value, java.util.Calendar p_cal) throws java.sql.SQLException
java.sql.SQLException
void setDate(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setDate(int p_iIdx, java.lang.Object p_value, java.util.TimeZone p_tz) throws java.sql.SQLException
java.sql.SQLException
void setDate(int p_iIdx, java.lang.Object p_value, java.util.Calendar p_cal) throws java.sql.SQLException
java.sql.SQLException
void setString(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException
java.sql.SQLException
void setCharacterStream(int p_iIdx, java.lang.Object p_value) throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
void close() throws java.sql.SQLException
close
in interface ICloseable
java.sql.SQLException
- If a database error occurred.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |