#import "PersonDBTool.h"
#import <FMDB.h>
@implementation PersonDBTool
static FMDatabase *_dataBase;
+ (void)initialize{
//1.创建数据,并且打开/连接到沙盒中的数据库
NSString *documentPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
NSString *filePath = [documentPath stringByAppendingPathComponent:@"person.db"];
_dataBase = [FMDatabase databaseWithPath:filePath];
//2.打开
BOOL result = [_dataBase open];
if(result){
//3.创建表
BOOL createTableResult = [_dataBase executeUpdate:@"create table if not exists t_person(id integer primary key,name text,age integer);"];
if(createTableResult){
NSLog(@"create Table ok!!!");
}else{
NSLog(@"error!!!");
}
}
}
#pragma mark - FMDB DML语句
+ (void)insertPerson:(Person *)person{
[_dataBase executeUpdateWithFormat:@"insert into t_person(name,age) values(%@,%d) ;",person.name,person.age];
}
+ (void)updatePerson:(Person *)person{
[_dataBase executeUpdateWithFormat:@"update t_person set age = %d where name = %@",person.age,person.name];
}
+ (void)deletePersonWithId:(int)personId{
[_dataBase executeUpdateWithFormat:@"delete from t_person where id = %d",personId];
}
#pragma mark - DQL语句
+ (NSArray *)queryAllPerson{
NSMutableArray *persons = [NSMutableArray array];
FMResultSet *resultSet = [_dataBase executeQuery:@"select * from t_person"];
while ([resultSet next]) {//遍历到每一条记录
NSString *pname = [resultSet stringForColumn:@"name"];
int age = [resultSet intForColumn:@"age"];
Person *p = [[Person alloc] init];
p.name = pname;
p.age = age;
[persons addObject:p];
}
return persons.copy;
}
+ (NSArray *)queryPersonWithKeyWord:(NSString *)keyWord{
NSMutableArray *persons = [NSMutableArray array];
FMResultSet *resultSet = [_dataBase executeQuery:[NSString stringWithFormat:@"select * from t_person where name like '%%%@%%';",keyWord]];
while ([resultSet next]) {//遍历到每一条记录
NSString *pname = [resultSet stringForColumn:@"name"];
int age = [resultSet intForColumn:@"age"];
Person *p = [[Person alloc] init];
p.name = pname;
p.age = age;
[persons addObject:p];
}
return persons.copy;
}
@end
FMDB基本使用
最新推荐文章于 2024-01-12 16:17:32 发布