iBatis查询,isNotEmpty不起作用,解决方法:property别忘了写,修改成如下:
<select id="queryTable" parameterClass="ParameterClass" resultMap="ResultMap">
select * from table where 1 =1
<isNotEmpty property="fromId" prepend="and">
id <![CDATA[>=]]> #fromId#
</isNotEmpty>
<isNotEmpty property="toId" prepend="and">
id <![CDATA[<=]]> #toId#
</isNotEmpty>
order by id
</select>