Package de.uplanet.lucy.server.util.db

Class DbQuery

java.lang.Object

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

All Implemented Interfaces:

de.uplanet.lucy.server.util.db.IDbQuery, de.uplanet.util.ICloseable, AutoCloseable

public final class DbQuery
extends Object
implements de.uplanet.lucy.server.util.db.IDbQuery

This class provides a database API that is intended to be used in scripting environments.

Constructor Summary

Constructors

Constructor	Description
DbQuery()

Method Summary

Modifier and Type	Method	Description
void	close()
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)
IValueHolder<?>	executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)
int	getDefaultFetchSize()	Get the default fetch size.
DbPreparedStatement	prepare(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)
void	setDefaultFetchSize(int p_iDefaultFetchSize)	Set the default fetch size for prepared statements created by this class.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DbQuery

public DbQuery()

Method Detail

getDefaultFetchSize

public int getDefaultFetchSize()

Get the default fetch size. The default value is 100.

Specified by:

getDefaultFetchSize in interface de.uplanet.lucy.server.util.db.IDbQuery

Returns:

The default fetch size.

setDefaultFetchSize

public void setDefaultFetchSize(int p_iDefaultFetchSize)

Set the default fetch size for prepared statements created by this class.

Specified by:

setDefaultFetchSize in interface de.uplanet.lucy.server.util.db.IDbQuery

Parameters:

p_iDefaultFetchSize - The default fetch size.

executeAndGetScalarValueHolder

public IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn,
                                                      String p_strQuery)
                                               throws SQLException

Specified by:

executeAndGetScalarValueHolder in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery,
                                       Object p_valueFallback)
                                throws SQLException

Specified by:

executeAndGetScalarValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery)
                                throws SQLException

Specified by:

executeAndGetScalarValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery,
                                       Object p_valueFallback,
                                       groovy.lang.Closure<?> p_closure)
                                throws SQLException

Specified by:

executeAndGetScalarValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery,
                                       groovy.lang.Closure<?> p_closure)
                                throws SQLException

Specified by:

executeAndGetScalarValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery,
                                               Object p_valueFallback)
                                        throws SQLException,
                                               de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBooleanValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery)
                                        throws SQLException,
                                               de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBooleanValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery,
                                               Object p_valueFallback,
                                               groovy.lang.Closure<?> p_closure)
                                        throws SQLException,
                                               de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBooleanValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery,
                                               groovy.lang.Closure<?> p_closure)
                                        throws SQLException,
                                               de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBooleanValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarByteValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarByteValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarByteValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarByteValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarShortValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarShortValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarShortValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarShortValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarIntValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarIntValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarIntValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarIntValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarLongValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarLongValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarLongValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarLongValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarFloatValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarFloatValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarFloatValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarFloatValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDoubleValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDoubleValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDoubleValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDoubleValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery,
                                                     Object p_valueFallback)
                                              throws SQLException,
                                                     de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBigDecimalValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery)
                                              throws SQLException,
                                                     de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBigDecimalValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery,
                                                     Object p_valueFallback,
                                                     groovy.lang.Closure<?> p_closure)
                                              throws SQLException,
                                                     de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBigDecimalValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery,
                                                     groovy.lang.Closure<?> p_closure)
                                              throws SQLException,
                                                     de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarBigDecimalValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarStringValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarStringValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarStringValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarStringValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery,
                                                   Object p_valueFallback)
                                            throws SQLException,
                                                   de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimestampValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery)
                                            throws SQLException,
                                                   de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimestampValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery,
                                                   Object p_valueFallback,
                                                   groovy.lang.Closure<?> p_closure)
                                            throws SQLException,
                                                   de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimestampValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery,
                                                   groovy.lang.Closure<?> p_closure)
                                            throws SQLException,
                                                   de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimestampValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDateValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDateValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDateValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarDateValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimeValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimeValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimeValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException

Specified by:

executeAndGetScalarTimeValue in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

de.uplanet.lucy.server.util.db.ValueCastException

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         String p_strQuery)
                  throws SQLException

Specified by:

executeUpdate in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         String p_strQuery,
                         groovy.lang.Closure<?> p_closure)
                  throws SQLException

Specified by:

executeUpdate in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

prepare

public DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn,
                                   String p_strQuery)
                            throws SQLException

Specified by:

prepare in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException

close

public void close()
           throws SQLException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface de.uplanet.lucy.server.util.db.IDbQuery

Throws:

SQLException