在fmdb中从本地数据库访问数据

let database = FMDatabase(path: databasePath)
if database.open() {
    // 数据库连接成功
} else {
    // 数据库连接失败
}

let resultSet = try database.executeQuery("SELECT * FROM table", values: nil)
while resultSet.next() {
    // 处理查询结果
    let column1 = resultSet.string(forColumn: "column1")
    let column2 = resultSet.int(forColumn: "column2")
    // ...
}
resultSet.close()

let success = database.executeUpdate("INSERT INTO table (column1, column2) VALUES (?, ?)", withArgumentsIn: ["value1", 2])
if success {
    // 更新成功
} else {
    // 更新失败
}

database.close()