android数据库

G:\android\android-sdk_r07-windows\android-sdk-windows\tools>adb shell
# sqlite3 /data/data/com.android.deskclock/databases/alarms.db
sqlite3 /data/data/com.android.deskclock/databases/alarms.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
.table
alarms            android_metadata
sqlite>

看见表了吧

sqlite> select * from alarms;
select * from alarms;
1|8|30|31|0|0|1|||10|0
2|9|0|96|0|0|1|||10|0
3|13|57|0|0|0|1||content://settings/system/alarm_alert|5|3
sqlite>

看看字段

sqlite> .schema
.schema
CREATE TABLE alarms (_id INTEGER PRIMARY KEY,hour INTEGER, minutes INTEGER, days
ofweek INTEGER, alarmtime INTEGER, enabled INTEGER, vibrate INTEGER, message TEX
T, alert TEXT, times INTEGER, interval INTEGER);
CREATE TABLE android_metadata (locale TEXT);
sqlite>

sqlite> .schema alarms
.schema alarms
CREATE TABLE alarms (_id INTEGER PRIMARY KEY,hour INTEGER, minutes INTEGER, days
ofweek INTEGER, alarmtime INTEGER, enabled INTEGER, vibrate INTEGER, message TEX
T, alert TEXT, times INTEGER, interval INTEGER);
sqlite>