//  ViewController.m//  JRFMDB////  Created by jerehedu on 15/6/18.//  Copyright (c) 2015年 jerehedu. All rights reserved.//#import "ViewController.h"#import "FMDatabase.h"@interface ViewController ()@PRoperty (nonatomic, strong) FMDatabase *db;@end@implementation ViewController- (void)viewDidLoad{    [super viewDidLoad];    //導(dǎo)入sqlite框架，導(dǎo)入FMDB文件夾        //1.獲得數(shù)據(jù)庫(kù)文件的路徑    NSString *doc=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];    NSString *fileName=[doc stringByAppendingPathComponent:@"student.sqlite"];    NSLog(@"fileName = %@",fileName);        //2.獲得數(shù)據(jù)庫(kù)    FMDatabase *db = [FMDatabase databaseWithPath:fileName];        //3.打開(kāi)數(shù)據(jù)庫(kù)    if ([db open]) {        NSLog(@"ok");                //4.創(chuàng)表        BOOL result=[db executeUpdate:@"CREATE TABLE IF NOT EXISTS t_student (id integer PRIMARY KEY AUTOINCREMENT, name text NOT NULL, age integer NOT NULL);"];        if (result) {            NSLog(@"創(chuàng)表成功");        }else{            NSLog(@"創(chuàng)表失敗");        }    }    self.db=db;        //插入數(shù)據(jù)    [self insertStu];    [self deleteStu:6];    [self updateStu:@"apple7_name" :@"7777"];        [self queryStu];    [self dropStu];    [self insertStu];    [self queryStu];        //6.關(guān)閉數(shù)據(jù)庫(kù)    [self.db close];}#pragma mark 插入數(shù)據(jù)-(void)insertStu{    for (int i=0; i<10; i++)    {        NSString *name = [NSString stringWithFormat:@"1apple%i_name",i];        int age = arc4random()%3+20;                //1.  executeUpdate : 不確定的參數(shù)用?來(lái)占位 (后面參數(shù)必須都是oc對(duì)象)        [self.db executeUpdate:@"INSERT INTO t_student (name, age) VALUES (?,?);",name,@(age)];                //2.  executeUpdateWithFormat : 不確定的參數(shù)用%@、%d等來(lái)占位 （參數(shù)為原始數(shù)據(jù)類型）        //        [self.db executeUpdateWithFormat:@"insert into t_student (name, age) values (%@, %i);",name,age];                //3. 數(shù)組        //        [self.db executeUpdate:@"INSERT INTO t_student (name, age) VALUES (?,?);" withArgumentsInArray:@[name,@(age)]];    }    }#pragma mark 刪除數(shù)據(jù)-(void)deleteStu:(int)idNum{    //a.  executeUpdate : 不確定的參數(shù)用?來(lái)占位 (后面參數(shù)必須都是oc對(duì)象)    //    [self.db executeUpdate:@"delete from t_student where id=?;",@(idNum)];        //b.  executeUpdateWithFormat : 不確定的參數(shù)用%@、%d等來(lái)占位    //    [self.db executeUpdateWithFormat:@"delete from t_student where name=%@;",@"apple9_name"];}#pragma mark 銷毀表格-(void)dropStu{    [self.db executeUpdate:@"drop table if exists t_student;"];        //4.創(chuàng)表    BOOL result=[self.db executeUpdate:@"CREATE TABLE IF NOT EXISTS t_student (id integer PRIMARY KEY AUTOINCREMENT, name text NOT NULL, age integer NOT NULL);"];    if (result) {        NSLog(@"再次創(chuàng)表成功");    }else{        NSLog(@"再次創(chuàng)表失敗");    }}#pragma mark 修改數(shù)據(jù)-(void)updateStu:(NSString *)oldName :(NSString*)newName{    //    [self.db executeUpdateWithFormat:@"update t_student set name=%@ where name=%@;",newName,oldName];    [self.db executeUpdate:@"update t_student set name=? where name=?",newName,oldName];}#pragma mark 查詢數(shù)據(jù)-(void)queryStu{    //1.執(zhí)行查詢語(yǔ)句    //    FMResultSet *resultSet = [self.db executeQuery:@"select * from t_student;"];    FMResultSet *resultSet = [self.db executeQuery:@"select * from t_student where id<?;",@(14)];        //2.遍歷結(jié)果集合    while ([resultSet next]) {        int idNum = [resultSet intForColumn:@"id"];        NSString *name = [resultSet objectForColumnName:@"name"];        int age = [resultSet intForColumn:@"age"];        NSLog(@"id=%i ,name=%@, age=%i",idNum,name,age);    }    }- (void)didReceiveMemoryWarning{    [super didReceiveMemoryWarning];    // Dispose of any resources that can be recreated.}@end