Interface IDbQuery
- All Superinterfaces:
AutoCloseable
,de.uplanet.util.ICloseable
- All Known Implementing Classes:
DbQuery
-
Method Summary
Modifier and TypeMethodDescriptionvoid
close()
Close this database query object and all dependentDbPreparedStatement
andDbResultSet
objects.executeAndGetScalarBigDecimalValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarBigDecimalValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarBigDecimalValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarBigDecimalValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarBooleanValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarBooleanValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarBooleanValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarBooleanValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarByteValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarByteValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarByteValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarByteValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarDateValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarDateValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarDateValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarDateValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarDoubleValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarDoubleValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarDoubleValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarDoubleValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarFloatValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarFloatValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarFloatValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarFloatValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarIntValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarIntValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarIntValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarIntValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarLongValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarLongValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarLongValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarLongValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarShortValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarShortValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarShortValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarShortValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarStringValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarStringValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarStringValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarStringValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarTimestampValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarTimestampValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarTimestampValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarTimestampValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarTimeValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.executeAndGetScalarTimeValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.executeAndGetScalarTimeValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.executeAndGetScalarTimeValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.executeAndGetScalarValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Get the value of the first column in the first row of the result set.executeAndGetScalarValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Get the value of the first column in the first row of the result set.executeAndGetScalarValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) Get the value of the first column in the first row of the result set.executeAndGetScalarValue
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) Get the value of the first column in the first row of the result set.IValueHolder<?>
executeAndGetScalarValueHolder
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Get the value of the first column in the first row of the result set.int
executeUpdate
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) Execute anINSERT
orUPDATE
statement.int
executeUpdate
(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) Execute a preparedINSERT
orUPDATE
statement.int
Get the default fetch size.Prepares a statement.void
setDefaultFetchSize
(int p_iDefaultFetchSize) Set the default fetch size for prepared statements.
-
Method Details
-
getDefaultFetchSize
int getDefaultFetchSize()Get the default fetch size.- Returns:
- The default fetch size.
-
setDefaultFetchSize
void setDefaultFetchSize(int p_iDefaultFetchSize) Set the default fetch size for prepared statements.- Parameters:
p_iDefaultFetchSize
- The default fetch size.
-
executeAndGetScalarValueHolder
IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException Get the value of the first column in the first row of the result set.If the result set is empty,
null
is returned.- Returns:
- A value holder that contains the value of the first column in the first
row of the result set, or
null
if the result set is empty. - Throws:
SQLException
- If a database error occurred.
-
executeAndGetScalarValue
Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException Get the value of the first column in the first row of the result set.If the result set is empty, or the value is
null
,p_valueIfNull
is returned.Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective
executeAndGetScalarValueXxx
methods.- Parameters:
p_conn
- The database connection to be used.p_strQuery
- The query.p_valueFallback
- The return value if the query returns an empty result set, ornull
.- Returns:
- The value of the first column in the first row of the result set,
or
p_valueIfNull
if the result set is empty, or the value isnull
. - Throws:
SQLException
- If a database error occurred.
-
executeAndGetScalarValue
Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException Get the value of the first column in the first row of the result set.If the result set is empty,
null
is returned.Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective
executeAndGetScalarValueXxx
methods.- Returns:
- The value of the first column in the first row of the result set,
or
null
if the result set is empty. - Throws:
SQLException
- If a database error occurred.
-
executeAndGetScalarValue
Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException Get the value of the first column in the first row of the result set.If the result set is empty or the value is
null
,p_valueIfNull
is returned.Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective
executeAndGetScalarValueXxx
methods.- Parameters:
p_conn
- The database connection to be used.p_strQuery
- The query.p_valueFallback
- The return value if the query returns an empty result set, ornull
.p_closure
- The closure that prepares the statement.- Returns:
- The value of the first column in the first row of the result set,
or
p_valueIfNull
if the result set is empty or the value isnull
. - Throws:
SQLException
- If a database error occurred.
-
executeAndGetScalarValue
Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException Get the value of the first column in the first row of the result set.If the result set is empty or the value is
null
,p_valueIfNull
is returned.Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective
executeAndGetScalarValueXxx
methods.- Parameters:
p_conn
- The database connection to be used.p_strQuery
- The query.p_closure
- The closure that prepares the statement.- Returns:
- The value of the first column in the first row of the result set,
or
p_valueIfNull
if the result set is empty or the value isnull
. - Throws:
SQLException
- If a database error occurred.
-
executeAndGetScalarBooleanValue
Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBooleanValue
Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBooleanValue
Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBooleanValue
Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarByteValue
Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarByteValue
Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarByteValue
Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarByteValue
Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarShortValue
Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarShortValue
Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarShortValue
Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarShortValue
Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarIntValue
Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarIntValue
Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarIntValue
Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarIntValue
Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarLongValue
Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarLongValue
Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarLongValue
Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarLongValue
Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarFloatValue
Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarFloatValue
Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarFloatValue
Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarFloatValue
Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDoubleValue
Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDoubleValue
Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDoubleValue
Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDoubleValue
Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBigDecimalValue
BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBigDecimalValue
BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBigDecimalValue
BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBigDecimalValue
BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarStringValue
String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarStringValue
String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarStringValue
String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarStringValue
String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimestampValue
Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimestampValue
Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimestampValue
Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimestampValue
Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDateValue
Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDateValue
Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDateValue
Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDateValue
Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimeValue
Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimeValue
Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimeValue
Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Object, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimeValue
Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException, ValueCastException Typed version ofexecuteAndGetScalarValue(JdbcConnection, String, Closure)
.- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeUpdate
Execute anINSERT
orUPDATE
statement.- Parameters:
p_conn
- The database connection to be used.p_strQuery
- The SQL statement to be executed.- Returns:
- The number of affected rows in the database, or
0
. - Throws:
SQLException
-
executeUpdate
int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure) throws SQLException Execute a preparedINSERT
orUPDATE
statement.- Parameters:
p_conn
- The database connection to be used.p_strQuery
- The (prepared) SQL statement to be executed.p_closure
- The closure that prepares the statement.- Returns:
- The number of affected rows in the database, or
0
. - Throws:
SQLException
-
prepare
DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery) throws SQLException Prepares a statement.- Parameters:
p_conn
- The database connection to be used.p_strQuery
- The (parameterized) SQL query.- Returns:
- A prepared statement object.
- Throws:
SQLException
- If a database error occurred.
-
close
Close this database query object and all dependentDbPreparedStatement
andDbResultSet
objects.- Specified by:
close
in interfaceAutoCloseable
- Throws:
SQLException
- If a database error occurred.
-