如何以编程方式配置JDBCAppender

   // 创建JDBCAppender

   AppenderComponentBuilder appenderBuilder = builder.newAppender("database", "JDBC")

           .addAttribute("bufferSize", 100)

           .addAttribute("ignoreExceptions", true);

   // 配置数据库连接

   appenderBuilder.add(builder.newComponent("ConnectionFactory")

           .addComponent(builder.newComponent("Jdbc"))

           .addAttribute("url", "jdbc:mysql://localhost:3306/mydb")

           .addAttribute("driverClassName", "com.mysql.jdbc.Driver")

           .addAttribute("username", "root")

           .addAttribute("password", "password"));

   // 配置日志表结构

   appenderBuilder.add(builder.newComponent("Column")

           .addAttribute("name", "eventDate")

           .addAttribute("pattern", "%d{yyyy-MM-dd HH:mm:ss}"));

   appenderBuilder.add(builder.newComponent("Column")

           .addAttribute("name", "level")

           .addAttribute("pattern", "%level"));

   appenderBuilder.add(builder.newComponent("Column")

           .addAttribute("name", "logger")

           .addAttribute("pattern", "%logger"));

   appenderBuilder.add(builder.newComponent("Column")

           .addAttribute("name", "message")

           .addAttribute("pattern", "%message"));

   // 配置日志格式

   LayoutComponentBuilder layoutBuilder = builder.newLayout("PatternLayout")

           .addAttribute("pattern", "%d{yyyy-MM-dd HH:mm:ss} [%t] %-5level %logger{36} - %msg%n");

   appenderBuilder.add(layoutBuilder);

   // 添加Appender到Logger

   builder.add(appenderBuilder);

   // 更新配置

   Configuration configuration = builder.build();

   LoggerContext context = (LoggerContext) LogManager.getContext(false);

   context.start(configuration);

   Configurator.initialize(context);

   Logger logger = LogManager.getLogger(JDBCAppenderExample.class);

   logger.info("This is a JDBCAppender example.");

   // 其他日志记录操作...