Example usage for org.apache.ibatis.type JdbcType SMALLINT

List of usage examples for org.apache.ibatis.type JdbcType SMALLINT

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.type.*
  5. JdbcType
  6. SMALLINT

Introduction

In this page you can find the example usage for org.apache.ibatis.type JdbcType SMALLINT.

Prototype

JdbcType SMALLINT

To view the source code for org.apache.ibatis.type JdbcType SMALLINT.

Click Source Link

Usage

From source file:com.hbc.api.trade.order.mapping.gen.OrderBeanMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table `trade_order`
 *
 * @mbggenerated/*ww w  .  j  a  va 2s  . co m*/
 */
@SelectProvider(type = OrderBeanSqlProvider.class, method = "selectByExampleWithBLOBs")
@Results({ @Result(column = "order_no", property = "orderNo", jdbcType = JdbcType.VARCHAR, id = true),
        @Result(column = "third_trade_no", property = "thirdTradeNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_status", property = "orderStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_status_name", property = "orderStatusName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_type", property = "orderType", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_goods_type", property = "orderGoodsType", jdbcType = JdbcType.INTEGER),
        @Result(column = "good_no", property = "goodNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_source", property = "orderSource", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_channel", property = "orderChannel", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_time", property = "serviceTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "service_end_time", property = "serviceEndTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "service_continent_id", property = "serviceContinentId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_continent_name", property = "serviceContinentName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_country_id", property = "serviceCountryId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_country_name", property = "serviceCountryName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_id", property = "serviceCityId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_city_spell", property = "serviceCitySpell", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_enname", property = "serviceCityEnname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_name", property = "serviceCityName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_area_code", property = "serviceAreaCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_address_tel", property = "serviceAddressTel", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_daily_type", property = "serviceDailyType", jdbcType = JdbcType.SMALLINT),
        @Result(column = "service_local_days", property = "serviceLocalDays", jdbcType = JdbcType.SMALLINT),
        @Result(column = "service_nonlocal_days", property = "serviceNonlocalDays", jdbcType = JdbcType.SMALLINT),
        @Result(column = "total_days", property = "totalDays", jdbcType = JdbcType.TINYINT),
        @Result(column = "service_pass_city", property = "servicePassCity", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_end_cityid", property = "serviceEndCityid", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_end_cityname", property = "serviceEndCityname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "expected_comp_time", property = "expectedCompTime", jdbcType = JdbcType.INTEGER),
        @Result(column = "start_address", property = "startAddress", jdbcType = JdbcType.VARCHAR),
        @Result(column = "start_address_detail", property = "startAddressDetail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "start_address_poi", property = "startAddressPoi", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address", property = "destAddress", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address_detail", property = "destAddressDetail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address_poi", property = "destAddressPoi", jdbcType = JdbcType.VARCHAR),
        @Result(column = "distance", property = "distance", jdbcType = JdbcType.DOUBLE),
        @Result(column = "car_id", property = "carId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_license_num", property = "carLicenseNum", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_type_id", property = "carTypeId", jdbcType = JdbcType.INTEGER),
        @Result(column = "car_seat_num", property = "carSeatNum", jdbcType = JdbcType.TINYINT),
        @Result(column = "car_name", property = "carName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_desc", property = "carDesc", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_id", property = "coupId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_type", property = "coupType", jdbcType = JdbcType.INTEGER),
        @Result(column = "coup_label", property = "coupLabel", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_price_info", property = "coupPriceInfo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "price_mark", property = "priceMark", jdbcType = JdbcType.VARCHAR),
        @Result(column = "price_base", property = "priceBase", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_guide", property = "priceGuide", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_ticket", property = "priceTicket", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_channel", property = "priceChannel", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_guide_base", property = "priceGuideBase", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_reward", property = "priceReward", jdbcType = JdbcType.DOUBLE),
        @Result(column = "user_id", property = "userId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_account", property = "userAccount", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_name", property = "userName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code1", property = "userAreaCode1", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile1", property = "userMobile1", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code2", property = "userAreaCode2", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile2", property = "userMobile2", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code3", property = "userAreaCode3", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile3", property = "userMobile3", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_email", property = "userEmail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_comment_status", property = "userCommentStatus", jdbcType = JdbcType.TINYINT),
        @Result(column = "user_remark", property = "userRemark", jdbcType = JdbcType.VARCHAR),
        @Result(column = "system_comment_status", property = "systemCommentStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "guide_assign_time", property = "guideAssignTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "guide_pre_id", property = "guidePreId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_id", property = "guideId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_no", property = "guideNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_name", property = "guideName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_area_code", property = "guideAreaCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_mobile", property = "guideMobile", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_comment_status", property = "guideCommentStatus", jdbcType = JdbcType.SMALLINT),
        @Result(column = "guide_agency_type", property = "guideAgencyType", jdbcType = JdbcType.INTEGER),
        @Result(column = "guide_agency_boss_id", property = "guideAgencyBossId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_boss_name", property = "guideAgencyBossName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_account_no", property = "guideAccountNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_id", property = "guideAgencyId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_name", property = "guideAgencyName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_id", property = "agentId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_name", property = "agentName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_opid", property = "agentOpid", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_opname", property = "agentOpname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "admin_id", property = "adminId", jdbcType = JdbcType.INTEGER),
        @Result(column = "im_token", property = "imToken", jdbcType = JdbcType.VARCHAR),
        @Result(column = "deliver_status", property = "deliverStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "deliver_type", property = "deliverType", jdbcType = JdbcType.INTEGER),
        @Result(column = "deliver_acp_time", property = "deliverAcpTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "urgent_flag", property = "urgentFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "urgent_hour", property = "urgentHour", jdbcType = JdbcType.INTEGER),
        @Result(column = "serial_flag", property = "serialFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "serial_order_no", property = "serialOrderNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "cargroup_flag", property = "cargroupFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "cargroup_id", property = "cargroupId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_no", property = "flightNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_airport_code", property = "flightAirportCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_airport_name", property = "flightAirportName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_fly_time", property = "flightFlyTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "flight_arrive_time", property = "flightArriveTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "flight_is_custom", property = "flightIsCustom", jdbcType = JdbcType.INTEGER),
        @Result(column = "flight_airport_buiding", property = "flightAirportBuiding", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_register_id", property = "flightRegisterId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_brand_sign", property = "flightBrandSign", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_code", property = "flightDestCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_name", property = "flightDestName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_building", property = "flightDestBuilding", jdbcType = JdbcType.VARCHAR),
        @Result(column = "line_subject", property = "lineSubject", jdbcType = JdbcType.VARCHAR),
        @Result(column = "line_description", property = "lineDescription", jdbcType = JdbcType.VARCHAR),
        @Result(column = "adult_num", property = "adultNum", jdbcType = JdbcType.INTEGER),
        @Result(column = "child_num", property = "childNum", jdbcType = JdbcType.INTEGER),
        @Result(column = "child_seat", property = "childSeat", jdbcType = JdbcType.VARCHAR),
        @Result(column = "is_arrival_visa", property = "isArrivalVisa", jdbcType = JdbcType.SMALLINT),
        @Result(column = "check_in_price", property = "checkInPrice", jdbcType = JdbcType.DOUBLE),
        @Result(column = "cancel_time", property = "cancelTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "complete_time", property = "completeTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "is_readable", property = "isReadable", jdbcType = JdbcType.INTEGER),
        @Result(column = "is_new_track", property = "isNewTrack", jdbcType = JdbcType.INTEGER),
        @Result(column = "create_time", property = "createTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "update_time", property = "updateTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "journey_comment", property = "journeyComment", jdbcType = JdbcType.LONGVARCHAR) })
List<OrderBean> selectByExampleWithBLOBs(OrderBeanExample example);

From source file:com.hbc.api.trade.order.mapping.gen.OrderBeanMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table `trade_order`
 *
 * @mbggenerated//  w  w w.  j ava2  s.  co  m
 */
@SelectProvider(type = OrderBeanSqlProvider.class, method = "selectByExample")
@Results({ @Result(column = "order_no", property = "orderNo", jdbcType = JdbcType.VARCHAR, id = true),
        @Result(column = "third_trade_no", property = "thirdTradeNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_status", property = "orderStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_status_name", property = "orderStatusName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_type", property = "orderType", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_goods_type", property = "orderGoodsType", jdbcType = JdbcType.INTEGER),
        @Result(column = "good_no", property = "goodNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_source", property = "orderSource", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_channel", property = "orderChannel", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_time", property = "serviceTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "service_end_time", property = "serviceEndTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "service_continent_id", property = "serviceContinentId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_continent_name", property = "serviceContinentName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_country_id", property = "serviceCountryId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_country_name", property = "serviceCountryName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_id", property = "serviceCityId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_city_spell", property = "serviceCitySpell", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_enname", property = "serviceCityEnname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_name", property = "serviceCityName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_area_code", property = "serviceAreaCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_address_tel", property = "serviceAddressTel", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_daily_type", property = "serviceDailyType", jdbcType = JdbcType.SMALLINT),
        @Result(column = "service_local_days", property = "serviceLocalDays", jdbcType = JdbcType.SMALLINT),
        @Result(column = "service_nonlocal_days", property = "serviceNonlocalDays", jdbcType = JdbcType.SMALLINT),
        @Result(column = "total_days", property = "totalDays", jdbcType = JdbcType.TINYINT),
        @Result(column = "service_pass_city", property = "servicePassCity", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_end_cityid", property = "serviceEndCityid", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_end_cityname", property = "serviceEndCityname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "expected_comp_time", property = "expectedCompTime", jdbcType = JdbcType.INTEGER),
        @Result(column = "start_address", property = "startAddress", jdbcType = JdbcType.VARCHAR),
        @Result(column = "start_address_detail", property = "startAddressDetail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "start_address_poi", property = "startAddressPoi", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address", property = "destAddress", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address_detail", property = "destAddressDetail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address_poi", property = "destAddressPoi", jdbcType = JdbcType.VARCHAR),
        @Result(column = "distance", property = "distance", jdbcType = JdbcType.DOUBLE),
        @Result(column = "car_id", property = "carId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_license_num", property = "carLicenseNum", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_type_id", property = "carTypeId", jdbcType = JdbcType.INTEGER),
        @Result(column = "car_seat_num", property = "carSeatNum", jdbcType = JdbcType.TINYINT),
        @Result(column = "car_name", property = "carName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_desc", property = "carDesc", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_id", property = "coupId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_type", property = "coupType", jdbcType = JdbcType.INTEGER),
        @Result(column = "coup_label", property = "coupLabel", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_price_info", property = "coupPriceInfo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "price_mark", property = "priceMark", jdbcType = JdbcType.VARCHAR),
        @Result(column = "price_base", property = "priceBase", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_guide", property = "priceGuide", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_ticket", property = "priceTicket", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_channel", property = "priceChannel", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_guide_base", property = "priceGuideBase", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_reward", property = "priceReward", jdbcType = JdbcType.DOUBLE),
        @Result(column = "user_id", property = "userId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_account", property = "userAccount", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_name", property = "userName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code1", property = "userAreaCode1", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile1", property = "userMobile1", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code2", property = "userAreaCode2", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile2", property = "userMobile2", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code3", property = "userAreaCode3", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile3", property = "userMobile3", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_email", property = "userEmail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_comment_status", property = "userCommentStatus", jdbcType = JdbcType.TINYINT),
        @Result(column = "user_remark", property = "userRemark", jdbcType = JdbcType.VARCHAR),
        @Result(column = "system_comment_status", property = "systemCommentStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "guide_assign_time", property = "guideAssignTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "guide_pre_id", property = "guidePreId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_id", property = "guideId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_no", property = "guideNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_name", property = "guideName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_area_code", property = "guideAreaCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_mobile", property = "guideMobile", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_comment_status", property = "guideCommentStatus", jdbcType = JdbcType.SMALLINT),
        @Result(column = "guide_agency_type", property = "guideAgencyType", jdbcType = JdbcType.INTEGER),
        @Result(column = "guide_agency_boss_id", property = "guideAgencyBossId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_boss_name", property = "guideAgencyBossName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_account_no", property = "guideAccountNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_id", property = "guideAgencyId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_name", property = "guideAgencyName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_id", property = "agentId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_name", property = "agentName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_opid", property = "agentOpid", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_opname", property = "agentOpname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "admin_id", property = "adminId", jdbcType = JdbcType.INTEGER),
        @Result(column = "im_token", property = "imToken", jdbcType = JdbcType.VARCHAR),
        @Result(column = "deliver_status", property = "deliverStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "deliver_type", property = "deliverType", jdbcType = JdbcType.INTEGER),
        @Result(column = "deliver_acp_time", property = "deliverAcpTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "urgent_flag", property = "urgentFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "urgent_hour", property = "urgentHour", jdbcType = JdbcType.INTEGER),
        @Result(column = "serial_flag", property = "serialFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "serial_order_no", property = "serialOrderNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "cargroup_flag", property = "cargroupFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "cargroup_id", property = "cargroupId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_no", property = "flightNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_airport_code", property = "flightAirportCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_airport_name", property = "flightAirportName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_fly_time", property = "flightFlyTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "flight_arrive_time", property = "flightArriveTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "flight_is_custom", property = "flightIsCustom", jdbcType = JdbcType.INTEGER),
        @Result(column = "flight_airport_buiding", property = "flightAirportBuiding", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_register_id", property = "flightRegisterId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_brand_sign", property = "flightBrandSign", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_code", property = "flightDestCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_name", property = "flightDestName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_building", property = "flightDestBuilding", jdbcType = JdbcType.VARCHAR),
        @Result(column = "line_subject", property = "lineSubject", jdbcType = JdbcType.VARCHAR),
        @Result(column = "line_description", property = "lineDescription", jdbcType = JdbcType.VARCHAR),
        @Result(column = "adult_num", property = "adultNum", jdbcType = JdbcType.INTEGER),
        @Result(column = "child_num", property = "childNum", jdbcType = JdbcType.INTEGER),
        @Result(column = "child_seat", property = "childSeat", jdbcType = JdbcType.VARCHAR),
        @Result(column = "is_arrival_visa", property = "isArrivalVisa", jdbcType = JdbcType.SMALLINT),
        @Result(column = "check_in_price", property = "checkInPrice", jdbcType = JdbcType.DOUBLE),
        @Result(column = "cancel_time", property = "cancelTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "complete_time", property = "completeTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "is_readable", property = "isReadable", jdbcType = JdbcType.INTEGER),
        @Result(column = "is_new_track", property = "isNewTrack", jdbcType = JdbcType.INTEGER),
        @Result(column = "create_time", property = "createTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "update_time", property = "updateTime", jdbcType = JdbcType.TIMESTAMP) })
List<OrderBean> selectByExample(OrderBeanExample example);

From source file:com.hbc.api.trade.order.mapping.gen.OrderBeanMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table `trade_order`
 *
 * @mbggenerated/*from ww w. j ava  2  s .c  o  m*/
 */
@Select({ "select", "order_no, third_trade_no, order_status, order_status_name, order_type, order_goods_type, ",
        "good_no, order_source, order_channel, service_time, service_end_time, service_continent_id, ",
        "service_continent_name, service_country_id, service_country_name, service_city_id, ",
        "service_city_spell, service_city_enname, service_city_name, service_area_code, ",
        "service_address_tel, service_daily_type, service_local_days, service_nonlocal_days, ",
        "total_days, service_pass_city, service_end_cityid, service_end_cityname, expected_comp_time, ",
        "start_address, start_address_detail, start_address_poi, dest_address, dest_address_detail, ",
        "dest_address_poi, distance, car_id, car_license_num, car_type_id, car_seat_num, ",
        "car_name, car_desc, coup_id, coup_type, coup_label, coup_price_info, price_mark, ",
        "price_base, price_guide, price_ticket, price_channel, price_guide_base, price_reward, ",
        "user_id, user_account, user_name, user_area_code1, user_mobile1, user_area_code2, ",
        "user_mobile2, user_area_code3, user_mobile3, user_email, user_comment_status, ",
        "user_remark, system_comment_status, guide_assign_time, guide_pre_id, guide_id, ",
        "guide_no, guide_name, guide_area_code, guide_mobile, guide_comment_status, guide_agency_type, ",
        "guide_agency_boss_id, guide_agency_boss_name, guide_account_no, guide_agency_id, ",
        "guide_agency_name, agent_id, agent_name, agent_opid, agent_opname, admin_id, ",
        "im_token, deliver_status, deliver_type, deliver_acp_time, urgent_flag, urgent_hour, ",
        "serial_flag, serial_order_no, cargroup_flag, cargroup_id, flight_no, flight_airport_code, ",
        "flight_airport_name, flight_fly_time, flight_arrive_time, flight_is_custom, ",
        "flight_airport_buiding, flight_register_id, flight_brand_sign, flight_dest_code, ",
        "flight_dest_name, flight_dest_building, line_subject, line_description, adult_num, ",
        "child_num, child_seat, is_arrival_visa, check_in_price, cancel_time, complete_time, ",
        "is_readable, is_new_track, create_time, update_time, journey_comment", "from `trade_order`",
        "where order_no = #{orderNo,jdbcType=VARCHAR}" })
@Results({ @Result(column = "order_no", property = "orderNo", jdbcType = JdbcType.VARCHAR, id = true),
        @Result(column = "third_trade_no", property = "thirdTradeNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_status", property = "orderStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_status_name", property = "orderStatusName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_type", property = "orderType", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_goods_type", property = "orderGoodsType", jdbcType = JdbcType.INTEGER),
        @Result(column = "good_no", property = "goodNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "order_source", property = "orderSource", jdbcType = JdbcType.INTEGER),
        @Result(column = "order_channel", property = "orderChannel", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_time", property = "serviceTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "service_end_time", property = "serviceEndTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "service_continent_id", property = "serviceContinentId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_continent_name", property = "serviceContinentName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_country_id", property = "serviceCountryId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_country_name", property = "serviceCountryName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_id", property = "serviceCityId", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_city_spell", property = "serviceCitySpell", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_enname", property = "serviceCityEnname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_city_name", property = "serviceCityName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_area_code", property = "serviceAreaCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_address_tel", property = "serviceAddressTel", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_daily_type", property = "serviceDailyType", jdbcType = JdbcType.SMALLINT),
        @Result(column = "service_local_days", property = "serviceLocalDays", jdbcType = JdbcType.SMALLINT),
        @Result(column = "service_nonlocal_days", property = "serviceNonlocalDays", jdbcType = JdbcType.SMALLINT),
        @Result(column = "total_days", property = "totalDays", jdbcType = JdbcType.TINYINT),
        @Result(column = "service_pass_city", property = "servicePassCity", jdbcType = JdbcType.VARCHAR),
        @Result(column = "service_end_cityid", property = "serviceEndCityid", jdbcType = JdbcType.INTEGER),
        @Result(column = "service_end_cityname", property = "serviceEndCityname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "expected_comp_time", property = "expectedCompTime", jdbcType = JdbcType.INTEGER),
        @Result(column = "start_address", property = "startAddress", jdbcType = JdbcType.VARCHAR),
        @Result(column = "start_address_detail", property = "startAddressDetail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "start_address_poi", property = "startAddressPoi", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address", property = "destAddress", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address_detail", property = "destAddressDetail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "dest_address_poi", property = "destAddressPoi", jdbcType = JdbcType.VARCHAR),
        @Result(column = "distance", property = "distance", jdbcType = JdbcType.DOUBLE),
        @Result(column = "car_id", property = "carId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_license_num", property = "carLicenseNum", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_type_id", property = "carTypeId", jdbcType = JdbcType.INTEGER),
        @Result(column = "car_seat_num", property = "carSeatNum", jdbcType = JdbcType.TINYINT),
        @Result(column = "car_name", property = "carName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "car_desc", property = "carDesc", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_id", property = "coupId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_type", property = "coupType", jdbcType = JdbcType.INTEGER),
        @Result(column = "coup_label", property = "coupLabel", jdbcType = JdbcType.VARCHAR),
        @Result(column = "coup_price_info", property = "coupPriceInfo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "price_mark", property = "priceMark", jdbcType = JdbcType.VARCHAR),
        @Result(column = "price_base", property = "priceBase", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_guide", property = "priceGuide", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_ticket", property = "priceTicket", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_channel", property = "priceChannel", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_guide_base", property = "priceGuideBase", jdbcType = JdbcType.DOUBLE),
        @Result(column = "price_reward", property = "priceReward", jdbcType = JdbcType.DOUBLE),
        @Result(column = "user_id", property = "userId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_account", property = "userAccount", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_name", property = "userName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code1", property = "userAreaCode1", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile1", property = "userMobile1", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code2", property = "userAreaCode2", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile2", property = "userMobile2", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_area_code3", property = "userAreaCode3", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_mobile3", property = "userMobile3", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_email", property = "userEmail", jdbcType = JdbcType.VARCHAR),
        @Result(column = "user_comment_status", property = "userCommentStatus", jdbcType = JdbcType.TINYINT),
        @Result(column = "user_remark", property = "userRemark", jdbcType = JdbcType.VARCHAR),
        @Result(column = "system_comment_status", property = "systemCommentStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "guide_assign_time", property = "guideAssignTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "guide_pre_id", property = "guidePreId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_id", property = "guideId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_no", property = "guideNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_name", property = "guideName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_area_code", property = "guideAreaCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_mobile", property = "guideMobile", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_comment_status", property = "guideCommentStatus", jdbcType = JdbcType.SMALLINT),
        @Result(column = "guide_agency_type", property = "guideAgencyType", jdbcType = JdbcType.INTEGER),
        @Result(column = "guide_agency_boss_id", property = "guideAgencyBossId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_boss_name", property = "guideAgencyBossName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_account_no", property = "guideAccountNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_id", property = "guideAgencyId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "guide_agency_name", property = "guideAgencyName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_id", property = "agentId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_name", property = "agentName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_opid", property = "agentOpid", jdbcType = JdbcType.VARCHAR),
        @Result(column = "agent_opname", property = "agentOpname", jdbcType = JdbcType.VARCHAR),
        @Result(column = "admin_id", property = "adminId", jdbcType = JdbcType.INTEGER),
        @Result(column = "im_token", property = "imToken", jdbcType = JdbcType.VARCHAR),
        @Result(column = "deliver_status", property = "deliverStatus", jdbcType = JdbcType.INTEGER),
        @Result(column = "deliver_type", property = "deliverType", jdbcType = JdbcType.INTEGER),
        @Result(column = "deliver_acp_time", property = "deliverAcpTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "urgent_flag", property = "urgentFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "urgent_hour", property = "urgentHour", jdbcType = JdbcType.INTEGER),
        @Result(column = "serial_flag", property = "serialFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "serial_order_no", property = "serialOrderNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "cargroup_flag", property = "cargroupFlag", jdbcType = JdbcType.INTEGER),
        @Result(column = "cargroup_id", property = "cargroupId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_no", property = "flightNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_airport_code", property = "flightAirportCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_airport_name", property = "flightAirportName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_fly_time", property = "flightFlyTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "flight_arrive_time", property = "flightArriveTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "flight_is_custom", property = "flightIsCustom", jdbcType = JdbcType.INTEGER),
        @Result(column = "flight_airport_buiding", property = "flightAirportBuiding", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_register_id", property = "flightRegisterId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_brand_sign", property = "flightBrandSign", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_code", property = "flightDestCode", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_name", property = "flightDestName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flight_dest_building", property = "flightDestBuilding", jdbcType = JdbcType.VARCHAR),
        @Result(column = "line_subject", property = "lineSubject", jdbcType = JdbcType.VARCHAR),
        @Result(column = "line_description", property = "lineDescription", jdbcType = JdbcType.VARCHAR),
        @Result(column = "adult_num", property = "adultNum", jdbcType = JdbcType.INTEGER),
        @Result(column = "child_num", property = "childNum", jdbcType = JdbcType.INTEGER),
        @Result(column = "child_seat", property = "childSeat", jdbcType = JdbcType.VARCHAR),
        @Result(column = "is_arrival_visa", property = "isArrivalVisa", jdbcType = JdbcType.SMALLINT),
        @Result(column = "check_in_price", property = "checkInPrice", jdbcType = JdbcType.DOUBLE),
        @Result(column = "cancel_time", property = "cancelTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "complete_time", property = "completeTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "is_readable", property = "isReadable", jdbcType = JdbcType.INTEGER),
        @Result(column = "is_new_track", property = "isNewTrack", jdbcType = JdbcType.INTEGER),
        @Result(column = "create_time", property = "createTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "update_time", property = "updateTime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "journey_comment", property = "journeyComment", jdbcType = JdbcType.LONGVARCHAR) })
OrderBean selectByPrimaryKey(String orderNo);

From source file:com.zkbr.platform.dao.customer.CorporationInfoMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table corporation_info
 *
 * @mbggenerated Sun Aug 21 13:05:40 CST 2016
 *///from w  ww .  j a va  2 s .  co m
@Select({ "select", "id, customerName, corporationName, industryType, registerTime, registerCapital, ",
        "license, taxId, orgNo, businessType, lrName, lrSex, lrAge, lrCountry, lrCertNo, ",
        "lrMobile, lrEduType, lrPhone, lrCertType, staffCount", "from corporation_info",
        "where id = #{id,jdbcType=VARCHAR}" })
@Results({ @Result(column = "id", property = "id", jdbcType = JdbcType.VARCHAR, id = true),
        @Result(column = "customerName", property = "customerName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "corporationName", property = "corporationName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "industryType", property = "industryType", jdbcType = JdbcType.VARCHAR),
        @Result(column = "registerTime", property = "registerTime", jdbcType = JdbcType.DATE),
        @Result(column = "registerCapital", property = "registerCapital", jdbcType = JdbcType.DECIMAL),
        @Result(column = "license", property = "license", jdbcType = JdbcType.VARCHAR),
        @Result(column = "taxId", property = "taxId", jdbcType = JdbcType.VARCHAR),
        @Result(column = "orgNo", property = "orgNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "businessType", property = "businessType", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrName", property = "lrName", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrSex", property = "lrSex", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrAge", property = "lrAge", jdbcType = JdbcType.SMALLINT),
        @Result(column = "lrCountry", property = "lrCountry", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrCertNo", property = "lrCertNo", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrMobile", property = "lrMobile", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrEduType", property = "lrEduType", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrPhone", property = "lrPhone", jdbcType = JdbcType.VARCHAR),
        @Result(column = "lrCertType", property = "lrCertType", jdbcType = JdbcType.VARCHAR),
        @Result(column = "staffCount", property = "staffCount", jdbcType = JdbcType.SMALLINT) })
CorporationInfo selectByPrimaryKey(String id);