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
