<select id="getUsersByPara" parameterClass="User" resultClass="User">
select id,name,age from user
<dynamic prepend="where">
<isNotEmpty prepend="and" property="name">
(name like concat('%',#name#,'%'))
</isNotEmpty>
<isNotEmpty prepend="and" property="age">
(age like concat('%',#age#,'%'))
</isNotEmpty>
</dynamic>
<!--mysql concat('%',#name#,'%') -->
<!--oracle '%'||#name#||'%' -->
<!--sqlserver '%'+#name#+'%' -->
</select>
PS: 推荐使用instr()>0替代like 。