Mybatis引入Logback日志框架-----Mybatis框架

引入内容需要参照DTD约束
日志实现可以显示连接对象什么时候创建,什么时候关闭,sql语句是怎么样的
SLF是一个日志标准,其中有一个叫logback的框架,实现了SLF规范
引入Logback的依赖
引入logback.xml这个配置文件,这个配置文件必须放在类的根路径下
未指定mybatis日志文件时自动查找,首先从SLF等开始查找(有引入第三方的情况下)
日志风格SLF,LOG4J,LOG4J2,STDOUT_LOGGING
如果既没有指定,也没有选择自带的标准日志组件,它默认是不开启的

引入内容需要参照DTD约束
日志实现可以显示连接对象什么时候创建,什么时候关闭,sql语句是怎么样的
SLF是一个日志标准,其中有一个叫logback的框架,实现了SLF规范
引入Logback的依赖
引入logback.xml这个配置文件,这个配置文件必须放在类的根路径下
未指定mybatis日志文件时自动查找,首先从SLF等开始查找(有引入第三方的情况下)
日志风格SLF,LOG4J,LOG4J2,STDOUT_LOGGING
如果既没有指定,也没有选择自带的标准日志组件,它默认是不开启的

<?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="SLF4J"/>
    </settings>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:13306/powernode" />
                <property name="username" value="root" />
                <property name="password" value="abc123" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--        指定xml文件的路径,自动从根路径下找资源-->
        <mapper resource="CarMapper.xml"></mapper>
        <!--        url属性,是从绝对路径下加载资源的,语法格式是file:///加绝对路径-->
        <!--        <mapper resource="CarMapper.xml" url="file:///d:/CarMapper.xml"></mapper>-->
    </mappers>
</configuration>

<?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="SLF4J"/>
    </settings>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:13306/powernode" />
                <property name="username" value="root" />
                <property name="password" value="abc123" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--        指定xml文件的路径,自动从根路径下找资源-->
        <mapper resource="CarMapper.xml"></mapper>
        <!--        url属性,是从绝对路径下加载资源的,语法格式是file:///加绝对路径-->
        <!--        <mapper resource="CarMapper.xml" url="file:///d:/CarMapper.xml"></mapper>-->
    </mappers>
</configuration>

<?xml version="1.0" encoding="UTF-8" ?>

<configuration debug="false">
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="org.apache.ibatis" level="TRACE"></logger>
    <logger name="java.sql.Connection" level="DEBUG"></logger>
    <logger name="java.sql.Statement" level="DEBUG"></logger>
    <logger name="java.sql.PreparedStatement" level="DEBUG"></logger>
    <!--日志级别,由低到高-->
    <!--ALL < TRACE < DEBUG < INFO < WARN < ERROR < FATAL < OFF-->
    <root level="DEBUG">
        <appender-ref ref="STDOUT"></appender-ref>
        <appender-ref ref="FILE"></appender-ref>
    </root>

</configuration>

<?xml version="1.0" encoding="UTF-8" ?>

<configuration debug="false">
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="org.apache.ibatis" level="TRACE"></logger>
    <logger name="java.sql.Connection" level="DEBUG"></logger>
    <logger name="java.sql.Statement" level="DEBUG"></logger>
    <logger name="java.sql.PreparedStatement" level="DEBUG"></logger>
    <!--日志级别,由低到高-->
    <!--ALL < TRACE < DEBUG < INFO < WARN < ERROR < FATAL < OFF-->
    <root level="DEBUG">
        <appender-ref ref="STDOUT"></appender-ref>
        <appender-ref ref="FILE"></appender-ref>
    </root>

</configuration>

package com.powernode.mybatis;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class Spring6Config
{
    @Bean("sqlSessionFactoryBuilder")
    public SqlSessionFactoryBuilder getSqlSessionFactoryBuilder()
    {
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        return sqlSessionFactoryBuilder;
    }
}

package com.powernode.mybatis;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class Spring6Config
{
    @Bean("sqlSessionFactoryBuilder")
    public SqlSessionFactoryBuilder getSqlSessionFactoryBuilder()
    {
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        return sqlSessionFactoryBuilder;
    }
}