1.配置文件
<appenders>
<!--写入数据库配置,在Logger中设置日志级别为INFO ,tableName对应的数据库日志表-->
<JDBC name="Log2DataBaseInfo" tableName="T_OPTLOG">
<!-- 获取数据库连接对象 -->
<ConnectionFactory class="xxxxx.utils.DBConnectionFactory"
method="getDruidConnection" />
<!-- 数据库字段,和表字段一一对应 -->
<ColumnMapping name="inserttime" />
<ColumnMapping name="userid" />
<ColumnMapping name="clientip" />
<ColumnMapping name="url" />
<MessageLayout />
</JDBC>
</appenders>
<loggers>
<logger name="logger4database" level="info" additivity="false">
<appender-ref ref="Log2DataBaseInfo" level="INFO" />
</logger>
</loggers>
2.java代码
MapMessage logMap = new MapMessage();
logMap.put("inserttime", log.getResponseTime());
logMap.put("userid", log.getUserid());
logMap.put("clientip", log.getClientIp());
logMap.put("url", log.getServletPath());
logger4database.info(logMap);