ssm框架配置log4j打印mybatis的sql语句

最新推荐文章于 2024-08-22 02:09:51 发布

蓝星花

最新推荐文章于 2024-08-22 02:09:51 发布

阅读量4.1k

点赞数

分类专栏：后端编程文章标签： ssm sql语句

本文链接：https://blog.csdn.net/m0_37499059/article/details/79329819

版权

后端编程专栏收录该内容

85 篇文章 5 订阅

订阅专栏

修改mybatis-config.xml文件：

<?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>
<plugins>
    <!-- com.github.pagehelper为PageHelper类所在包名   分页-->
    <plugin interceptor="com.github.pagehelper.PageHelper">
            <property name="dialect" value="mysql"/>
            <property name="offsetAsPageNum" value="false"/>
            <property name="rowBoundsWithCount" value="false"/>
            <property name="pageSizeZero" value="true"/>
            <property name="reasonable" value="false"/>
            <property name="supportMethodsArguments" value="false"/>
            <property name="returnPageInfo" value="none"/>
        </plugin>
</plugins>
</configuration>

log4j.properties

log4j.rootLogger=info,console,file  
  
log4j.appender.console=org.apache.log4j.ConsoleAppender  
log4j.appender.console.layout=org.apache.log4j.PatternLayout  
log4j.appender.console.layout.ConversionPattern=[%-5p] %m%n  
   
#log4j.logger.org.mybatis=DEBUG  
#log4j.logger.com.sliver.ebookshop.mapper=DEBUG  

log4j.appender.file=org.apache.log4j.DailyRollingFileAppender  
log4j.appender.file.DatePattern='-'yyyy-MM-dd  
log4j.appender.file.File=./logs/weixinmpmenu.log  
log4j.appender.file.Append=true  
log4j.appender.file.layout=org.apache.log4j.PatternLayout  
log4j.appender.file.layout.ConversionPattern=[%-5p] %d %37c %3x - %m%n