iOS数据库之查找功能的实现(2)

       
        //将数据库中的数据放到一个集合类FMResultSet中
       
        FMResultSet *set = [self.sqlite3 executeQuery:query];
       
        //创建一个动态数组
       
        NSMutableArray *dataArr = [[NSMutableArray alloc]init];
       
    //将集合中的数据循环取出，并赋给变动数组，返回值为这个变动数组
       
        while ([set next])
        {
           
            baoCunData * data = [[baoCunData alloc]init];
           
            data.nameData =[set stringForColumn:@"name"];
           
            data.numberData = [set stringForColumn:@"number"];
           
            [dataArr addObject:data];
           
        }
        return dataArr;
    }
@end

 

 

建立一个保存数据的类

 

//
//  baoCunData.h
//  shuJuKu
//
//  Created by liyongxing on 13-7-31.
//  Copyright (c) 2013年 liyongxing. All rights reserved.
//

#import <Foundation/Foundation.h>

@interface baoCunData : NSObject

//一个姓名字符串

@property (nonatomic ,strong) NSString * nameData;

//号码字符串（号码中可能存在符号或者英文）

@property (nonatomic ,strong) NSString * numberData;

@end

.m中

//
//  baoCunData.m
//  shuJuKu
//
//  Created by liyongxing on 13-7-31.
//  Copyright (c) 2013年 liyongxing. All rights reserved.
//

#import "baoCunData.h"

@implementation baoCunData

-(id)init
{
    if (self == [super init])
    {
       
        self.nameData = nil;
       
        self.numberData = nil;