如何使用嵌入式接口在QuestDB中追加行？

import io.questdb.cairo.CairoEngine;
import io.questdb.cairo.TableWriter;
import io.questdb.cairo.sql.Record;
import io.questdb.cairo.sql.RecordCursor;
import io.questdb.cairo.sql.RecordMetadata;
import io.questdb.cairo.sql.RecordSink;
import io.questdb.cairo.sql.RecordSinkFactory;
import io.questdb.std.FilesFacade;
import io.questdb.std.FilesFacadeImpl;
import io.questdb.std.str.Path;

public class QuestDBExample {
    public static void main(String[] args) {
        // 创建数据库连接对象
        CairoEngine engine = new CairoEngine(new FilesFacadeImpl());

        // 指定数据库路径
        Path path = new Path();
        path.of("path/to/questdb");

        // 创建表对象
        TableWriter writer = engine.getWriter(path, "my_table");

        // 定义表的列
        writer.addColumn("column1", "INT");
        writer.addColumn("column2", "STRING");

        // 创建行对象
        Record record = writer.newRow();

        // 设置行的列值
        record.putInt(0, 123);
        record.putStr(1, "Hello, QuestDB!");

        // 插入行到表中
        writer.append(record);

        // 关闭表和数据库连接
        writer.close();
        engine.close();
    }
}