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

偏执的太偏执、 2024-03-24 20:42 42阅读 0赞

>     引入内容需要参照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>
>             
>             <mapper resource="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>
>             
>             <mapper resource="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>
>         
>         
>         <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>
>         
>         
>         <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;
>         }
>     }