log4j可以支持将log输出到文件,数据库,甚至远程服务器,这次给大家分享下如何输出到mysql中。
项目截图:
运行截图:
mysql存储截图:
mysql建表语句:
- create database `zuidaima_log4j_write_mysql`;
- use `zuidaima_log4j_write_mysql`;
- CREATE TABLE `zuidaima_log` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `create_time` datetime NOT NULL,
- `log` varchar(200) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
create database `zuidaima_log4j_write_mysql`;
use `zuidaima_log4j_write_mysql`;
CREATE TABLE `zuidaima_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`create_time` datetime NOT NULL,
`log` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
代码下载: http://www.zuidaima.com/share/1621277092793344.htm