SQLite3第三方框架——FMDB的基本使用

//
//  ViewController.m
//  FMDB的基本使用


#import "ViewController.h"
#import "FMDatabase.h"

@interface ViewController ()
@property(nonatomic,strong)FMDatabase *db;
- (IBAction)insert;
- (IBAction)query;

@end

@implementation ViewController

- (void)viewDidLoad {
    [super viewDidLoad];
    // Do any additional setup after loading the view, typically from a nib.
    
    //0.获得沙盒中的数据库文件名
    //沙盒caches目录：NSCachesDirectory
    //沙盒Document目录：NSDocumentDirectory
    NSString *filename = [[NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES) lastObject] stringByAppendingPathComponent:@"student.sqlite"];
    
    //1.创建数据库实例对象
    self.db = [FMDatabase databaseWithPath:filename];
    
    //2.打开数据库
    if ([self.db open]) {
       //建表
       BOOL result = [self.db executeUpdate:@"create table if not exists t_student (id integer primary key autoincrement,name text,age integer);"];
        if (result) {
            NSLog(@"建表成功");
        }else{
            NSLog(@"建表失败");
        }
    }else{
        NSLog(@"数据库打开失败");
    }
}



- (IBAction)insert {
    for (int i=0; i<40; i++) {
        NSString *name = [NSString stringWithFormat:@"rose--%d",arc4random() % 1000];
        NSNumber *age = @(arc4random() % 100 + 1);
        [self.db executeUpdate:@"insert into t_student (name,age) values (?,?);",name,age];
    }

}

- (IBAction)query {
    //1.查询数据
   FMResultSet *rs = [self.db executeQuery:@"select * from t_student where age>?;",@50];
    
    //2.遍历结果集
    while (rs.next) {
        int ID = [rs intForColumn:@"id"];
        NSString *name = [rs stringForColumn:@"name"];
        int age = [rs intForColumn:@"age"];
        NSLog(@"%d %@ %d",ID,name,age);
    }
}
@end