|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectit.eng.spago.util.QueryExecutor
it.eng.spagobi.commons.services.DelegatedQueryExecutor
public class DelegatedQueryExecutor
Field Summary | |
---|---|
static java.lang.String |
CREATE
|
static java.lang.String |
DELETE
|
static java.lang.String |
READ
|
static java.lang.String |
UPDATE
|
Constructor Summary | |
---|---|
DelegatedQueryExecutor()
|
Method Summary | |
---|---|
static it.eng.spago.dbaccess.sql.SQLCommand |
createStatementSql(it.eng.spago.dbaccess.sql.DataConnection dataConnection,
java.lang.String statement,
java.lang.String type)
Creates the command to execute dependent on request type. |
static java.lang.Object |
executeQuery(it.eng.spago.dbaccess.sql.DataConnection dataConnection,
java.lang.String type,
it.eng.spago.base.SourceBean query,
java.util.ArrayList parameters)
Execs statement SQL with explicit parameters. |
protected static java.lang.Object |
executeQuery(it.eng.spago.dbaccess.sql.DataConnection dataConnection,
java.lang.String statement,
java.lang.String type,
java.util.ArrayList inputParameters)
|
static java.lang.Object |
executeQuery(it.eng.spago.base.RequestContainer requestContainer,
it.eng.spago.base.ResponseContainer responseContainer,
it.eng.spago.dbaccess.sql.DataConnection dataConnection,
it.eng.spago.base.SourceBean query,
java.lang.String type)
Execs the commands: SQL SELECT, INSERT, DELETE, UPDATE. |
static java.lang.Object |
executeQuery(it.eng.spago.base.RequestContainer requestContainer,
it.eng.spago.base.ResponseContainer responseContainer,
java.lang.String pool,
it.eng.spago.base.SourceBean query,
java.lang.String type)
Execs the commands: SQL SELECT, INSERT, DELETE, UPDATE. |
protected static boolean |
handleFilterParameter(it.eng.spago.base.RequestContainer requestContainer,
it.eng.spago.base.ResponseContainer responseContainer,
it.eng.spago.base.SourceBean parameter,
java.util.ArrayList inputParameters,
it.eng.spago.dbaccess.sql.DataConnection dataConnection,
java.lang.StringBuffer statement,
java.lang.String condizioneSql)
Treatment of Filter's parameters |
protected static void |
handleOrderByParameter(it.eng.spago.base.RequestContainer requestContainer,
it.eng.spago.base.ResponseContainer responseContainer,
it.eng.spago.base.SourceBean parameter,
java.lang.StringBuffer statement,
java.lang.String condizioneSql)
Management of option ORDER_BY |
protected static boolean |
handleParameter(it.eng.spago.base.RequestContainer requestContainer,
it.eng.spago.base.ResponseContainer responseContainer,
it.eng.spago.base.SourceBean parameter,
java.util.ArrayList inputParameters,
it.eng.spago.dbaccess.sql.DataConnection dataConnection)
Treatment of standard parameters |
protected static boolean |
handleParameter(it.eng.spago.base.RequestContainer requestContainer,
it.eng.spago.base.ResponseContainer responseContainer,
it.eng.spago.base.SourceBean parameter,
java.util.ArrayList inputParameters,
it.eng.spago.dbaccess.sql.DataConnection dataConnection,
boolean isFilterParameter,
java.lang.StringBuffer statement,
java.lang.String condizioneSql)
General management for normal and filter parameters |
static it.eng.spago.dbaccess.sql.DataConnection |
openConnection(java.lang.String pool)
Opens the pool connection. |
Methods inherited from class it.eng.spago.util.QueryExecutor |
---|
handleOrderByParameter |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String CREATE
public static final java.lang.String READ
public static final java.lang.String UPDATE
public static final java.lang.String DELETE
Constructor Detail |
---|
public DelegatedQueryExecutor()
Method Detail |
---|
public static it.eng.spago.dbaccess.sql.SQLCommand createStatementSql(it.eng.spago.dbaccess.sql.DataConnection dataConnection, java.lang.String statement, java.lang.String type)
dataConnection
- the data connectiontype
- type of query to execute: CREATE, READ, UPDATE, DELETEstatement
- the statement
public static it.eng.spago.dbaccess.sql.DataConnection openConnection(java.lang.String pool) throws it.eng.spago.error.EMFInternalError
pool
- the pool
it.eng.spago.error.EMFInternalError
- the EMF internal errorpublic static java.lang.Object executeQuery(it.eng.spago.base.RequestContainer requestContainer, it.eng.spago.base.ResponseContainer responseContainer, java.lang.String pool, it.eng.spago.base.SourceBean query, java.lang.String type)
requestContainer
- the request containerresponseContainer
- the response containerpool
- pool's namequery
- the SourceBean that contains the configuration of the querytype
- type of query: CREATE, READ, UPDATE, DELETE
public static java.lang.Object executeQuery(it.eng.spago.base.RequestContainer requestContainer, it.eng.spago.base.ResponseContainer responseContainer, it.eng.spago.dbaccess.sql.DataConnection dataConnection, it.eng.spago.base.SourceBean query, java.lang.String type)
requestContainer
- the request containerresponseContainer
- the response containerdataConnection
- connection on dbquery
- the SourceBean that contains the configurationtype
- type of query: CREATE, READ, UPDATE, DELETE
public static java.lang.Object executeQuery(it.eng.spago.dbaccess.sql.DataConnection dataConnection, java.lang.String type, it.eng.spago.base.SourceBean query, java.util.ArrayList parameters) throws java.lang.Exception
dataConnection
- connection on database:type
- type of query: CREATE, READ, UPDATE, DELETEquery
- the SourceBean that contains the configuration of the queryparameters
- The parameters to add into statement
java.lang.Exception
- the exceptionprotected static java.lang.Object executeQuery(it.eng.spago.dbaccess.sql.DataConnection dataConnection, java.lang.String statement, java.lang.String type, java.util.ArrayList inputParameters) throws java.lang.Exception
java.lang.Exception
protected static boolean handleParameter(it.eng.spago.base.RequestContainer requestContainer, it.eng.spago.base.ResponseContainer responseContainer, it.eng.spago.base.SourceBean parameter, java.util.ArrayList inputParameters, it.eng.spago.dbaccess.sql.DataConnection dataConnection)
requestContainer
- responseContainer
- parameter
- inputParameters
- dataConnection
-
protected static boolean handleFilterParameter(it.eng.spago.base.RequestContainer requestContainer, it.eng.spago.base.ResponseContainer responseContainer, it.eng.spago.base.SourceBean parameter, java.util.ArrayList inputParameters, it.eng.spago.dbaccess.sql.DataConnection dataConnection, java.lang.StringBuffer statement, java.lang.String condizioneSql)
requestContainer
- responseContainer
- parameter
- inputParameters
- dataConnection
- statement
- condizioneSql
-
protected static boolean handleParameter(it.eng.spago.base.RequestContainer requestContainer, it.eng.spago.base.ResponseContainer responseContainer, it.eng.spago.base.SourceBean parameter, java.util.ArrayList inputParameters, it.eng.spago.dbaccess.sql.DataConnection dataConnection, boolean isFilterParameter, java.lang.StringBuffer statement, java.lang.String condizioneSql)
requestContainer
- responseContainer
- parameter
- inputParameters
- dataConnection
- isFilterParameter
- statement
- condizioneSql
-
protected static void handleOrderByParameter(it.eng.spago.base.RequestContainer requestContainer, it.eng.spago.base.ResponseContainer responseContainer, it.eng.spago.base.SourceBean parameter, java.lang.StringBuffer statement, java.lang.String condizioneSql)
parameter
- statement
- condizioneSql
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |