////  ViewController.m//  SQLiteDemo////  Created by wangtouwang on 15/4/9.//  Copyright (c) 2015年 wangtouwang. All rights reserved.//#import "ViewController.h"#import "WPUser.h"#define DBNAME @ "MySQLite.sqlite"@interface ViewController (){    sqlite3 *db;}@end@implementation ViewController- (void)viewDidLoad {    [super viewDidLoad];        [self createSqlDBOrOpenDB];        [self createTable];    //    for (int index=0; index<30; index++) {//         [self insertIntoData];//    }    [self updateData:[self searchAllData]];        }#PRagma mark 更新數據 -(void)updateData:(NSMutableArray *)array{    NSString *sql = @"update user set name=?,age=? where id=?";    sqlite3_stmt *stmt;    for (int index=0; index<array.count; index++) {        WPUser *user =  (WPUser *)array[index];        user.name=@"張建華";        user.age=31;        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &stmt, NULL)==SQLITE_OK) {            sqlite3_bind_text(stmt, 1, [user.name UTF8String], -1, NULL);            sqlite3_bind_int(stmt, 2, user.age);            sqlite3_bind_int(stmt, 3, user.ID);            if (sqlite3_step(stmt)==SQLITE_DONE) {                NSLog(@"更新成功");            }        }    }}#pragma mark 讀取數據 -(NSMutableArray *)searchAllData{    NSMutableArray *array = [NSMutableArray array];    NSString *sql = @"select id,name,age from user";    sqlite3_stmt *stmt;    if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &stmt, NULL)==SQLITE_OK) {        while (sqlite3_step(stmt)==SQLITE_ROW) {            NSInteger ID =  sqlite3_column_int(stmt, 0);             char *name = (char*)sqlite3_column_text(stmt, 1);           NSString *uname = [[NSString alloc] initWithUTF8String:name];            NSInteger age = sqlite3_column_int(stmt, 2);            NSLog(@"ID=%lu NAME=%s AGE=%lu",ID,name,age);            WPUser *user = [WPUser initUserName:uname Age:age];            user.ID=ID;            [array addObject:user];        }    }     sqlite3_close(db);    return array;}#pragma mark 新增數據-(void)insertIntoData{    NSString *sql = @"insert into user(name,age) values(?,?)";    WPUser *user = [WPUser initUserName:@"JACK" Age:11];    sqlite3_stmt *stmt;    //插入數據前檢測語法是否正確    if ((sqlite3_prepare_v2(db, [sql UTF8String], -1, &stmt, NULL))==SQLITE_OK ) {        //綁定參數 參數2:為序號（從1開始），參數3:為字符串值，參數4 為字符串長度。sqlite3_bind_text的第五個參數為一個函數指針        sqlite3_bind_text(stmt, 1, [user.name UTF8String], -1, NULL);        sqlite3_bind_int(stmt, 2,user.age);        //真正執行插入 sqlite3_step        if (sqlite3_step(stmt)==SQLITE_DONE) {            NSLog(@"INSERT INTO SUCCESS");        }else{            NSLog(@"INSERT INTO ERROR");        }    }}#pragma mark 創建表 -(void)createTable{    NSString *sql = @"create table if not exists user (id integer primary key autoincrement,name text,age integer);";    char *errormsg;    //執行創建語句 sqlite3_exex 是函數 參數一:數據庫的句柄（db），參數二: 為sql語句，參數三 回調參數，是一個指向函數的指針，如果把callback前面的*改成^則就是一個block代碼段，                                //參數四 可以寫NULL，第五個參數為錯誤信息    //在這里創建需要先判斷表是否已存在    int result = sqlite3_exec(db, [sql UTF8String], NULL, NULL, &errormsg);    if (result==SQLITE_OK) {        NSLog(@"創建成功");    }else{        NSLog(@"創建失敗 愿因是:%s",errormsg);    }}#pragma mark 創建數據庫實例或者打開數據實例-(void)createSqlDBOrOpenDB{    //獲取 項目 Doucment文件目錄地址    NSString  *doc =  [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];    NSLog(@"%@",doc);    //創建 SQLITE 文件或者獲取該文件路徑    NSString *DB_PATH = [doc stringByAppendingPathComponent:DBNAME];    NSLog(@"%@",DB_PATH);    //打開或者創建DB實例 這里用到C里面的語法和指針    int result = sqlite3_open([DB_PATH UTF8String], &db);//sqlite3_open方法名 參數 const filename DB文件路徑,第二個參數就是數據庫實例化對象 返回參數 int 類型    if(result!=SQLITE_OK){        sqlite3_close(db);//關閉實例化        NSLog(@"打開數據哭實例化對象失敗");    }else{        NSLog(@"CREATE SUCCESS");    }}@end

////  WPUser.m//  SQLiteDemo////  Created by wangtouwang on 15/4/9.//  Copyright (c) 2015年 wangtouwang. All rights reserved.//#import "WPUser.h"@implementation WPUser-(instancetype)initUserName:(NSString *)name Age:(NSInteger)age{    if (self= [super init]) {        self.name = name;        self.age = age;    }    return self;}+(instancetype)initUserName:(NSString *)name Age:(NSInteger)age{    return [[WPUser alloc] initUserName:name Age:age];}@end