网上说mybatis的早前版本配置打印sql还比较简单,在3.0.6之后配置方式修改了。
现在的spring-mybatis.xml配置如下:
<pre style="margin: 0px; padding: 0px; white-space: pre-wrap; word-wrap: break-word; font-family: "Courier New" !important; font-size: 12px !important;">
<
bean
id
="sqlSessionFactory"
class
="org.mybatis.spring.SqlSessionFactoryBean"
<
property
name
="dataSource"
ref
="dataSource"
/>
<
property
name
="configLocation"
value
="classpath:conf/mybatis-config.xml"
</
property
<
property
name
="mapperLocations"
value
="classpath:com/cyber/vip/dao/*.xml"
</
property
</
bean
</pre>
mybatis-config.xml:
[ 复制代码](javascript:void(0); "复制代码")
<pre style="margin: 0px; padding: 0px; white-space: pre-wrap; word-wrap: break-word; font-family: "Courier New" !important; font-size: 12px !important;">
<?
xml version="1.0" encoding="UTF-8"
?>
<!
DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd"
<
configuration
<
settings
<
setting
name
="logImpl"
value
="STDOUT_LOGGING"
/>
</
settings
</
configuration
</pre>
[ 复制代码](javascript:void(0); "复制代码")
不错,打印SQL只需要加一个setting就可以了。
mybatis的日志打印方式比较多,SLF4J | LOG4J | LOG4J2 | JDK_LOGGING | COMMONS_LOGGING | STDOUT_LOGGING | NO_LOGGING,可以根据自己的需要进行配置
settings的更多参数可以参考官网文档:http://www.mybatis.org/mybatis-3/zh/configuration.html#settings
网友评论