【log4j使用入门】结合MyBatis入门案例

怼烎@ 2022-04-15 01:28 276阅读 0赞

## 1.引入maven依赖 ##

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>MyBatis1118</groupId>
      <artifactId>MyBatis1118</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      
      
      
      <properties>
      	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      </properties>
      
      
      <build>
      	<plugins>
      		<plugin>
      			<artifactId>maven-compiler-plugin</artifactId>
      			<configuration>
      				<source>1.8</source>
      				<target>1.8</target>
      			</configuration>
      		</plugin>
      	</plugins>
      </build>
      
      
      <dependencies>
      	<dependency>
      		<groupId>org.mybatis</groupId>
      		<artifactId>mybatis</artifactId>
      		<version>3.3.0</version>
      	</dependency>
      	
      	<dependency>
      		<groupId>junit</groupId>
      		<artifactId>junit</artifactId>
      		<version>4.12</version>
      	</dependency>
      	<dependency>
      		<groupId>mysql</groupId>
      		<artifactId>mysql-connector-java</artifactId>
      		<version>5.1.38</version>
      	</dependency>
      	<dependency>
      		<groupId>org.slf4j</groupId>
      		<artifactId>slf4j-api</artifactId>
      		<version>1.7.12</version>
      	</dependency>
      	<dependency>
      		<groupId>org.slf4j</groupId>
      		<artifactId>slf4j-log4j12</artifactId>
      		<version>1.7.12</version>
      	</dependency>
      	<dependency>
      		<groupId>log4j</groupId>
      		<artifactId>log4j</artifactId>
      		<version>1.2.17</version>
      	</dependency>
      </dependencies>
    </project>

## 2.maven工程目录结构 ##

![20181120081236188.png][]

## 3.创建log4j.properties配置文件 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70][]

## 4.log4j.properties的配置如下 ##

#全局配置
    log4j.rootLogger=ERROR,stdout
    #Mybatis日志配置 监控的是mapper文件的位置
    log4j.logger.com.zit.dao=TRACE
    #控制台输出配置
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

### ![20181120081946342.png][] ###

### 注意： ###

***log4j.logger.com.zit.dao=TRACE//这行的配置是mapper.xml文件所在的包，通过配置这可以再控制台打印sql***

## 5.测试代码 ##

package com.zit.mapper;
    
    import java.io.Reader;
    import java.util.List;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import org.junit.BeforeClass;
    import org.junit.Test;
    
    import com.zit.entity.Country;
    
    public class CountryMapperTest {
    	
    	private static SqlSessionFactory sqlSessionFactory;
    	
    	@BeforeClass
    	public static void init() {
    		try {
    			Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
    			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
    			reader.close();
    		} catch (Exception e) {
    		}
    	}
    	
    	@Test
    	public void testSelectAll() {
    		SqlSession sqlSession = sqlSessionFactory.openSession();
    		try {
    			List<Country> countryList = sqlSession.selectList("selectAll");
    			printCountryList(countryList);
    		} catch (Exception e) {
    		}finally {
    			sqlSession.close();
    		}
    	}
    	
    	
    	private static void printCountryList(List<Country> countryList) {
    		for (Country country : countryList) {
    			System.out.println(country.getCountryname()+"##"+country.getCountrycode());
    		}
    	}
    	
    
    }

## 6.控制台运行结果 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70 1][]

## 7.工程源码下载 ##

[点击此处下载][Link 1]

[20181120081236188.png]: /images/20220415/5097b40fd06a406285ca1045e51d1dd3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70]: /images/20220415/c68891113f894821971152f301b80594.png
[20181120081946342.png]: /images/20220415/202bee2f36b04575979b7cd127eb65de.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70 1]: /images/20220415/215769ce7c8f4408b4b0f617e969fbed.png
[Link 1]: https://download.csdn.net/download/qq_37306041/10794989