queryhelper.java

来自「OBPM是一个开源」· Java 代码 · 共 81 行

package cn.myapps.core.report.query.action;

import java.util.Collection;
import java.util.HashSet;

import cn.myapps.base.action.BaseHelper;
import cn.myapps.core.report.query.ejb.Query;
import cn.myapps.core.report.query.ejb.QueryProcess;
import cn.myapps.util.ProcessFactory;

public class QueryHelper extends BaseHelper{
	
	public QueryHelper() throws ClassNotFoundException {
		super(ProcessFactory.createProcess(QueryProcess.class));
	}

	public String moduleid;
	
	public String applicationid;
  
	public String getApplicationid() {
		return applicationid;
	}

	public void setApplicationid(String appid) {
		this.applicationid = appid;
	}

	public String getModuleid() {
		return moduleid;
	}

	public void setModuleid(String moduleid) {
		this.moduleid = moduleid;
	}

	public Collection get_queryStringList()throws Exception
	{
		QueryProcess process = (QueryProcess) ProcessFactory
		.createProcess(QueryProcess.class);
		Collection rs = new HashSet();
		 rs = process.get_queryStringList(getModuleid(),getApplicationid());
		return rs;
	}
	
	public  Collection getParameters(String queryid) throws Exception {

		QueryProcess process = (QueryProcess) ProcessFactory
		.createProcess(QueryProcess.class);
		Query vo=(Query)process.doView(queryid);
		if (vo==null||vo.getQueryString() == null || vo.getQueryString().length() == 0)
			return null;
		String sql=vo.getQueryString();
		Collection list = new HashSet();
		while (sql.indexOf("{") >= 0) {
			int i = sql.indexOf("{", 0);
			int j = sql.indexOf("}", i);
			String paramName = sql.substring(i + 1, j);
			if(!list.contains(paramName))
			list.add(paramName);
			sql = sql.substring(j + 1, sql.length());
		}
		return list;
	}
	
	public  Collection getParametersBySQL(String  sql) throws Exception {

		Collection list = new HashSet();
		while (sql.indexOf("{") >= 0) {
			int i = sql.indexOf("{", 0);
			int j = sql.indexOf("}", i);
			String paramName = sql.substring(i + 1, j);
			if(!list.contains(paramName))
			list.add(paramName);
			sql = sql.substring(j + 1, sql.length());
		}
		return list;
	}
	
}