ios操作mysql数据库_ios数据库操作
查询数据
if ([app.db open]) {
[mainArr removeAllObjects];
[subArr removeAllObjects];
NSString * type = [[NSString alloc]init];
NSString * mobile =[[NSString alloc]init];
NSString * content =[[NSString alloc]init];
NSString * steta =[[NSString alloc]init];
NSString * time =[[NSString alloc]init];
NSString * msg_id = [[NSString alloc]init];
NSString * sqlStr = [NSString stringWithFormat:@"SELECT * FROM myMessage order by mobile"];
FMResultSet * rs = [app.db executeQuery:sqlStr];
while ([rs next]) {
BOOL isExsit = NO;
NSMutableDictionary * dic = [[NSMutableDictionary alloc]init];
type = [rs stringForColumn:@"type"];
mobile = [rs stringForColumn:@"mobile"];
content = [rs stringForColumn:@"content"];
steta = [rs stringForColumn:@"steta"];
time = [rs stringForColumn:@"time"];
msg_id = [rs stringForColumn:@"msg_id"];
}
}