今天在设计一个通用查询的时候,封装了一个通用查询参数的对象大至如下:
然后:
[color=indigo]
<select id="select" paramterClass="queryParamter" resultMap="userResultMap">
select * from users
where 1=1
<isNotEmpty prepend="and" property="如果里是queryParamter中map中key为userName的值该写">
user_name like '%$如果里是queryParamter中map中key为userName的值该写$%'
</isNotEmpty>
</select>
[/color]
public class QueryParamter {
int getStart(){}
int getLimit(){}
Map getMap(){...}
..........
}
然后:
[color=indigo]
<select id="select" paramterClass="queryParamter" resultMap="userResultMap">
select * from users
where 1=1
<isNotEmpty prepend="and" property="如果里是queryParamter中map中key为userName的值该写">
user_name like '%$如果里是queryParamter中map中key为userName的值该写$%'
</isNotEmpty>
</select>
[/color]