SQL语句

创建语句:
create table if not exists Contact(con_id integer primary key autoincrement, con_name text, con_gender text, con_age text, con_phoneNum text, con_image blob)
插入语句:
insert into Contact(con_name, con_gender, con_age, con_phoneNum, con_image) values(?, ?, ?, ?, ?)
更新语句:
update Contacts set con_name = ?, con_gender = ?, con_age = ?, con_phoneNum = ?, con_image = ? where con_id = ?
posted @ 2016-03-10 09:06  莫念莫忘  阅读(78)  评论(0编辑  收藏  举报