/**
* 运行查询
*
* @param request HttpServletRequest
* @return QueryValue
*/
public QueryValue run(HttpServletRequest request) {
CalTime calTime = new CalTime();
CalTime calTimeSub = new CalTime();
// 获取结果
QueryValue queryValue = new QueryValue();
request.setAttribute("queryValue", queryValue);
// 获取运行次数
queryValue.queryName = this.getQuery().getQueryName();
queryValue.lastQueryName = RequestUtils.getStringParameter(request, "QueryName", "");
if (queryValue.queryName.equals(queryValue.lastQueryName)) queryValue.runTime = 1;
else {
if (queryValue.lastQueryName.equals("")) queryValue.runTime = 0;
else queryValue.runTime = -1;
}
// 解析参数中的页面大小和页数
queryValue.pageSize = RequestUtils.getIntParameter(request, "query_pagesize", 0);
if (queryValue.pageSize == 0) queryValue.pageSize = this.pageSize;
queryValue.pageNo =
RequestUtils.getIntParameter(request, queryValue.queryName + "_query_pageno", 1);
// 将配置的Sql元素传送给SqlConfig
SqlConfig sqlConfig = new SqlConfig();
SqlString sqlStringSelect = new SqlString(this.sqlSelect);
sqlConfig.sqlSelect = sqlStringSelect.getParseSql(request, null);
// sqlConfig.sqlStringSelect = this.sqlStringSelect;
sqlConfig.sqlStringFromWhere = this.sqlStringFromWhere;
// 统计解析
String sqlGroup = "";
String sqlGroupSelectGroup = "";
queryValue.drillURL = drillURL;
queryValue.needTotalX = this.needTotalX;
queryValue.needTotalY = this.needTotalY;
if (groupList != null) {
// 统计没有分页
queryValue.pageSize = -1;
StringBuffer sqlGroupSb = new StringBuffer();
StringBuffer sqlGroupSelectGroupSb = new StringBuffer();
queryValue.groupRalationList = this.groupRelationList;
queryValue.groupList = new ArrayList();
// 初始化XYZ轴
if (queryValue.runTime != 1) // 第一次运行和从别的查询过来
{
queryValue.groupListY = (ArrayList) this.groupListY.clone();
queryValue.groupListX = (ArrayList) this.groupListX.clone();
queryValue.groupListSelect = (ArrayList) this.groupListSelect.clone();
queryValue.groupList = (ArrayList) this.groupList.clone();
} // end 初始化XYZ轴 if
else {
// 从Request中获取用户选择的X、Y轴
queryValue.groupListY = new ArrayList();
queryValue.groupListX = new ArrayList();
queryValue.groupListSelect = new ArrayList();
// Y轴
String[] groupYName = RequestUtils.getStringParameters(request, "groupYName");
String[] checkGroupYSubTotal =
RequestUtils.getStringParameters(request, "checkGroupYSubTotal");
for (int i = 0; i < groupYName.length; i++) {
Object obj = groupMap.get(groupYName[i]);
if (obj != null) {
Group group = (Group) ((Group) obj).clone();
group.position = 'y' + String.valueOf(i + 1);
if (ArrayUtils.contains(checkGroupYSubTotal, groupYName[i])) group.needSubTotal = true;
else group.needSubTotal = false;
queryValue.groupListY.add(group);
}
}
// X轴
String[] groupXName = RequestUtils.getStringParameters(request, "groupXName");
for (int i = 0; i < groupXName.length; i++) {
Object obj = groupMap.get(groupXName[i]);
if (obj != null) {
Group group = (Group) ((Group) obj).clone();
group.position = 'x' + String.valueOf(i + 1);
queryValue.groupListX.add(group);
}
}
// Z轴
String[] groupList = RequestUtils.getStringParameters(request, "groupZName");
for (int i = 0; i < groupList.length; i++) {
Object obj = groupMap.get(groupList[i]);
if (obj != null) {
Group group = (Group) ((Group) obj).clone();
group.position = String.valueOf(i + 1);
queryValue.groupListSelect.add(group);
}
}
queryValue.groupList.addAll(queryValue.groupListX);
queryValue.groupList.addAll(queryValue.groupListY);
} // end 初始化XYZ轴 else
if (!(queryValue.runTime == 0 && !firstShow)) {
for (int i = 0; i < queryValue.groupList.size(); i++) {
Group group = (Group) queryValue.groupList.get(i);
if (group.metadata.size() == 0 && !group.metadatasql.equals("")) {
group.metadata =
JdbcUtils.queryForList(
group.metadataSqlString.getParseSql(request, this.replaceMap));
}
sqlGroupSb.append(group.macrovalue).append(',');
sqlGroupSelectGroupSb
.append(group.macrovalue)
.append(" as ")
.append(group.groupLabel)
.append(',');
}
sqlGroup = sqlGroupSb.deleteCharAt(sqlGroupSb.length() - 1).toString();
sqlGroupSelectGroup = sqlGroupSelectGroupSb.toString();
}
}
// 如果不是第1次并配置为第1次不运行
if (queryValue.runTime == 0 && !firstShow) {
queryValue.title = new String[0];
} else {
queryValue.dataList = new ArrayList();
queryValue.allDataList = new ArrayList();
// 进行sqlFromWhere的解析
sqlConfig.sqlFromWhere = sqlConfig.sqlStringFromWhere.getParseSql(request, this.replaceMap);
// sqlConfig.sqlSelect = sqlConfig.sqlStringSelect.getParseSql(request, this.replaceMap);
if (sqlGroup.length() > 0)
sqlConfig.sqlData =
"select "
+ sqlGroupSelectGroup
+ sqlGroupSelect.getSql(request)
+ " "
+ sqlConfig.sqlFromWhere
+ " group by "
+ sqlGroup;
else {
sqlConfig.sqlData = "select " + sqlConfig.sqlSelect + " " + sqlConfig.sqlFromWhere;
sqlConfig.sqlSum = this.sqlSum;
if (sqlConfig.sqlSum.length() > 0)
sqlConfig.sqlDataSum = "select " + sqlConfig.sqlSum + " " + sqlConfig.sqlFromWhere;
sqlConfig.sqlCount =
"select count(*) from (" + sqlConfig.sqlData + ")"; // + sqlConfig.sqlFromWhere;
String query_sortcol = RequestUtils.getStringParameter(request, "query_sortcol", "");
sqlConfig.sqlOrder = this.sqlOrder;
if (!StringUtils.isBlank(query_sortcol)) {
sqlConfig.sqlOrder =
" order by "
+ query_sortcol
+ " "
+ RequestUtils.getStringParameter(request, "query_sortdir", "");
}
sqlConfig.sqlOrder = StringUtils.trimToEmpty(sqlConfig.sqlOrder);
}
// 从数据库获取数据
calTime.begin();
if (needCache
&& agentClass.fetchCacheResultFromDb(eleConfig, sqlConfig, request, queryValue)) {
int position = queryValue.pageSize * (queryValue.pageNo - 1);
int maxsize = position + queryValue.pageSize;
if (queryValue.allDataList.size() <= maxsize) maxsize = queryValue.allDataList.size();
else {
queryValue.hasNextPage = true;
}
if (queryValue.pageSize == -1) {
position = 0;
maxsize = queryValue.allDataList.size();
}
for (int i = position; i < maxsize; i++) {
queryValue.dataList.add(queryValue.allDataList.get(i));
}
} else {
calTimeSub.begin();
agentClass.fetchPageResultFromDb(eleConfig, sqlConfig, request, queryValue);
queryValue
.calTimeSb
.append("从数据库获取数据时间：")
.append(calTimeSub.endString())
.append(StringUtils.LINE_SEPARATOR);
}
queryValue
.calTimeSb
.append("总共获取数据时间：")
.append(calTime.endString())
.append(StringUtils.LINE_SEPARATOR);
}
return queryValue;
}
/**
* 初始化：读取配置信息
*
* @return boolean
*/
public boolean init() {
// 页面大小
this.pageSize = JdomUtils.getAttributeIntValue(eleConfig, "pageSize", DEFAULT_PAGE_SIZE);
// 从配置文件中读取代理类名并实例化代理类
this.agentClassName = JdomUtils.getAttributeValue(eleConfig, "agentClass", "");
if (agentClassName.length() > 0) {
try {
this.agentClass = (IValueFetch) ClassUtils.newInstance(agentClassName);
} catch (RuntimeException ex) {
QueryManager.logError(logger, this.query, "结果获取代理类（" + agentClassName + "）实例化失败");
}
}
if (agentClass == null) agentClass = this;
// 读取是否首次显示
this.firstShow = JdomUtils.getAttributeBooleanValue(eleConfig, "firstShow", true);
// 读取Sql配置信息
Element eleSql = eleConfig.getChild("sql");
if (eleSql == null) {
QueryManager.logError(logger, query, "没有配置valuefetch中的sql");
return false;
}
// 读取Cache配置
Element eleCache = eleConfig.getChild("cache");
if (eleCache != null) {
this.needCache = true;
this.needRadom = JdomUtils.getAttributeBooleanValue(eleCache, "radom", false);
this.cacheLimit = JdomUtils.getAttributeIntValue(eleCache, "radom", DEFAULT_CACHE_LIMIT);
}
// 读取Sql配置
this.sqlSelect = StringUtils.trimToEmpty(eleSql.getChildText("SqlSelect"));
this.sqlStringFromWhere =
new SqlString(StringUtils.trimToEmpty(eleSql.getChildText("SqlFromWhere")));
this.sqlSum = StringUtils.trimToEmpty(eleSql.getChildTextTrim("SqlSum"));
this.sqlOrder = StringUtils.trimToEmpty(eleSql.getChildTextTrim("SqlOrder"));
// 读取Group定义
Element eleSqlGroup = eleConfig.getChild("sql").getChild("SqlGroup");
if (eleSqlGroup != null) {
drillURL = JdomUtils.getAttributeValue(eleSqlGroup, "drillURL");
this.needTotalX = JdomUtils.getAttributeBooleanValue(eleSqlGroup, "needTotalX", true);
this.needTotalY = JdomUtils.getAttributeBooleanValue(eleSqlGroup, "needTotalY", true);
// 统计缺省第一次不运行
firstShow = false;
this.pageSize = -1;
groupList = new ArrayList();
groupMap = new HashMap();
groupListY = new ArrayList();
groupListX = new ArrayList();
groupListSelect = new ArrayList();
Iterator iterator = eleSqlGroup.getChildren("Group").iterator();
while (iterator.hasNext()) {
Element eleGroup = (Element) iterator.next();
String groupName = JdomUtils.getAttributeValue(eleGroup, "groupName");
String groupLabel = JdomUtils.getAttributeValue(eleGroup, "groupLabel");
String metadatasql = JdomUtils.getAttributeValue(eleGroup, "metadatasql");
String macrovalue = JdomUtils.getAttributeValue(eleGroup, "macrovalue");
String position = JdomUtils.getAttributeValue(eleGroup, "position");
Group group = new Group(groupName, groupLabel, metadatasql, macrovalue, position);
if (JdomUtils.getAttributeBooleanValue(eleGroup, "subTotal", false))
group.needSubTotal = true;
group.needDrill = JdomUtils.getAttributeBooleanValue(eleGroup, "drill", false);
if (!group.metadatasql.equals("") && !group.metadataSqlString.needParse())
group.metadata = JdbcUtils.queryForList(metadatasql);
if (StringUtils.contains(position, "y")) groupListY.add(group);
else if (StringUtils.contains(position, "x")) groupListX.add(group);
else groupListSelect.add(group);
groupMap.put(group.groupName, group);
Collections.sort(groupListY);
Collections.sort(groupListX);
Collections.sort(groupListSelect);
}
groupList.addAll(groupListX);
groupList.addAll(groupListY);
// 读取统计量配置
ArrayList sqlGroupSelectList = new ArrayList();
sqlGroupSelect = new MultiCheckbox();
sqlGroupSelect.name = "sqlGroupSelect";
Iterator iteratorSqlGroupSelect =
eleConfig
.getChild("sql")
.getChild("SqlGroupSelect")
.getChildren("GroupSelect")
.iterator();
while (iteratorSqlGroupSelect.hasNext()) {
Element eleGroupSelect = (Element) iteratorSqlGroupSelect.next();
String label = JdomUtils.getAttributeValue(eleGroupSelect, "label");
String value = JdomUtils.getAttributeValue(eleGroupSelect, "value");
String addvalue = JdomUtils.getAttributeValue(eleGroupSelect, "addvalue");
Checkbox groupSelect = new Checkbox("", label, value, addvalue, true);
sqlGroupSelectList.add(groupSelect);
}
this.sqlGroupSelect.metadata = sqlGroupSelectList;
// 读取Group关系定义
Element eleSqlGroupRelation = eleConfig.getChild("sql").getChild("SqlGroupRelation");
groupRelationList = new ArrayList();
if (eleSqlGroupRelation != null) {
iterator = eleSqlGroupRelation.getChildren("GroupRelation").iterator();
while (iterator.hasNext()) {
Element eleGroupRelation = (Element) iterator.next();
String groupName1 = JdomUtils.getAttributeValue(eleGroupRelation, "groupName1");
String groupName2 = JdomUtils.getAttributeValue(eleGroupRelation, "groupName2");
String relationsql = JdomUtils.getAttributeValue(eleGroupRelation, "relationsql");
ArrayList relation = JdbcUtils.queryForList(relationsql);
GroupRelation groupRelation = new GroupRelation(groupName1, groupName2, relation);
groupRelationList.add(groupRelation);
}
}
}
if ((sqlSelect.length() == 0 && groupList == null)
|| sqlStringFromWhere.getSql().length() == 0) {
QueryManager.logError(logger, query, "没有配置valuefetch中的sql中的SqlSelect或者SqlFromWhere");
return false;
}
needCount = JdomUtils.getAttributeBooleanValue(eleSql, "count", true);
// 读取宏替换配置
Element elementReplaces = eleConfig.getChild("sql").getChild("replaces");
replaceMap = new HashMap();
if (elementReplaces != null) {
Iterator iterator = elementReplaces.getChildren().iterator();
while (iterator.hasNext()) {
Element elementReplace = (Element) iterator.next();
String replacename = JdomUtils.getAttributeValue(elementReplace, "replacename", "");
ArrayList paraReplaceList = new ArrayList();
MacroReplace replace = null;
if (elementReplace.getAttributeValue("replacevalue") == null) // 配置放在下面的parareplace节点
{
Iterator iteratorParaReplace = elementReplace.getChildren().iterator();
while (iteratorParaReplace.hasNext()) {
Element elementParaReplace = (Element) iteratorParaReplace.next();
String conditionExpr =
JdomUtils.getAttributeValue(elementParaReplace, "conditionExpr", "");
String paraname = JdomUtils.getAttributeValue(elementParaReplace, "paraname", "");
String paravalue = JdomUtils.getAttributeValue(elementParaReplace, "paravalue", "");
String relation = JdomUtils.getAttributeValue(elementParaReplace, "relation", "!=");
String replacevalue =
JdomUtils.getAttributeValue(elementParaReplace, "replacevalue", "");
replace = new MacroReplace(conditionExpr, paraname, paravalue, relation, replacevalue);
paraReplaceList.add(replace);
}
replaceMap.put(replacename, paraReplaceList);
} else // 配置就放在replace节点
{
String conditionExpr = JdomUtils.getAttributeValue(elementReplace, "conditionExpr", "");
String paraname = JdomUtils.getAttributeValue(elementReplace, "paraname", "");
String paravalue = JdomUtils.getAttributeValue(elementReplace, "paravalue", "");
String relation = JdomUtils.getAttributeValue(elementReplace, "paravalue", "!=");
String replacevalue = JdomUtils.getAttributeValue(elementReplace, "replacevalue", "");
replace = new MacroReplace(conditionExpr, paraname, paravalue, relation, replacevalue);
paraReplaceList.add(replace);
replaceMap.put(replacename, paraReplaceList);
}
}
}
return true;
}