mybatis中的日志

深碍√TFBOYSˉ_ 2022-02-13 10:23 202阅读 0赞

# 一、mybatis环境搭建: #

![20190427190222970.png][]

1.  ## 导包 ##
2.  ## 配置全局配置文件  ##

配置mybatis全局文件，主要配置数据库连接信息，以及mapper文件。其中settings中开启mybatis的日志

<?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="LOG4J"/>
    	</settings>
        
    	<environments default="mysql">
    		<environment id="mysql">
    			<transactionManager type="JDBC"/>
    			<dataSource type="POOLED">
    				<property name="driver" value="com.mysql.jdbc.Driver"/>
    				<property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
    				<property name="username" value="root"/>
    				<property name="password" value="root"/>
    			</dataSource>
    		</environment>
    	</environments>
        
    	<mappers>
    		<mapper resource="com/test/mapper/PeopleMapper.xml"/>
    		<mapper resource="com/test/mapper/PeopleMapper2.xml"/>
    	</mappers>
    </configuration>

##  3.在项目的src下导入log4j.properties文件 ##

在该文件中主要配置日志的信息以及错误输出级别

log4j.rootCategory=ERROR, CONSOLE,LOGFILE     #第一行控制输出级别 以及输出位置
    
    log4j.logger.com.test.mapper=DUBUG    #对具体的某个包的级别
    
    
    log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender  
    log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout  
    log4j.appender.CONSOLE.layout.ConversionPattern=%p-%l-%L -%m%n   #具体的输出形式
    
    
    log4j.appender.LOGFILE=org.apache.log4j.FileAppender
    log4j.appender.LOGFILE.File=F:/axis.log      #日志文件输出的磁盘位置
    log4j.appender.LOGFILE.Append=true
    log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
    log4j.appender.LOGFILE.layout.ConversionPattern=-%p-%d{yyyy/MM/dd HH:mm:ss,SSS}-%l-%L-%m%n

log4j输出级别大小顺序      fatal(致命错误) > error (错误) > warn (警告) > info(普通信息) > debug(调试信息)

一般在总的输出级别中设置一个大的级别过滤掉没用的信息，然后针对具体的某个包或类设置小的级别

## 4.测试代码 ##

package com.test;
    import java.io.IOException;
    import java.io.InputStream;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    
    /**
     * @author QuLei
     *测试mybatis框架的日志
     */
    public class Test {
    
    	public static void main(String[] args) throws IOException {
    		// TODO Auto-generated method stub
    		
    		InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
    		SqlSessionFactory factory = (new SqlSessionFactoryBuilder()).build(is);
    		SqlSession session = factory.openSession();
    		session.selectList("com.test.mapper.PeopleMapper.selAll");
    		session.selectList("com.test.mapper.PeopleMapper.selOne");
    		session.selectList("com.test.map.PeopleMapper.selAll");
    		
    	}

##      ##

[20190427190222970.png]: /images/20220213/766f7efab50443d492fd90dcedcb259d.png