打开android设备上的settings.db数据库

C:\Documents and Settings\Administrator>adb shell

# sqlite3 data/data/com.android.providers.settings/databases/settings.db

sqlite3 data/data/com.android.providers.settings/databases/settings.db

SQLite version 3.6.22

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite> .databases

.databases

seq  name             file

---  ---------------  ----------------------------------------------------------

0    main             //data/data/com.android.providers.settings/databases/setti

sqlite> .tables

.tables

android_metadata   bookmarks          system

bluetooth_devices  secure

sqlite> select * from system;

select * from system;

1|volume_music|11

2|volume_ring|5

3|volume_system|7

4|volume_voice|4

5|volume_alarm|6

6|volume_notification|5

7|volume_bluetooth_sco|7

8|mode_ringer|2

9|vibrate_on|4

10|mode_ringer_streams_affected|166

11|mute_streams_affected|46

12|dim_screen|1

13|stay_on_while_plugged_in|0

14|screen_off_timeout|60000

15|emergency_tone|0

16|call_auto_retry|0

17|dtmf_tone_type|0

18|hearing_aid|0

19|tty_mode|0

20|airplane_mode_on|0

21|airplane_mode_radios|cell,bluetooth,wifi

22|airplane_mode_toggleable_radios|wifi

23|auto_time|1

24|screen_brightness|102

25|screen_brightness_mode|0

26|window_animation_scale|1.0

27|transition_animation_scale|1.0

28|accelerometer_rotation|1

29|haptic_feedback_enabled|1

30|notification_light_pulse|1

31|set_install_location|0

32|default_install_location|0

33|power_sounds_enabled|1

34|low_battery_sound|/system/media/audio/ui/LowBattery.ogg

35|dock_sounds_enabled|0

36|desk_dock_sound|/system/media/audio/ui/Dock.ogg

37|desk_undock_sound|/system/media/audio/ui/Undock.ogg

38|car_dock_sound|/system/media/audio/ui/Dock.ogg

39|car_undock_sound|/system/media/audio/ui/Undock.ogg

40|lockscreen_sounds_enabled|0

41|lock_sound|/system/media/audio/ui/Lock.ogg

42|unlock_sound|/system/media/audio/ui/Unlock.ogg

43|vibrate_in_silent|1

44|volume_ring_last_audible|5

45|next_alarm_formatted|

46|ringtone|content://media/internal/audio/media/8

47|notification_sound|content://media/internal/audio/media/41

48|alarm_alert|content://media/internal/audio/media/56

//删除指定字段记录

sqlite> delete from system where _id=2;

delete from secure where _id=2;

sqlite>

 

  

备注:

此数据库由:frameworks\base\packages\SettingsProvider\src\com\android\providers\settings\DatabaseHelper.java 创建,

其默认初始值位置:frameworks\base\packages\SettingsProvider\res\values\defaults.xml