ios上的数据库操作实例

NSLog(@"onButtonClicked");
	NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);  
	NSString *documentDirectory = [paths objectAtIndex:0];  
	//dbPath： 数据库路径，在Document中。  
	NSString *dbPath = [documentDirectory stringByAppendingPathComponent:@"test.db"];
	FMDatabase *db= [FMDatabase databaseWithPath:dbPath];  
	if (![db open]) {  
		NSLog(@"Could not open db."); 
		return;
	}
	NSLog(@"db opened");
	BOOL b1 =  [db executeUpdate:@"create table if not exists user (id integer primary key, name varchar, age integer);"];
	if(!b1)
	{
		NSLog(@"create table failed");
	}
	/插入数据
	NSString *sqlaa = nil;
	sqlaa = @"insert into user (name,age) values ('samyou',18);";
	sqlaa = [NSString stringWithFormat:@"insert into user (name,age) values ('%@',%d);",@"sam",22];
	NSLog(sqlaa);
	BOOL b2 =  [db executeUpdate:sqlaa];
	if(!b2)
	{
		NSLog(@"insert failed");
	}
	/修改数据
	NSString *sqlbb = [NSString stringWithFormat:@"UPDATE user SET name = '%@',age = %d WHERE age = %d ",@"咪咪",10,18]; 
	NSLog(sqlbb);
	BOOL b3 = [db executeUpdate:sqlbb];
	if(!b3)
	{
		NSLog(@"update failed");
	}
	///查询数据
	FMResultSet *rs = [db executeQuery:@"select * from user"];
	if(rs)
	{
		NSLog(@"get rs");
	}
	while ([rs next]) {
		NSLog(@"%@%d",[rs stringForColumn:@"name"],[rs intForColumn:@"age"]);
	}
	//close
	[rs close];
	[db close];

参考了http://blog.csdn.net/f520131480315/article/details/6444297的文章,有些细节的东西请看原文

上传了一个源代码工程，可以去我的资源页下载

http://download.csdn.net/detail/samguoyi/4433645