list
<if test=“xx!=null and xx.size()>0">
</if>
集合遍历
<foreach collection="xx" open="(" separator="," close=")" item="item">
#{item}
</foreach>
like拼接
and Method like CONCAT('%', #{xx}, '%')
日志
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
log4j.appender.dailyFile.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%t] [%l] - [%p] %m%n
order by
使用$不是#