数据库--iOS

1.创建表

@"create table if not exists Person(id integer primary key autoincrement,name text,gender text,age integer,photo blob)"

2.插入

insert into Person(name,gender,age,photo)values(?,?,?,?)"

3.查找

select * from Person

4.更新

@"update Person set gender = ? where id = ?"

5.删除

delete from Person where id = ?"

posted @ 2015-12-21 21:36  喵喵yy  阅读(162)  评论(0编辑  收藏  举报