响应UIWebView的点击事件(播放声音)，从数据库中取出声音保存在本地。

最新推荐文章于 2023-02-26 14:11:46 发布

zlwonder

最新推荐文章于 2023-02-26 14:11:46 发布

阅读量127

点赞数

分类专栏： iPhone开发文章标签： SQLite Objective-C Cache Scheme SQL

本文链接：https://blog.csdn.net/zlwonder/article/details/83708289

版权

iPhone开发专栏收录该内容

25 篇文章 0 订阅

订阅专栏

在iPhone开发中经常会遇到需要在UIWebView中点击按钮并进行相应的操作，比如点击按钮播放声音等，以下是代码，并从数据库中取出声音数据，以文件的形式保存在本地。


- (BOOL)webView:(UIWebView*)webView shouldStartLoadWithRequest:(NSURLRequest*)request navigationType:(UIWebViewNavigationType)navigationType {
		...AppDelegate *appDelegate=(...AppDelegate *)[[UIApplication sharedApplication] delegate];
	if (navigationType == UIWebViewNavigationTypeLinkClicked) {
		NSURL *URL = [request URL];	
		NSLog([URL scheme]);
		NSLog([URL absoluteString]);

		//.......code here and call the delegate method


		NSAutoreleasePool *pool=[[NSAutoreleasePool alloc] init];
		BOOL audioResult=FALSE;
		NSFileManager *fileManager = [NSFileManager defaultManager];
		//check if file existed in cache folder
		NSArray *cache = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES);
		NSString *cachePath = [cache objectAtIndex:0] ;
		NSString *filepath ;

		filepath=[cachePath stringByAppendingPathComponent:[audioId stringByAppendingString:@".wav"]];

		if ([fileManager fileExistsAtPath:filepath]==YES){
			[self playVoice:filepath];
		}
		else
		{
			audioResult=[appDelegate saveAudio:audioId];
			if (audioResult==YES)
			{
				//NSLog(@"Speak the audio by the path=%@",filepath);
				[self playVoice:filepath];
			}
		}
		[pool release];



		[appDelegate saveAudio:gotFM];

	}

保存声音的方法：


-(BOOL)saveAudio:(NSString *)key
{
	NSLog(key);
	BOOL saveSuccess=FALSE;
	NSString *dbPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"testVoice.db"];	

	if(sqlite3_open([dbPath UTF8String], &database_voice) == SQLITE_OK)
	{

		NSString *sqlString=[NSString stringWithFormat:@"select * from tb_voice where id='%@'",key];
		NSLog(sqlString);
		const char *sql_char=[sqlString UTF8String];
		//prepare the select statement
		int returnValue = sqlite3_prepare_v2(database_voice, sql_char, -1, &selectStatement, NULL);
		if(returnValue == SQLITE_OK)
		{
			//loop all the rows returned by the query.
			if(sqlite3_step(selectStatement) == SQLITE_ROW)
			{

				NSFileManager *fileManager = [NSFileManager defaultManager];
				NSArray *cache = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES);
				NSString *cachePath = [cache objectAtIndex:0] ;


				NSString *filename=[NSString stringWithUTF8String:(char *)sqlite3_column_text(selectStatement, 0)];
				NSLog(filename);

				NSData *fileData=[NSData dataWithBytes:sqlite3_column_blob(selectStatement, 2) length:sqlite3_column_bytes(selectStatement,2)];
				//save the file data

				//check 
				NSString *filepath = [cachePath stringByAppendingPathComponent:filename];	

				filepath=[filepath stringByAppendingString:@".wav"];
				if ([fileManager createDirectoryAtPath:cachePath attributes:nil]==NO){
					NSLog(@"fileManager createDirectoryAtPath:cachePath attributes:nil");
				}

				if ([fileData writeToFile:filepath atomically:YES]){
					saveSuccess=TRUE;
					//NSLog(@"saveSuccess");
					NSLog(@"returnValue");
				}
				else
				{
					//NSLog(@"save Fail");
				}
			}
			sqlite3_finalize(selectStatement);
		}
	}
	return saveSuccess;
}