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

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

Introduction

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

Prototype

JdbcType DOUBLE

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

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//from   w ww . j  a va  2  s.  c  om
 */
@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  ww  .j  av a 2 s.c  o 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  w w w  . java  2 s .  c om*/
 */
@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.sc.mapper.generator.SellersMapper.java

@SelectProvider(type = SellersSqlProvider.class, method = "selectByExample")
@Results({ @Result(column = "CM_SELLERID", property = "CM_SELLERID", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SELLERNAME", property = "CM_SELLERNAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PHONE", property = "CM_PHONE", jdbcType = JdbcType.BIGINT),
        @Result(column = "CM_ACCOUNT", property = "CM_ACCOUNT", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PASSWORD", property = "CM_PASSWORD", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_BRANDID", property = "CM_BRANDID", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_CARDPATH", property = "CM_CARDPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_STOREPATH", property = "CM_STOREPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_LICENSEPATH", property = "CM_LICENSEPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_ADDRESS", property = "CM_ADDRESS", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_LON", property = "CM_LON", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_LAT", property = "CM_LAT", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_CREATETIME", property = "CM_CREATETIME", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "CM_ISEXAMINE", property = "CM_ISEXAMINE", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_REASON", property = "CM_REASON", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CARDNO", property = "CM_CARDNO", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_NAME", property = "CM_NAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CONTACTNAME", property = "CM_CONTACTNAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CONTACTPHONE", property = "CM_CONTACTPHONE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_TELEPHONE", property = "CM_TELEPHONE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PAX", property = "CM_PAX", jdbcType = JdbcType.VARCHAR) })
List<Sellers> selectByExample(SellersExample example);

From source file:com.sc.mapper.generator.UserapplicationsMapper.java

@SelectProvider(type = UserapplicationsSqlProvider.class, method = "selectByExample")
@Results({ @Result(column = "CM_ID", property = "CM_ID", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_NAME", property = "CM_NAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PHONE", property = "CM_PHONE", jdbcType = JdbcType.BIGINT),
        @Result(column = "CM_CARDFACEPATH", property = "CM_CARDFACEPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CARDBACKPATH", property = "CM_CARDBACKPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PERSONALPATH", property = "CM_PERSONALPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_LICENSEPATH", property = "CM_LICENSEPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SHOPEADDRESS", property = "CM_SHOPEADDRESS", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SHOPLON", property = "CM_SHOPLON", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_SHOPLAT", property = "CM_SHOPLAT", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_STATE", property = "CM_STATE", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_REASON", property = "CM_REASON", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_TYPE", property = "CM_TYPE", jdbcType = JdbcType.INTEGER) })
List<Userapplications> selectByExample(UserapplicationsExample example);

From source file:com.sc.mapper.generator.UsersMapper.java

@SelectProvider(type = UsersSqlProvider.class, method = "selectByExample")
@Results({ @Result(column = "CM_USERID", property = "CM_USERID", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SHOPNAME", property = "CM_SHOPNAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PHONE", property = "CM_PHONE", jdbcType = JdbcType.BIGINT),
        @Result(column = "CM_ACCOUNT", property = "CM_ACCOUNT", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PASSWORD", property = "CM_PASSWORD", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_INTEGRAL", property = "CM_INTEGRAL", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_BALANCE", property = "CM_BALANCE", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_CARDPATH", property = "CM_CARDPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_STOREPATH", property = "CM_STOREPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_LICENSEPATH", property = "CM_LICENSEPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SHOPEADDRESS", property = "CM_SHOPEADDRESS", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SHOPLON", property = "CM_SHOPLON", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_SHOPLAT", property = "CM_SHOPLAT", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_LEVEL", property = "CM_LEVEL", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_CREATETIME", property = "CM_CREATETIME", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "CM_ISEXAMINE", property = "CM_ISEXAMINE", jdbcType = JdbcType.INTEGER),
        @Result(column = "CM_REASON", property = "CM_REASON", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CARDNO", property = "CM_CARDNO", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_NAME", property = "CM_NAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CONTACTNAME", property = "CM_CONTACTNAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CONTACTPHONE", property = "CM_CONTACTPHONE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_TELEPHONE", property = "CM_TELEPHONE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PAX", property = "CM_PAX", jdbcType = JdbcType.VARCHAR) })
List<Users> selectByExample(UsersExample example);

From source file:com.sc.mapper.manage.ManageMapper.java

@SelectProvider(type = ManageSqlProvider.class, method = "getSellerDetail")
@Results({ @Result(column = "CM_CREATETIME", property = "CM_CREATETIME"),
        @Result(column = "CM_PHONE", property = "CM_PHONE", jdbcType = JdbcType.DECIMAL),
        @Result(column = "CM_NAME", property = "CM_NAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CONTACTNAME", property = "CM_CONTACTNAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CONTACTPHONE", property = "CM_CONTACTPHONE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_TELEPHONE", property = "CM_TELEPHONE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_PAX", property = "CM_PAX", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_STOREPATH", property = "CM_STOREPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CARDNO", property = "CM_CARDNO", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_CARDPATH", property = "CM_CARDPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_ISEXAMINE", property = "CM_ISEXAMINE", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_LICENSEPATH", property = "CM_LICENSEPATH", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_REASON", property = "CM_REASON", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SELLERID", property = "CM_SELLERID", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_ADDRESS", property = "CM_ADDRESS", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_SELLERNAME", property = "CM_SELLERNAME", jdbcType = JdbcType.VARCHAR),
        @Result(column = "CM_LAT", property = "CM_LAT", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_LON", property = "CM_LON", jdbcType = JdbcType.DOUBLE),
        @Result(column = "CM_BRAND", property = "CM_BRAND", jdbcType = JdbcType.VARCHAR) })
List<SellerDetail> getSellerDetail(String sellerid);