Mybatis - resultType 和 resultMap 的使用规范

争对问题：配置文件未开启驼峰命名时 SQL 查询结果中字段有值但对应的实体类属性无值

1. 解决方式一：resultMap 标签

<resultMap id="result" type="com.tech.omp.copartner.domain.POrgAdmin">
        <id property="loginId" column="LOGIN_ID" />
        <result column="MOBILE" property="mobile" />
        <result column="MOBILE_CIPHERTEXT" property="mobileCiphertext"/>
</resultMap>

<select id="findPOrgAdminListUnencrypted" resultMap="result">
        SELECT LOGIN_ID,MOBILE,MOBILE_CIPHERTEXT
        FROM PARTNER.P_ORG_ADMINISTRATOR
        WHERE MOBILE IS NOT NULL
</select>

2. 解决方式二：字段采用别称 + resultType 标签

<select id="findPOrgAdminListUnencrypted" resultType="com.tech.omp.copartner.domain.POrgAdmin">
        SELECT LOGIN_ID AS loginId,MOBILE AS mobile,MOBILE_CIPHERTEXT AS mobileCiphertext
        FROM PARTNER.P_ORG_ADMINISTRATOR
        WHERE MOBILE IS NOT NULL
</select>

不采用配置文件开启驼峰命名的原因：安全部门不允许 see bye !