Swift代碼庫之完整的數(shù)據(jù)讀取代碼
很多新手經(jīng)常會困惑欺劳，如何存儲和讀取數(shù)據(jù)呢圈匆？
最佳的解決方案就是使用Sqlite。下面我就介紹一個讀取數(shù)據(jù)的小例子
數(shù)據(jù)長成什么樣
sqlite數(shù)據(jù)庫截圖
讀取代碼
func readData(){
//Query de SELECT
let queryString = "SELECT * FROM mword limit 10"
//Statement pointer
var stmt:OpaquePointer?
//Prearando el query
if sqlite3_prepare(db, queryString, -1, &stmt, nil) != SQLITE_OK{
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("error preparing insert: \(errmsg)")
return
}
var wordList = [FRWord]()
//Leyendo registros
while(sqlite3_step(stmt) == SQLITE_ROW){
let id = sqlite3_column_int(stmt, 0)
let mkey = String(cString: sqlite3_column_text(stmt, 1))
let tupian = String(cString: sqlite3_column_text(stmt, 2))
let bushou = String(cString: sqlite3_column_text(stmt, 3))
let guwen = String(cString: sqlite3_column_text(stmt, 4))
let pinyin = String(cString: sqlite3_column_text(stmt, 5))
let juanbie = String(cString: sqlite3_column_text(stmt, 6))
let bsbihua = sqlite3_column_int(stmt, 7)
let fbihua = sqlite3_column_int(stmt, 8)
let zbihua = sqlite3_column_int(stmt, 9)
let duyin = String(cString: sqlite3_column_text(stmt, 10))
let lizi = String(cString: sqlite3_column_text(stmt, 11))
print("\(id),\(mkey),\(pinyin),\(zbihua)")
}
}
}
輸出結(jié)果
輸出結(jié)果
