作者:手机用户2502894533 | 来源:互联网 | 2022-12-20 10:35
网上很多人没给出最终判断方法,我这里给个简单的判断是否存在表-(BOOL)isTableOK:(NSString*)tableName{FMResultSet*r
网上很多人没给出最终判断方法,我这里给个简单的
- (BOOL) isTableOK:(NSString *)tableName
{
FMResultSet *rs = [self.DB executeQuery:@"select count(*) as 'count' from sqlite_master where type ='table' and name = ?", tableName];
while ([rs next])
{
NSInteger count = [rs intForColumn:@"count"];
NSLog(@"isTableOK %d", count);
if (0 == count)
{
return NO;
}
else
{
return YES;
}
}
return NO;
}