Android数据存储和访问.ppt

* 在应用程序的使用过程中,用户经常会根据自己的习惯,更改应用程序的设置,或设定个性化的内容.为了保存用户 的设置和个性化内容,应用程序一般在文件系统中保存一个配置文件,并在每次应用程序启动时,读取这个配置文件的 内容. * # mkdir databases mkdir databases # ls -l ls -l drwxrwxrwx root root 2011-01-30 08:50 databases drwxrwx--x app_33 app_33 2011-01-30 01:48 shared_prefs drwxr-xr-x system system 2011-01-14 03:17 lib drwxrwx--x app_33 app_33 2011-01-30 02:32 files # ls ls databases shared_prefs lib files # cd databases cd databases # ls ls # sqlite3 people.db sqlite3 people.db SQLite version 3.6.22 Enter .help for instructions Enter SQL statements terminated with a ; sqlite create table peopleinfo create table peopleinfo ... (_id integer primary key autoincrement, (_id integer primary key autoincrement, ... name text not null, name text not null, ... age integer, age integer, ... height float); height float); sqlite .tables .tables peopleinfo sqlite .schema peopleinfo .schema peopleinfo CREATE TABLE peopleinfo (_id integer primary key autoincrement, name text not null, age integer, height float); sqlite insert into peopleinfo values(熊昊,21,1.81); insert into peopleinfo values(熊昊,21,1.81); Error: table peopleinfo has 4 columns but 3 values were supplied sqlite select * from peopleinfo; select * from peopleinfo; sqlite insert into peopleinfo values(null,熊昊,21,1.81); insert into peopleinfo values(null,熊昊,21,1.81); sqlite select * from peopleinfo; select * from peopleinfo; 1|熊昊|21|1.81 sqlite insert into peopleinfo values(null,Tom,22,1.78); insert into peopleinfo values(null,Tom,22,1.78); sqlite insert into peopleinfo values(null,Jim,19,1.68); insert into peopleinfo values(null,Jim,19,1.68); sqlite select * from peopleinfo; select * from peopleinfo; 1|熊昊|21|1.81 2|Tom|22|1.78 3|Jim|19|1.68 sqlite .mode column .mode column sqlite select * from peopleinfo; select * from peopleinfo; 1 熊昊 21 1.81 2 Tom 22 1.78 3 Jim 19 1.68 sqlite .databa