我在绑定(bind)和插入数据或检索数据时遇到问题。老实说，我不确定如何确定导致问题的原因。我正在尝试使用以下代码将 textfield、latitude 和 longitude 添加到数据库中。我几乎肯定问题出在 sqlite3_bind_text 或 sqlite3_column_text 函数上，但我将这两个函数完整地包含在上下文中。当我运行调试打印语句时，每个值都作为经度值打印出来。几乎好像经度值正在覆盖其他两列？我传递 latitude 和 longitude 的方式绑定(bind)不正确吗？还是我检索数据不正确？

@IBAction func submitPressed(_sender: UIButton) {

    var lat = ""
    var long = ""

    if(isLocationEnabled.isOn == true){
        enableLocationManager()
        let location:CLLocationCoordinate2D = locationManager.location!.coordinate
        lat = String(location.latitude)
        long = String(location.longitude)
        print(lat)
        print(long)

    } else {
        disableLocationManager()
        lat = "44.5"
        long = "-123.2"
    }

    let text = textEntered.text?.trimmingCharacters(in: .whitespacesAndNewlines)


    if(text?.isEmpty)!{
        textEntered.layer.borderColor = UIColor.red.cgColor
    }

    var statement: OpaquePointer?

    let newQuery = "INSERT INTO Location (textEntered, latitude, longitude) VALUES (?,?,?)"

    if sqlite3_prepare(database, newQuery, -1, &statement, nil) != SQLITE_OK {
        let error = String(cString: sqlite3_errmsg(database)!)
        print("Error Preparing: \(error)")
        return
    }

    if sqlite3_bind_text(statement, 1, text, -1, nil) != SQLITE_OK {
        let error = String(cString: sqlite3_errmsg(database)!)
        print("Error Binding: \(error)")
        return
    }

    if sqlite3_bind_text(statement, 2, lat, -1, nil) != SQLITE_OK {
        let error = String(cString: sqlite3_errmsg(database)!)
        print("Error Binding: \(error)")
        return
    }

    if sqlite3_bind_text(statement, 3, long, -1, nil) != SQLITE_OK {
        let error = String(cString: sqlite3_errmsg(database)!)
        print("Error Binding: \(error)")
        return
    }

    if sqlite3_step(statement) != SQLITE_DONE {
        let error = String(cString: sqlite3_errmsg(database)!)
        print("Error Inserting: \(error)")
        return
    }

    textEntered.text = ""

然后，我尝试使用以下代码检索它:

func readValues() {
    posts.removeAll()

    let newQuery = "SELECT id, textEntered, latitude, longitude FROM Location"

    var statement: OpaquePointer?

    if sqlite3_prepare(database, newQuery, -1, &statement, nil) != SQLITE_OK {
        let error = String(cString: sqlite3_errmsg(database)!)
        print(error)
    }

    while(sqlite3_step(statement) == SQLITE_ROW) {
        let id = sqlite3_column_int(statement,0)
        let textEntered = String(cString: sqlite3_column_text(statement,1))
        let latitude = String(cString: sqlite3_column_text(statement,2))
        let longitude = String(cString: sqlite3_column_text(statement,3))


        print("Text Entered: \(textEntered)")
        print("Latitude: \(latitude)")
        print("Longitude: \(longitude)")

        posts.append(Post(id: Int(id),textEntered: String(describing: textEntered), latitude: String(describing: latitude), longitude: String(describing: longitude)))
    }

    self.tableViewPosts.reloadData()

}

编辑:我能够确定插入件中存在缺陷。当我通过 DB Browser 查看 SQLite 数据库时，我看到经度值被插入到所有列中。我只是不确定我的语法在 sqlite3_bind_text 中哪里有缺陷。

最佳答案

我发现 sqlite3_bind_text 有问题。我从

if sqlite3_bind_text(statement, 1, text, -1, nil) != SQLITE_OK {
        let error = String(cString: sqlite3_errmsg(database)!)
        print("Error Binding: \(error)")
        return
}

到

 if sqlite3_bind_text(statement, 1, text, -1, SQLITE_TRANSIENT) != SQLITE_OK {
            let error = String(cString: sqlite3_errmsg(database)!)
            print("Error Binding: \(error)")
            return
}

其中 SQLITE_TRANSIENT 定义为

let SQLITE_TRANSIENT = unsafeBitCast(OpaquePointer(bitPattern: -1), to: sqlite3_destructor_type.self)

关于ios - SQLite Swift 绑定(bind)和检索，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/48859139/