Android数据库高手秘籍

http://blog.csdn.net/guolin_blog/article/details/40614197#comments

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


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


C:\Users\Administrator>adb devices
List of devices attached
90671c6e5ee3    device
emulator-5554   device




C:\Users\Administrator>adb devices
List of devices attached
90671c6e5ee3    device
emulator-5554   device




C:\Users\Administrator>adb -s emulator-5554 shell
root@generic:/ # cd data/data
cd data/data
root@generic:/data/data # ls
ls
com.android.backupconfirm
com.android.browser
com.android.calculator2
com.android.calendar
com.android.camera
com.android.certinstaller
com.android.contacts
com.android.customlocale2
com.android.defcontainer
com.android.deskclock
com.android.development
com.android.development_settings
com.android.dreams.basic
com.android.email
com.android.emulator.connectivity.test
com.android.emulator.gps.test
com.android.exchange
com.android.fallback
com.android.gallery
com.android.gesture.builder
com.android.htmlviewer
com.android.inputdevices
com.android.inputmethod.latin
com.android.inputmethod.pinyin
com.android.keychain
com.android.launcher
com.android.location.fused
com.android.mms
com.android.music
com.android.netspeed
com.android.packageinstaller
com.android.phone
com.android.protips
com.android.providers.applications
com.android.providers.calendar
com.android.providers.contacts
com.android.providers.downloads
com.android.providers.downloads.ui
com.android.providers.drm
com.android.providers.media
com.android.providers.settings
com.android.providers.telephony
com.android.providers.userdictionary
com.android.quicksearchbox
com.android.sdksetup
com.android.settings
com.android.sharedstoragebackup
com.android.shell
com.android.soundrecorder
com.android.speechrecorder
com.android.systemui
com.android.vpndialogs
com.android.wallpaper.livepicker
com.android.widgetpreview
com.example.android.apis
com.example.android.livecubes
com.example.android.softkeyboard
com.huofu.app
com.svox.pico
jp.co.omronsoft.openwnn
root@generic:/data/data # cd com.android.provider.contacts
cd com.android.provider.contacts
/system/bin/sh: cd: /data/data/com.android.provider.contacts: No such file or di
rectory
2|root@generic:/data/data # ls
ls
com.android.backupconfirm
com.android.browser
com.android.calculator2
com.android.calendar
com.android.camera
com.android.certinstaller
com.android.contacts
com.android.customlocale2
com.android.defcontainer
com.android.deskclock
com.android.development
com.android.development_settings
com.android.dreams.basic
com.android.email
com.android.emulator.connectivity.test
com.android.emulator.gps.test
com.android.exchange
com.android.fallback
com.android.gallery
com.android.gesture.builder
com.android.htmlviewer
com.android.inputdevices
com.android.inputmethod.latin
com.android.inputmethod.pinyin
com.android.keychain
com.android.launcher
com.android.location.fused
com.android.mms
com.android.music
com.android.netspeed
com.android.packageinstaller
com.android.phone
com.android.protips
com.android.providers.applications
com.android.providers.calendar
com.android.providers.contacts
com.android.providers.downloads
com.android.providers.downloads.ui
com.android.providers.drm
com.android.providers.media
com.android.providers.settings
com.android.providers.telephony
com.android.providers.userdictionary
com.android.quicksearchbox
com.android.sdksetup
com.android.settings
com.android.sharedstoragebackup
com.android.shell
com.android.soundrecorder
com.android.speechrecorder
com.android.systemui
com.android.vpndialogs
com.android.wallpaper.livepicker
com.android.widgetpreview
com.example.android.apis
com.example.android.livecubes
com.example.android.softkeyboard
com.huofu.app
com.svox.pico
jp.co.omronsoft.openwnn
root@generic:/data/data # cd com.android.providers.contacts
cd com.android.providers.contacts
root@generic:/data/data/com.android.providers.contacts # ls
ls
cache
databases
files
lib
shared_prefs
root@generic:/data/data/com.android.providers.contacts # cd databases
cd databases
root@generic:/data/data/com.android.providers.contacts/databases # ls
ls
contacts2.db
contacts2.db-journal
profile.db
profile.db-journal
root@generic:/data/data/com.android.providers.contacts/databases # sqlite3 conta
cts2.db
3 contacts2.db                                                                <
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
.tables
_sync_state               phone_lookup              view_data_usage_stat
_sync_state_metadata      photo_files               view_entities
accounts                  properties                view_groups
agg_exceptions            raw_contacts              view_raw_contacts
android_metadata          search_index              view_raw_entities
calls                     search_index_content      view_stream_items
contacts                  search_index_docsize      view_v1_contact_methods
data                      search_index_segdir       view_v1_extensions
data_usage_stat           search_index_segments     view_v1_group_membership
default_directory         search_index_stat         view_v1_groups
deleted_contacts          settings                  view_v1_organizations
directories               status_updates            view_v1_people
groups                    stream_item_photos        view_v1_phones
mimetypes                 stream_items              view_v1_photos
name_lookup               v1_settings               visible_contacts
nickname_lookup           view_contacts             voicemail_status
packages                  view_data
sqlite> .mode line
.mode line
sqlite> progma table_info(accounts);
progma table_info(accounts);
Error: near "progma": syntax error
sqlite> pragma table_info(accounts);
pragma table_info(accounts);
       cid = 0
      name = _id
      type = INTEGER
   notnull = 0
dflt_value =
        pk = 1


       cid = 1
      name = account_name
      type = TEXT
   notnull = 0
dflt_value =
        pk = 0


       cid = 2
      name = account_type
      type = TEXT
   notnull = 0
dflt_value =
        pk = 0


       cid = 3
      name = data_set
      type = TEXT
   notnull = 0
dflt_value =
        pk = 0
sqlite> select * from accounts;
select * from accounts;
sqlite> select * from sqlite_master where name = 'account';
select * from sqlite_master where name = 'account';
sqlite> select * from sqlite_master where name = 'accounts';
select * from sqlite_master where name = 'accounts';
    type = table
    name = accounts
tbl_name = accounts
rootpage = 14
     sql = CREATE TABLE accounts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_
name TEXT, account_type TEXT, data_set TEXT)
sqlite>










CREATE TABLE album (id integer primary key autoincrement,nam
e text unique default 'unknown', price real)