美文网首页
ios中使用FMDB数据的增删改查

ios中使用FMDB数据的增删改查

作者: MacleChen | 来源:发表于2019-11-07 17:52 被阅读0次
image

使用cocoapods集成

1. 初始化pod文件

pod init

2. 编写Podfile文件

# Uncomment the next line to define a global platform for your project
# platform :ios, '9.0'

target 'MyFMDBDemo' do
  # Uncomment the next line if you're using Swift or would like to use dynamic frameworks
  # use_frameworks!

  # Pods for MyFMDBDemo
    pod 'Masonry'          // 添加布局框架
    pod 'SDWebImage', '~> 5.0'   // 添加图片加载框架
    pod 'FMDB'   // 添加封装数据库

  target 'MyFMDBDemoTests' do
    inherit! :search_paths
    # Pods for testing
  end

  target 'MyFMDBDemoUITests' do
    inherit! :search_paths
    # Pods for testing
  end

end

3. 安装框架（记得重新打开项目时，选择.xcworkspace那个文件）

pod install

4. 在项目中使用框架

//
//  CZFFMDBExecute.m
//  MyFMDBDemo
//
//  Created by 陈帆 on 2019/11/7.
//  Copyright © 2019 陈帆. All rights reserved.
//

#import "CZFFMDBExecute.h"
#import "User.h"

// 集成FMDB框架
#import <fmdb/FMDB.h>

#define tableName @"User"

@interface CZFFMDBExecute()

/// 文件目录
@property(nonatomic, copy) NSString *documentDir;
@property(nonatomic, copy) FMDatabase *database;

@end

@implementation CZFFMDBExecute

/// 单例
+ (instancetype)shareInstance {
    static CZFFMDBExecute *instance = nil;
    static dispatch_once_t onceToken;
    
    dispatch_once(&onceToken, ^{
        instance =[[CZFFMDBExecute alloc] init];
    });
    
    return instance;
}

#pragma mark - Data base operate
- (NSString *)documentDir {
    if (!_documentDir) {
        _documentDir = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0];
    }
    
    return _documentDir;
}

- (FMDatabase *)database {
    if (!_database) {
        NSString *path = [self.documentDir stringByAppendingPathComponent:@"fmdb.db"];
        _database = [FMDatabase databaseWithPath:path];
        
        // create table
        if (![_database open]) {
            NSLog(@"database does not open.");
            return _database;
        }
        
        // 数据库中创建表（可创建多张）
        NSString *sql = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@ ('userId' TEXT,'username' TEXT NOT NULL, 'userIcon' TEXT ,'age' INTEGER, 'createTime' INTEGER, 'income' REAL, 'isMan' INTEGER)", tableName];
        BOOL result = [_database executeUpdate:sql];
        if (result) {
            NSLog(@"create table success");
        }
        
        [_database close];
    }
    return _database;
}


/// 增加用户实体
/// @param user 用户对象
- (void)addUser:(User *)user {
    if (![self.database open]) {
        NSLog(@"database does not open.");
        return;
    }
    NSString *execSql = [NSString stringWithFormat:@"INSERT INTO %@ VALUES('%@','%@','%@',%d,%ld,%f,%d)", tableName, user.userId, user.username, user.userIcon, user.age, (NSInteger)[user.createTime timeIntervalSince1970], [user.income floatValue], user.isMan ? 1 : 0];
    BOOL result = [self.database executeUpdate:execSql];
    if (result) {
        NSLog(@"add user success");
    }
    
    [self.database close];
}


/// 获取用户列表
- (NSArray<User *> *)getUserList {
    if (![self.database open]) {
        NSLog(@"database does not open.");
        return NULL;
    }
    
    NSString *execSql = [NSString stringWithFormat:@"SELECT * FROM %@", tableName];
    FMResultSet *result = [self.database executeQuery:execSql];
    NSMutableArray *arr = [NSMutableArray array];
    while ([result next]) {
        User *user = [User new];
        user.userId = [result stringForColumn:@"userId"];
        user.username = [result stringForColumn:@"username"];
        user.userIcon = [result stringForColumn:@"userIcon"];
        user.age = [result intForColumn:@"age"];
        user.createTime = [NSDate dateWithTimeIntervalSince1970:[result longForColumn:@"createTime"]];
        user.income = [[NSDecimalNumber alloc] initWithFloat:[result doubleForColumn:@"income"]];
        user.isMan = [result intForColumn:@"isMan"] == 0 ? NO : YES;
        [arr addObject:user];
    }
    
    [self.database close];
    
    return arr;
}

/// 删除指定索引用户
/// @param userId 用户id
- (void)deleteUser:(NSString *)userId {
    if (![self.database open]) {
        NSLog(@"database does not open.");
        return;
    }
    NSString *execSql = [NSString stringWithFormat:@"delete from %@ where userId = '%@'", tableName, userId];
    BOOL result = [self.database executeUpdate:execSql];
    if (result) {
        NSLog(@"delete user success");
    }
    
    [self.database close];
}

/// 删除所有用户
- (void)deleteAllUser {
    if (![self.database open]) {
        NSLog(@"database does not open.");
        return;
    }
    NSString *execSql = [NSString stringWithFormat:@"delete from %@", tableName];
    BOOL result = [self.database executeUpdate:execSql];
    if (result) {
        NSLog(@"delete all user success");
    }
    
    [self.database close];
}

/// 更新（修改）用户
/// @param user 用户对象
- (void)updateUser:(User *)user {
    if (![self.database open]) {
        NSLog(@"database does not open.");
        return;
    }
    NSString *execSql = [NSString stringWithFormat:@"UPDATE %@ SET username = '%@', age = %d, isMan = %d WHERE userId = '%@'", tableName, user.username, user.age, user.isMan ? 1 : 0, user.userId];
    BOOL result = [self.database executeUpdate:execSql];
    if (result) {
        NSLog(@"update user success");
    }
    
    [self.database close];
}

@end

5. 使用数据的增删改查

//
//  ViewController.m
//  MyFMDBDemo
//
//  Created by 陈帆 on 2019/11/7.
//  Copyright © 2019 陈帆. All rights reserved.
//

#import "ViewController.h"
#import "CZFFMDBExecute.h"
#import "User.h"

@interface ViewController ()<UITableViewDelegate, UITableViewDataSource>

@property(nonatomic, strong) NSMutableArray *dataSource;
@property(nonatomic, strong) UITableView *tableView;
@property(nonatomic, weak) UIButton *addBtn;
@property(nonatomic, weak) UIButton *deleteBtn;
@property(nonatomic, weak) UIButton *modifyBtn;
@property(nonatomic, weak) UIButton *queryBtn;

@property(nonatomic, weak) UILabel *noDataTipLabel;

@end

@implementation ViewController

- (void)viewDidLoad {
    [super viewDidLoad];
    // Do any additional setup after loading the view.
    [self setViewUI];
}

- (void)setViewUI {
    // 设置增加按钮
    UIButton *addBtn = [[UIButton alloc] init];
    self.addBtn = addBtn;
    [addBtn setTitle:@"增加" forState:UIControlStateNormal];
    addBtn.backgroundColor = [UIColor blueColor];
    [addBtn setTitleColor:[UIColor whiteColor] forState:UIControlStateNormal];
    addBtn.titleLabel.font = [UIFont systemFontOfSize:14.0];
    [addBtn addTarget:self action:@selector(addBtnClick:) forControlEvents:UIControlEventTouchUpInside];
    
    // 设置删除按钮
    UIButton *deleteBtn = [[UIButton alloc] init];
    self.deleteBtn = deleteBtn;
    [deleteBtn setTitle:@"删除" forState:UIControlStateNormal];
    deleteBtn.backgroundColor = [UIColor blueColor];
    [deleteBtn setTitleColor:[UIColor whiteColor] forState:UIControlStateNormal];
    deleteBtn.titleLabel.font = [UIFont systemFontOfSize:14.0];
    [deleteBtn addTarget:self action:@selector(deleteBtnClick:) forControlEvents:UIControlEventTouchUpInside];
    
    // 设置修改按钮
    UIButton *modifyBtn = [[UIButton alloc] init];
    self.modifyBtn = modifyBtn;
    [modifyBtn setTitle:@"修改" forState:UIControlStateNormal];
    modifyBtn.backgroundColor = [UIColor blueColor];
    [modifyBtn setTitleColor:[UIColor whiteColor] forState:UIControlStateNormal];
    modifyBtn.titleLabel.font = [UIFont systemFontOfSize:14.0];
    [modifyBtn addTarget:self action:@selector(modifyBtnClick:) forControlEvents:UIControlEventTouchUpInside];
    
    // 设置查询按钮
    UIButton *queryBtn = [[UIButton alloc] init];
    self.queryBtn = queryBtn;
    [queryBtn setTitle:@"查询" forState:UIControlStateNormal];
    queryBtn.backgroundColor = [UIColor blueColor];
    [queryBtn setTitleColor:[UIColor whiteColor] forState:UIControlStateNormal];
    queryBtn.titleLabel.font = [UIFont systemFontOfSize:14.0];
    [queryBtn addTarget:self action:@selector(queryBtnClick:) forControlEvents:UIControlEventTouchUpInside];
    
    // 没有数据提醒
    UILabel *noDataTipLabel = [[UILabel alloc] init];
    self.noDataTipLabel = noDataTipLabel;
    noDataTipLabel.text = @"没有数据啦";
    noDataTipLabel.textColor = [UIColor lightGrayColor];
    noDataTipLabel.textAlignment = NSTextAlignmentCenter;
    noDataTipLabel.font = [UIFont systemFontOfSize:14.0];
    noDataTipLabel.numberOfLines = 0;
//    noDataTipLabel.hidden = YES;
    
    
    self.tableView.layer.masksToBounds = true;
    self.tableView.layer.cornerRadius = 10;
    self.tableView.backgroundColor = [UIColor systemGroupedBackgroundColor];
    self.tableView.tableFooterView = [UIView new];
    self.tableView.delegate = self;
    self.tableView.dataSource = self;
    
    [self.view addSubview:addBtn];
    [self.view addSubview:modifyBtn];
    [self.view addSubview:deleteBtn];
    [self.view addSubview:queryBtn];
    self.tableView.backgroundView = self.noDataTipLabel;
    [self.view addSubview:self.tableView];
    self.view.backgroundColor = [UIColor darkGrayColor];
}

- (void)viewDidLayoutSubviews {
    [super viewDidLayoutSubviews];
    
    // 设置布局适配
    int btnWidth = 70, btnHeight = 30, gapXY = 20;
    [self.addBtn mas_makeConstraints:^(MASConstraintMaker *make) {
        make.top.equalTo(self.view.mas_top).with.offset(gapXY*2);
        make.right.equalTo(self.view.mas_centerX).with.offset(-gapXY/2);
        make.width.mas_equalTo(btnWidth);
        make.height.mas_equalTo(btnHeight);
    }];
    
    [self.deleteBtn mas_makeConstraints:^(MASConstraintMaker *make) {
        make.top.equalTo(self.view.mas_top).with.offset(gapXY*2);
        make.left.equalTo(self.view.mas_centerX).with.offset(gapXY/2);
        make.width.mas_equalTo(btnWidth);
        make.height.mas_equalTo(btnHeight);
    }];
    
    [self.modifyBtn mas_makeConstraints:^(MASConstraintMaker *make) {
        make.top.equalTo(self.addBtn.mas_bottom).with.offset(gapXY);
        make.right.equalTo(self.view.mas_centerX).with.offset(-gapXY/2);
        make.width.mas_equalTo(btnWidth);
        make.height.mas_equalTo(btnHeight);
    }];
    
    [self.queryBtn mas_makeConstraints:^(MASConstraintMaker *make) {
        make.top.equalTo(self.deleteBtn.mas_bottom).with.offset(gapXY);
        make.left.equalTo(self.view.mas_centerX).with.offset(gapXY/2);
        make.width.mas_equalTo(btnWidth);
        make.height.mas_equalTo(btnHeight);
    }];
    
    [self.tableView mas_makeConstraints:^(MASConstraintMaker *make) {
        make.top.equalTo(self.modifyBtn.mas_bottom).with.offset(gapXY);
        make.left.mas_equalTo(gapXY);
        make.right.mas_equalTo(-gapXY);
        make.bottom.equalTo(self.view.mas_bottom).with.offset(-gapXY);
    }];
    
    [self.noDataTipLabel mas_makeConstraints:^(MASConstraintMaker *make) {
        make.centerX.mas_equalTo(self.tableView.mas_centerX);
        make.centerY.mas_equalTo(self.tableView.mas_centerY);
        make.width.mas_equalTo(self.tableView.mas_width);
        make.height.mas_equalTo(btnHeight);
    }];
}

// MARK: - selector action funcation
// MARK: 增加按钮响应
- (void)addBtnClick:(UIButton *)sender {
    User *user = [User new];
    user.userId = [NSString stringWithFormat:@"%f", [[NSDate date] timeIntervalSince1970]];
    user.username = [NSString stringWithFormat:@"张三%ld", random()];
    user.age = 18;
    user.createTime = [NSDate date];
    user.income = [[NSDecimalNumber alloc] initWithFloat:1233.04338];
    user.isMan = YES;
    user.userIcon = @"https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1573042496310&di=d6b4363fe0bb7455d97672b4d5d0e316&imgtype=jpg&src=http%3A%2F%2Fimg1.imgtn.bdimg.com%2Fit%2Fu%3D4232323981%2C903032036%26fm%3D214%26gp%3D0.jpg";

    [[CZFFMDBExecute shareInstance] addUser:user];

    // 查询
    [self queryBtnClick:nil];
}

// MARK: 删除按钮响应
- (void)deleteBtnClick:(UIButton *)sender {
    if (self.dataSource.count > 0) {
        User *user = self.dataSource[0];
        [[CZFFMDBExecute shareInstance] deleteUser:user.userId];
    }
    
    [self queryBtnClick:nil];
    NSLog(@"删除成功");
}

// MARK: 需改按钮响应
- (void)modifyBtnClick:(UIButton *)sender {
    if (self.dataSource.count > 0) {
        [self.tableView selectRowAtIndexPath:[NSIndexPath indexPathForRow:0 inSection:0] animated:true scrollPosition:UITableViewScrollPositionTop];
        [self tableView:self.tableView didSelectRowAtIndexPath:[NSIndexPath indexPathForRow:0 inSection:0]];
    }
}

// MARK: 查询按钮响应
- (void)queryBtnClick:(UIButton *)sender {
    [self.dataSource removeAllObjects];
    
    NSArray *userList = [[CZFFMDBExecute shareInstance] getUserList];
    if (userList.count > 0) {
        [self.dataSource addObjectsFromArray:userList];
    }

    [self.tableView reloadData];
}


// MARK: - UITableView Delegate
// MARK: section Count
- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {
    return 1;
}

// MARK: row count in section
- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {
    self.noDataTipLabel.hidden = self.dataSource.count > 0;
    return self.dataSource.count;
}

// MARK: cell content
- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:@"cell"];
    if (!cell) {
        cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleSubtitle reuseIdentifier:@"cell"];
        cell.detailTextLabel.numberOfLines = 0;
    }
    
    // 填充数据
    User *user = self.dataSource[indexPath.row];
    cell.textLabel.text = user.username;
    cell.detailTextLabel.text = [NSString stringWithFormat:@"age:%d\ncreateTime:%@\nincome:%@\nisMan:%@\nuserId:%@", user.age, user.createTime, user.income, user.isMan ? @"YES":@"NO", user.userId];
    [cell.imageView sd_setImageWithURL:[NSURL URLWithString:user.userIcon] completed:^(UIImage * _Nullable image, NSError * _Nullable error, SDImageCacheType cacheType, NSURL * _Nullable imageURL) {
        if (image) {
            // 调整图片大小
            CGSize imageSize = CGSizeMake(70, 70);
            UIGraphicsBeginImageContextWithOptions(imageSize, NO, UIScreen.mainScreen.scale);
            [image drawInRect:CGRectMake(0, 0, imageSize.width, imageSize.height)];
            cell.imageView.image = UIGraphicsGetImageFromCurrentImageContext();
            UIGraphicsEndImageContext();
        }
    }];
    
    return cell;
}

// MARK: cell height
- (CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath {
    return 140;
}

// MARK: did selected
- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath {
     UIAlertController *alertController = [UIAlertController alertControllerWithTitle:@"提示" message:@"请输入个人信息" preferredStyle:UIAlertControllerStyleAlert];
    
    // selected user
    User *user = self.dataSource[indexPath.row];
    
     //增加确定按钮；
     [alertController addAction:[UIAlertAction actionWithTitle:@"确定" style:UIAlertActionStyleDefault handler:^(UIAlertAction * _Nonnull action) {
         //获取第1个输入框；
         UITextField *userNameTextField = alertController.textFields.firstObject;
         if (![userNameTextField.text isEqual:@""] && ![userNameTextField.text isEqual:user.username]) {
             user.username = userNameTextField.text;
         }
         
         //获取第2个输入框；
         UITextField *ageTextField = [alertController.textFields objectAtIndex:1];
         if (![ageTextField.text isEqual:@""] && ![ageTextField.text isEqual:[NSString stringWithFormat:@"%d", user.age]]) {
             user.age = [ageTextField.text intValue];
         }
         
         //获取第3个输入框；
         UITextField *sexField = alertController.textFields.lastObject;
         if (![sexField.text isEqual:@""]) {
             user.isMan = ![sexField.text isEqual:@"0"];
         }
         [[CZFFMDBExecute shareInstance] updateUser:user];
         
         [self.tableView reloadData];
     }]];
    // 增加取消按钮
    [alertController addAction:[UIAlertAction actionWithTitle:@"取消" style:UIAlertActionStyleCancel handler:^(UIAlertAction * _Nonnull action) {
        NSLog(@"取消");
        [self.tableView deselectRowAtIndexPath:indexPath animated:true];
    }]];
    
    //定义第一个输入框；
    [alertController addTextFieldWithConfigurationHandler:^(UITextField * _Nonnull textField) {
      textField.placeholder = @"请输入用户名";
    }];
    //定义第二个输入框；
    [alertController addTextFieldWithConfigurationHandler:^(UITextField * _Nonnull textField) {
      textField.placeholder = @"请输入年龄";
    }];
    //定义第三个输入框；
    [alertController addTextFieldWithConfigurationHandler:^(UITextField * _Nonnull textField) {
      textField.placeholder = @"性别";
    }];
    [self presentViewController:alertController animated:true completion:nil];
    
}

// MARK: - get / set 方法

/// get dataSource
- (NSMutableArray *)dataSource {
    if (!_dataSource) {
        _dataSource = [[NSMutableArray alloc] init];
    }
    return _dataSource;
}

/// get tableview
- (UITableView *)tableView {
    if (!_tableView) {
        _tableView = [[UITableView alloc] initWithFrame:self.view.bounds style:UITableViewStylePlain];
    }
    
    return _tableView;
}


@end

相关文章

  • iOS编程中FMDB 使用方法

    一.什么是FMDB？ 1.FMDB存在的意义 iOS中使用C语言函数对原生SQLite数据库进行增删改查操作，复杂...

  • iOS数据库FMDB

    iOS数据库FMDB 简介 iOS中使用C语言函数对原生SQLite数据库进行增删改查操作，复杂麻烦，于是，就出现...

  • FMDB

    FMDB使用，包括数据的增删改查，多线程安全处理FMDatabaseQueue的使用，和事务的使用。 代码 代码地址

  • 数据库

    数据库常用操作介绍增删改查 FMDB FMDB简单介绍 、FMDB使用 需求：判断一个table是存在 判断一个t...

  • iOS FMDB

    iOS FMDB 数据库创建、增、删、改、查。 创建对象 创建表 integer，text：类型 primary ...

  • iOS 数据库

    一，FMDB 1，FMDB 的基本使用创建数据库 创建表单 增 删 改 查 FMDatabase这个类, 他不是线...

  • FMDB在swift中的使用

    1.什么是FMDB 由于iOS中使用C语言函数对原生SQLite数据库进行增删改查操作，复杂麻烦，所以就出现了一系...

  • ios中使用FMDB数据的增删改查

    使用cocoapods集成 1. 初始化pod文件 2. 编写Podfile文件 3. 安装框架（记得重新打开项目...

  • 【转·链接】iOS FMDB对数据库进行加密

    iOS - 使用FMDB进行数据库加密iOS FMDB数据库加密相关

  • 增删改

    对于表中的操作，就是增删改查，查内容较多，这里先说增删改。 1.增（insert或者load） 即插入数据，多行插...

网友评论

      本文标题：ios中使用FMDB数据的增删改查

      本文链接：https://www.haomeiwen.com/subject/zzivbctx.html

      延伸阅读

      深度阅读

      • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

      栏目导航

      热点阅读

      关于我们|服务条款|联系我们|ios中使用FMDB数据的增删改查|投稿指南|网站地图|RSS订阅|排版工具|手机版

      提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

      Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

      备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

      本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

      所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！