第一遍
(不完全)封装SQLite工具,使用该工具,可以实现对模型数据的增删改查.
注意:SQLite数据库中是不区分大小写的;
import UIKit
class SQLiteTool: NSObject {
static let shareinstance = SQLiteTool()
var db : COpaquePointer = nil
override init() {
super.init()
openDB()
}
func openDB() -> Void {
let sql = "/Users/lizhanpeng/Desktop/dataBase/demo.sqlite"
if sqlite3_open(sql, &db) != SQLITE_OK{
print("打开数据库失败")
}else{
print("打开数据库成功")
}
}
func createTable() -> Void {
let sql = "create table if not exists t_student (name text, age integer ,id integer)"
if execSQlite(sql){
print("创建表格成功")
}else{
print("创建表格失败")
}
}
func dropTable() -> Void {
let sql = "drop table if exists t_student"
if execSQlite(sql){
print("删除表格成功")
}else{
print("删除表格失败")
}
}
func alterTable() -> Void {
let sql = "alter table t_person add column cL text"
if execSQlite(sql){
print("修改表格成功")
}else{
print("修改表格失败")
}
}
func execSQlite(sql : String) -> Bool {
return (sqlite3_exec(db, sql, nil, nil, nil) == SQLITE_OK)
}
}
第二篇
代码定义的是Student模型;
import UIKit
class Student: NSObject {
var name : String = ""
var age : Int = 0
var score : Double = 0
override init() {
}
init(name : String,age : Int,score : Double) {
self.name = name
self.age = age
self.score = score
}
func insertStu() -> Bool {
let sql = "insert into t_person(name,age,score) values ('\(name)',\(age),\(score))"
return SQLiteTool.shareinstance.execSQlite(sql)
}
func deleteStu() -> Bool {
let sql = "delete from t_person where name = '\(name)'"
return SQLiteTool.shareinstance.execSQlite(sql)
}
func updateStu(newStu : Student) -> Bool {
let sql = "update t_person set name = '\(newStu.name)',age = \(newStu.age),score = \(newStu.score)"
return SQLiteTool.shareinstance.execSQlite(sql)
}
}
第三遍
下面代码是在控制器中实例化student对象,进行数据库操作
注意:实例化的一个student对象,即为一个模型
class ViewController: UIViewController {
override func touchesBegan(touches: Set<UITouch>, withEvent event: UIEvent?) {
let stu = Student(name: "Batac", age: 19, score: 99)
stu.insertStu()
let newStu = Student(name: "Batac_Lee", age: 20, score: 100)
newStu.updateStu(newStu)
}
}