public class AnalyticDAO extends AddressDAO
CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>| Modifier and Type | Field and Description |
|---|---|
static java.lang.String |
TABLE_ANALYTIC_HOUSE_CAPACITY |
LOAD_LEVEL_CITY, LOAD_LEVEL_COUNTRY, LOAD_LEVEL_HOUSE, LOAD_LEVEL_STREET, PARAM_SUBJECTcon, 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 |
|---|
AnalyticDAO(java.sql.Connection con) |
| Modifier and Type | Method and Description |
|---|---|
void |
deleteHouseCapacityItem(int houseId) |
java.util.List<HouseCapacityItem> |
getHouseCapacityItemList(int houseId) |
void |
updateHouseCapacityItem(HouseCapacityItem houseCapacityItem) |
addHouseSelectQueryJoins, checkItem, deleteAddressArea, deleteAddressCity, deleteAddressCountry, deleteAddressHouse, deleteAddressQuarter, deleteAddressStreet, getAddressAgglomerationFromRs, getAddressArea, getAddressCity, getAddressCityAgglomeration, getAddressCityFromRs, getAddressCountry, getAddressCountryFromRs, getAddressHouse, getAddressHouseFromRs, getAddressItemFromRs, getAddressQuarter, getAddressStreet, getAddressStreetsBySubstring, getAddressSubjectAreaFromRs, getAddressSubjectFromRs, getAgglomerationByCity, getAgglomerationByHouseId, getCitiesByAgglomeration, getCitiesList, getCitiesMap, getCityIdByAddress, getCityIdsByAgglomerationId, getCityTitle, getCountryIdByCityId, getHouseIdsByStreetAndHouse, getHouseListByTerm, getQuartersInCitiesMap, getQuartersList, getSegmentsInCitiesMap, getSegmentsList, getUpdatedAreas, getUpdatedCities, getUpdatedCountries, getUpdatedHouses, getUpdatedQuarters, getUpdatedStreets, searchAddressAgglomerationList, searchAddressAreaList, searchAddressAreaList, searchAddressCityList, searchAddressCountryList, searchAddressHouseList, searchAddressHouseList, searchAddressHouseList, searchAddressQuarterList, searchAddressQuarterList, searchAddressQuarterList, searchAddressStreetList, searchAddressStreetList, searchAddressStreetList, searchFullAddressList, updateAddressArea, updateAddressCity, updateAddressCityAgglomeration, updateAddressCountry, updateAddressHouse, updateAddressQuarter, updateAddressStreet, updateLastUpdateColumndeleteById, 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_ANALYTIC_HOUSE_CAPACITY
public java.util.List<HouseCapacityItem> getHouseCapacityItemList(int houseId) throws java.sql.SQLException
java.sql.SQLExceptionpublic void updateHouseCapacityItem(HouseCapacityItem houseCapacityItem) throws java.sql.SQLException
java.sql.SQLExceptionpublic void deleteHouseCapacityItem(int houseId)
throws java.sql.SQLException
java.sql.SQLException