select
需要注意的是,特殊字符并没有用反斜杠“\”表示转义符。
- (NSString *)sqliteEscape:(NSString *)keyWord_
{
if ([keyWord_ length])
{
// keyWord = keyWord.replace("/", "//");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"/" withString: @"//"];
// keyWord = keyWord.replace("'", "''");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"'" withString: @"''"];
// keyWord = keyWord.replace("[", "/[");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"[" withString: @"/["];
// keyWord = keyWord.replace("]", "/]");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"]" withString: @"/]"];
// keyWord = keyWord.replace("%", "/%");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"%" withString: @"/%"];
// keyWord = keyWord.replace("&","/&");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"&" withString: @"/&"];
// keyWord = keyWord.replace("_", "/_");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"_" withString: @"/_"];
// keyWord = keyWord.replace("(", "/(");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @"(" withString: @"/("];
// keyWord = keyWord.replace(")", "/)");
keyWord_ = [keyWord_ stringByReplacingOccurrencesOfString: @")" withString: @"/)"];
}
return keyWord_;
}