网上转抄的做法还是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