???在OC項(xiàng)目中我一直使用LKDBHelper這個(gè)數(shù)據(jù)庫(kù)框架岸军，深度封裝FMDB苟弛，使用起來(lái)感受不到數(shù)據(jù)庫(kù)的存在，但又會(huì)讓你更直觀的了解表關(guān)系红竭，總體來(lái)說(shuō)是一個(gè)很棒的框架。在這也不作過(guò)多介紹喘落，直接上代碼茵宪。
- 因?yàn)長(zhǎng)KDBHelper是OC庫(kù)，雖加了Swift支持瘦棋，但在Swift3中完全封閉了dispatch_once的單例機(jī)制稀火，暫且找不到重寫(xiě)OC單例的方法，致使不能夠達(dá)到自定義數(shù)據(jù)庫(kù)路徑和數(shù)據(jù)庫(kù)名的情況出現(xiàn)赌朋。所以我暫時(shí)采用的是OC跟Swift混編凰狞，以O(shè)C類(lèi)作為基類(lèi)，Swift類(lèi)繼承OC類(lèi)的方法在OC類(lèi)中重寫(xiě)類(lèi)方法getUsingLKDBHelper從而實(shí)現(xiàn)能夠獲取LKDBHelper單例的辦法暫時(shí)解決沛慢。如有更好的解決方法歡迎各路大牛指點(diǎn)赡若。
創(chuàng)建OCbase類(lèi)，系統(tǒng)自動(dòng)生成橋接文件
#import "ocBaseModel.h"
#import "LKDBHelper.h"
@implementation ocBaseModel
//重寫(xiě)父類(lèi)方法
+ (LKDBHelper *)getUsingLKDBHelper
{
static LKDBHelper* db;
//創(chuàng)建helper單例
static dispatch_once_t onceToken;
dispatch_once(&onceToken, ^{
NSString *sqlitePath = [ocBaseModel downloadPath];
NSString *dbpath = [sqlitePath stringByAppendingPathComponent:[NSString stringWithFormat:@"JCMsgDB.db"]];
db = [[LKDBHelper alloc]initWithDBPath:dbpath];
});
return db;
}
//拼接數(shù)據(jù)庫(kù)保存路徑
+ (NSString *)downloadPath
{
NSString *documentPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)firstObject];
NSString *downloadPath = [documentPath stringByAppendingString:@""];
NSLog(@"downloadPath = %@---",downloadPath);
return downloadPath;
}
橋接文件团甲，Cocopod已經(jīng)支持swift橋接逾冬，不需在項(xiàng)目橋接文件導(dǎo)入
#ifndef addressBook_Bridging_Header_h
#define addressBook_Bridging_Header_h
#import "ocBaseModel.h"
#endif
創(chuàng)建SwiftContact類(lèi)繼承自ocBaseModel，并重寫(xiě)
import UIKit
class contactDBModel: ocBaseModel {
var contactID:Int = 0
var name:String?
var phoneNum:String?
init(name:String,phoneNum:String) {
self.name = name
self.phoneNum = phoneNum
super.init()
}
//重寫(xiě)父類(lèi)init方法
override init() {
super.init()
}
override class func getPrimaryKey() -> String {
return "contactID"
}
override class func getTableName() -> String {
return "contactList"
}
override class func isContainParent() -> Bool{
return true
}
}
簡(jiǎn)單CRUD操作
import UIKit
import LKDBHelper
class mainViewController: UIViewController {
var dbHelper:LKDBHelper?
override func viewDidLoad() {
super.viewDidLoad()
//基本使用
//通過(guò)類(lèi)方法獲取helper單例
self.dbHelper = contactDBModel.getUsingLKDBHelper()
//增
var contact1 = contactDBModel(name: "張三", phoneNum: "13888889998")
//插入
contact1.saveToDB()
//查
let searchResultArray = contactDBModel.search(withWhere:["name":"張三"], orderBy: nil, offset: 0, count: 0);
//改
var contactResult:contactDBModel = searchResultArray?.firstObject as! contactDBModel
contactResult.name = "李四"
contactResult.updateToDB()
//刪
let searchResultArray1 = contactDBModel.search(withWhere:["phoneNum":"13888889998"], orderBy: nil, offset: 0, count: 0);
var contactResult1:contactDBModel = searchResultArray?.firstObject as! contactDBModel
contactResult1.deleteToDB()
}
}
gitHub-- https://github.com/cenzuen/swiftAddressBook.git
歡迎指點(diǎn)
