IOS基礎(chǔ)基于pod上手體驗FMDB框架

// // ViewController.m // FMDBSingleOC // // Created by 魯軍 on 2021/3/17. //#import "ViewController.h" #import <FMDatabase.h>@interface ViewController ()@property(nonatomic,strong)FMDatabase *db; @end@implementation ViewController- (void)viewDidLoad {[super viewDidLoad];NSString *doc = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];NSString *fileName = [doc stringByAppendingPathComponent:@"students.sqlite"];FMDatabase *db = [FMDatabase databaseWithPath:fileName];if(![db open]){return;}BOOL result = [db executeUpdate:@"create table if not exists t_student (id integer primary key autoincrement, name text not null,age integer not null);"];if(result){NSLog(@"創(chuàng)表成功");}else{NSLog(@"創(chuàng)表失敗");}self.db = db; } - (void)touchesBegan:(NSSet<UITouch *> *)touches withEvent:(UIEvent *)event{// [self insert];//[self query];[self delete1];NSLog(@"%@",NSHomeDirectory()); }-(void)insert{for(int i=0;i<10;i++){NSString *name = [NSString stringWithFormat:@"jack-%d",arc4random_uniform(100)]; // // [self.db executeUpdate:@"insert into t_student (name,age) values (?,?)",name,@(arc4random_uniform(40))]; // [self.db executeUpdateWithFormat:@"insert into t_student (name,age) values (%@,%d);",name,arc4random_uniform(40)];}}-(void)delete1{ // [self.db executeUpdate:@"delete from t_student;"];[self.db executeUpdate:@"drop table if exists t_student;"]; }-(void)query{FMResultSet *resultSet = [self.db executeQuery:@"select * from t_student"];while ([resultSet next]) {int ID = [resultSet intForColumn:@"id"];NSString *name = [resultSet stringForColumn:@"name"];int age = [resultSet intForColumn:@"age"];NSLog(@"%d %@ %d",ID,name,age);} } @end

總結(jié)

以上是生活随笔為你收集整理的IOS基础基于pod上手体验FMDB框架的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。