FMDB的简单应用

    // 加载或新建数据库文件(boundle路径)
    NSString *path = [[ NSBundle mainBundle ] pathForResource : @"DB" ofType : @"sqlite" ];
   //沙盒路径
    NSString *newPath = [ NSHomeDirectory () stringByAppendingString : @"/Documents/newDB.db" ];
    NSLog ( @"%@" ,newPath);

//将boundle路径复制到沙盒路径
    BOOL isSuc = [[ NSFileManager defaultManager ] copyItemAtPath :path toPath :newPath error : nil ];
    NSLog ( @"%d" ,isSuc);
   
    FMDatabase *db = [ FMDatabase databaseWithPath :newPath];
   
    _db = db;
    // 打开数据库文件
    if ([db open ]) {
       
        FMResultSet *set = [db executeQuery : @"select * from t_student; " ];
       
        while ([set next ]) {
           
            NSString *s_name = [set stringForColumn : @"name" ];
            int s_age = [set intForColumn : @"age" ];
            int s_id = [set intForColumn : @"id" ];
           
            // 初始化一个 student 对象，并给属性赋值
            Student *stu = [[ Student alloc ] init ];
            stu. name = s_name;
            stu. age = s_age;
            stu. s_id = s_id;
            [ _students addObject :stu];
           
        }
    }
   
    // 关闭数据库文件
    [db close ];