如何在GTK TreeView中显示SQLite数据库中的数据？

#include <gtk/gtk.h>
#include <sqlite3.h>

// 回调函数，用于关闭窗口
static void destroy(GtkWidget *widget, gpointer data)
{
    gtk_main_quit();
}

int main(int argc, char *argv[])
{
    // 初始化GTK
    gtk_init(&argc, &argv);

    // 创建窗口
    GtkWidget *window = gtk_window_new(GTK_WINDOW_TOPLEVEL);
    g_signal_connect(window, "destroy", G_CALLBACK(destroy), NULL);

    // 创建TreeView
    GtkWidget *treeview = gtk_tree_view_new();

    // 创建TreeModel
    GtkListStore *store = gtk_list_store_new(2, G_TYPE_STRING, G_TYPE_STRING);

    // 连接到SQLite数据库
    sqlite3 *db;
    sqlite3_open("example.db", &db);

    // 执行SQL查询语句
    sqlite3_stmt *stmt;
    sqlite3_prepare_v2(db, "SELECT * FROM table", -1, &stmt, NULL);

    // 将查询结果添加到TreeModel中
    while (sqlite3_step(stmt) == SQLITE_ROW)
    {
        const char *col1 = sqlite3_column_text(stmt, 0);
        const char *col2 = sqlite3_column_text(stmt, 1);

        GtkTreeIter iter;
        gtk_list_store_append(store, &iter);
        gtk_list_store_set(store, &iter, 0, col1, 1, col2, -1);
    }

    // 关闭查询
    sqlite3_finalize(stmt);

    // 关闭数据库连接
    sqlite3_close(db);

    // 将TreeModel设置为TreeView的Model
    gtk_tree_view_set_model(GTK_TREE_VIEW(treeview), GTK_TREE_MODEL(store));

    // 创建并添加列
    GtkCellRenderer *renderer = gtk_cell_renderer_text_new();
    GtkTreeViewColumn *column = gtk_tree_view_column_new_with_attributes("Column 1", renderer, "text", 0, NULL);
    gtk_tree_view_append_column(GTK_TREE_VIEW(treeview), column);

    renderer = gtk_cell_renderer_text_new();
    column = gtk_tree_view_column_new_with_attributes("Column 2", renderer, "text", 1, NULL);
    gtk_tree_view_append_column(GTK_TREE_VIEW(treeview), column);

    // 将TreeView添加到窗口中
    gtk_container_add(GTK_CONTAINER(window), treeview);

    // 显示窗口和数据
    gtk_widget_show_all(window);

    // 进入GTK主循环
    gtk_main();

    return 0;
}