通過動態(tài)表名和動態(tài)字段查詢數(shù)據(jù)腻扇，一般我們會這樣寫:
NSString *sql = [NSString stringWithFormat:@"SELECT * FROM %@ WHERE obj = ％@", 表名,字段內(nèi)容];
但是這樣寫FMDB會報(bào)錯(cuò)
正確寫法:
- (BOOL)seekString:(NSString *) value WithTabel:(NSString *) tableName {
NSString *cachePath = [NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES) lastObject];
NSString *databaseFilePath = [cachePath stringByAppendingPathComponent:kSqliteName];
FMDatabase *database = [[FMDatabase alloc]initWithPath:databaseFilePath];
if ([database open]) {
NSString *sql1 = @"SELECT page FROM ";
// obj 字段名
NSString *sql2 = @"WHERE obj = ?";
// tableName 表名
NSString *sql = [sql1 stringByAppendingString:tableName];
sql = [sql stringByAppendingString:sql2];
// value 字段內(nèi)容
FMResultSet *result = [database executeQuery:sql, value];
while ([result next]) {
return YES;
}
}
[database close];
return NO;
}
