////  XPStoreManager.swift//  CoreDataDemo////  Created by xiaopin on 16/9/16.//  Copyright © 2016年 xiaopin.cnblogs.com. All rights reserved.//import CoreData/// 本地数据库管理类：默认是写在AppDelegate的，可以这样分离出来class XPStoreManager {        //单例写法    static let shareInstance = XPStoreManager()        private init() {            }        // MARK: - Core Data stack        lazy var applicationDocumentsDirectory: NSURL = {        // The directory the application uses to store the Core Data store file. This code uses a directory named "com.pinguo.CoreDataDemo" in the application‘s documents Application Support directory.        let urls = NSFileManager.defaultManager().URLsForDirectory(.DocumentDirectory, inDomains: .UserDomainMask)        print("\(urls[urls.count-1])")        return urls[urls.count-1]    }()        lazy var managedObjectModel: NSManagedObjectModel = {        // The managed object model for the application. This property is not optional. It is a fatal error for the application not to be able to find and load its model.        let modelURL = NSBundle.mainBundle().URLForResource("CoreDataDemo", withExtension: "momd")!        return NSManagedObjectModel(contentsOfURL: modelURL)!    }()        lazy var persistentStoreCoordinator: NSPersistentStoreCoordinator = {        // The persistent store coordinator for the application. This implementation creates and returns a coordinator, having added the store for the application to it. This property is optional since there are legitimate error conditions that could cause the creation of the store to fail.        // Create the coordinator and store        let coordinator = NSPersistentStoreCoordinator(managedObjectModel: self.managedObjectModel)        let url = self.applicationDocumentsDirectory.URLByAppendingPathComponent("SingleViewCoreData.sqlite")        var failureReason = "There was an error creating or loading the application‘s saved data."        do {            try coordinator.addPersistentStoreWithType(NSSQLiteStoreType, configuration: nil, URL: url, options: nil)        } catch {            // Report any error we got.            var dict = [String: AnyObject]()            dict[NSLocalizedDescriptionKey] = "Failed to initialize the application‘s saved data"            dict[NSLocalizedFailureReasonErrorKey] = failureReason                        dict[NSUnderlyingErrorKey] = error as NSError            let wrappedError = NSError(domain: "YOUR_ERROR_DOMAIN", code: 9999, userInfo: dict)            // Replace this with code to handle the error appropriately.            // abort() causes the application to generate a crash log and terminate. You should not use this function in a shipping application, although it may be useful during development.            NSLog("Unresolved error \(wrappedError), \(wrappedError.userInfo)")            abort()        }                return coordinator    }()        lazy var managedObjectContext: NSManagedObjectContext = {        // Returns the managed object context for the application (which is already bound to the persistent store coordinator for the application.) This property is optional since there are legitimate error conditions that could cause the creation of the context to fail.        let coordinator = self.persistentStoreCoordinator        var managedObjectContext = NSManagedObjectContext(concurrencyType: .MainQueueConcurrencyType)        managedObjectContext.persistentStoreCoordinator = coordinator        return managedObjectContext    }()        // MARK: - Core Data Saving support        func saveContext () {        if managedObjectContext.hasChanges {            do {                try managedObjectContext.save()            } catch {                // Replace this implementation with code to handle the error appropriately.                // abort() causes the application to generate a crash log and terminate. You should not use this function in a shipping application, although it may be useful during development.                let nserror = error as NSError                NSLog("Unresolved error \(nserror), \(nserror.userInfo)")                abort()            }        }    }    }

func applicationWillTerminate(application: UIApplication) {        // Called when the application is about to terminate. Save data if appropriate. See also applicationDidEnterBackground:.        // Saves changes in the application‘s managed object context before the application terminates.        XPStoreManager.shareInstance.saveContext()    }

////  Student.swift//  CoreDataDemo////  Created by cdmac on 16/9/12.//  Copyright © 2016年 xiaopin.cnblogs.com. All rights reserved.//import Foundationimport CoreDataclass Student: NSManagedObject {    // Insert code here to add functionality to your managed object subclass    /*     一般涉及到的情况有：增删改，单对象查询，分页查询（所有，条件查询，排序），对象是否存在，批量增加，批量修改     */        /// 判断对象是否存在, obj参数是当前属性的字典    class func exsitsObject(obj:[String:String]) -> Bool {                //获取管理数据对象的上下文        let context = XPStoreManager.shareInstance.managedObjectContext        //声明一个数据请求        let fetchRequest = NSFetchRequest(entityName: "Student")                //组合过滤参数        let stuId = obj["stuId"]        let name = obj["name"]                //方式一        let predicate1 = NSPredicate(format: "stuId = %@", stuId!)        let predicate2 = NSPredicate(format: "name = %@", name!)        //合成过滤条件        //or ,and, not , 意思是：或与非，懂数据库的同学应该就很容易明白        let predicate = NSCompoundPredicate(orPredicateWithSubpredicates: [predicate1,predicate2])        //let predicate = NSCompoundPredicate(andPredicateWithSubpredicates: [predicate1,predicate2])        fetchRequest.predicate = predicate                //方式二        //fetchRequest.predicate = NSPredicate(format: "stuId = %@ or name = %@", stuId!, name!)        //fetchRequest.predicate = NSPredicate(format: "stuId = %@ and name = %@", stuId!, name!)                do{            let fetchObjects:[AnyObject]? = try context.executeFetchRequest(fetchRequest)                        return fetchObjects?.count > 0 ? true : false        }catch {            fatalError("exsitsObject \(error)")        }                return false    }        /// 添加对象, obj参数是当前属性的字典    class func insertObject(obj: [String:String]) -> Bool {                //如果存在对象了就返回        if exsitsObject(obj) {            return false        }                //获取管理的数据上下文 对象        let context = XPStoreManager.shareInstance.managedObjectContext                //创建学生对象        let stu = NSEntityDescription.insertNewObjectForEntityForName("Student",                                                                       inManagedObjectContext: context) as! Student        //对象赋值        let sexStr:String        if obj["sex"] == "男"{            sexStr = "1"        }else{            sexStr = "0"        }        let numberFMT = NSNumberFormatter()        numberFMT.numberStyle = .NoStyle        stu.stuId = numberFMT.numberFromString(obj["stuId"]!)        stu.name = obj["name"]        stu.createtime = NSDate()        stu.sex = numberFMT.numberFromString(sexStr)        stu.classId = numberFMT.numberFromString(obj["classId"]!)                //保存        do {            try context.save()            print("保存成功！")            return true        } catch {            fatalError("不能保存：\(error)")        }        return false    }        /// 删除对象    class func deleteObject(obj:Student) -> Bool{                //获取管理的数据上下文 对象        let context = XPStoreManager.shareInstance.managedObjectContext                //方式一: 比如说列表已经是从数据库中获取的对象，直接调用CoreData默认的删除方法        context.deleteObject(obj)        XPStoreManager.shareInstance.saveContext()                //方式二：通过obj参数比如：id,name ,通过这样的条件去查询一个对象一个，把这个对象从数据库中删除        //代码：略                return true    }        /// 更新对象    class func updateObject(obj:[String: String]) -> Bool {        //obj参数说明：当前对象的要更新的字段信息，唯一标志是必须的，其他的是可选属性        let context = XPStoreManager.shareInstance.managedObjectContext                let oid = obj["stuId"]        let student:Student = self.fetchObjectById(Int(oid!)!)! as! Student                //遍历参数，然后替换相应的参数        let numberFMT = NSNumberFormatter()        numberFMT.numberStyle = .NoStyle                for key in obj.keys {            switch key {            case "name":                student.name = obj["name"]            case "classId":                student.classId = numberFMT.numberFromString(obj["classId"]!)            default:                print("如果有其他参数需要修改，类似")            }        }                //执行更新操作        do {            try context.save()            print("更新成功！")            return true        } catch {            fatalError("不能保存：\(error)")        }                return false    }            /// 查询对象    class func fetchObjects(pageIndex:Int, pageSize:Int) -> [AnyObject]? {        //获取管理的数据上下文 对象        let context = XPStoreManager.shareInstance.managedObjectContext                //声明数据的请求        let fetchRequest:NSFetchRequest = NSFetchRequest(entityName: "Student")        fetchRequest.fetchLimit = pageSize //每页大小        fetchRequest.fetchOffset = pageIndex * pageSize //第几页                //设置查询条件:参考exsitsObject        //let predicate = NSPredicate(format: "id= ‘1‘ ", "")        //fetchRequest.predicate = predicate                //设置排序        //按学生ID降序        let stuIdSort = NSSortDescriptor(key: "stuId", ascending: false)        //按照姓名升序        let nameSort = NSSortDescriptor(key: "name", ascending: true)        let sortDescriptors:[NSSortDescriptor] = [stuIdSort,nameSort]        fetchRequest.sortDescriptors = sortDescriptors                //查询操作        do {            let fetchedObjects:[AnyObject]? = try context.executeFetchRequest(fetchRequest)                        //遍历查询的结果            /*            for info:Student in fetchedObjects as! [Student]{                print("id=\(info.stuId)")                print("name=\(info.name)")                print("sex=\(info.sex)")                print("classId=\(info.classId)")                print("createTime=\(info.createtime)")                print("-------------------")                            }             */            return fetchedObjects        }        catch {            fatalError("不能保存：\(error)")        }        return nil    }            /// 根据ID查询当个对象    class func fetchObjectById(oid:Int) -> AnyObject?{                //获取上下文对象        let context = XPStoreManager.shareInstance.managedObjectContext                //创建查询对象        let fetchRequest:NSFetchRequest = NSFetchRequest(entityName: "Student")                //构造参数        fetchRequest.predicate = NSPredicate(format: "stuId = %@", String(oid))                //执行代码并返回结果        do{            let results:[AnyObject]? = try context.executeFetchRequest(fetchRequest)                        if results?.count > 0 {                return results![0]            }        }catch{            fatalError("查询当个对象致命错误：\(error)")        }                return nil    }}

////  ViewController.swift//  CoreDataDemo////  Created by cdmac on 16/9/11.//  Copyright © 2016年 pinguo. All rights reserved.//import UIKitlet cellIdentifiler = "ReuseCell"class ViewController: UIViewController {    @IBOutlet weak var txtNo: UITextField!    @IBOutlet weak var txtName: UITextField!    @IBOutlet weak var txtSex: UITextField!    @IBOutlet weak var txtClassId: UITextField!    @IBOutlet weak var tableView: UITableView!    var dataArray:[AnyObject]?        override func viewDidLoad() {        super.viewDidLoad()        // Do any additional setup after loading the view, typically from a nib.        self.dataArray = Student.fetchObjects(0, pageSize: 20)        self.tableView.reloadData()    }    override func didReceiveMemoryWarning() {        super.didReceiveMemoryWarning()        // Dispose of any resources that can be recreated.    }    @IBAction func addAction(sender: AnyObject) {        var dic = [String:String]()                dic["stuId"] = txtNo.text        dic["name"] = txtName.text        dic["sex"] = txtSex.text        dic["classId"] = txtClassId.text                if Student.insertObject(dic) {            print("添加成功")            self.dataArray = Student.fetchObjects(0,pageSize: 20)                        self.tableView.reloadData()        }else{            print("添加失败")        }    }        @IBAction func updateAction(sender: AnyObject) {                var dic = [String:String]()                dic["stuId"] = txtNo.text        dic["name"] = txtName.text        //dic["sex"] = txtSex.text        dic["classId"] = txtClassId.text                if Student.updateObject(dic) {            print("更新成功")            self.dataArray = Student.fetchObjects(0,pageSize: 20)                        self.tableView.reloadData()        }else{            print("更新失败")        }            }    }extension ViewController:UITableViewDelegate,UITableViewDataSource{        //表格有多少组    func numberOfSectionsInTableView(tableView: UITableView) -> Int {        return 1    }        //每组多少行    func tableView(tableView: UITableView, numberOfRowsInSection section: Int) -> Int {        if self.dataArray != nil && self.dataArray?.count > 0 {            return self.dataArray!.count        }        return 0    }        //高度    func tableView(tableView: UITableView, heightForRowAtIndexPath indexPath: NSIndexPath) -> CGFloat {        return 50    }        //单元格加载    func tableView(tableView: UITableView, cellForRowAtIndexPath indexPath: NSIndexPath) -> UITableViewCell {        let cell = tableView.dequeueReusableCellWithIdentifier(cellIdentifiler)                let stu:Student = self.dataArray![indexPath.row] as! Student                let label1:UILabel = cell?.contentView.viewWithTag(10001) as! UILabel        let label2:UILabel = cell?.contentView.viewWithTag(10002) as! UILabel        var sexStr = "男"        if stu.sex?.intValue != 1 {            sexStr = "女"        }        label1.text = "\(stu.stuId!) \(stu.name!) \(sexStr) \(stu.classId!)"        label2.text = "http://xiaopin.cnblogs.com"                return cell!    }        //选中    func tableView(tableView: UITableView, didSelectRowAtIndexPath indexPath: NSIndexPath) {            }        func tableView(tableView: UITableView, canEditRowAtIndexPath indexPath: NSIndexPath) -> Bool {        return true    }        func tableView(tableView: UITableView, commitEditingStyle editingStyle: UITableViewCellEditingStyle, forRowAtIndexPath indexPath: NSIndexPath) {        if editingStyle == .Delete {            //获取当前对象            let student:Student = self.dataArray![indexPath.row] as! Student                        //删除本地存储            Student.deleteObject(student)                        //刷新数据源            self.dataArray?.removeAtIndex(indexPath.row)            //self.dataArray = Student.fetchObjects(0, pageSize: 20)                        //删除单元格            tableView.deleteRowsAtIndexPaths([indexPath], withRowAnimation: .Automatic)        }    }        func tableView(tableView: UITableView, editingStyleForRowAtIndexPath indexPath: NSIndexPath) -> UITableViewCellEditingStyle {        return .Delete    }        func tableView(tableView: UITableView, titleForDeleteConfirmationButtonForRowAtIndexPath indexPath: NSIndexPath) -> String? {        return "删除"    }}