1.创建一个table @"create table rockTB(myId integer primary key autoincrement not null, time varchar(128) , body varchar(1024))"];
2.查询
FMResultSet * result = [sDB executeQuery:@"select * from rockTB"];
while ([result next])
{
NSString * time = [result stringForColumn:@"time"];
NSString * body = [result stringForColumn:@"body"];
int myId = [result intForColumn:@"myId"];
NSLog(@"time:%@ body:%@ myId:%d",time,body,myId);
}
3.更新
NSString * str = [NSString stringWithFormat:@"update rockTB SET title = '%@' ,body = '%@' WHERE myId = %d",
info.title, info.body, info.aId];
BOOL ret = [sDB executeUpdate:str];