//數(shù)據(jù)庫存放路徑
let sqlitepath = NSHomeDirectory().stringByAppendingPathComponent("Documents/sqlite3.db")
//打開數(shù)據(jù)庫，指定數(shù)據(jù)庫文件路徑，如果文件不存在后先創(chuàng)建文件，再打開，所以無需手動(dòng)創(chuàng)建文件
let state = sqlite3_open(sqlitepath, &db)
if state == SQLITE_OK{
 println("打開數(shù)據(jù)庫成功")
}else{
 println("打開數(shù)據(jù)庫失敗")
}

var db:COpaquePointer = nil
override func viewDidLoad() {
 super.viewDidLoad()
 ...
}

//創(chuàng)建表
let createtable = "create table if not exists students (id integer primary key autoincrement,name
text,stuId integer)"
let result = sqlite3_exec(db, createtable, nil, nil, nil)
if result == SQLITE_OK{
 println("創(chuàng)建表成功")
}
//刪除表
let removetable = "drop table studets"
let result2 = sqlite3_exec(db, removetable, nil, nil, nil)
if result2 == SQLITE_OK{
 println("刪除表成功")
}

//插入數(shù)據(jù)
let inserttable = "insert into studets (stuId,name) values(?,?)"
var statement:COpaquePointer = nil
let result3 = sqlite3_prepare_v2(db, inserttable, -1, &statement, nil)
if result3 == SQLITE_OK{
 //綁定數(shù)據(jù)
 sqlite3_bind_int(statement, 1, 1)
 sqlite3_bind_text(statement, 2, "lijialong", -1, nil)
 
 //執(zhí)行
 if sqlite3_step(statement) == SQLITE_DONE{
  println("數(shù)據(jù)插入成功")
 }
 sqlite3_finalize(statement)
 }

let updatetable = "update studets set name ='ss' where id = 1"
var statement:COpaquePointer = nil
sqlite3_prepare_v2(db, updatetable, -1, &statement, nil)
sqlite3_step(statement)
sqlite3_finalize(statement)

let deleterow = "delete from studets where name='lijialong'"
sqlite3_prepare_v2(db, deleterow, -1, &statement, nil)
sqlite3_step(statement)
sqlite3_finalize(statement)

//查詢數(shù)據(jù)
let query = "select * from studets"
//這條執(zhí)行后，數(shù)據(jù)就已經(jīng)在sattement中了
sqlite3_prepare_v2(db, query, -1, &statement, nil)
//游標(biāo)往下走一步，如果返回SQLITE_ROW就進(jìn)入
while sqlite3_step(statement) == SQLITE_ROW{
 let id = sqlite3_column_int(statement, 0)
 let stuId = sqlite3_column_int(statement, 2)
}