FMDB的一些基本操作小结

#import

#import"FMDatabase.h"

#import"FMDatabaseAdditions.h"

@interfacewiDBRoot : NSObject

@property (retain, nonatomic) FMDatabase *DB;

@property (retain, nonatomic) NSString *DBName;

//+ (id)modelWithDBName:(NSString *)dbName;

- (id)initWithDBName:(NSString *)dbName;

//删除数据库

- (void)deleteDatabse;

//数据库存储路径

//- (NSString *)getPath:(NSString *)dbName;

//打开数据库

- (void)readyDatabse;

//判断是否存在表

- (BOOL) isTableOK:(NSString *)tableName;

//获得表的数据条数

- (BOOL) getTableItemCount:(NSString *)tableName;

//创建表

- (BOOL) createTable:(NSString *)tableName withArguments:(NSString *)arguments;

//删除表-彻底删除表

- (BOOL) deleteTable:(NSString *)tableName;

//清除表-清数据

- (BOOL) eraseTable:(NSString *)tableName;

//插入数据

- (BOOL)insertTable:(NSString*)sql, ...;

//修改数据

- (BOOL)updateTable:(NSString*)sql, ...;

//整型

- (NSInteger)getDb_Integerdata:(NSString *)tableName withFieldName:(NSString *)fieldName;

//布尔型

- (BOOL)getDb_Booldata:(NSString *)tableName withFieldName:(NSString *)fieldName;

//字符串型

- (NSString *)getDb_Stringdata:(NSString *)tableName withFieldName:(NSString *)fieldName;

//二进制数据型

- (NSData *)getDb_Bolbdata:(NSString *)tableName withFieldName:(NSString *)fieldName;

@end


#import"wiDBRoot.h"

@interfacewiDBRoot ()

- (NSString *)getPath:(NSString *)dbName;

@end

@implementationwiDBRoot

@synthesizeDB;

@synthesizeDBName;

/*

+ (id)modelWithDBName:(NSString *)dbName

{

[[[self alloc] initWithDBName:dbName] autorelease];

return self;

}

*/

- (id)initWithDBName:(NSString *)dbName

{

self = [super init];

if(nil != self)

{

DBName = [self getPath:dbName];

WILog(@"DBName: %@", DBName);

}

returnself;

}

- (void)dealloc {

[DB close];

[DB release];

[DBName release];

[super dealloc];

}

//数据库存储路径(内部使用)

- (NSString *)getPath:(NSString *)dbName

{

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

NSString *documentsDirectory = [paths objectAtIndex:0];

return[documentsDirectory stringByAppendingPathComponent:dbName];

}

//打开数据库

- (void)readyDatabse

{

//BOOL success;

//NSError *error;

//NSFileManager *fileManager = [NSFileManager defaultManager];

//success = [fileManager fileExistsAtPath:self.DBName];

if([DB databaseExists])

return;

//DB = [FMDatabase databaseWithPath:DBName];

DB = [[FMDatabase alloc] initWithPath:DBName];

if(![DB open])

{

[DB close];

NSAssert1(0,@"Failed to open database file with message '%@'.", [DB lastErrorMessage]);

}

//kind of experimentalish.

[DB setShouldCacheStatements:YES];

}

#pragmamark 删除数据库

//删除数据库

- (void)deleteDatabse

{

BOOL success;

NSError *error;

NSFileManager *fileManager = [NSFileManager defaultManager];

//delete the old db.

if([fileManager fileExistsAtPath:DBName])

{

[DB close];

success = [fileManager removeItemAtPath:DBName error:&error];

if(!success) {

NSAssert1(0,@"Failed to delete old database file with message '%@'.", [error localizedDescription]);

}

}

}

//判断是否存在表

- (BOOL) isTableOK:(NSString *)tableName

{

FMResultSet *rs = [DB executeQuery:@"SELECT count(*) as 'count' FROM sqlite_master WHERE type ='table' and name = ?", tableName];

while([rs next])

{

//just print out what we've got in a number of formats.

NSInteger count = [rs intForColumn:@"count"];

WILog(@"isTableOK %d", count);

if(0== count)

{

returnNO;

}

else

{

returnYES;

}

}

returnNO;

}

//获得表的数据条数

- (BOOL) getTableItemCount:(NSString *)tableName

{

NSString *sqlstr = [NSString stringWithFormat:@"SELECT count(*) as 'count' FROM %@", tableName];

FMResultSet *rs = [DB executeQuery:sqlstr];

while([rs next])

{

//just print out what we've got in a number of formats.

NSInteger count = [rs intForColumn:@"count"];

WILog(@"TableItemCount %d", count);

returncount;

}

return0;

}

//创建表

- (BOOL) createTable:(NSString *)tableName withArguments:(NSString *)arguments

{

NSString *sqlstr = [NSString stringWithFormat:@"CREATE TABLE %@ (%@)", tableName, arguments];

if(![DB executeUpdate:sqlstr])

//if ([DB executeUpdate:@"create table user (name text, pass text)"] == nil)

{

WILog(@"Create db error!");

returnNO;

}

returnYES;

}

//删除表

- (BOOL) deleteTable:(NSString *)tableName

{

NSString *sqlstr = [NSString stringWithFormat:@"DROP TABLE %@", tableName];

if(![DB executeUpdate:sqlstr])

{

WILog(@"Delete table error!");

returnNO;

}

returnYES;

}

//清除表

- (BOOL) eraseTable:(NSString *)tableName

{

NSString *sqlstr = [NSString stringWithFormat:@"DELETE FROM %@", tableName];

if(![DB executeUpdate:sqlstr])

{

WILog(@"Erase table error!");

returnNO;

}

returnYES;

}

//插入数据

- (BOOL)insertTable:(NSString*)sql, ...

{

va_list args;

va_start(args, sql);

BOOL result = [DB executeUpdate:sql error:nil withArgumentsInArray:nil orVAList:args];

va_end(args);

returnresult;

}

//修改数据

- (BOOL)updateTable:(NSString*)sql, ...

{

va_list args;

va_start(args, sql);

BOOL result = [DB executeUpdate:sql error:nil withArgumentsInArray:nil orVAList:args];

va_end(args);

returnresult;

}

//暂时无用

#pragmamark 获得单一数据

//整型

- (NSInteger)getDb_Integerdata:(NSString *)tableName withFieldName:(NSString *)fieldName

{

NSInteger result = NO;

NSString *sql = [NSString stringWithFormat:@"SELECT %@ FROM %@", fieldName, tableName];

FMResultSet *rs = [DB executeQuery:sql];

if([rs next])

result = [rs intForColumnIndex:0];

[rs close];

returnresult;

}

//布尔型

- (BOOL)getDb_Booldata:(NSString *)tableName withFieldName:(NSString *)fieldName

{

BOOL result;

result = [self getDb_Integerdata:tableName withFieldName:fieldName];

returnresult;

}

//字符串型

- (NSString *)getDb_Stringdata:(NSString *)tableName withFieldName:(NSString *)fieldName

{

NSString *result = NO;

NSString *sql = [NSString stringWithFormat:@"SELECT %@ FROM %@", fieldName, tableName];

FMResultSet *rs = [DB executeQuery:sql];

if([rs next])

result = [rs stringForColumnIndex:0];

[rs close];

returnresult;

}

//二进制数据型

- (NSData *)getDb_Bolbdata:(NSString *)tableName withFieldName:(NSString *)fieldName

{

NSData *result = NO;

NSString *sql = [NSString stringWithFormat:@"SELECT %@ FROM %@", fieldName, tableName];

FMResultSet *rs = [DB executeQuery:sql];

if([rs next])

result = [rs dataForColumnIndex:0];

[rs close];

returnresult;

}

@end

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • 最近项目中用到本地数据库存储数据,将具体的实现记录一下。 1.数据库的创建,创建了一个单例文件。.h文件代码如下。...
    妃雪阅读 1,518评论 0 2
  • 作者唯一QQ:228544117。。。。。 =========后面的都要新建一个文章 AppDelegate.h ...
    CC_iOS阅读 964评论 0 0
  • 哦吼吼,又研究了几天,把FMDB这个封装好的数据库搞定了,写了个简单的例子,基于FMDB的添删改查操作,界面很一般...
    lichengjin阅读 571评论 0 0
  • 数据库存在的意义就是对数据进行整合和管理,即对数据进行增,删,改,查的操作。 1.创建表的格式为 create t...
    彬至睢阳阅读 1,055评论 0 1
  • Spark SQL, DataFrames and Datasets Guide Overview SQL Dat...
    Joyyx阅读 8,353评论 0 16