fmdb 数据库简单使用

       FMDB 学习笔记

//

//  UserDB.m

//  FMDB

//

//  Created by GuoBIn on 15/7/20.

//  Copyright (c) 2015年自强不息. All rights reserved.

//

#import "UserDB.h"

#import <FMDB.h>

#define dataBasePath [[(NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES)) lastObject]stringByAppendingPathComponent:dataBaseName]

#define dataBaseName @"GuoBIn.sqlite"

staticUserDB *instnce;

@implementation UserDB

+ (id)shareInstance

{

   if (instnce ==nil) {

       instnce = [[[selfclass] alloc]init];

    }

    returninstnce;

}

// 创建用户表

- (void)createTable

{

    // 文件路径

    NSString *filePath = [NSHomeDirectory()stringByAppendingFormat:@"/Documents/%@",dataBaseName];

   NSLog(@"文件路径 == %@",filePath);

    FMDatabase *db = [FMDatabasedatabaseWithPath:dataBasePath];

    

   if ([db open]) {

       if (![db tableExists:@"user"]) {

            if ([dbexecuteUpdate:@"CREATE TABLE user (Serial text primary key,dataText text)"]) {

               NSLog(@"创建表成功");

            }else{

               NSLog(@"创建表失败");

            }

        }else {

           NSLog(@"表已经存在");

        }

    }else{

       NSLog(@"打开表失败");

    }

    [dbclose];     // 打开就要关闭

    

}

// 添加用户

- (void)addData:(NSArray *)dataArray

{

   NSString *serial   = [dataArray objectAtIndex:0];

   NSString *dataText = [dataArray objectAtIndex:1];

    

    FMDatabase *db = [FMDatabasedatabaseWithPath:dataBasePath];

   if ([db open]) {

    // 插入数据

    BOOL rs = [dbexecuteUpdate:@"insert into user (Serial,DataText) values(?,?)",serial,dataText,nil];

       if (rs) {

           NSLog(@"添加成功");

        }else {

           NSLog(@"添加失败");

        }

    }

    [dbclose];

}

// 查询用户

- (NSArray *)findDatas

{

    NSMutableArray *users = [NSMutableArrayarray];

    FMDatabase *db = [FMDatabasedatabaseWithPath:dataBasePath];

   if ([db open]) {

        // 获取所有数据

       FMResultSet *rs = [db executeQuery:@"SELECT * FROM user"];

       while ([rs next]) {

           NSString *serial = [rs stringForColumn:@"Serial"];

           NSString *dataText = [rs stringForColumn:@"DataText"];

            

            [usersaddObject:@[serial,dataText]];

        }

        [rsclose];

    }

    [dbclose];

   return users;

}

- (void)deleteRowData:(NSArray *)array

{

   NSString *serial = [array objectAtIndex:0];

   NSString *dataText = [array objectAtIndex:1];

    

    FMDatabase *db = [FMDatabasedatabaseWithPath:dataBasePath];

   if ([db open]) {

        // 删除某个数据

        BOOL rs = [dbexecuteUpdate:@"DELETE FROM user WHERE Serial = ? and DataText = ?",serial,dataText];

        

       if (rs) {

           NSLog(@"删除成功");

        }else {

           NSLog(@"删除失败");

        }

    }

    [dbclose];

}

// 清空表中的数据：

- (void)clearTableData

{

    FMDatabase *db = [FMDatabasedatabaseWithPath:dataBasePath];

   if ([db open]) {

        // 清除全部数据

        [db executeUpdate:@"DELETE FROM user"];

    }

    [dbclose];

}

// 更新数据

- (void)executeUpdate:(NSArray *)array

{

   NSString *serial = [array objectAtIndex:0];

   NSString *dataText = [array objectAtIndex:1];

    

    FMDatabase *db = [FMDatabasedatabaseWithPath:dataBasePath];

   if ([db open]) {

        [db executeUpdate:@"UPDATE user SET DataText = ? WHERE Serial = ?",dataText,serial];

    }

    [dbclose];

    

}

@end

好记性，不如烂笔头

https://github.com/19940524/LCY_FMDB.git