用于spring boot应用程序的Logback自定义数据库附加器

<dependency>
    <groupId>ch.qos.logback</groupId>
    <artifactId>logback-classic</artifactId>
    <version>2.0.0</version>
</dependency>
<dependency>
    <!-- 添加你使用的数据库驱动依赖 -->
</dependency>

# 配置数据库连接信息
spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
spring.datasource.username=username
spring.datasource.password=password

# 配置Logback的数据库附加器
logging.level.root=INFO
logging.level.com.example=DEBUG
logging.config=classpath:logback.xml

<configuration>
    <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">
            <driverClass>com.mysql.jdbc.Driver</driverClass>
            <url>jdbc:mysql://localhost:3306/mydatabase</url>
            <user>username</user>
            <password>password</password>
        </connectionSource>
        <sqlDialect class="ch.qos.logback.core.db.dialect.MySQLDialect" />
    </appender>

    <root level="INFO">
        <appender-ref ref="DB" />
    </root>
</configuration>

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class MyService {
    private static final Logger logger = LoggerFactory.getLogger(MyService.class);

    public void doSomething() {
        logger.info("This is an info message");
        logger.error("This is an error message");
    }
}