public class VacancyDAO extends CommonDAO
CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>
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 |
---|
VacancyDAO(java.sql.Connection con) |
Modifier and Type | Method and Description |
---|---|
void |
deleteVacancy(int id) |
java.util.Set<java.lang.Integer> |
findVacancyGroups() |
Vacancy |
getVacancy(int id) |
void |
searchVacancy(SearchResult<Vacancy> searchResult,
java.lang.String filter,
int group_filter) |
void |
updateVacancy(Vacancy vacancy) |
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, updateIds
public Vacancy getVacancy(int id) throws BGException
BGException
public java.util.Set<java.lang.Integer> findVacancyGroups() throws BGException
BGException
public void searchVacancy(SearchResult<Vacancy> searchResult, java.lang.String filter, int group_filter) throws BGException
BGException
public void updateVacancy(Vacancy vacancy) throws BGException, java.sql.SQLException
BGException
java.sql.SQLException
public void deleteVacancy(int id) throws BGException
BGException