add by 2015.05.08
在Ubuntu12.04上查看sqlite数据库工具,可以安装
sudo apt-get install sqliteman
非常不错的桌面工具
在Window下可以使用:SQLite Expert
----------------------------------------------------------------------------
在调试过程中,需要修改数据库中的数据,此时就要用到sqlite3工具,可以方便我们调试
由于在界面上无法打开“数据连接”,只能通过修改数据库来打开
下面先来看下如何修改表global中的mobile_data数据
dzt@dzt-All-Series:~$ adb root
adbd is already running as root
dzt@dzt-All-Series:~$ adb remount
remount succeeded
dzt@dzt-All-Series:~$ adb shell
root@GiONEE:/ # cd data/da
dalvik-cache/ data/ data_tmpfs_log/
root@GiONEE:/ # cd data/dat
data/ data_tmpfs_log/
root@GiONEE:/ # cd data/data/com.android.providers.settings
root@GiONEE:/data/data/com.android.providers.settings # ls
databases
lib
root@GiONEE:/data/data/com.android.providers.settings # cd databases
root@GiONEE:/data/data/com.android.providers.settings/databases # ls
settings.db
settings.db-journal
qlite3 settings.db <
SQLite version 3.8.6 2014-08-15 11:46:33
Enter ".help" for usage hints.
sqlite> .table
android_metadata bookmarks secure
bluetooth_devices global system
sqlite> select * from global;
1|airplane_mode_on|0
2|airplane_mode_radios|cell,bluetooth,wifi,nfc,wimax
3|airplane_mode_toggleable_radios|bluetooth,wifi,nfc
4|assisted_gps_enabled|1
5|auto_time|1
6|auto_time_zone|1
7|stay_on_while_plugged_in|0
8|wifi_sleep_policy|2
9|mode_ringer|2
10|package_verifier_enable|1
12|wifi_networks_available_notification_on|1
13|bluetooth_on|0
14|cdma_cell_broadcast_sms|1
15|data_roaming|0
18|netstats_enabled|1
19|install_non_market_apps|0
20|usb_mass_storage_enabled|1
21|wifi_max_dhcp_retry_count|9
22|wifi_display_on|0
23|lock_sound|/system/media/audio/ui/Lock.ogg
24|unlock_sound|/system/media/audio/ui/Unlock.ogg
25|trusted_sound|/system/media/audio/ui/Trusted.ogg
26|power_sounds_enabled|1
27|low_battery_sound|/system/media/audio/ui/LowBattery.ogg
28|dock_sounds_enabled|0
29|desk_dock_sound|/system/media/audio/ui/Dock.ogg
30|desk_undock_sound|/system/media/audio/ui/Undock.ogg
31|car_dock_sound|/system/media/audio/ui/Dock.ogg
32|car_undock_sound|/system/media/audio/ui/Undock.ogg
33|wireless_charging_started_sound|/system/media/audio/ui/WirelessChargingStarted.ogg
34|dock_audio_media_enabled|1
35|set_install_location|0
36|default_install_location|0
37|emergency_tone|0
38|call_auto_retry|0
40|subscription_mode|0
41|low_battery_sound_timeout|0
42|wifi_scan_always_enabled|1
43|heads_up_notifications_enabled|1
44|device_name|GN9006
45|guest_user_enabled|1
46|data_roaming_2|0