/*****************************************************
* 函数名: ReplaceSqlChar
* 机能概要: 对字符串进行TAG处理
* "/" --> "//"
* "%" --> "/%"
* "_" --> "/_"
* "'" --> "''"
*
* 参数: strin 待转换的字符串
* 返回值: 处理后的字符串
*********************************************************/
public static String ReplaceSqlChar(String strin){
int iPos = 0;
String strTemp="";
String strRight="";
if(strin==null) return null;
if(strin.equals("")) return "";
strRight = strin;
iPos = strin.indexOf("/");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "//";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("/");
}
strin = strTemp + strRight;
strTemp="";
strRight = strin;
iPos = strin.indexOf("%");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "/%";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("%");
}
strin = strTemp + strRight;
/* strTemp="";
strRight = strin;
iPos = strin.indexOf("_");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "/_";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("_");
}
strin = strTemp + strRight;
*/
/*
strTemp="";
strRight = strin;
iPos = strin.indexOf("\"");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "/\"";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("\"");
}
strin = strTemp + strRight;
*/
strTemp="";
strRight = strin;
iPos = strin.indexOf("'");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "''";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("'");
}
strin = strTemp + strRight;
return strin;
}
* 函数名: ReplaceSqlChar
* 机能概要: 对字符串进行TAG处理
* "/" --> "//"
* "%" --> "/%"
* "_" --> "/_"
* "'" --> "''"
*
* 参数: strin 待转换的字符串
* 返回值: 处理后的字符串
*********************************************************/
public static String ReplaceSqlChar(String strin){
int iPos = 0;
String strTemp="";
String strRight="";
if(strin==null) return null;
if(strin.equals("")) return "";
strRight = strin;
iPos = strin.indexOf("/");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "//";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("/");
}
strin = strTemp + strRight;
strTemp="";
strRight = strin;
iPos = strin.indexOf("%");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "/%";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("%");
}
strin = strTemp + strRight;
/* strTemp="";
strRight = strin;
iPos = strin.indexOf("_");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "/_";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("_");
}
strin = strTemp + strRight;
*/
/*
strTemp="";
strRight = strin;
iPos = strin.indexOf("\"");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "/\"";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("\"");
}
strin = strTemp + strRight;
*/
strTemp="";
strRight = strin;
iPos = strin.indexOf("'");
while(iPos != -1){
strTemp = strTemp + strRight.substring(0,iPos) + "''";
strRight = strRight.substring(iPos + 1);
iPos = strRight.indexOf("'");
}
strin = strTemp + strRight;
return strin;
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12379366/viewspace-85545/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12379366/viewspace-85545/