<select id="findById" parameterClass="java.util.Map" resultClass="company" remapResults="true">
SELECT
<dynamic prepend=" ">
<isNotEmpty property="C_INTRO" prepend=",">C_INTRO</isNotEmpty>
<isNotEmpty property="C_HONOUR" prepend=",">C_HONOUR</isNotEmpty>
<isNotEmpty property="C_CULTURE" prepend=",">C_CULTURE</isNotEmpty>
</dynamic>
FROM T_COMPANY
WHERE I_COMPANYID = #companyId#
</select>
由于ibaits 会缓存查询的meta信息
因此在查询动态字段时务必添加以下配置:
remapResults="true"