学习笔记-- IPhone 中使用Sqlite 保存数据

今天做了一个小例子

使用sqlite进行数据保存

-(IBAction)saveClick:(id)sender
{
	
	NSArray *path = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
	
	NSString *paths = [path objectAtIndex:0];
	NSString *file = [paths stringByAppendingPathComponent:@"User.db"];
	
	//NSLog(@"file:%@",file);
	
	char *errMsg;
	
	sqlite3_stmt *stmt;
	
	if(sqlite3_open([file UTF8String],&database) != SQLITE_OK)
	{
		NSLog(@"Failed to open Database.");
	}else 
	{
		NSString *insertSQL = [NSString stringWithFormat:@"Insert into UserName (id,names) values (9,%@",userName.text];
		NSLog(@"insert SQL:%@",insertSQL);
		
		if(sqlite3_exec(database, [insertSQL UTF8String], NULL, NULL, &errMsg) != SQLITE_OK)
		{
			NSLog(@"insert ERR:%s",errMsg);
		}else {
			NSLog(@"Insert OK");
		}

	}
	sqlite3_finalize(stmt);
	
	NSLog(@"SaveClick");
}

标记一下。。。