Package de.xima.fc.manager

Class DBQueryManager

java.lang.Object

de.xima.fc.manager.DBQueryManager

public class DBQueryManager
extends Object

Constructor Summary

Constructors

Constructor	Description
DBQueryManager()

Method Summary

Modifier and Type	Method	Description
static de.xima.cmn.db.model.SerializableResultSet	executeDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, boolean suppressStatementLimits, boolean publicOnly, IReplacerParams placeholderParams, Serializable... parameters)
static de.xima.cmn.db.model.SerializableResultSet	executeDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, boolean suppressStatementLimits, boolean publicOnly, Serializable... parameters)
static de.xima.cmn.db.model.SerializableResultSet	executeDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, boolean suppressStatementLimits, IReplacerParams placeholderParams, Serializable... parameters)
static de.xima.cmn.db.model.SerializableResultSet	executeDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, boolean suppressStatementLimits, Serializable... parameters)
static de.xima.cmn.db.model.SerializableResultSet	executeDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, Serializable... parameters)	Deprecated. use executeDBquery(IEntityContext, Mandant, String, boolean, Serializable...).
static de.xima.cmn.db.model.SerializableResultSet	executePublicDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, boolean suppressStatementLimits, IReplacerParams replacerParams, Serializable... parameters)
static de.xima.cmn.db.model.SerializableResultSet	executePublicDBquery(IEntityContext ec, Mandant mandant, String datenquellenName, boolean suppressStatementLimits, Serializable... parameters)
static Integer	executeSql(IEntityContext ec, Long dbZugriffId, String sql)
static PreparedStatement	prepareStatement(Connection con, String sql, IReplacerParams replacerParameters, Serializable... args)
static de.xima.cmn.db.model.SerializableResultSet	query(IEntityContext ec, Integer dbZugriffId, String sql, boolean suppressStatementLimits, IReplacerParams params, Serializable... args)
static de.xima.cmn.db.model.SerializableResultSet	query(IEntityContext ec, Integer dbZugriffId, String sql, boolean suppressStatementLimits, Serializable... args)
static de.xima.cmn.db.model.SerializableResultSet	query(IEntityContext ec, Integer dbZugriffId, String sql, Serializable... args)	Deprecated. use query(IEntityContext, Integer, String, boolean, Serializable...).
static de.xima.cmn.db.model.SerializableResultSet	query(Connection con, String sql, boolean suppressStatementLimits, Serializable... args)
static de.xima.cmn.db.model.SerializableResultSet	query(Connection con, String sql, IReplacerParams params, boolean suppressStatementLimits, Serializable... args)
static int	update(IEntityContext ec, Integer dbZugriffId, String sql, Serializable... args)

Methods inherited from class java.lang.Object

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

Constructor Detail

DBQueryManager

public DBQueryManager()

Method Detail

update

public static int update(IEntityContext ec,
                         Integer dbZugriffId,
                         String sql,
                         Serializable... args)
                  throws PropertyVetoException

Parameters:

ec - the IEntityContext

dbZugriffId - Integer the id of the database-connection

sql - String the sql

args - Serializable parameters

Returns:

Integer the number of updated rows

Throws:

PropertyVetoException - on errors in the database-connection properties

query

@Deprecated
public static de.xima.cmn.db.model.SerializableResultSet query(IEntityContext ec,
                                                               Integer dbZugriffId,
                                                               String sql,
                                                               Serializable... args)
                                                        throws PropertyVetoException

Deprecated.

use query(IEntityContext, Integer, String, boolean, Serializable...). Suppression of statement-limits disabled!

Throws:

PropertyVetoException

query

public static de.xima.cmn.db.model.SerializableResultSet query(IEntityContext ec,
                                                               Integer dbZugriffId,
                                                               String sql,
                                                               boolean suppressStatementLimits,
                                                               Serializable... args)
                                                        throws PropertyVetoException

Throws:

PropertyVetoException

query

public static de.xima.cmn.db.model.SerializableResultSet query(IEntityContext ec,
                                                               Integer dbZugriffId,
                                                               String sql,
                                                               boolean suppressStatementLimits,
                                                               IReplacerParams params,
                                                               Serializable... args)
                                                        throws PropertyVetoException

Parameters:

ec - IEntityContext

dbZugriffId - Integer the id of the database-connection

sql - String the sql

suppressStatementLimits - Boolean if the statement limit should be suppressed

args - Serializable parameters

Returns:

an SerializableResultSet

Throws:

PropertyVetoException - on errors in the database-connection properties

query

public static de.xima.cmn.db.model.SerializableResultSet query(Connection con,
                                                               String sql,
                                                               boolean suppressStatementLimits,
                                                               Serializable... args)
                                                        throws SQLException

Throws:

SQLException

query

public static de.xima.cmn.db.model.SerializableResultSet query(Connection con,
                                                               String sql,
                                                               IReplacerParams params,
                                                               boolean suppressStatementLimits,
                                                               Serializable... args)
                                                        throws SQLException

Parameters:

con - Connection to use for the query.

sql - SQL statement to execute. May contain parameters.

params - placeholderParameters

suppressStatementLimits - Boolean if the statement limit should be suppressed

args - Additional arguments for the prepared statement.

Returns:

The result of the SQL query, or null when the database returned no result.

Throws:

SQLException - When the query could not be executed.

executeSql

public static Integer executeSql(IEntityContext ec,
                                 Long dbZugriffId,
                                 String sql)
                          throws PropertyVetoException

Parameters:

ec - the IEntityContext

dbZugriffId - Long the id of the database-connection

sql - String the sql

Returns:

an count of executed statements

Throws:

PropertyVetoException - on errors in the database-connection properties

executeDBquery

@Deprecated
public static de.xima.cmn.db.model.SerializableResultSet executeDBquery(IEntityContext ec,
                                                                        Mandant mandant,
                                                                        String datenquellenName,
                                                                        Serializable... parameters)
                                                                 throws PropertyVetoException,
                                                                        IllegalArgumentException

Deprecated.

use executeDBquery(IEntityContext, Mandant, String, boolean, Serializable...). Suppression of statement-limits disabled!

Throws:

PropertyVetoException

IllegalArgumentException

executeDBquery

public static de.xima.cmn.db.model.SerializableResultSet executeDBquery(IEntityContext ec,
                                                                        Mandant mandant,
                                                                        String datenquellenName,
                                                                        boolean suppressStatementLimits,
                                                                        Serializable... parameters)
                                                                 throws PropertyVetoException,
                                                                        IllegalArgumentException

Parameters:

ec - the IEntityContext

mandant - the ManagedBeanCreationException

datenquellenName - String the name of the datasource

suppressStatementLimits - Boolean if the statement limi should be supressed

parameters - Serializable parameters

Returns:

an SerializableResultSet

Throws:

PropertyVetoException - if the properties of the connection are not corret

IllegalArgumentException - if the parameter count doesn´t match

executeDBquery

public static de.xima.cmn.db.model.SerializableResultSet executeDBquery(IEntityContext ec,
                                                                        Mandant mandant,
                                                                        String datenquellenName,
                                                                        boolean suppressStatementLimits,
                                                                        IReplacerParams placeholderParams,
                                                                        Serializable... parameters)
                                                                 throws PropertyVetoException,
                                                                        IllegalArgumentException

Throws:

PropertyVetoException

IllegalArgumentException

executePublicDBquery

public static de.xima.cmn.db.model.SerializableResultSet executePublicDBquery(IEntityContext ec,
                                                                              Mandant mandant,
                                                                              String datenquellenName,
                                                                              boolean suppressStatementLimits,
                                                                              Serializable... parameters)
                                                                       throws PropertyVetoException,
                                                                              IllegalArgumentException

Throws:

PropertyVetoException

IllegalArgumentException

executePublicDBquery

public static de.xima.cmn.db.model.SerializableResultSet executePublicDBquery(IEntityContext ec,
                                                                              Mandant mandant,
                                                                              String datenquellenName,
                                                                              boolean suppressStatementLimits,
                                                                              IReplacerParams replacerParams,
                                                                              Serializable... parameters)
                                                                       throws PropertyVetoException,
                                                                              IllegalArgumentException

Throws:

PropertyVetoException

IllegalArgumentException

executeDBquery

public static de.xima.cmn.db.model.SerializableResultSet executeDBquery(IEntityContext ec,
                                                                        Mandant mandant,
                                                                        String datenquellenName,
                                                                        boolean suppressStatementLimits,
                                                                        boolean publicOnly,
                                                                        Serializable... parameters)
                                                                 throws PropertyVetoException,
                                                                        IllegalArgumentException

Throws:

PropertyVetoException

IllegalArgumentException

executeDBquery

public static de.xima.cmn.db.model.SerializableResultSet executeDBquery(IEntityContext ec,
                                                                        Mandant mandant,
                                                                        String datenquellenName,
                                                                        boolean suppressStatementLimits,
                                                                        boolean publicOnly,
                                                                        IReplacerParams placeholderParams,
                                                                        Serializable... parameters)
                                                                 throws PropertyVetoException,
                                                                        IllegalArgumentException

Throws:

PropertyVetoException

IllegalArgumentException

prepareStatement

public static PreparedStatement prepareStatement(Connection con,
                                                 String sql,
                                                 IReplacerParams replacerParameters,
                                                 Serializable... args)
                                          throws SQLException

Throws:

SQLException