通过命令行操作安卓数据库

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>adb shell
error: more than one device/emulator

C:\Users\Administrator>adb devices
List of devices attached
127.0.0.1:26944 device
HAOZ5HPF5LHUSCCM        unauthorized

C:\Users\Administrator>adb -s 127.0.0.1:26944 shell
nping.httprequest01/databases/                                                <
root@android:/data/data/com.example.fujianping.httprequest01/databases #
root@android:/data/data/com.example.fujianping.httprequest01/databases # ls
BookStore.db
BookStore.db-journal
ite3 BookStore.db                                                             <
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
android_metadata  book              table_schema
sqlite> select * from book;
1|author0|bookname0
2|author1|bookname1
3|author2|bookname2
4|author3|bookname3
5|author4|bookname4
sqlite>