0032-mybatis相关标签

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 )