Swift的SQLite :插入到SELECT中不起作用

// 假设有一个表名为"users"，包含"id"和"name"两个字段

// 执行插入操作
let insertStatement = "INSERT INTO users (id, name) VALUES (?, ?)"
if sqlite3_prepare_v2(database, insertStatement, -1, &insertStatement, nil) == SQLITE_OK {
    let id: Int32 = 1
    let name: NSString = "John"
    
    sqlite3_bind_int(insertStatement, 1, id)
    sqlite3_bind_text(insertStatement, 2, name.utf8String, -1, nil)
    
    if sqlite3_step(insertStatement) == SQLITE_DONE {
        print("数据插入成功")
    } else {
        print("数据插入失败")
    }
}

// 执行SELECT操作
let selectStatement = "SELECT * FROM users"
if sqlite3_prepare_v2(database, selectStatement, -1, &selectStatement, nil) == SQLITE_OK {
    while sqlite3_step(selectStatement) == SQLITE_ROW {
        let id = sqlite3_column_int(selectStatement, 0)
        let name = String(cString: sqlite3_column_text(selectStatement, 1))
        
        print("id: \(id), name: \(name)")
    }
}