//参数是一个block
-(void)executeSQL:(void (^)(FMDatabase *db))block{
NSString *path = [NSString stringWithFormat:@"%@/Documents/db.sqlite",NSHomeDirectory()];
FMDatabase *db = [[FMDatabase alloc] initWithPath:path];
//打开开
[db open];
//执行sql语句
block(db);
//关闭
[db close];
}
//创建数据库
- (IBAction)create:(id)sender {
//创建table
[self executeSQL:^(FMDatabase *db) {
[db executeUpdate:@"create table if not exists userInfo(id integer primary key autoincrement,name varchar(256),age integer,image blob)"];
//varchar
}];
}
添加表格
- (IBAction)add:(id)sender {
[self executeSQL:^(FMDatabase *db) {
[db executeUpdate:@"insert into userInfo(name,age) values(?,?)", @"孙林泽", @"22"];
}];
}
//删除
- (IBAction)delete:(id)sender {
[self executeSQL:^(FMDatabase *db) {
[db executeUpdate:@"delete from userInfo where name = ?", @"孙林泽"];
}];
}
//修改
- (IBAction)modify:(id)sender {
[self executeSQL:^(FMDatabase *db) {
[db executeUpdate:@"update userInfo set name=?,age=?,image=? where name =?",@"李彩玉",@"18",@"孙林泽"];
}];
}
//查询
- (IBAction)query:(id)sender {
[self executeSQL:^(FMDatabase *db) {
FMResultSet *result =[db executeQuery:@"select * from userInfo"];
while ([result next]) {
NSLog(@"name=%@",[result stringForColumn:@"name"]);
NSLog(@"age=%d",[result intForColumn:@"age"]);
}
}];
}