利用FMDB封装工具类

<pre name="code" class="objc"><pre name="code" class="objc">@class UserModel;  
@interface LVFmdbTool : NSObject  
  
// 插入模型数据  
+ (BOOL)insertModel:(UserModel *)model;  
  
/** 查询数据,如果 传空 默认会查询表中所有数据 */  
+ (NSArray *)queryData:(NSString *)querySql;  
  
/** 删除数据,如果 传空 默认会删除表中所有数据 */  
+ (BOOL)deleteData:(NSString *)deleteSql;  
  
/** 修改数据 */  
+ (BOOL)modifyData:(NSString *)modifySql;  

#define LVSQLITE_NAME @"modals.sqlite"  
  
@implementation LVFmdbTool  
  
  
static FMDatabase *_fmdb;  
  
+ (void)initialize {  
    // 执行打开数据库和创建表操作  
    NSString *filePath = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject] stringByAppendingPathComponent:LVSQLITE_NAME];  
    _fmdb = [FMDatabase databaseWithPath:filePath];  
      
    [_fmdb open];  
      
#warning 必须先打开数据库才能创建表。。。否则提示数据库没有打开  
    [_fmdb executeUpdate:@"CREATE TABLE IF NOT EXISTS t_modals(id INTEGER PRIMARY KEY, name TEXT NOT NULL, age INTEGER NOT NULL, ID INTEGER NOT NULL);"];  
}  
  
+ (BOOL)insertModel:(UserModel *)model{  
    NSString *insertSql = [NSString stringWithFormat:@"INSERT INTO t_modals(name, age, ID_No) VALUES ('%@', '%zd', '%zd');", modal.name, modal.age, modal.ID_No];  
    return [_fmdb executeUpdate:insertSql];  
}  
  
//查询  
+ (NSArray *)queryData:(NSString *)querySql {  
      
    if (querySql == nil) {  
        querySql = @"SELECT * FROM t_modals;";  
    }  
      
    NSMutableArray *arrM = [NSMutableArray array];  
    FMResultSet *set = [_fmdb executeQuery:querySql];  
      
    while ([set next]) {  
          
        NSString *name = [set stringForColumn:@"name"];  
        NSString *age = [set stringForColumn:@"age"];  
        NSString *ID = [set stringForColumn:@"ID"];  
          
        LVModal *modal = [LVModal modalWith:name age:age.intValue no:ID.intValue];  
        [arrM addObject:modal];  
    }  
    return arrM;  
}  
  
//删除 默认删除表  
+ (BOOL)deleteData:(NSString *)deleteSql {  
      
    if (deleteSql == nil) {  
        deleteSql = @"DELETE FROM t_modals";  
    }  
      
    return [_fmdb executeUpdate:deleteSql];  
  
}  
  
//更改  
+ (BOOL)modifyData:(NSString *)modifySql {  
      
    if (modifySql == nil) {  
        modifySql = @"UPDATE t_modals SET ID_No = '789789' WHERE name = 'lisi'";  
    }  
    return [_fmdb executeUpdate:modifySql];  
}