|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.openmobileis.common.util.database.AbstractQueryManager
Title: OpenMobileIS project source
Description: This class is ths super class of the queries It allows to execute queries through the db manager. A query is built with : A pattern : SQL query
with variables Parameters : Values of the variables defined in the pattern For instance, the query "SELECT * FROM TABLE WHERE ROW1 = val1 AND ROW2 = val2
will have the following pattern : "SELECT * FROM TABLE WHERE ROW1 = %0% AND ROW2 = %1% and the following parameters : {"val1", "val2"}. Note that the name of
the variables are a sequential number starting by 0 and inserted between two separators : % The Manager variable contains dbManager instance which provides
services to be connected / disconnected to the database as well as a service to get a connection from the pool connection object.
Constructor Summary | |
AbstractQueryManager()
|
Method Summary | |
protected java.lang.String |
buildDynamicQuery(java.lang.String pattern,
java.util.Hashtable variables)
|
protected java.lang.String |
buildQuery(java.lang.String queryPattern,
java.lang.String[] parameters)
buildQuery() get the query pattern stored in queries and insert the parameters. |
void |
close()
close() allows to close the database |
protected void |
executeBlobUpdate(java.lang.String queryPattern,
java.lang.String[] parameters,
byte[][] blobs)
execute insert or update query with Blob data. |
protected java.sql.ResultSet |
executeDynamicQuery(java.lang.String queryPattern,
java.util.Hashtable variables)
executeQuery() allows to execute a query such as "SELECT * FROM TABLE") use SQL syntax to perform queries Connection is not close to keep the resulting resultset. |
protected void |
executeDynamicUpdate(java.lang.String queryPattern,
java.util.Hashtable variables)
executeUpdateQuery() allows to execute a query with INSERT, UPDATE or DELETE statements use SQL syntax to perform queries Connection is not close to keep the resulting resultset. |
protected java.sql.ResultSet |
executeQuery(java.lang.String queryPattern,
java.lang.String[] parameters)
executeQuery() allows to execute a query such as "SELECT * FROM TABLE") use SQL syntax to perform queries Connection is not close to keep the resulting resultset. |
protected void |
executeUpdate(java.lang.String queryPattern,
java.lang.String[] parameters)
executeUpdateQuery() allows to execute a query with INSERT, UPDATE or DELETE statements use SQL syntax to perform queries Close and garbage the connection and pending result. |
ManagerDB |
getDbManager()
Returns the dbManager. |
protected java.lang.String |
makeSQLList(java.lang.String[] items)
|
void |
registerManagerDB(ManagerDB manager)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public AbstractQueryManager()
Method Detail |
public void registerManagerDB(ManagerDB manager)
public void close()
None
protected void executeBlobUpdate(java.lang.String queryPattern, java.lang.String[] parameters, byte[][] blobs) throws DatabaseException
DatabaseException
protected java.sql.ResultSet executeQuery(java.lang.String queryPattern, java.lang.String[] parameters) throws DatabaseException
java.sql.SQLException
DatabaseException
protected java.sql.ResultSet executeDynamicQuery(java.lang.String queryPattern, java.util.Hashtable variables) throws DatabaseException
java.sql.SQLException
DatabaseException
protected void executeUpdate(java.lang.String queryPattern, java.lang.String[] parameters) throws DatabaseException
java.sql.SQLException
DatabaseException
protected void executeDynamicUpdate(java.lang.String queryPattern, java.util.Hashtable variables) throws DatabaseException
java.sql.SQLException
DatabaseException
protected java.lang.String buildDynamicQuery(java.lang.String pattern, java.util.Hashtable variables)
protected java.lang.String buildQuery(java.lang.String queryPattern, java.lang.String[] parameters) throws DatabaseException
java.lang.Exception
DatabaseException
protected java.lang.String makeSQLList(java.lang.String[] items)
public ManagerDB getDbManager()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |