public class ConfigDAO extends CommonDAO
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_LEFT_JOIN, SQL_LIMIT, 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) |
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) |
addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds
public 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) throws java.sql.SQLException
java.sql.SQLException
public Config getGlobalConfig(int id) throws java.sql.SQLException
java.sql.SQLException
public Config getActiveGlobalConfig() throws java.sql.SQLException
java.sql.SQLException
public void setActiveGlobalConfig(int id) throws java.sql.SQLException
java.sql.SQLException
public void updateGlobalConfig(Config config) throws java.sql.SQLException
java.sql.SQLException
public void deleteGlobalConfig(int id) throws java.sql.SQLException
java.sql.SQLException
public java.util.List<ConfigRecord> getConfigRecordList(java.lang.String tableId, int recordId) throws java.sql.SQLException
java.sql.SQLException
public java.util.Map<java.lang.String,java.lang.String> getConfigRecordMap(java.lang.String tableId, int recordId) throws java.sql.SQLException
java.sql.SQLException
public void updateConfigForRecord(java.lang.String tableId, int recordId, java.util.Map<java.lang.String,java.lang.String> config) throws java.sql.SQLException
java.sql.SQLException
public void updateConfigForRecord(java.lang.String tableId, int recordId, java.util.List<ConfigRecord> config) throws java.sql.SQLException
java.sql.SQLException