mybatis

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

使用$不是#