springboot项目，logback日志写入数据库配置

忘是亡心i 2022-05-17 00:53 324阅读 0赞

直接进入主题：

一、引入数据库连接池

<dependency>
       <groupId>commons-dbcp</groupId>
       <artifactId>commons-dbcp</artifactId>
       <version>1.4</version>
    </dependency>
    <dependency>
       <groupId>commons-pool</groupId>
       <artifactId>commons-pool</artifactId>
       <version>1.6</version>
    </dependency>

2.logback-spring.xml引入新的appender

<appender name="DBLog" class="ch.qos.logback.classic.db.DBAppender">
        <connectionSource class="ch.qos.logback.core.db.DataSourceConnectionSource">
            <dataSource class="org.apache.commons.dbcp.BasicDataSource">
                <driverClassName>com.mysql.jdbc.Driver</driverClassName>
                <url>jdbc:mysql://127.0.0.1:3306/y2fe?characterEncoding=UTF-8</url>
                <username>root</username>
                <password>root</password>
            </dataSource>
        </connectionSource>
    </appender>

3.数据库建表，直接上建表代码

BEGIN;  
DROP TABLE IF EXISTS logging\_event\_property;  
DROP TABLE IF EXISTS logging\_event\_exception;  
DROP TABLE IF EXISTS logging\_event;  
COMMIT;

BEGIN;  
CREATE TABLE logging\_event   
  (  
    timestmp         BIGINT NOT NULL,  
    formatted\_message  TEXT NOT NULL,  
    logger\_name       VARCHAR(254) NOT NULL,  
    level\_string      VARCHAR(254) NOT NULL,  
    thread\_name       VARCHAR(254),  
    reference\_flag    SMALLINT,  
    arg0              VARCHAR(254),  
    arg1              VARCHAR(254),  
    arg2              VARCHAR(254),  
    arg3              VARCHAR(254),  
    caller\_filename   VARCHAR(254) NOT NULL,  
    caller\_class      VARCHAR(254) NOT NULL,  
    caller\_method     VARCHAR(254) NOT NULL,  
    caller\_line       CHAR(4) NOT NULL,  
    event\_id          BIGINT NOT NULL AUTO\_INCREMENT PRIMARY KEY  
  );  
COMMIT;

BEGIN;  
CREATE TABLE logging\_event\_property  
  (  
    event\_id       BIGINT NOT NULL,  
    mapped\_key        VARCHAR(254) NOT NULL,  
    mapped\_value      TEXT,  
    PRIMARY KEY(event\_id, mapped\_key),  
    FOREIGN KEY (event\_id) REFERENCES logging\_event(event\_id)  
  );  
COMMIT;

BEGIN;  
CREATE TABLE logging\_event\_exception  
  (  
    event\_id         BIGINT NOT NULL,  
    i                SMALLINT NOT NULL,  
    trace\_line       VARCHAR(254) NOT NULL,  
    PRIMARY KEY(event\_id, i),  
    FOREIGN KEY (event\_id) REFERENCES logging\_event(event\_id)  
  );  
COMMIT;

4.log的日志都会输入到数据库