在Sybase数据库时,模糊查询代有"["的字符串,例如:物价[2005]号文件,如果只输入"[2005"实现模糊查询就不能查询欲得到的结果
解决方案:
String temp_queryArchives_no = convertStr(queryArchives_no);
condition = " and archives_no like '%" + temp_queryArchives_no + "%' escape '//' ";
convertStr方法
private String convertStr(String input)
{
StringBuffer filtered = new StringBuffer(input.length());
char c;
for (int i = 0; i < input.length(); i++)
{
c = input.charAt(i);
if (c == '[')
{
filtered.append("//[");
}
else if (c == ']')
{
filtered.append("//]");
}
else
{
filtered.append(c);
}
}
return (filtered.toString());
}