1.模糊查询:username LIKE '%' || UPPER(#{queryMap.name, jdbcType = VARCHAR}) || '%' ESCAPE '\'
2.<if></if>标签
<if test="queryMap.Id != null and queryMap.Id != '0'.toString() and queryMap.Id=‘2’.toString()">
3.mybatis传参,"#"
id = #{queryMap.Id, jdbcType = VARCHAR}
4.foreach标签
<foreach collection="queryMap.list"
index="index" item="item" open="(" separator="," close=")">
#{item, jdbcType = VARCHAR}
</foreach>
5.COALESCE函数
COALESCE( SUM(num ) , 0 )