xitong获取SQlite音频

主类

package com.bai.xitong;

import java.util.ArrayList;
import java.util.List;

import android.app.Activity;
import android.content.ContentResolver;
import android.database.Cursor;
import android.media.MediaPlayer;
import android.os.Bundle;
import android.provider.MediaStore;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;

import com.bai.xitong.adapter.Adapter;
import com.bai.xitong.bean.Music;

public class MainActivity extends Activity {

 private ContentResolver resolver;
 private ListView lv;
 private MediaPlayer mp;
 private List<Music> lm=new ArrayList<Music>();
 private Adapter adapter;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  resolver=getContentResolver();
  lv=(ListView)findViewById(R.id.listView1);
  adapter=new Adapter(lm, this);
  lv.setAdapter(adapter);
  lv.setOnItemClickListener(listener);
 }
 OnItemClickListener listener=new OnItemClickListener() {

  @Override
  public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
    long arg3) {
   // TODO Auto-generated method stub
   Music m=(Music) adapter.getItem(arg2);
   if(mp!=null){
    mp.stop();
    mp.reset();
    mp=null;
   }
   mp=new MediaPlayer();
   try {
    mp.setDataSource(m.getPath());
    //mp.release();
    mp.prepare();
    mp.start();
   } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
 };
 public void huoqu(View v){
  if(lm.size()==0)
   lm.clear();
  //读取SqLite数据库中的音乐
  Cursor cursor = resolver.query(MediaStore.Audio.Media.EXTERNAL_CONTENT_URI, null, null, null, null);
  while(cursor.moveToNext()){
   //获取歌名
   String name=cursor.getString(cursor.getColumnIndex("_display_name"));
   //获取全路径
   String path=cursor.getString(cursor.getColumnIndex("_data"));
   //获取作者
   String geshou=cursor.getString(cursor.getColumnIndex("title"));
   //获取音乐大小
   String shichang=cursor.getString(cursor.getColumnIndex("_size"));
   lm.add(new Music(name, path, geshou, shichang));
  }
  //重置适配器重新加载
  adapter.notifyDataSetChanged();
 }

}