é
ç½®log4j2æ¥å¿è®°å½è³æ°æ®åº
1ã建ç«ç¨äºä¿åæ¥å¿çæ°æ®åºè¡¨ï¼
CREATE TABLE `sys_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` varchar(32) NOT NULL,
`logger` varchar(100) NOT NULL,
`message` varchar(1000) DEFAULT NULL,
`exception` varchar(10000) DEFAULT NULL,
`date_add` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;
2ãé
ç½® databaseAppender ï¼
<JDBC name="databaseAppender" tableName="sys_log">
<ConnectionFactory class="cc.s2m.web.s2mBlog.util.StaticProp" method="getDatabaseConnection" />
<Column name="date_add" isEventTimestamp="true" />
<Column name="level" pattern="%level" />
<Column name="logger" pattern="%logger" />
<Column name="message" pattern="%message" />
<Column name="exception" pattern="%ex{full}" />
</JDBC>
3ãå
¶ä¸ cc.s2m.web.s2mBlog.util.StaticProp ç±»çgetDatabaseConnectionæ¹æ³ä¸ºè·åå¯ç¨çdatasourceï¼
DriverManagerDataSource ds = new DriverManagerDataSource();
ds.setDriverClassName("com.mysql.jdbc.Driver");
ds.setUrl("jdbc:mysql://127.0.0.1/s2mBlog?characterEncoding=utf8");
ds.setUsername("root");
ds.setPassword("123456");
return ds.getConnection();
4ãææ´¾éè¦è®°å½çæ¥å¿ï¼ä½¿ç¨ databaseAppender å³å¯ï¼
<logger name="SYSLOG" level="INFO" additivity="false">
<appender-ref ref="databaseAppender"/>
</logger>