📄 querysqltransition.java
字号:
result += " " + tempStr + " >= '" + xValue + "' ";
} else
if("14".equals(xname.subSequence(7,9))){
result += " " + tempStr + " <= '" + xValue + "' ";
}
}
result += " ) ";
}
} else
//2.两个同时比较 compare01field049_field049a_field049b
if("compare".equals(xname.substring(0,7))){
//01数字并且 ,02数字或 ，03字符并且，04字符或
if("01".equals(xname.substring(7,9))){
result += " and ";
tempStr = xname.substring(9,xname.length());
Debug.println("[querySqlTransition]-getQuerySql--->compare:" + tempStr);
//01 数字大于,02 数字小于,03 数字大于等于,04 数字小于等于,05 等于,06 在....之间
//取变量组合 and field049 > 'field049a' and (field049>='field049a' and )
StringTokenizer subTokenizer = new StringTokenizer(tempStr,"_");
String tempStr1 = "";
String tempStr2 = "";
if(subTokenizer.hasMoreTokens()){
tempStr = (String) (subTokenizer.nextToken());
}
if(subTokenizer.hasMoreTokens()){
//取得数值
tempStr1 = (String) (subTokenizer.nextToken());
tempStr1 = getMapValue(pageParMap,tempStr1);
}
if(subTokenizer.hasMoreTokens()){
tempStr2 = (String) (subTokenizer.nextToken());
tempStr2 = getMapValue(pageParMap,tempStr2);
}
//获得sql
if(!"".equals(tempStr) || !"".equals(tempStr1) || !"".equals(tempStr2)){
if("01".equals(xValue)){
result += " " + tempStr + " >" + tempStr1 + " ";
} else
if("02".equals(xValue)){
result += " " + tempStr + " < " + tempStr1 + " ";
} else
if("03".equals(xValue)){
result += " " + tempStr + " >= " + tempStr1 + " ";
} else
if("04".equals(xValue)){
result += " " + tempStr + " <= " + tempStr1 + " ";
} else
if("05".equals(xValue)){
result += " " + tempStr + " = '" + tempStr1 + "' ";
} else
if("06".equals(xValue)){
result += " " + tempStr + ",0) >= " + tempStr1 + " and " + tempStr + " <= " + tempStr2 + " ";
}
}
} else
if("02".equals(xname.substring(7,9))){
result += " or ";
tempStr = xname.substring(9,xname.length());
//01 数字大于,02 数字小于,03 数字大于等于,04 数字小于等于,05 等于,06 在....之间
//取变量组合 and field049 > 'field049a' and (field049>='field049a' and )
StringTokenizer subTokenizer = new StringTokenizer(tempStr,"_");
String tempStr1 = "";
String tempStr2 = "";
if(subTokenizer.hasMoreTokens()){
tempStr = (String) (subTokenizer.nextToken());
}
if(subTokenizer.hasMoreTokens()){
//取得数值
tempStr1 = (String) (subTokenizer.nextToken());
tempStr1 = getMapValue(pageParMap,tempStr1);
}
if(subTokenizer.hasMoreTokens()){
tempStr2 = (String) (subTokenizer.nextToken());
tempStr2 = getMapValue(pageParMap,tempStr2);
}
//获得sql
if(!"".equals(tempStr) || !"".equals(tempStr1) || !"".equals(tempStr2)){
if("01".equals(xValue)){
result += " " + tempStr + " > " + tempStr1 + " ";
} else
if("02".equals(xValue)){
result += " " + tempStr + " < " + tempStr1 + " ";
} else
if("03".equals(xValue)){
result += " " + tempStr + " >= " + tempStr1 + " ";
} else
if("04".equals(xValue)){
result += " " + tempStr + " <= " + tempStr1 + " ";
} else
if("05".equals(xValue)){
result += " " + tempStr + " = '" + tempStr1 + "' ";
} else
if("06".equals(xValue)){
result += " " + tempStr + " >= " + tempStr1 + " and " + tempStr + " <= " + tempStr1 + " ";
}
}
} else
//字符并且
if("03".equals(xname.substring(7,9))){
result += " and ";
tempStr = xname.substring(9,xname.length());
Debug.println("[querySqlTransition]-getQuerySql--->compare:" + tempStr);
//01 字符大于,02 字符小于,03 字符大于等于,04 字符小于等于,05 等于,06 在....之间
//取变量组合 and field049 > 'field049a' and (field049>='field049a' and )
StringTokenizer subTokenizer = new StringTokenizer(tempStr,"_");
String tempStr1 = "";
String tempStr2 = "";
if(subTokenizer.hasMoreTokens()){
tempStr = (String) (subTokenizer.nextToken());
}
if(subTokenizer.hasMoreTokens()){
//取得数值
tempStr1 = (String) (subTokenizer.nextToken());
tempStr1 = getMapValue(pageParMap,tempStr1);
}
if(subTokenizer.hasMoreTokens()){
tempStr2 = (String) (subTokenizer.nextToken());
tempStr2 = getMapValue(pageParMap,tempStr2);
}
//获得sql
if(!"".equals(tempStr) || !"".equals(tempStr1) || !"".equals(tempStr2)){
if("01".equals(xValue)){
result += " " + tempStr + " >'" + tempStr1 + "' ";
} else
if("02".equals(xValue)){
result += " " + tempStr + " < '" + tempStr1 + "' ";
} else
if("03".equals(xValue)){
result += " " + tempStr + " >= '" + tempStr1 + "' ";
} else
if("04".equals(xValue)){
result += " " + tempStr + " <= '" + tempStr1 + "' ";
} else
if("05".equals(xValue)){
result += " " + tempStr + " = '" + tempStr1 + "' ";
} else
if("06".equals(xValue)){
result += " " + tempStr + " >= '" + tempStr1 + "' and " + tempStr + " <= '" + tempStr2 + "' ";
}
}
} else
//字符或
if("04".equals(xname.substring(7,9))){
result += " or ";
tempStr = xname.substring(9,xname.length());
//01 字符大于,02 字符小于,03 字符大于等于,04 字符小于等于,05 等于,06 在....之间
//取变量组合 and field049 > 'field049a' and (field049>='field049a' and )
StringTokenizer subTokenizer = new StringTokenizer(tempStr,"_");
String tempStr1 = "";
String tempStr2 = "";
if(subTokenizer.hasMoreTokens()){
tempStr = (String) (subTokenizer.nextToken());
}
if(subTokenizer.hasMoreTokens()){
//取得数值
tempStr1 = (String) (subTokenizer.nextToken());
tempStr1 = getMapValue(pageParMap,tempStr1);
}
if(subTokenizer.hasMoreTokens()){
tempStr2 = (String) (subTokenizer.nextToken());
tempStr2 = getMapValue(pageParMap,tempStr2);
}
//获得sql
if(!"".equals(tempStr) || !"".equals(tempStr1) || !"".equals(tempStr2)){
if("01".equals(xValue)){
result += " " + tempStr + " > '" + tempStr1 + "' ";
} else
if("02".equals(xValue)){
result += " " + tempStr + " < '" + tempStr1 + "' ";
} else
if("03".equals(xValue)){
result += " " + tempStr + ">= '" + tempStr1 + "' ";
} else
if("04".equals(xValue)){
result += " " + tempStr + " <= '" + tempStr1 + "' ";
} else
if("05".equals(xValue)){
result += " " + tempStr + " = '" + tempStr1 + "' ";
} else
if("06".equals(xValue)){
result += " " + tempStr + " >= '" + tempStr1 + "' and " + tempStr + " <= '" + tempStr1 + "' ";
}
}
}
} else
//3.排序 orderby???
if("orderby".equals(xname.substring(0,7))){
if(xname.substring(7,9) == "01") { //desc
orderbyState = "1";
} else{
orderbyState = "0";
}
tempStr = xname.substring(9,xname.length());
if("".equals(orderbyStr)) {
orderbyStr += tempStr;
} else{
orderbyStr += "," + tempStr;
}
}
Debug.println("[querySqlTransition]-getQuerySql--->result:" + result + " xname:" + xname + " xValue:" + xValue);
}
}
if(!"".equals(orderbyStr)){
if("1".equals(orderbyState)) {
result += " order by " + orderbyStr + " desc";
} else{
result += " order by " + orderbyStr;
}
}
} catch(Exception ex){
Debug.println("[querySqlTransition]--->exception:" + ex.getMessage());
}
Debug.println("[querySqlTransition]-getQuerySql--->result end :" + result);
return result;
}
//取得页面变量做sql规则转换，应用于模糊查询
public static String getMapValue(HashMap pageParMap,String xname){
String result = "";
String tempStr;
ArrayList sub = new ArrayList();
try{
for(int i = 0;i < pageParMap.size();i++){
sub = (ArrayList) pageParMap.get((Object)new Integer(i));
tempStr = (String) sub.get(0);
if(xname.equals(tempStr)){
result = (String) sub.get(1);
break;
}
}
} catch(Exception ex){
Debug.println("[querySqlTransition]-getMapValue--->Exception:" + ex.getMessage());
}
Debug.println("[querySqlTransition]-getMapValue--->get[xname]:" + xname + " result:" + result);
return result;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -