举例:

 

@"create table student(stuid integer primary key autoincrement,name text,number integer,theory float,skills float,remark text)"

 @"insert into student (name,number,theory,skills,remark) values('%@','%ld','%.1f','%.1f','%@')"

 @"delete from student where stuid='%ld'"

 @"update student set name='%@',number='%ld',theory='%.1f',skills='%.1f',remark='%@' where stuid=%ld"

 @"select * from student"

 @"select * from student where stuid = 1"

posted on 2016-07-01 08:40  Yevgeni  阅读(181)  评论(0编辑  收藏  举报