objective-c - 语法 : assign method's property value to sql command

Question

我有方法:

-(NSMutableArray*)getTheCountriesEurope:(int)continentID
{
NSMutableArray* euCountriesArray=[[[NSMutableArray alloc]init]autorelease];
const char* sqlContinents="SELECT countries.countryID,countries.countryName\
FROM countries\
WHERE countries.relativeToContinentID=?";

如何将我的 (int)continentID 属性分配给 sql 命令？我的意思是声明

WHERE countries.relativeToContinentID=?";

提前谢谢你。

Answer 1

试试这个:

formattedString = [NSString stringWithFormat:
    @"SELECT countries.countryID,countries.countryName\
    FROM countries\
    WHERE countries.relativeToContinentID=%i"
    ,continentID];