/**
* @param strExp
* @param filterExpressions
* @param values
* @return
*/
public static String replaceValue(String strExp, Object[] values, int colCount) {
if (strExp != null && values != null) {
for (int i = 0; i < colCount; i++) {
String sValue = (String) values[i].toString().trim();
String columnIndex = StringFunction.FillZeroFromBegin((i + 1), 3);
// 查询根据摘要过滤结果集，因为摘要里有$特殊字符，导致过滤报错 modify by ES 2014-07-18
int index = sValue.indexOf("$");
if (index > -1) {
while (index > -1) {
sValue = sValue.substring(0, index) + "\\$" + sValue.substring(index + 1);
index = sValue.substring(index + 3).indexOf("$");
}
}
strExp = strExp.replaceAll(JCExpression.COLUMN_NAME_PREFIX + columnIndex, sValue);
}
}
return strExp;
}
/**
* modi by fengbo 2007-9-27 正规化.
*
* @param filterExpressions
* @return
*/
public static String normalize(Object[] values, int colCount, JCExpression exp) {
String strExp = "", columnIndex;
// 获取所有条件表达式列表
Vector exps = exp.mExpItems;
// 解析表达式
for (Enumeration e = exps.elements(); e.hasMoreElements(); ) {
JCExpressionItem info = (JCExpressionItem) e.nextElement();
// 2.1 组织一个三位长度的列序号
columnIndex =
JCExpression.COLUMN_NAME_PREFIX
+ StringFunction.FillZeroFromBegin(info.mCompareItem.getColumnIndex(), 3);
// 2.2 解析运算符--like
if (info.mOpCompare.trim().equalsIgnoreCase("like")) {
strExp += info.mOpLeft + "like(" + "\"" + columnIndex + "\"";
strExp += ",";
strExp += "\"";
strExp += info.mCompareValue;
strExp += "\"";
strExp += ")" + info.mOpRight;
} else {
// 数值类型运算
if (info.mCompareItem.getColumnType().equals("N")) {
strExp += info.mOpLeft + columnIndex;
if (info.mOpCompare.trim().equals("=")) {
strExp += "==";
} else if (info.mOpCompare.trim().equals("<>")) {
strExp += "!=";
} else {
strExp += info.mOpCompare;
}
strExp += info.mCompareValue;
strExp += info.mOpRight;
}
// 字符类型
else {
strExp += info.mOpLeft + "\"" + columnIndex + "\"";
if (info.mOpCompare.trim().equals("=")) {
strExp += "==";
} else if (info.mOpCompare.trim().equals("<>")) {
strExp += "!=";
} else {
strExp += info.mOpCompare;
}
strExp += "\"";
strExp += info.mCompareValue;
strExp += "\"" + info.mOpRight;
}
}
// 解析连接运算符
if (info.mOpConn.equals("OR")) {
strExp += " || ";
} else if (info.mOpConn.equals("AND")) {
strExp += " && ";
}
}
return replaceValue(strExp, values, colCount);
}