Ibatis动态字段查询

<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"