Android图片浏览器

当手机开机、插拔USB连接时，Android系统会启动MediaScanner，扫描SD卡和内存里面的文件，扫描的结果保存在data/data/com.android.providers.media/databases/external.db下。通过DDMS可以找到，数据库中包含了图片、视频、音乐等文件的信息。开发者不用遍历文件，只要使用ContentProvider就可以获取SD卡中不同种类的文件列表。

数据库external.db：
sqlite3 external.db
.tables
所有的表：
album_art              audio_genres           images               
album_info             audio_genres_map       log                  
albums                 audio_genres_map_noid  search               
android_metadata       audio_meta             searchhelpertitle    
artist_info            audio_playlists        semc_metadata        
artists                audio_playlists_map    semc_metadata_version
artists_albums_map     files                  thumbnails           
audio                  files_ext              video                
audio_ext              files_with_ext         videothumbnails

选择images并查询；

.mode column         (.mode column 将设置为列显示模式，.header 将显示列名)

.header ON
select * from images;

结果如下：
_id|_data|_size|_display_name|mime_type|title|date_added|date_modified|description|picasa_id|isprivate|latitude|longitude|datetaken|orientation|mini_thumb_magic|bucket_id|bucket_display_name|width|height
86|/mnt/sdcard/DCIM/100ANDRO/DSC_0001.jpg|607597|DSC_0001.jpg|image/jpeg|DSC_0001|1371782044|1361346484||||||1361346484000|90|7241443144086764191|1278012876|100ANDRO|2048|1536

示例代码：

列表界面：

public class PlayerActivity extends Activity {    private ListView listView;    private CursorAdapter adapter;    private Cursor cursor;    private String path;    @SuppressWarnings("deprecation")    @Override    protected void onCreate(Bundle savedInstanceState) {        // TODO Auto-generated method stub        super.onCreate(savedInstanceState);        setContentView(R.layout.main);        listView = (ListView)findViewById(R.id.listView);        ContentResolver contentResolver = getContentResolver();        cursor = contentResolver.query(MediaStore.Images.Media.EXTERNAL_CONTENT_URI,                null, null, null, null);        adapter = new SimpleCursorAdapter(this, android.R.layout.simple_list_item_2, cursor,                new String[] {                        MediaStore.Images.ImageColumns.TITLE, MediaStore.Images.ImageColumns.SIZE                }, new int[] {                        android.R.id.text1, android.R.id.text2                });        listView.setAdapter(adapter);        listView.setOnItemClickListener(new OnItemClickListener() {            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {                // TODO Auto-generated method stub                try {                    if (cursor.moveToPosition(position)) {                        path = cursor.getString(cursor.getColumnIndex("_data"));                    }                } catch (Exception e) {                    // TODO: handle exception                    e.printStackTrace();                }                Intent intent = new Intent(PlayerActivity.this, ShowActivity.class);                intent.putExtra("path", path);                startActivity(intent);            }        });    }    @Override    protected void onDestroy() {        // TODO Auto-generated method stub        super.onDestroy();        cursor.close();    }}

显示界面：

public class ShowActivity extends Activity {    private ImageView imageView;    @Override    protected void onCreate(Bundle savedInstanceState) {        // TODO Auto-generated method stub        super.onCreate(savedInstanceState);        this.requestWindowFeature(Window.FEATURE_NO_TITLE);        setContentView(R.layout.show);        imageView = (ImageView)findViewById(R.id.show);        Intent intent = getIntent();        String path = intent.getStringExtra("path");        BitmapDrawable drawable = new BitmapDrawable(getResources(), path);        imageView.setImageDrawable(drawable);    }}

MediaStore：基于SQLite的多媒体数据库，包含了视频、音频、图片等所有的多媒体文件的信息。
MediaStore.Audio：音频信息
MediaStore.Files：非媒体信息
MediaStore.Images：图片信息
MediaStore.Video：视频信息
MediaStore.MediaColumns：部分MediaProvider表的常用列