使用FMDB进行数据库操作

最新推荐文章于 2022-09-20 11:14:58 发布

Jacob-wj

最新推荐文章于 2022-09-20 11:14:58 发布

阅读量9k

点赞数

分类专栏： IOS UI基础

本文链接：https://blog.youkuaiyun.com/wangjia55/article/details/50740247

版权

IOS UI基础专栏收录该内容

30 篇文章

订阅专栏

本文介绍如何通过FMDB库实现iOS应用中的简单数据库增删改查操作，包括数据库连接、表创建、数据插入、删除、更新及查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

FMDB： https://github.com/ccgus/fmdb

按照教程可以通过pods的方式进行依赖引入。

简单的增删改查操作，代码如下：

#import "ViewController.h"
#import "FMDB.h"

@interface ViewController ()
@property(nonatomic,strong) FMDatabase *db;

- (IBAction)insert:(UIButton *)sender;
- (IBAction)delete:(UIButton *)sender;
- (IBAction)update:(UIButton *)sender;
- (IBAction)select:(UIButton *)sender;

@end

@implementation ViewController

- (void)viewDidLoad {
    [super viewDidLoad];
    
    //数据的路径，放在沙盒的cache下面
    NSString *cacheDir = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES)[0];
    NSString *filePath = [cacheDir stringByAppendingPathComponent:@"contact.sqlite"];
    
    //创建并且打开一个数据库
    _db = [FMDatabase databaseWithPath:filePath];
    
    BOOL flag = [_db open];
    if (flag) {
        NSLog(@"数据库打开成功");
    }else{
        NSLog(@"数据库打开失败");
    }
    
    //创建表
   BOOL create =  [_db executeUpdate:@"create table if not exists t_health(id integer primary key  autoincrement, name text,phone text)"];
    
    if (create) {
        NSLog(@"创建表成功");
    }else{
        NSLog(@"创建表失败");
    }
    
}

- (IBAction)insert:(UIButton *)sender {
    
    BOOL insert = [_db executeUpdate:@"insert into t_health (name,phone) values(?,?)",@"jacob",@"138000000000"];
    if (insert) {
        NSLog(@"插入数据成功");
    }else{
        NSLog(@"插入数据失败");
    }
}

- (IBAction)delete:(UIButton *)sender {
    BOOL delete = [_db executeUpdate:@"delete from t_health where name like ?",@"jacob"];
    if (delete) {
        NSLog(@"删除数据成功");
    }else{
        NSLog(@"删除数据失败");
    }
}

- (IBAction)update:(UIButton *)sender {
    BOOL update = [_db executeUpdate:@"update t_health set name = ?  where phone = '%@'",@"jacob111"];
    if (update) {
        NSLog(@"更新数据成功");
    }else{
        NSLog(@"更新数据失败");
    }
    
}

- (IBAction)select:(UIButton *)sender {
   FMResultSet *set = [_db executeQuery:@"select * from t_health "];
    while ([set next]) {
        NSString *name =  [set stringForColumn:@"name"];
        NSString *phone = [set stringForColumn:@"phone"];
        NSLog(@"name : %@ phone: %@",name,phone);
    }
   
}
@end