大家帮忙看看,我用service调用音乐文件然后插入自己创建的数据库,在avd上正常，可是在手机上总是意外关闭

package com.musicplayer;



import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.text.DecimalFormat;

import java.util.LinkedList;



import android.content.BroadcastReceiver;

import android.content.ContentResolver;

import android.content.Context;

import android.content.Intent;

import android.content.IntentFilter;

import android.content.SharedPreferences;

import android.database.Cursor;

import android.util.Log;



import android.app.Service;

import android.media.MediaPlayer;

import android.os.Bundle;

import android.os.IBinder;

import android.provider.MediaStore;



public class UpdateService extends Service{



	private MySql mysql;

	private BroadcastReceiver receiver;

	

	@Override

	public IBinder onBind(Intent arg0) {

		

		return null;

	}

	

	public void onCreate(){



		receiver=new commandReceiver();

		IntentFilter filter=new IntentFilter();

		filter.addAction("android.intent.action.update");

		UpdateService.this.registerReceiver(receiver, filter);

		super.onCreate();



	}

	

	public void onStart(Intent intent,int startId){



		super.onStart(intent, startId);

			

	}

	

	public void onDestroy(){

		

		UpdateService.this.unregisterReceiver(receiver);

		super.onDestroy();

		

	}

	

	

	public class commandReceiver extends BroadcastReceiver{



		@Override

		public void onReceive(Context context, Intent intent) {

		

			

			Bundle bd=intent.getExtras();

			if(bd.getBoolean("update",false)){

			

				getdata();

				

			}

			

		}

		

		

	}

	

	public void getdata(){

		

		 //实例化数据库

		mysql=new MySql(UpdateService.this);

		mysql.open(MusicplayerActivity.DB_NAME);

		mysql.execsql("delete from "+MusicplayerActivity.DB_TABLE);

		

		//利用contentprovider获取音乐文件

		

		ContentResolver resolver=this.getContentResolver();

		Cursor cur=resolver.query(MediaStore.Audio.Media.EXTERNAL_CONTENT_URI, null, null, null, null);

		

		int count=cur.getCount();

		

		cur.moveToFirst();

		for(int i=0;i<count;i++){

			

			String album=cur.getString(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.ALBUM));

			int album_id=cur.getInt(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.ALBUM_ID));

			String artist=cur.getString(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.ARTIST));

			int artist_id=cur.getInt(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.ARTIST_ID));

			String filename=cur.getString(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.DATA));

			String title=cur.getString(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.TITLE));

			int duration=cur.getInt(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.DURATION));

			int filesize=cur.getInt(cur.getColumnIndexOrThrow(MediaStore.Audio.Media.SIZE));

			

			String sqlstr="insert into "+MusicplayerActivity.DB_TABLE+"(album,album_id,artist,artist_id,filepath,title,duration,filesize) values('"+album+"',"+album_id+",'"+artist+"',"+artist_id+",'"+filename+"',"+"'"+title+"',"+duration+","+"'"+filesize+"')";

			

			//Log.i("sql",sqlstr);

			mysql.execsql(sqlstr);

			

			cur.moveToNext();

			

		}

		

		cur.close();

		

		mysql.close();

		

		

	}

	

	

	



	

	





}

补充：移动开发 ,  Android

上一个：Android 播放 FLV格式视频
下一个：加入Android开发行列，过来推荐两个教学视频