|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectit.eng.spago.util.QueryExecutor
DATE CONTRIBUTOR/DEVELOPER NOTE 13-12-2004 Butano - SourceBean ora restituisce ArrayList 13-12-2005 Boccalon/Grassi - Added utility methods to execute queries giving the DataConnection instead of the connection pool, or giving the parameter list instead of the automatic parameters retrieval
Field Summary | |
static java.lang.String |
CREATE
|
static java.lang.String |
DELETE
|
static java.lang.String |
READ
|
static java.lang.String |
UPDATE
|
Constructor Summary | |
QueryExecutor()
|
Method Summary | |
static SQLCommand |
createStatementSql(DataConnection dataConnection,
java.lang.String statement,
java.lang.String type)
Crea il comando da eseguire a seconda del tipo di richiesta |
static java.lang.Object |
executeQuery(DataConnection dataConnection,
java.lang.String type,
SourceBean query,
java.util.ArrayList parameters)
Esegue statement SQL con parametri passati esplicitamente nel metodo |
protected static java.lang.Object |
executeQuery(DataConnection dataConnection,
java.lang.String statement,
java.lang.String type,
java.util.ArrayList inputParameters)
|
static java.lang.Object |
executeQuery(RequestContainer requestContainer,
ResponseContainer responseContainer,
DataConnection dataConnection,
SourceBean query,
java.lang.String type)
Esegue i comandi SQL SELECT, INSERT, DELETE, UPDATE. |
static java.lang.Object |
executeQuery(RequestContainer requestContainer,
ResponseContainer responseContainer,
java.lang.String pool,
SourceBean query,
java.lang.String type)
Esegue i comandi SQL SELECT, INSERT, DELETE, UPDATE. |
protected static boolean |
handleFilterParameter(RequestContainer requestContainer,
ResponseContainer responseContainer,
SourceBean parameter,
java.util.ArrayList inputParameters,
DataConnection dataConnection,
java.lang.StringBuffer statement,
java.lang.String condizioneSql)
Trattamento dei parametri di tipo FILTER |
protected static void |
handleOrderByParameter(SourceBean parameter,
java.lang.StringBuffer statement,
java.lang.String condizioneSql)
Gestione dell'opzione ORDER_BY |
protected static boolean |
handleParameter(RequestContainer requestContainer,
ResponseContainer responseContainer,
SourceBean parameter,
java.util.ArrayList inputParameters,
DataConnection dataConnection)
Trattamento dei parametri "standard" |
protected static boolean |
handleParameter(RequestContainer requestContainer,
ResponseContainer responseContainer,
SourceBean parameter,
java.util.ArrayList inputParameters,
DataConnection dataConnection,
boolean isFilterParameter,
java.lang.StringBuffer statement,
java.lang.String condizioneSql)
Gestione generalizzata per i parametri di tipo "normale" e FILTER |
static DataConnection |
openConnection(java.lang.String pool)
Apre la connessione attraverso il pool |
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 QueryExecutor()
Method Detail |
public static SQLCommand createStatementSql(DataConnection dataConnection, java.lang.String statement, java.lang.String type)
dataConnection
- type
- Il tipo di query da eseguire: CREATE, READ, UPDATE, DELETE
public static DataConnection openConnection(java.lang.String pool) throws EMFInternalError
pool
-
EMFInternalError
public static java.lang.Object executeQuery(RequestContainer requestContainer, ResponseContainer responseContainer, java.lang.String pool, SourceBean query, java.lang.String type)
requestContainer
- responseContainer
- pool
- Il nome del pool del databasequery
- Il SourceBean contenente la configurazione della query da eseguiretype
- Il tipo di query da eseguire: CREATE, READ, UPDATE, DELETE
public static java.lang.Object executeQuery(RequestContainer requestContainer, ResponseContainer responseContainer, DataConnection dataConnection, SourceBean query, java.lang.String type)
requestContainer
- responseContainer
- dataConnection
- La connessione verso il databasequery
- Il SourceBean contenente la configurazione della query da eseguiretype
- Il tipo di query da eseguire: CREATE, READ, UPDATE, DELETE
public static java.lang.Object executeQuery(DataConnection dataConnection, java.lang.String type, SourceBean query, java.util.ArrayList parameters) throws java.lang.Exception
dataConnection
- La connessione di database: non viene effettuata alcuna commit
o rollbacktype
- Il tipo di query da eseguire: CREATE, READ, UPDATE, DELETEquery
- Il SourceBean contenente la configurazione della query da eseguireparameters
- I parametri da integrare nello statement
java.lang.Exception
protected static java.lang.Object executeQuery(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(RequestContainer requestContainer, ResponseContainer responseContainer, SourceBean parameter, java.util.ArrayList inputParameters, DataConnection dataConnection)
requestContainer
- responseContainer
- parameter
- inputParameters
- dataConnection
-
protected static boolean handleFilterParameter(RequestContainer requestContainer, ResponseContainer responseContainer, SourceBean parameter, java.util.ArrayList inputParameters, DataConnection dataConnection, java.lang.StringBuffer statement, java.lang.String condizioneSql)
requestContainer
- responseContainer
- parameter
- inputParameters
- dataConnection
- statement
- condizioneSql
-
protected static boolean handleParameter(RequestContainer requestContainer, ResponseContainer responseContainer, SourceBean parameter, java.util.ArrayList inputParameters, DataConnection dataConnection, boolean isFilterParameter, java.lang.StringBuffer statement, java.lang.String condizioneSql)
requestContainer
- responseContainer
- parameter
- inputParameters
- dataConnection
- isFilterParameter
- statement
- condizioneSql
-
protected static void handleOrderByParameter(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 |