Package ru.bgcrm.dao.user

Class AppointmentDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.user.AppointmentDAO

public class AppointmentDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

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 Summary

Constructors

Constructor	Description
AppointmentDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteAppointment(int id)
Appointment	getAppointment(int id)
Appointment	getAppointmentByTitle(String title)
List<Appointment>	getAppointmentList()
void	searchAppointment(SearchResult<Appointment> searchResult)
void	searchAppointment(SearchResult<Appointment> searchResult, String filter)
void	updateAppointment(Appointment appointment)

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

AppointmentDAO

public AppointmentDAO(Connection con)

Method Details

deleteAppointment

public void deleteAppointment(int id)
                       throws BGException

Throws:

BGException

getAppointmentList

public List<Appointment> getAppointmentList()
                                     throws BGException

Throws:

BGException

searchAppointment

public void searchAppointment(SearchResult<Appointment> searchResult)
                       throws BGException

Throws:

BGException

searchAppointment

public void searchAppointment(SearchResult<Appointment> searchResult,
 String filter)
                       throws BGException

Throws:

BGException

getAppointment

public Appointment getAppointment(int id)
                           throws BGException

Throws:

BGException

getAppointmentByTitle

public Appointment getAppointmentByTitle(String title)
                                  throws BGException

Throws:

BGException

updateAppointment

public void updateAppointment(Appointment appointment)
                       throws BGException,
SQLException

Throws:

BGException

SQLException