SQLite常用操作:
创建表格:
create table staff(
_id integer primary key autoincrement,
name text,
sex text,
department text,
salary float
)
增加数据:
insert into staff values(null,'Jim','male','computer','5400');
删除数据
delete from staff where name="Jim";
更改数据
update staff set name='Jim' where name="Tom";
查询数据
public People[] select(){
//String table="DB_TABLE";
String[] columns = new String[] { KEY_ID,KEY_NUM, KEY_NAME, KEY_ADDRESS, KEY_SPECIALTY};
String selection......
阅读全文