FMDB HelloWorld

new_gist_file

//使用 FMDB 只要加入libsqlite3.0.dylib 好像 libsqlite3.dylib 也可以没差别。。。
//注意占位符后面的参数需要是 NSString NSNumber 这样的，不能是 int bool,NSInteger 这些
- (BOOL)saveUser:(NSString *)name age:(int)age sex:(bool)male {
	NSArray		*paths			= NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
	NSString	*documentDir	= [paths objectAtIndex:0];
	NSString	*dbpath			= [documentDir stringByAppendingPathComponent:@"user.db"];
	FMDatabase	*db				= [FMDatabase databaseWithPath:dbpath];

	if (![db open]) {
		return NO;
	}

	NSString	*sql	= @"insert into user(name,age,sex) values(?,?,?);";
	bool		result	= [db executeUpdate:sql, name, [NSNumber numberWithInt:age], [NSNumber numberWithBool:male]];

	if (!result) {
		[db close];
		return NO;
	}

	[db close];
	return YES;
}