springboot日志写入mysql_SpringBoot 2.0 | Log4j2 日志写入数据库

1.建立存储用户登录日志表

create table `log`(

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(255) DEFAULT NULL,

`userIP` varchar(255) DEFAULT NULL,

`actionClassName` varchar(6000) DEFAULT NULL,

`actionDate` varchar(255) DEFAULT NULL,

`result` varchar(6000) DEFAULT NULL,

PRIMARY KEY(`id`)

)ENGINE=InnoDB AUTO_INCREMENT =1 DEFAULT CHARSET = utf8;

2.添加maven依赖

org.apache.logging.log4j

log4j-api

2.11.1

org.apache.logging.log4j

log4j-core

2.11.1

com.alibaba

druid

1.0.14

3.配置拦截器Filter

package com.hly.sirius.filter;

/**

* @author :hly

* @github :github.com/SiriusHly

* @blog :blog.csdn.net/Sirius_hly

* @date :2018/10/2

*/