首页 / IOS / iOS sqlite 增删改查 简单封装(基于 FMDB)

iOS sqlite 增删改查 简单封装(基于 FMDB)

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了iOS sqlite 增删改查 简单封装(基于 FMDB)，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含8940字，纯文字阅读大概需要13分钟。

内容图文

/**
 *  对 sqlite 的使用进行简单封装,仅涉及简单的单表 增删改查
 *
 *  基于 FMDB
 *
 *  操作基于 model ,数据库表字段与 model 属性一一对应,对 model 整体进行操作
 *
 *  根据 model 对象自动建表,字段类型只支持 NSString , NSIteger , float
 *
 *  用到 runtime 运行时获取 model 属性
 *
 */

技术分享 技术分享 
                  1
                //
                  2
                //
                  AGDatabaseManager.h

                  3
                //
                  4
                //
                  Created by Ager on 15/11/10.

                  5
                //
                  Copyright ? 2015年 Ager. All rights reserved.

                  6
                //

                  7
                  8
                  9
                /*
                *

                 10
                 *  对 sqlite 的使用进行简单封装,仅涉及简单的单表 增删改查

                 11
                 *

                 12
                 *  基于 FMDB

                 13
                 *

                 14
                 *  操作基于 model ,数据库表字段与 model 属性一一对应,对 model 整体进行操作

                 15
                 *

                 16
                 *  根据 model 对象自动建表,字段类型只支持 NSString , NSIteger , float

                 17
                 *

                 18
                 *  用到 runtime 运行时获取 model 属性

                 19
                 *

                 20
                */
                 21
                 22
                #import <Foundation/Foundation.h>
 23 24@interface AGDatabaseManager : NSObject
 25 26 + (AGDatabaseManager*)shareAGDatabaseManager;
 27 28/**
 29 *  创建表格
 30 *
 31 *  @param cls    model 类
 32 *  @param tbName 表名
 33 *  @param keyName 主键字段
 34 *  @param key    主键的属性设置
 35 *
 36 *  @return 创建表格是否成功
 37*/ 38 - (BOOL)creatTable:(Class)cls tableName:(NSString*)tbName keyName:(NSString*)keyName primaryKey:(NSString*) key;
 39 40 41/**
 42 *  向表格插入数据
 43 *
 44 *  @param model  数据模型与数据库表格对应
 45 *  @param tbName 要操作的表名
 46 *
 47 *  @return 添加是否成功
 48*/ 49 - (BOOL)insert:(id)model tableName:(NSString*)tbName;
 50 51 52/**
 53 *  更新数据
 54 *
 55 *  @param tbName 要操作的表名
 56 *  @param model 数据模型与数据库表格对应
 57 *  @param str   更新操作查要更新的数据的条件
 58 *
 59 *  @return 更新是否成功
 60*/ 61 - (BOOL)update:(id)model tableName:(NSString*)tbName where:(NSString*)str;
 62 63 64/**
 65 *  删除数据
 66 *
 67 *  @param tbName 要删除数据的表名
 68 *  @param str    要删除的数据的查找条件
 69 *
 70 *  @return 删除是否成功
 71*/ 72 - (BOOL)deleteTableName:(NSString*)tbName where:(NSString*)str;
 73 74 75/**
 76 *  查询数据
 77 *
 78 *  @param model  数据模型与数据库表格对应
 79 *  @param tbName 要操作的表名
 80 *  @param str    删除操作查要删除的数据的条件
 81 *
 82 *  @return 查询结果 (数组每一项为字典)
 83*/ 84 - (NSArray*)select:(Class)model tableName:(NSString*)tbName where:(NSString*)str;
 85 86 87/**
 88 *  查询全部数据
 89 *
 90 *  @param model  数据模型与数据库表格对应
 91 *  @param tbName 要操作的表名
 92 *
 93 *  @return 查询结果 (数组每一项为字典)
 94*/ 95 - (NSArray*)selectALL:(Class)model tableName:(NSString*)tbName;
 96 97 98 99100@end
AGDatabaseManager.h
技术分享 技术分享 
                  1
                //
                  2
                //
                  AGDatabaseManager.m

                  3
                //
                  4
                //
                  Created by Ager on 15/11/10.

                  5
                //
                  Copyright ? 2015年 Ager. All rights reserved.

                  6
                //

                  7
                  8
                #import
                "
                AGDatabaseManager.h
                "
                  9
                #import
                "
                FMDatabase.h
                "
                 10
                #import <objc/runtime.h>
 11 12static FMDatabase *fmdb = nil;
 13 14@implementation AGDatabaseManager
 15 16 17 - (instancetype)init{
 18if (self = [super init]) {
 19 20static dispatch_once_t oneToken;
 21         dispatch_once(&oneToken, ^{
 22             NSString *document = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES)[0];
 23             NSString *filePath = [document stringByAppendingPathComponent:@"database.sqlite"];
 24             NSLog(@"%@",document);
 25             fmdb = [FMDatabase databaseWithPath:filePath];
 26 27        });
 28    }
 29return self;
 30}
 31 32 33 + (AGDatabaseManager*)shareAGDatabaseManager{
 34return [[AGDatabaseManager alloc]init];
 35}
 36 37 38 - (BOOL)creatTable:(Class)cls tableName:(NSString*)tbName keyName:(NSString*)keyName primaryKey:(NSString*) key{
 39 40     NSArray *array = [self getModelAllProperty:cls];
 41     NSMutableString *sql = [NSMutableString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@ (",tbName];
 42 43for (int i = 0; i < array.count; i++) {
 44         NSDictionary *dic = array[i];
 45         [sql appendFormat:@"%@  %@ ",[dic objectForKey:@"name"],[dic objectForKey:@"type"]];
 46if(keyName != nil && [keyName isEqualToString:[dic objectForKey:@"name"]]){
 47            [sql appendString:key];
 48        }
 49if (i < array.count - 1){
 50             [sql appendString:@","];
 51        }
 52    }
 53 54     [sql appendString:@")"];
 55 56     NSLog(@"创建表格: %@",sql);
 57 58    [fmdb open];
 59     BOOL result = [fmdb executeUpdate:[sql copy]];
 60     NSLog(@"创建表格:%@",result ? @"成功":@"失败");
 61    [fmdb close];
 62return result;
 63}
 64 65 66 - (BOOL)insert:(id)model tableName:(NSString*)tbName{
 67 68     NSArray *array = [self getModelAllProperty:[model class]];
 69 70     NSMutableString *propertyStr = [[NSMutableString alloc]init];
 71     NSMutableString *valuesStr = [[NSMutableString alloc]init];
 72 73for (int i = 0; i < array.count; i++) {
 74         NSDictionary *dic = array[i];
 75         [propertyStr appendString:[dic objectForKey:@"name"]];
 76         [valuesStr appendFormat:@"‘%@‘",[model valueForKey:[dic objectForKey:@"name"]]];
 77 78if (i < array.count - 1){
 79             [propertyStr appendString:@","];
 80             [valuesStr appendString:@","];
 81        }
 82    }
 83     NSMutableString *sql = [NSMutableString stringWithFormat:@"INSERT INTO %@ (%@) values (%@)",tbName,propertyStr ,valuesStr];
 84     NSLog(@"添加数据 : %@",sql);
 85    [fmdb open];
 86     BOOL result = [fmdb executeUpdate:[sql copy]];
 87    [fmdb close];
 88      NSLog(@"添加数据:%@",result ? @"成功":@"失败");
 89 90return result;
 91}
 92 93 94 - (BOOL)update:(id)model tableName:(NSString*)tbName where:(NSString*)str{
 95     NSArray *array = [self getModelAllProperty:[model class]];
 96     NSMutableString *sql = [NSMutableString stringWithFormat:@"UPDATE %@ SET ",tbName];
 97 98for (int i = 0; i < array.count; i++) {
 99         NSDictionary *dic = array[i];
100         NSString *pro = [dic objectForKey:@"name"];
101         [sql appendFormat:@"%@ = ‘%@‘",pro,[model valueForKey:pro]];
102if (i < array.count - 1){
103             [sql appendString:@","];
104        }
105    }
106107     [sql appendFormat:@" where %@",str];
108109     NSLog(@"修改数据 : %@",sql);
110    [fmdb open];
111     BOOL result = [fmdb executeUpdate:[sql copy]];
112    [fmdb close];
113     NSLog(@"更新数据:%@",result ? @"成功":@"失败");
114return result;
115}
116117118 - (BOOL)deleteTableName:(NSString*)tbName where:(NSString*)str{
119     NSString *sql = [NSString stringWithFormat:@"delete from %@ where %@",tbName,str];
120     NSLog(@"删除数据 : %@",sql);
121    [fmdb open];
122     BOOL result = [fmdb executeUpdate:sql];
123    [fmdb close];
124     NSLog(@"更新数据:%@",result ? @"成功":@"失败");
125return result;
126}
127128129 - (NSArray*)select:(Class)model tableName:(NSString*)tbName where:(NSString*)str{
130     NSString *sql = [NSString stringWithFormat:@"select * from %@ where %@",tbName,str];
131     NSArray *array = [self getModelAllProperty:[model class]];
132    [fmdb open];
133     NSLog(@"查询数据 : %@",sql);
134     FMResultSet *set = [fmdb executeQuery:sql];
135     NSMutableArray *allArray = [[NSMutableArray alloc]init];
136while ([set next]) {
137         NSMutableDictionary *dic = [[NSMutableDictionary alloc]init];
138for (int i = 0; i < array.count; i++) {
139             NSDictionary *dic1 = array[i];
140             NSString *pro = [dic1 objectForKey:@"name"];
141             [dic setValue:[set stringForColumn:pro] forKey:pro];
142        }
143        [allArray addObject:dic];
144    }
145146     [set close];
147    [fmdb close];
148return [allArray copy];
149}
150151 - (NSArray*)selectALL:(Class)model tableName:(NSString*)tbName {
152     NSString *sql = [NSString stringWithFormat:@"select * from %@ ",tbName];
153     NSArray *array = [self getModelAllProperty:[model class]];
154    [fmdb open];
155     NSLog(@"查询数据 : %@",sql);
156     FMResultSet *set = [fmdb executeQuery:sql];
157     NSMutableArray *allArray = [[NSMutableArray alloc]init];
158while ([set next]) {
159         NSMutableDictionary *dic = [[NSMutableDictionary alloc]init];
160for (int i = 0; i < array.count; i++) {
161             NSDictionary *dic1 = array[i];
162             NSString *pro = [dic1 objectForKey:@"name"];
163             [dic setValue:[set stringForColumn:pro] forKey:pro];
164        }
165        [allArray addObject:dic];
166    }
167168     [set close];
169    [fmdb close];
170return [allArray copy];
171}
172173174175176#pragma mark --- 辅助方法 ---
177178/**
179 *  获取 model 类全部的属性和属性类型
180 *
181 *  @param cls model 类 class
182 *
183 *  @return 返回 model 的属性和属性类型
184*/185 - (NSArray *)getModelAllProperty:(Class)cls{
186187     unsigned int count = 0;
188     objc_property_t *propertys = class_copyPropertyList(cls, &count);
189     NSMutableArray *array = [NSMutableArray array];
190for (int i = 0; i < count; i++) {
191192         objc_property_t property = propertys[i];
193         NSString *propertyName = [NSString stringWithCString:property_getName(property) encoding:NSUTF8StringEncoding];
194195         NSString *type = [self getPropertyAttributeValue:property name:@"T"];
196197if ([type isEqualToString:@"q"]||[type isEqualToString:@"i"]) {
198             type = @"INTEGER";
199         }elseif([type isEqualToString:@"f"] || [type isEqualToString:@"d"]){
200             type = @"FLOAT";
201         }else{
202             type = @"TEXT";
203        }
204205         NSDictionary *dic = [NSDictionary dictionaryWithObjectsAndKeys:propertyName , @"name",type , @"type", nil];
206207        [array addObject:dic];
208209    }
210    free(propertys);
211212return array.copy;
213}
214215/**
216 *  获取属性的特征值
217*/218219 - (NSString*)getPropertyAttributeValue:(objc_property_t) pro name:(NSString*)name{
220221     unsigned int count = 0;
222     objc_property_attribute_t *attributes = property_copyAttributeList(pro, &count);
223224for (int i = 0 ; i < count; i++) {
225         objc_property_attribute_t attribute = attributes[i];
226if (strcmp(attribute.name, name.UTF8String) == 0) {
227return [NSString stringWithCString:attribute.value encoding:NSUTF8StringEncoding];
228        }
229    }
230    free(attributes);
231return nil;
232}
233234@end
AGDatabaseManager.m

FMDB + AGDatabaseManager 文件

 

原文：http://www.cnblogs.com/Ager/p/4954800.html

内容总结

以上是互联网集市为您收集整理的iOS sqlite 增删改查 简单封装(基于 FMDB)全部内容，希望文章能够帮你解决iOS sqlite 增删改查 简单封装(基于 FMDB)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1199788.html

来源：【匿名】