de.uplanet.lucy.server.util.db
Class DbQuery

java.lang.Object
  extended by de.uplanet.lucy.server.util.db.DbQuery
All Implemented Interfaces:
IDbQuery, ICloseable

public final class DbQuery
extends java.lang.Object
implements IDbQuery

Version:
$Revision: 92937 $

Constructor Summary
DbQuery()
           
 
Method Summary
 void close()
          Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.
 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure)
          Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
 java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Get the value of the first column in the first row of the result set.
 java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Get the value of the first column in the first row of the result set.
 java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback)
          Get the value of the first column in the first row of the result set.
 java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.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, java.lang.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, java.lang.String p_strQuery)
          Execute an INSERT or UPDATE statement.
 int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure)
          Execute a prepared INSERT or UPDATE statement.
 DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Prepares a statement.
 DbPreparedStatement prepareDeprecated(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery)
          Deprecated.  
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

DbQuery

public DbQuery()
Method Detail

executeAndGetScalarValueHolder

public IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn,
                                                      java.lang.String p_strQuery)
                                               throws java.sql.SQLException
Description copied from interface: IDbQuery
Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Specified by:
executeAndGetScalarValueHolder in interface IDbQuery
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:
java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery,
                                                 java.lang.Object p_valueFallback)
                                          throws java.sql.SQLException
Description copied from interface: IDbQuery
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.

Specified by:
executeAndGetScalarValue in interface IDbQuery
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, or null.
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 is null.
Throws:
java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery)
                                          throws java.sql.SQLException
Description copied from interface: IDbQuery
Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Specified by:
executeAndGetScalarValue in interface IDbQuery
Returns:
The value of the first column in the first row of the result set, or null if the result set is empty.
Throws:
java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery,
                                                 java.lang.Object p_valueFallback,
                                                 groovy.lang.Closure p_closure)
                                          throws java.sql.SQLException
Description copied from interface: IDbQuery
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.

Specified by:
executeAndGetScalarValue in interface IDbQuery
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, or null.
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 is null.
Throws:
java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery,
                                                 groovy.lang.Closure p_closure)
                                          throws java.sql.SQLException
Description copied from interface: IDbQuery
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.

Specified by:
executeAndGetScalarValue in interface IDbQuery
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 is null.
Throws:
java.sql.SQLException

executeAndGetScalarBooleanValue

public java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery,
                                                         java.lang.Object p_valueFallback)
                                                  throws java.sql.SQLException,
                                                         ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarBooleanValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBooleanValue

public java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery)
                                                  throws java.sql.SQLException,
                                                         ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarBooleanValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBooleanValue

public java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery,
                                                         java.lang.Object p_valueFallback,
                                                         groovy.lang.Closure p_closure)
                                                  throws java.sql.SQLException,
                                                         ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarBooleanValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBooleanValue

public java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery,
                                                         groovy.lang.Closure p_closure)
                                                  throws java.sql.SQLException,
                                                         ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarBooleanValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarByteValue

public java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarByteValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarByteValue

public java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarByteValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarByteValue

public java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarByteValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarByteValue

public java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarByteValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarShortValue

public java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarShortValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarShortValue

public java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarShortValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarShortValue

public java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarShortValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarShortValue

public java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarShortValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarIntValue

public java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarIntValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarIntValue

public java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarIntValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarIntValue

public java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarIntValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarIntValue

public java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarIntValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarLongValue

public java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarLongValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarLongValue

public java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarLongValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarLongValue

public java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarLongValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarLongValue

public java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarLongValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarFloatValue

public java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarFloatValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarFloatValue

public java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarFloatValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarFloatValue

public java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarFloatValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarFloatValue

public java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarFloatValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDoubleValue

public java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarDoubleValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDoubleValue

public java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarDoubleValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDoubleValue

public java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarDoubleValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDoubleValue

public java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarDoubleValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarBigDecimalValue

public java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery,
                                                               java.lang.Object p_valueFallback)
                                                        throws java.sql.SQLException,
                                                               ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarBigDecimalValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBigDecimalValue

public java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery)
                                                        throws java.sql.SQLException,
                                                               ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarBigDecimalValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBigDecimalValue

public java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery,
                                                               java.lang.Object p_valueFallback,
                                                               groovy.lang.Closure p_closure)
                                                        throws java.sql.SQLException,
                                                               ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarBigDecimalValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBigDecimalValue

public java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery,
                                                               groovy.lang.Closure p_closure)
                                                        throws java.sql.SQLException,
                                                               ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarBigDecimalValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarStringValue

public java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarStringValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarStringValue

public java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarStringValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarStringValue

public java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarStringValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarStringValue

public java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarStringValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimestampValue

public java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery,
                                                            java.lang.Object p_valueFallback)
                                                     throws java.sql.SQLException,
                                                            ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarTimestampValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimestampValue

public java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery)
                                                     throws java.sql.SQLException,
                                                            ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarTimestampValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimestampValue

public java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery,
                                                            java.lang.Object p_valueFallback,
                                                            groovy.lang.Closure p_closure)
                                                     throws java.sql.SQLException,
                                                            ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarTimestampValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimestampValue

public java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery,
                                                            groovy.lang.Closure p_closure)
                                                     throws java.sql.SQLException,
                                                            ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarTimestampValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDateValue

public java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarDateValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDateValue

public java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarDateValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDateValue

public java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarDateValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDateValue

public java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarDateValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimeValue

public java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:
executeAndGetScalarTimeValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimeValue

public java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:
executeAndGetScalarTimeValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimeValue

public java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:
executeAndGetScalarTimeValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimeValue

public java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException
Description copied from interface: IDbQuery
Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:
executeAndGetScalarTimeValue in interface IDbQuery
Throws:
java.sql.SQLException - If a database error occurred.
ValueCastException - If the database value could not be cast to the specific type.
See Also:
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         java.lang.String p_strQuery)
                  throws java.sql.SQLException
Description copied from interface: IDbQuery
Execute an INSERT or UPDATE statement.

Specified by:
executeUpdate in interface IDbQuery
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:
java.sql.SQLException

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         java.lang.String p_strQuery,
                         groovy.lang.Closure p_closure)
                  throws java.sql.SQLException
Description copied from interface: IDbQuery
Execute a prepared INSERT or UPDATE statement.

Specified by:
executeUpdate in interface IDbQuery
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:
java.sql.SQLException

prepare

public DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn,
                                   java.lang.String p_strQuery)
                            throws java.sql.SQLException
Description copied from interface: IDbQuery
Prepares a statement.

Specified by:
prepare in interface IDbQuery
Parameters:
p_conn - The database connection to be used.
p_strQuery - The (parameterized) SQL query.
Returns:
A prepared statement object.
Throws:
java.sql.SQLException - If a database error occurred.

prepareDeprecated

@Deprecated
public DbPreparedStatement prepareDeprecated(de.uplanet.jdbc.JdbcConnection p_conn,
                                                        java.lang.String p_strQuery)
                                      throws java.sql.SQLException
Deprecated. 

In deprecated mode DbDisconnectedRow does not support null values for primitive numeric or boolean datatypes, but returns 0 or false values instead.

Throws:
java.sql.SQLException

close

public void close()
           throws java.sql.SQLException
Description copied from interface: IDbQuery
Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.

Specified by:
close in interface IDbQuery
Specified by:
close in interface ICloseable
Throws:
java.sql.SQLException - If a database error occurred.


Last updated: 2011-08-11 10-04
Copyright © 2000-2011 United Planet. All Rights Reserved.