Springmvc与mybatis整合，log4j输出sql语句

最新推荐文章于 2024-08-15 14:47:41 发布

weixin_34378969

最新推荐文章于 2024-08-15 14:47:41 发布

阅读量130

点赞数

文章标签： java 运维 python

原文链接：https://my.oschina.net/xunzhizhe/blog/609257

版权

2019独角兽企业重金招聘Python工程师标准>>>

Maven 依赖

<!--添加log4j依赖-->
<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
    <scope>runtime</scope>
</dependency>

<!--添加SpringMVC依赖-->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>${spring.version}</version>
</dependency>

<!-- 添加mybatis依赖 -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.2.5</version>
</dependency>
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.2.2</version>
</dependency>

a. 配置mybatis_config.xml在settings中添加logImpl属性

<settings>
    <setting name="logImpl" value="LOG4J"/>
</settings>

b. 写一个servlet，如下

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;

/**
 * 初始化Log4j的Servlet类
 * Created by charlie.deng on 1/25/2016.
 */
public class InitLog4jServlet extends HttpServlet {

    private static final long serialVersionUID = 1L;

    @Override
    public void init() throws ServletException {
        super.init();
        org.apache.ibatis.logging.LogFactory.useLog4JLogging();
        System.out.println("************Tell mybatis use log4j************");
    }

}

c. 在web.xml中配置启动servlet

<servlet>  
    <servlet-name>InitLog4jServlet</servlet-name>  
    <servlet-class>com.xy.servlet.InitLog4jServlet</servlet-class>  
    <load-on-startup>2</load-on-startup>
</servlet>
<servlet-mapping>
    <servlet-name>InitLog4jServlet</servlet-name>
    <url-pattern>/InitLog4jServlet</url-pattern>
</servlet-mapping>

d. log4j.properties文件内容

#
log4j.rootLogger=INFO, stdout
#MyBatis 配置，biz.etao.dns.service.mapper是mybatis接口所在包
log4j.logger.biz.etao.dns.service.mapper=DEBUG
#
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss} [%t:%r] - [%p] %m%n
#
log4j.category.org.springframework=INFO

转载于:https://my.oschina.net/xunzhizhe/blog/609257