android adb shell

浏览数：74 / 时间：2015年06月11日

1:进入模式

adb shell

2:进入目录

cd dir

3:查看sqlite 数据库

sqlite>sqlite3 name.db

4:查看该数据库有那些表，查看表名

sqlite> .tables

4:查看表结构

sqlite> .schema

CREATE TABLE android_metadata (locale TEXT); CREATE TABLE record(_id integer primary key autoincrement,recordPath text,recordName text,recordTime integer,recordDuring integer,recordFlags text,recordIsCall integer default 0);

5:查看表内容

sqlite> select * from tablename;



1|/storage/emulated/0/Recorder/新录音1.amr|新录音1|7426851000|4060||0
2|/storage/emulated/0/Recorder/新录音2.amr|新录音2|7426853000|640||0
3|/storage/emulated/0/Recorder/新录音3.amr|新录音3|7426855000|580||0
4|/storage/emulated/0/Recorder/新录音4.amr|新录音4|7426858000|1080||0
5|/storage/emulated/0/Recorder/新录音5.amr|新录音5|7426895000|1100||0
6|/storage/emulated/0/Recorder/新录音6.amr|新录音6|7426899000|1520||0
7|/storage/emulated/0/Recorder/新录音7.amr|新录音7|7426903000|2660||0
8|/storage/emulated/0/Recorder/新录音8.amr|新录音8|7426906000|880||0
9|/storage/emulated/0/Recorder/新录音9.amr|新录音9|7426908000|500||0
10|/storage/emulated/0/Recorder/新录音10.amr|新录音10|7426910000|520||0
11|/storage/emulated/0/Recorder/新录音11.amr|新录音11|7426912000|420||0
12|/storage/emulated/0/Recorder/新录音12.amr|新录音12|7426914000|480||0
13|/storage/emulated/0/Recorder/新录音13.amr|新录音13|7426916000|480||0
14|/storage/emulated/0/Recorder/新录音14.amr|新录音14|7426922000|3360||0
15|/storage/emulated/0/Recorder/新录音15.amr|新录音15|7427010000|2720||0
16|/storage/emulated/0/Recorder/新录音16.amr|新录音16|7427012000|700||0
17|/storage/emulated/0/Recorder/新录音17.amr|新录音17|7427015000|640||0
18|/storage/emulated/0/Recorder/新录音18.amr|新录音18|7427067000|1340||0
19|/storage/emulated/0/Recorder/新录音19.amr|新录音19|7427776000|35320||0