首页 > 代码库 > android adb shell

android adb shell

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||02|/storage/emulated/0/Recorder/新录音2.amr|新录音2|7426853000|640||03|/storage/emulated/0/Recorder/新录音3.amr|新录音3|7426855000|580||04|/storage/emulated/0/Recorder/新录音4.amr|新录音4|7426858000|1080||05|/storage/emulated/0/Recorder/新录音5.amr|新录音5|7426895000|1100||06|/storage/emulated/0/Recorder/新录音6.amr|新录音6|7426899000|1520||07|/storage/emulated/0/Recorder/新录音7.amr|新录音7|7426903000|2660||08|/storage/emulated/0/Recorder/新录音8.amr|新录音8|7426906000|880||09|/storage/emulated/0/Recorder/新录音9.amr|新录音9|7426908000|500||010|/storage/emulated/0/Recorder/新录音10.amr|新录音10|7426910000|520||011|/storage/emulated/0/Recorder/新录音11.amr|新录音11|7426912000|420||012|/storage/emulated/0/Recorder/新录音12.amr|新录音12|7426914000|480||013|/storage/emulated/0/Recorder/新录音13.amr|新录音13|7426916000|480||014|/storage/emulated/0/Recorder/新录音14.amr|新录音14|7426922000|3360||015|/storage/emulated/0/Recorder/新录音15.amr|新录音15|7427010000|2720||016|/storage/emulated/0/Recorder/新录音16.amr|新录音16|7427012000|700||017|/storage/emulated/0/Recorder/新录音17.amr|新录音17|7427015000|640||018|/storage/emulated/0/Recorder/新录音18.amr|新录音18|7427067000|1340||019|/storage/emulated/0/Recorder/新录音19.amr|新录音19|7427776000|35320||0

 

android adb shell