一、Ibatis常用动态sql语法，简单粗暴用一例子
<select id=”iBatisSelectList” parameterClass=”java.util.HashMap” resultMap=”BeanFieldMap”>
SELECT
Column_list
FROM
Table_name
WHERE 1=1
<isNotEmpty prepend=”and” property=”areacode”>
areaCodes like concat(‘%’, #areacode#, ‘%’)
</isNotEmpty>
<isNotEmpty property=”types” prepend=”and”>
<iterate property=”types” open=”(” conjunction=”or” close=”)”>
type like concat(‘%’,#types[]#,’%’)
</iterate>
</isNotEmpty>
<isNotEmpty property=”datestart” prepend=”and”>
inputDate <![CDATA[>]]> #datestart#
</isNotEmpty>
<isNotEmpty property=”dateend” prepend=”and”>
inputDate <![CDATA[<]]> #dateend#
</isNotEmpty>
<isEqual property=”order” compareValue=”asc”>
order by inputDate asc limit #skipCount#,#pageSize#
</isEqual>
<isEqual property=”order” compareValue=”desc”>
order by inputDate desc limit #skipCount#,#pageSize#
</isEqual>
</select>
其中java中对应的
public List<T> selectLis(String areacode,String type,String datestart,String dateend,Integer skipCount,String order,Integer pageSize){
Map<String, Object> params = new HashMap<String, Object>();
params.put(“areacode”, areacode);
if(type.indexOf(“,”)>=0){ //type字符串多个以，隔开
String[] types = type.split(“,”);
params.put(“types”, types);
}else{
String[] types = {type};
params.put(“types”, types);
}
params.put(“skipCount”, skipCount.toString());
params.put(“pageSize”, pageSize.toString());
params.put(“datestart”, datestart);
params.put(“dateend”, dateend);
params.put(“order”, order);
logger.info(“输入参数：{}”, params);
try {
return sqlMapClient.queryForList(“iBatisSelectList”, params);
} catch (SQLException e) {
logger.info(“参数{},异常{}”, params, e.getStackTrace());
}
}
这个例子涉及到like语句（areacode）用法，集合语句(type)用法，特殊字符用法等，注意格式！！！
