MyBatis 日志信息配置

桃扇骨 2022-05-14 00:16 174阅读 0赞

**项目结构**

![70][]

**jar包**

![70 1][]

**创建User**

package com.po;
    public class User {
    	private Integer userId;
    	private String userName;
    	private String passWord;
    	public Integer getUserId() {
    		return userId;
    	}
        //省略get、set方法
    }

**创建UserMapper.xml**

<mapper namespace="com.mapper.UserMapper">
    	<insert id="addUser" parameterType="user" useGeneratedKeys="true" keyProperty="userId">
    		insert into t_user (userName,passWord) 
    		values(#{userName},#{passWord})
    	</insert>
    	<select id="getUserById" resultType="user" parameterType="Integer">
    		select * from t_user where userId=#{userId}
    	</select>
    </mapper>

**创建log4j.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">  
    <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">  
        <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">  
            <layout class="org.apache.log4j.PatternLayout">  
                <param name="ConversionPattern" value="%5p [%t] %m%n" />  
            </layout>  
        </appender>   
         <logger name="com.mapper.UserMapper">  
            <level value="DEBUG" />  
        </logger> 
        <root>  
            <level value="ERROR" />  
            <appender-ref ref="STDOUT" />  
        </root>  
    </log4j:configuration>

**创建mybatis-config.xml**

**创建SessionFactory**

package com.factory;
    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;
    public class SessionFactory {
    	private static SqlSessionFactory sessionFactory=null;
    	//初始化创建SqlSessionFactory对象
    	static {		
    				try {
    					//读取配置文件
    					InputStream	is = Resources.getResourceAsStream("mybatis-config.xml");
    					//根据配置文件构建SqlSessionFactory
    					sessionFactory=new SqlSessionFactoryBuilder().build(is);
    				} catch (IOException e) {
    					e.printStackTrace();
    				}				
    	}
    	//获取SqlSession对象
    	public static SqlSession getSqlSession() {
    		return sessionFactory.openSession();
    	}
    	// 获取SqlSessionFactory
    	public static SqlSessionFactory getSqlSessionFactory() {
    		return sessionFactory;
    	}
    }

**创建UserDao**

package com.dao;
    import org.apache.ibatis.session.SqlSession;
    import org.junit.Test;
    import com.factory.SessionFactory;
    import com.po.User;
    public class UserDao {
    	private SqlSession session=SessionFactory.getSqlSession();
    	@Test
    	public void getUserById() {
    		User user=session.selectOne("com.mapper.UserMapper.getUserById", 1);
    		session.close();
    		System.out.println(user);
    	}
    }

**执行getUserById()方法**

![70 2][]

[70]: /images/20220514/c3c5b9a2b9634731b4962f198a1d9143.png
[70 1]: /images/20220514/b3790be6dc274e27bae6c2ef729465a5.png
[70 2]: /images/20220514/494788360bea443c8f10132c5f430fb2.png