<select id="getPersonsByName" resultClass="com.unmi.Person">
select id as id,name as name,passwd as passwd from person
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="name">
(name like #name#)
</isNotNull>
</dynamic>
</select>
两种方法:
1,是把上面 (name like '%#name#%') 的 # 换成 $, 也就是 (name like '%$name$%')
2,是用 || 连接字符串的方式,写成 (name like '%' || #name# || '%')
select id as id,name as name,passwd as passwd from person
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="name">
(name like #name#)
</isNotNull>
</dynamic>
</select>
两种方法:
1,是把上面 (name like '%#name#%') 的 # 换成 $, 也就是 (name like '%$name$%')
2,是用 || 连接字符串的方式,写成 (name like '%' || #name# || '%')