public class ConfigDAO extends CommonDAO
CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>| Modifier and Type | Field and Description |
|---|---|
static java.lang.String |
TABLE_CONFIG |
static java.lang.String |
TABLE_CONFIG_GLOBAL |
con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE| Constructor and Description |
|---|
ConfigDAO(java.sql.Connection con) |
ConfigDAO(java.sql.Connection con,
java.lang.String tableName) |
| Modifier and Type | Method and Description |
|---|---|
void |
deleteGlobalConfig(int id) |
Config |
getActiveGlobalConfig() |
java.util.List<ConfigRecord> |
getConfigRecordList(java.lang.String tableId,
int recordId) |
java.util.Map<java.lang.String,java.lang.String> |
getConfigRecordMap(java.lang.String tableId,
int recordId) |
Config |
getGlobalConfig(int id) |
void |
searchGlobalConfigList(SearchResult<Config> searchResult,
java.util.Set<java.lang.Integer> allowedConfigIds,
int configId,
java.lang.String filterLike) |
void |
setActiveGlobalConfig(int id) |
void |
updateConfigForRecord(java.lang.String tableId,
int recordId,
java.util.List<ConfigRecord> config) |
void |
updateConfigForRecord(java.lang.String tableId,
int recordId,
java.util.Map<java.lang.String,java.lang.String> config) |
void |
updateGlobalConfig(Config config) |
deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIdspublic static final java.lang.String TABLE_CONFIG
public static final java.lang.String TABLE_CONFIG_GLOBAL
public ConfigDAO(java.sql.Connection con)
public ConfigDAO(java.sql.Connection con,
java.lang.String tableName)
public void searchGlobalConfigList(SearchResult<Config> searchResult, java.util.Set<java.lang.Integer> allowedConfigIds, int configId, java.lang.String filterLike) throws java.sql.SQLException
java.sql.SQLExceptionpublic Config getGlobalConfig(int id) throws java.sql.SQLException
java.sql.SQLExceptionpublic Config getActiveGlobalConfig() throws java.sql.SQLException
java.sql.SQLExceptionpublic void setActiveGlobalConfig(int id)
throws java.sql.SQLException
java.sql.SQLExceptionpublic void updateGlobalConfig(Config config) throws java.sql.SQLException
java.sql.SQLExceptionpublic void deleteGlobalConfig(int id)
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.util.List<ConfigRecord> getConfigRecordList(java.lang.String tableId, int recordId) throws java.sql.SQLException
java.sql.SQLExceptionpublic java.util.Map<java.lang.String,java.lang.String> getConfigRecordMap(java.lang.String tableId,
int recordId)
throws java.sql.SQLException
java.sql.SQLExceptionpublic void updateConfigForRecord(java.lang.String tableId,
int recordId,
java.util.Map<java.lang.String,java.lang.String> config)
throws java.sql.SQLException
java.sql.SQLExceptionpublic void updateConfigForRecord(java.lang.String tableId,
int recordId,
java.util.List<ConfigRecord> config)
throws java.sql.SQLException
java.sql.SQLException