在java中使用log4j2 jdbc附加器进行自定义日志记录

<dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-core</artifactId>
    <version>2.x.x</version>
</dependency>
<dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-api</artifactId>
    <version>2.x.x</version>
</dependency>
<dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-jdbc</artifactId>
    <version>2.x.x</version>
</dependency>

<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="INFO">
    <Appenders>
        <JDBC name="databaseAppender" tableName="logs">
            <ConnectionFactory class="your.database.ConnectionFactoryClass">
                <!-- 数据库连接配置 -->
            </ConnectionFactory>
            <Column name="timestamp" literal="CURRENT_TIMESTAMP" />
            <Column name="level" pattern="%level" />
            <Column name="logger" pattern="%logger" />
            <Column name="message" pattern="%message" />
        </JDBC>
    </Appenders>
    <Loggers>
        <Root level="info">
            <AppenderRef ref="databaseAppender" />
        </Root>
    </Loggers>
</Configuration>

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

public class MyClass {
    private static final Logger logger = LogManager.getLogger(MyClass.class);

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