就是将UITextfiled中的值作为条件来实现查询,感谢,求讲解,求代码,求实例
当然可以。
你先得到UITextField中的值,然后配置条件
NSString *searchString = @"larry";
NSString *likeParameter = [NSString stringWithFormat:@"%%%@%%", searchString];
NSString *sql = @"SELECT text_column FROM test WHERE text_column LIKE ?";
FMResultSet *results = [db executeQuery:sql, likeParameter];
if (!results)
{
NSLog(@"error: %@", [db lastErrorMessage]);
[db close];
return;
}
while ([results next])
{
NSLog(@"%s: %@", __FUNCTION__, results[0]);
}
[results close];
[db close];