所有的应用程序本地文件都存放在/data/data/目录下
1C:\Users\nicole>adb shell 2* daemon not running. starting it now on port 5039 * 3* daemon started successfully * 4 5N555J:/ $ su （$只是普通用户，su命令切换到超级用户#） 6 7N555J:/ # cd data/data 8 9N555J:/data/data # ls
查看Media数据库
1N555J:/data/data # cd com.android.providers.media 2 3N555J:/data/data/com.android.providers.media # ls 4cache code_cache databases files shared_prefs 5N555J:/data/data/com.android.providers.media # cd databases 6 7N555J:/data/data/com.android.providers.media/databases # ls 8external.db external.db-wal internal.db-shm 9external.db-shm internal.db internal.db-wal
查看某个数据库所有表
1N555J:/data/data/com.android.providers.media/databases # sqlite3 external.db 2SQLite version 3.19.4 2017-08-18 19:28:12 3Enter ".help" for usage hints. 4 5sqlite> .table 6album_art audio_genres log 7album_info audio_genres_map search 8albums audio_genres_map_noid searchhelpertitle 9android_metadata audio_meta thumbnails 10artist_info audio_playlists video 11artists audio_playlists_map videothumbnails 12artists_albums_map files 13audio images 14 15sqlite>
查看表结构
1sqlite> pragma table_info(images); 2pragma table_info(images); 30|_id|INTEGER|0||0 41|_data|TEXT|0||0 52|_size|INTEGER|0||0 63|_display_name|TEXT|0||0 74|mime_type|TEXT|0||0 85|title|TEXT|0||0 96|date_added|INTEGER|0||0 107|date_modified|INTEGER|0||0 118|description|TEXT|0||0 129|picasa_id|TEXT|0||0 1310|isprivate|INTEGER|0||0 1411|latitude|DOUBLE|0||0 1512|longitude|DOUBLE|0||0 1613|datetaken|INTEGER|0||0 1714|orientation|INTEGER|0||0 1815|mini_thumb_magic|INTEGER|0||0 1916|bucket_id|TEXT|0||0 2017|bucket_display_name|TEXT|0||0 2118|width|INTEGER|0||0 2219|height|INTEGER|0||0 2320|is_favorite|INTEGER|0||0 2421|date_favorited|LONG|0||0 2522|datetaken_favorited|LONG|0||0 2623|creator_package|TEXT|0||0
切换显示模式
1sqlite> .mode line 2 3sqlite> pragma table_info(images); 4pragma table_info(images); 5 cid = 0 6 name = _id 7 type = INTEGER 8 notnull = 0 9dflt_value = 10 pk = 0 11 12 cid = 1 13 name = _data 14 type = TEXT 15 notnull = 0 16dflt_value = 17 pk = 0 18 19 cid = 2 20 name = _size 21 type = INTEGER 22 notnull = 0 23dflt_value = 24 pk = 0
查询表中的数据
1sqlite> select * from images; 2 3 _id = 1 4 _data = /storage/emulated/0/Pictures/Screenshots/Screenshot_2018-05-10-10-27-04.png 5 _size = 1987030 6 _display_name = Screenshot_2018-05-10-10-27-04.png 7 mime_type = image/png 8 title = Screenshot_2018-05-10-10-27-04.png 9 date_added = 1525919227 10 date_modified = 1525919227 11 description = 12 picasa_id = 13 isprivate = 14 latitude = 15 longitude = 16 datetaken = 1525919224704 17 orientation = 18 mini_thumb_magic = 19 bucket_id = 1028075469 20bucket_display_name = Screenshots 21 width = 1080 22 height = 2160 23 is_favorite = 0 24 date_favorited = 1525919227 25datetaken_favorited = 1525919227098 26 creator_package =
查看数据库所有表的建表语句(每个SQLite数据库中都还有一个隐藏的sqlite_master表)
1sqlite> select * from sqlite_master; 2 type = table 3 name = android_metadata 4tbl_name = android_metadata 5rootpage = 3 6 sql = CREATE TABLE android_metadata (locale TEXT) 7 8 type = table 9 name = thumbnails 10tbl_name = thumbnails 11rootpage = 6 12 sql = CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER,kind INTEGER,width INTEGER,height INTEGER) 13 14 type = index 15 name = image_id_index 16tbl_name = thumbnails 17rootpage = 7 18 sql = CREATE INDEX image_id_index on thumbnails(image_id) 19 20 type = table 21 name = artists 22tbl_name = artists 23rootpage = 10 24 sql = CREATE TABLE artists (artist_id INTEGER PRIMARY KEY,artist_key TEXT NOT NULL UNIQUE,artist TEXT NOT NULL)