log4j 日志输出数据库

public void jdbcCreateTable() throws Exception { Connection connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=true&serverTimezone=UTC", "root", ""); Class.forName("com.mysql.cj.jdbc.Driver"); connection.createStatement().execute("CREATE TABLE `log_info` ( " + " `Id` int(11) NOT NULL AUTO_INCREMENT, " + " `level` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘优先级‘, " + " `category` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘类目‘, " + " `thread` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘进程‘, " + " `time` varchar(30) NOT NULL DEFAULT ‘‘ COMMENT ‘时间‘, " + " `location` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘位置‘, " + " `note` text COMMENT ‘日志信息‘, " + " PRIMARY KEY (`Id`) " + ")"); }

四：添加测试代码

/***
 * 
 * @author zhanchaohan
 *
 */
public class PrintTest {
    private static Logger logger = Logger.getLogger(PrintTest.class);

    public static void main(String[] args) throws Exception {
        PropertyConfigurator.configure(PrintTest.class.getResource("/log4j.properties"));
        
        logger.info("普通Info信息");
        logger.debug("调试debug信息");
        logger.error("报错error信息");
        logger.warn("警告warn信息");
        logger.fatal("严重错误fatal信息");
    }
}

 

log4j 日志输出数据库

标签：depend   pid   sql   tco   etl   调试   connector   pen   user