|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectde.uplanet.lucy.server.util.db.DbQuery
public final class DbQuery
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 |
---|
public DbQuery()
Method Detail |
---|
public IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException
IDbQuery
If the result set is empty, null
is returned.
executeAndGetScalarValueHolder
in interface IDbQuery
null
if the result set is empty.
java.sql.SQLException
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
IDbQuery
If the result set is empty, or the value is null
,
p_valueIfNull
is returned.
executeAndGetScalarValue
in interface IDbQuery
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_valueIfNull
if the result set is empty, or the value
is null
.
java.sql.SQLException
public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException
IDbQuery
If the result set is empty, null
is returned.
executeAndGetScalarValue
in interface IDbQuery
null
if the result set is empty.
java.sql.SQLException
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
IDbQuery
If the result set is empty or the value is null
,
p_valueIfNull
is returned.
executeAndGetScalarValue
in interface IDbQuery
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.
p_valueIfNull
if the result set is empty or the value
is null
.
java.sql.SQLException
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
IDbQuery
If the result set is empty or the value is null
,
p_valueIfNull
is returned.
executeAndGetScalarValue
in interface IDbQuery
p_conn
- The database connection to be used.p_strQuery
- The query.p_closure
- The closure that prepares the statement.
p_valueIfNull
if the result set is empty or the value
is null
.
java.sql.SQLException
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarBooleanValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarBooleanValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarBooleanValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarBooleanValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarByteValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarByteValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarByteValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarByteValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarShortValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarShortValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarShortValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarShortValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarIntValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarIntValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarIntValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarIntValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarLongValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarLongValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarLongValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarLongValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarFloatValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarFloatValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarFloatValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarFloatValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarDoubleValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarDoubleValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarDoubleValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarDoubleValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarBigDecimalValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarBigDecimalValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarBigDecimalValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarBigDecimalValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarStringValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarStringValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarStringValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarStringValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarTimestampValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarTimestampValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarTimestampValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarTimestampValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarDateValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarDateValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarDateValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarDateValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
.
executeAndGetScalarTimeValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)
public java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException, ValueCastException
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
.
executeAndGetScalarTimeValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
.
executeAndGetScalarTimeValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)
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
IDbQuery
IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
.
executeAndGetScalarTimeValue
in interface IDbQuery
java.sql.SQLException
- If a database error occurred.
ValueCastException
- If the database value could not be cast to
the specific type.IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)
public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException
IDbQuery
INSERT
or UPDATE
statement.
executeUpdate
in interface IDbQuery
p_conn
- The database connection to be used.p_strQuery
- The SQL statement to be executed.
0
.
java.sql.SQLException
public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) throws java.sql.SQLException
IDbQuery
INSERT
or UPDATE
statement.
executeUpdate
in interface IDbQuery
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.
0
.
java.sql.SQLException
public DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException
IDbQuery
prepare
in interface IDbQuery
p_conn
- The database connection to be used.p_strQuery
- The (parameterized) SQL query.
java.sql.SQLException
- If a database error occurred.@Deprecated public DbPreparedStatement prepareDeprecated(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) throws java.sql.SQLException
DbDisconnectedRow
does not support null
values for primitive numeric or boolean datatypes, but returns 0
or
false
values instead.
java.sql.SQLException
public void close() throws java.sql.SQLException
IDbQuery
DbPreparedStatement
and DbResultSet
objects.
close
in interface IDbQuery
close
in interface ICloseable
java.sql.SQLException
- If a database error occurred.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |