ios数据存储方式FMDB

来源：互联网发布：如何评价新东方知乎编辑：程序博客网时间：2024/05/01 09:12

从网上下载FMDB的原码,将其拖入到项目中，然后在Link Binary With Libraries中添加libsqlite3.dylib,就可以用了

实现如下：

[plain] view plaincopyprint?

#import "ViewController.h"
#import "FMDatabase.h"
#import "FMDatabaseAdditions.h"
#import "FMDatabaseQueue.h"
@interface ViewController ()
@end
@implementation ViewController
- (void)viewDidLoad
{
[super viewDidLoad];
// Do any additional setup after loading the view, typically from a nib.
}
- (void)didReceiveMemoryWarning
{
[super didReceiveMemoryWarning];
// Dispose of any resources that can be recreated.
}
- (void)dealloc {
[_nameText release];
[_ageText release];
[_sexText release];
[_showLabel release];
[super dealloc];
}
- (void)viewDidUnload {
[self setNameText:nil];
[self setAgeText:nil];
[self setSexText:nil];
[self setShowLabel:nil];
[super viewDidUnload];
}
//保存
- (IBAction)saveBtn:(id)sender {
FMDatabase* database=[FMDatabase databaseWithPath:[self databasePath]];
if (![database open]) {
NSLog(@"Open database failed");
return;
}
if (![database tableExists:@"user"]) {
[database executeUpdate:@"create table user (id integer primary key autoincrement not null,name text,age integer,sex text)"];
}
BOOL insert=[database executeUpdate:@"insert into user (name,age,sex) values (?,?,?)",_nameText.text,[NSNumber numberWithInteger:[_ageText.text integerValue]],_sexText.text];
//下面注释的也能实现数据的插入,只不过它是传入了字典
// NSMutableDictionary* argsDict=[NSMutableDictionary dictionary];
// [argsDict setObject:_nameText.text forKey:@"name"];
// [argsDict setObject:_ageText.text forKey:@"age"];
// [argsDict setObject:_sexText.text forKey:@"sex"];
// BOOL insert=[database executeUpdate:@"insert into user (name,age,sex) values (:name,:age,:sex)" withParameterDictionary:argsDict];
if (insert) {
UIAlertView* alert=[[UIAlertView alloc] initWithTitle:@"提示" message:@"保存成功" delegate:nil cancelButtonTitle:nil otherButtonTitles:@"确定",nil];
[alert show];
[alert release];
}else{
NSLog(@"insert failed");
}
[database close];
//下面注释的这一段也是创建表只不过它是多线程安全的，而上面的在多线程中是不安全的
// FMDatabaseQueue* queue=[FMDatabaseQueue databaseQueueWithPath:[self databasePath]];
// [queue inDatabase:^(FMDatabase* database){
// if (![database tableExists:@"user"]) {
// [database executeUpdate:@"create table user (id integer primary key autoincrement not null,name text,age integer,sex text)"];
// }
// BOOL insert=[database executeUpdate:@"insert into user (name,age,sex) values (?,?,?)",_nameText.text,[NSNumber numberWithInteger:[_ageText.text integerValue]],_sexText.text];
// if (insert) {
// UIAlertView* alert=[[UIAlertView alloc] initWithTitle:@"提示" message:@"保存成功" delegate:nil cancelButtonTitle:nil otherButtonTitles:@"确定",nil];
// [alert show];
// [alert release];
// }else{
// NSLog(@"insert failed");
// }
//
// }];
// [queue close];
}
//显示所有数据库中的数据
- (IBAction)showBtn:(id)sender {
FMDatabase* database=[FMDatabase databaseWithPath:[self databasePath]];
if (![database open]) {
return;
}
//注意此处的FMResultSet可以不用关闭，因为数据库关闭的时候FMResultSet自动关闭
FMResultSet* resultSet=[database executeQuery:@"select* from user"];
NSString* str=@"";
while ([resultSet next]) {
NSString* name=[resultSet stringForColumn:@"name"];
NSInteger age=[resultSet intForColumn:@"age"];
NSString* sex=[resultSet stringForColumn:@"sex"];
str=[str stringByAppendingFormat:@"Name:%@,Age:%d,Sex:%@\n",name,age,sex];
NSLog(@"Name:%@,Age:%d,Sex:%@\n",name,age,sex);
}
_showLabel.text=str;
[database close];
}
//查询
- (IBAction)checkBtn:(id)sender {
FMDatabase* database=[FMDatabase databaseWithPath:[self databasePath]];
if (![database open]) {
return;
}
FMResultSet* resultSet=[database executeQuery:@"select* from user where name = ?",@"chen"];
NSString* str=@"";
while ([resultSet next]) {
NSString* name=[resultSet stringForColumn:@"name"];
NSInteger age=[resultSet intForColumn:@"age"];
NSString* sex=[resultSet stringForColumn:@"sex"];
str=[str stringByAppendingFormat:@"Name:%@,Age:%d,Sex:%@\n",name,age,sex];
}
_showLabel.text=str;
[database close];
}
//删除
- (IBAction)deleteBtn:(id)sender {
FMDatabase* database=[FMDatabase databaseWithPath:[self databasePath]];
if (![database open]) {
return;
}
BOOL delete=[database executeUpdate:@"delete from user where name = ?",@"chen"];
if (delete) {
UIAlertView* alert=[[UIAlertView alloc] initWithTitle:@"提示" message:@"删除成功" delegate:nil cancelButtonTitle:nil otherButtonTitles:@"确定",nil];
[alert show];
[alert release];
}
[database close];
}
//更新
- (IBAction)updateBtn:(id)sender {
FMDatabase* database=[FMDatabase databaseWithPath:[self databasePath]];
if (![database open]) {
return;
}
BOOL update=[database executeUpdate:@"update user set age = ? where name= ?",[NSNumber numberWithInt:20],@"chen"];
if (update) {
UIAlertView* alert=[[UIAlertView alloc] initWithTitle:@"提示" message:@"更新成功" delegate:nil cancelButtonTitle:nil otherButtonTitles:@"确定",nil];
[alert show];
[alert release];
}
[database close];
}
-(NSString* )databasePath
{
NSString* path=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0];
NSString* dbPath=[path stringByAppendingPathComponent:@"user.db"];
return dbPath;
}
@end

0 0