ADB操作Android联系人数据库

1.获得一个ADB的shell

D:/android/tools>adb shell

 

2.进入contacts联系人数据库
# cd /data/data/com.android.providers.contacts/databases

 

3.用ls命令列举数据库文件

# ls
contacts2.db

 

4.用sqlite3命令打开数据库

# sqlite3 contacts2.db
SQLite version 3.5.9
Enter ".help" for instructions

 

5.查看数据库中的表

sqlite> .tables
_sync_state                       status_updates
_sync_state_metadata              v1_settings
activities                        view_contacts
agg_exceptions                    view_contacts_restricted
android_metadata                  view_data
calls                             view_data_restricted
contact_entities_view             view_groups
contact_entities_view_restricted  view_raw_contacts
contacts                          view_raw_contacts_restricted
data                              view_v1_contact_methods
groups                            view_v1_extensions
mimetypes                         view_v1_group_membership
name_lookup                       view_v1_groups
nickname_lookup                   view_v1_organizations
packages                          view_v1_people
phone_lookup                      view_v1_phones
raw_contacts                      view_v1_photos
settings

 

6.使用SQL语句查询数据

sqlite> select mimetype_id, raw_contact_id, data1, data2, data3, data4, data5, data6, data7, data8, data9,

data10 from data;
4|1|1-345-693-7321|1||12373965431||||||
5|1|sum milton|sum|milton|pre|mid|suffix|givenName|givenMid|givenFamily|
1|1|dd@ff.com|1||||||||
2|1|987654321|3|||4|||||
2|1|gg@live.cn|3|||1|||||
2|1|aimnumber|3|||0|||||
3|1|TD
ChengDu, SiChuan 643208
China|1||TD|||ChengDu|SiChuan|643208|China
9|1|hahei|||||||||
3|1|street
pobox
neighborhood
city, state zipcode
country|2||street|pobox|neighborhood|city|state|zipcode|country
3|1|d
df, a z|3||d|||df|a|z|
10|1|GAngGAng|1||||||||
11|1|www.mscof.com|7||||||||
8|1|company|1||position||||||

注：也可使用可视化工具SQLiteDeveloper进行查看和修改。