Inheritance diagram for org.openmobileis.modules.crm.database.common.jdbc.JDBCGlobalPropertyQueryManager:
Definition at line 27 of file JDBCGlobalPropertyQueryManager.java.
Public Member Functions | |
JDBCGlobalPropertyQueryManager () | |
void | createSyncTable () throws ServiceException, java.sql.SQLException |
void | create (String parameters[]) throws ServiceException |
void | delete (String parameters[]) throws ServiceException |
void | update (String parameters[]) throws ServiceException |
ResultSet | getGlobalProperty (String[] param) throws SQLException |
ResultSet | getPropertiesForService (String[] param) throws SQLException |
ResultSet | getAllGlobalProperties () throws SQLException |
GlobalProperty | convertResultSetToProperty (ResultSet result) throws DatabaseException |
String[] | getInsertParamFromProperty (GlobalProperty property) |
String[] | getUpdateParamFromProperty (GlobalProperty property) |
Static Protected Attributes | |
static String | queryGetGlobalProperty = "SELECT idservice, propkey, propvalue FROM oooglobalproperties where idservice='%0%' AND propkey='%1%'" |
static String | queryGetPropertiesForService = "SELECT idservice, propkey, propvalue FROM oooglobalproperties where idservice='%0%'" |
static String | queryGetAllGlobalProperties = "SELECT idservice, propkey, propvalue FROM oooglobalproperties" |
static String | queryInsertGlobalProperty |
static String | queryUpdateGlobalProperty |
static String | queryDeleteGlobalProperty = "DELETE FROM oooglobalproperties where idservice='%0%' AND propkey='%1%'" |