Example usage for org.apache.ibatis.mapping StatementType CALLABLE

List of usage examples for org.apache.ibatis.mapping StatementType CALLABLE

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.mapping.*
  5. StatementType
  6. CALLABLE

Introduction

In this page you can find the example usage for org.apache.ibatis.mapping StatementType CALLABLE.

Prototype

StatementType CALLABLE

To view the source code for org.apache.ibatis.mapping StatementType CALLABLE.

Click Source Link

Usage

From source file:com.cvent.rfp.mapper.LuMapper.java

/**
 * Validate lookup id//from www. ja v a  2 s .c o m
 *
 * @param luTableName
 * @param idColumnName
 * @param luId
 * @return
 * @throws java.lang.Exception
 */
@Select(VALIDATE_LOOKUP_ID)
@Options(statementType = StatementType.CALLABLE)
int validateLookUpId(@Param("tableName") String luTableName, @Param("idColumnName") String idColumnName,
        @Param("luId") int luId) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Get rfp info by rfp stub from sql server
 *
 * @param rfpStub/*  w  w  w . ja  va 2 s.  c o m*/
 * @return
 * @throws java.lang.Exception
 */
@Select(GET_RFP_BY_RFP_STUB)
@Options(statementType = StatementType.CALLABLE)
@Results(value = { @Result(property = "accountId", column = "acct_id"),
        @Result(property = "rfpStub", column = "rfp_stub"),
        @Result(property = "rfpName", column = "rfp_name") })
Rfp getRfpByStub(@Param("rfpStub") String rfpStub) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Get rfp agenda item info by rfp stub from sql server
 *
 * @param rfpStub//from w  ww. j av  a  2  s  .  co  m
 * @return
 * @throws java.lang.Exception
 */
@Select(GET_RFP_AGENDA_ITEM_LIST_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
@Results(value = { @Result(property = "id", column = "rfp_agenda_item_stub"),
        @Result(property = "name", column = "agenda_item_name"),
        @Result(property = "number", column = "agenda_item_number"),
        @Result(property = "typeId", column = "agenda_item_type_id"),
        @Result(property = "type", column = "agenda_item_type_name"),
        @Result(property = "setupId", column = "agenda_item_setup_id"),
        @Result(property = "setup", column = "agenda_item_setup_name"),
        @Result(property = "note", column = "agenda_addl_info"),
        @Result(property = "startTime", column = "start_time"),
        @Result(property = "endTime", column = "end_time"),
        @Result(property = "requiredRoomSize", column = "room_size"),
        @Result(property = "expectedNumberOfPeople", column = "attendee_count"),
        @Result(property = "isRoomInfoRequired", column = "room_info_required_flag"),
        @Result(property = "isTwentyFourHourHoldRequired", column = "twentyfour_hour_hold_flag"),
        @Result(property = "isLocatedAtPrimaryEventVenue", column = "located_at_host_venue_flag"),
        @Result(property = "days", column = "{accountId = rfp_acct_id, rfpStub = rfp_stub, agendaItemStub = rfp_agenda_item_stub}", javaType = List.class, many = @Many(select = "getAgendaItemDaysByStub")) })
List<AgendaItem> getRfpAgendaItemListByStub(@Param("rfpStub") String rfpStub) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Get rfp agenda item info by rfp stub from sql server
 *
 * @param rfpStub//from   www.j av a2  s .  c o m
 * @param agendaItemStub
 * @return
 * @throws java.lang.Exception
 */
@Select(GET_RFP_AGENDA_ITEM_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
@Results(value = { @Result(property = "id", column = "rfp_agenda_item_stub"),
        @Result(property = "name", column = "agenda_item_name"),
        @Result(property = "number", column = "agenda_item_number"),
        @Result(property = "typeId", column = "agenda_item_type_id"),
        @Result(property = "type", column = "agenda_item_type_name"),
        @Result(property = "setupId", column = "agenda_item_setup_id"),
        @Result(property = "setup", column = "agenda_item_setup_name"),
        @Result(property = "note", column = "agenda_addl_info"),
        @Result(property = "startTime", column = "start_time"),
        @Result(property = "endTime", column = "end_time"),
        @Result(property = "requiredRoomSize", column = "room_size"),
        @Result(property = "expectedNumberOfPeople", column = "attendee_count"),
        @Result(property = "isRoomInfoRequired", column = "room_info_required_flag"),
        @Result(property = "isTwentyFourHourHoldRequired", column = "twentyfour_hour_hold_flag"),
        @Result(property = "isLocatedAtPrimaryEventVenue", column = "located_at_host_venue_flag"),
        @Result(property = "days", column = "{accountId = rfp_acct_id, rfpStub = rfp_stub, agendaItemStub = rfp_agenda_item_stub}", javaType = List.class, many = @Many(select = "getAgendaItemDaysByStub")) })
AgendaItem getRfpAgendaItemByStub(@Param("rfpStub") String rfpStub,
        @Param("agendaItemStub") String agendaItemStub) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Get sleep room block info by rfp stub from sql server
 *
 * @param rfpStub//from w  w  w  .  java 2  s  .c  o m
 * @param agendaItemStub
 * @return
 * @throws java.lang.Exception
 */
@Select(GET_AGENDA_ITEM_DETAIL_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
@Results(value = { @Result(property = "dayNumber", column = "day_number"),
        @Result(property = "date", column = "date")
        //@Result(property = "date", column = "date", jdbcType = JdbcType.DATE, javaType = Date.class)
})
List<Days> getAgendaItemDaysByStub(@Param("rfpStub") String rfpStub,
        @Param("agendaItemStub") String agendaItemStub) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Delete agenda item by rfp stub and agenda item stub from sql server
 *
 * @param rfpStub//  www .  j a  va  2  s .co  m
 * @param agendaItemStub
 * @return
 * @throws java.lang.Exception
 */
@Delete(DELETE_AGENDA_ITEM_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
int deleteAgendaItemByStub(@Param("rfpStub") String rfpStub, @Param("agendaItemStub") String agendaItemStub)
        throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Delete agenda item by rfp stub and agenda item stub from sql server
 *
 * @param rfpStub//from ww  w .j ava 2  s. c o m
 * @param agendaItemStub
 * @return
 * @throws java.lang.Exception
 */
@Delete(DELETE_AGENDA_ITEM_DETAIL_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
int deleteAgendaItemDetailByStub(@Param("rfpStub") String rfpStub,
        @Param("agendaItemStub") String agendaItemStub) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Create agenda item in database//from  ww  w  .  j av a2 s  . c  om
 *
 * @param accountId
 * @param rfpStub
 * @param agendaItemStub
 * @param agendaItemName
 * @param agendaItemTypeId
 * @param agendaItemSetupId
 * @param agendaAddlNote
 * @param startTime
 * @param endTime
 * @param roomSize
 * @param attendeeCount
 * @param infoRequiredFlag
 * @param twentyFourHrHoldFlag
 * @param hostVenueFlag
 * @param agendaItemNumber
 * @return
 * @throws java.lang.Exception
 */
@Insert(INSERT_AGENDA_ITEM_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
int createAgendaItem(@Param("accountId") long accountId, @Param("rfpStub") String rfpStub,
        @Param("agendaItemStub") String agendaItemStub, @Param("agendaItemName") String agendaItemName,
        @Param("agendaItemTypeId") int agendaItemTypeId, @Param("agendaItemSetupId") int agendaItemSetupId,
        @Param("agendaAddlNote") String agendaAddlNote, @Param("startTime") Date startTime,
        @Param("endTime") Date endTime, @Param("roomSize") int roomSize,
        @Param("attendeeCount") int attendeeCount, @Param("infoRequiredFlag") int infoRequiredFlag,
        @Param("twentyFourHrHoldFlag") int twentyFourHrHoldFlag, @Param("hostVenueFlag") int hostVenueFlag,
        @Param("agendaItemNumber") int agendaItemNumber) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Create agenda item detail in database
 *
 * @param accountId//from w  ww. j av a  2 s. c om
 * @param rfpStub
 * @param agendaItemStub
 * @param dayNumber
 * @return
 * @throws java.lang.Exception
 */
@Insert(INSERT_AGENDA_ITEM_DETAIL_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
int createAgendaItemDetail(@Param("accountId") long accountId, @Param("rfpStub") String rfpStub,
        @Param("agendaItemStub") String agendaItemStub, @Param("dayNumber") int dayNumber) throws Exception;

From source file:com.cvent.rfp.mapper.RfpMapper.java

/**
 * Update agenda item by rfp stub and agenda item stub from sql server
 *
 * @param accountId/*  w ww. j  a va2 s  .co m*/
 * @param rfpStub
 * @param agendaItemStub
 * @param agendaItemName
 * @param agendaItemTypeId
 * @param agendaItemSetupId
 * @param agendaAddlNote
 * @param startTime
 * @param endTime
 * @param roomSize
 * @param attendeeCount
 * @param infoRequiredFlag
 * @param twentyFourHrHoldFlag
 * @param hostVenueFlag
 * @return
 * @throws java.lang.Exception
 */
@Delete(UPDATE_AGENDA_ITEM_BY_STUB)
@Options(statementType = StatementType.CALLABLE)
int updateAgendaItemByStub(@Param("accountId") long accountId, @Param("rfpStub") String rfpStub,
        @Param("agendaItemStub") String agendaItemStub, @Param("agendaItemName") String agendaItemName,
        @Param("agendaItemTypeId") int agendaItemTypeId, @Param("agendaItemSetupId") int agendaItemSetupId,
        @Param("agendaAddlNote") String agendaAddlNote, @Param("startTime") Date startTime,
        @Param("endTime") Date endTime, @Param("roomSize") int roomSize,
        @Param("attendeeCount") int attendeeCount, @Param("infoRequiredFlag") int infoRequiredFlag,
        @Param("twentyFourHrHoldFlag") int twentyFourHrHoldFlag, @Param("hostVenueFlag") int hostVenueFlag)
        throws Exception;