mybatis sql日志输出

网上转抄的做法还是ibatis那样，对java.sql.Connection的日志做输出，不知道这些人到底有没有去试过
正确做法如下
1. 标注里写SQL

package org.mybatis.example;
public interface BlogMapper {
  @Select("SELECT * FROM blog WHERE id = #{id}")
  Blog selectBlog(int id);
}

日志输出配置如下

log4j.logger.org.mybatis.example.BlogMapper=DEBUG

2. Mapper文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xx.blogMapper">
  <select id="selectBlog" parameterType="int" resultType="Blog">
    select * from Blog where id = #{id}
  </select>
</mapper>

日志输出配置如下

log4j.logger.com.xx.blogMapper=DEBUG