美文网首页
spring集成mybatis后,打印SQL语句

spring集成mybatis后,打印SQL语句

作者: enshunyan | 来源:发表于2017-11-24 11:02 被阅读0次

    网上说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

    相关文章

      网友评论

          本文标题:spring集成mybatis后,打印SQL语句

          本文链接:https://www.haomeiwen.com/subject/tfmxbxtx.html