查找表CQxtstandard中,符合條件:
CQ_ZPLX = %@ and CQ_DQDM = %@的數(shù)據(jù),
并且將其CSM值作為key,CSZ值作為value存入字典中。返回符合該條件的一個(gè)字典。

<pre>
-(NSMutableDictionary *)selectPhotoModel:(NSString *)ZPLX WithDQDM:(NSString *)DQDM
{
PhotoCQModel * returnModel = nil;
FMResultSet *result = [self.standardDatabase executeQueryWithFormat:@"select CQ_PhotoCQModel from CQxtstandard where CQ_ZPLX = %@ and CQ_DQDM = %@",ZPLX,DQDM];
NSLog(@"result = %@",result.columnNameToIndexMap);
NSMutableDictionary * dict = [NSMutableDictionary dictionary];
while ([result next]) {
NSData *data = [result dataForColumn:@"CQ_PhotoCQModel"];
returnModel = [NSKeyedUnarchiver unarchiveObjectWithData:data];
// NSLog(@"%@",returnModel.CSM);
// NSLog(@"%@",returnModel.CSZ);
[dict setValue:returnModel.CSZ forKey:returnModel.CSM]
}
return dict;
}
</pre>
從上面的代碼可以看出我們的返回值實(shí)際可以返回多種樣式,可以具體到表中某個(gè)數(shù)值,某條數(shù)據(jù),或者多條數(shù)據(jù)。這個(gè)查詢方法,可根據(jù)項(xiàng)目具體要求,實(shí)際應(yīng)用。