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

Introduction

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

Prototype

JdbcType DECIMAL

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

Click Source Link

Usage

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);

---

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  w  w  .  j  ava  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);

---