<!-- 模糊查询 -->
<select id="findPersons" parameterClass="com.tq365.vo.Person" resultMap="person_result">
select * from t_person
<dynamic prepend="where">
<isNotEmpty prepend="and" property="personname">
personname like '%$personname$%'
</isNotEmpty>
<!--此为精确查询,模糊查询写成like '%$value$%',#XX#,#将其在sql中表现为'XX'
<isNotEmpty prepend="and" property="personname">
(personname like #personname#)
</isNotEmpty>
-->
<!--
<isNotEmpty prepend="AND" property="address">
(address like #address#)
</isNotEmpty>
-->
</dynamic>
</select>
关于ibatis中模糊查询配置
最新推荐文章于 2019-11-28 19:10:59 发布