Java Report.getParameters方法代碼示例

import ro.nextreports.engine.Report; //導入方法依賴的package包/類
/**
 * Test (by name) if sub-report parameters types are incompatible with
 * report parameter types (where we want the sub-report to be inserted)
 * 
 * @return list of incompatible parameters
 */
public static List<String> incompatibleParametersType(Report report) {
	ParameterManager paramManager = ParameterManager.getInstance();
	List<QueryParameter> reportParams = paramManager.getParameters();
	List<QueryParameter> chartParams = report.getParameters();
	List<String> result = new ArrayList<String>();
	for (QueryParameter cqp : chartParams) {
		for (QueryParameter rqp : reportParams) {
			if (rqp.getName().equals(cqp.getName())) {
				if (!rqp.getValueClassName().equals(cqp.getValueClassName())) {
					result.add(rqp.getName());
				} else if (!rqp.getSelection().equals(cqp.getSelection())) {
					result.add(rqp.getName());
				}
			}
		}
	}
	return result;
}
 

import ro.nextreports.engine.Report; //導入方法依賴的package包/類
/**
 * Test if all parameters used in the report are defined
 *
 * @param report report object
 * @throws ParameterNotFoundException if a parameter used in the report is not defined
 */
public void parametersAreDefined(Report report) throws ParameterNotFoundException {
    String[] paramNames;
    String sql = report.getSql();
    if (sql == null) {
        sql = report.getQuery().toString();
    }
    Query query = new Query(sql);
    paramNames = query.getParameterNames();

    List<QueryParameter> parameters = report.getParameters();

    for (String paramName : paramNames) {
        QueryParameter param = null;
        for (QueryParameter p : parameters) {
            if (paramName.equals(p.getName())) {
                param = p;
            }
        }
        if (param == null) {
            throw new ParameterNotFoundException(paramName);
        }
    }
}
 

import ro.nextreports.engine.Report; //導入方法依賴的package包/類
/**
 * Test if sql from a report object and sql from all parameter sources (if any) are valid
 * 
 * @param con database connection
 * @param report report object
 * @return return message error if sql is not valid, null otherwise
 */
public static String isValidSqlWithMessage(Connection con, Report report) {
	String sql = getSql(report);
	List<QueryParameter> parameters = report.getParameters();
	String message = isValidSqlWithMessage(con, sql, parameters);
	if (message == null) {
		for (QueryParameter qp : parameters) {
			if (qp.isManualSource()) {
				String parMessage = isValidSqlWithMessage(con, qp.getSource(), parameters);
				if (parMessage != null) {
					parMessage = "Parameter '" + qp.getName() + "'\n" + parMessage;
					return parMessage;
				}
			}
			}
	} 
	return message;		
}
 

import ro.nextreports.engine.Report; //導入方法依賴的package包/類
/**
 * Get child dependent parameters
 *
 * @param report next report object
 * @param parameterName current parameter name
 * @return a map of all parameters that use the current parameter in theirs source definition
 */
public static Map<String, QueryParameter> getChildDependentParameters(Report report, String  parameterName) {
	if (report == null) {
		return new HashMap<String, QueryParameter>();
	}
	for (QueryParameter qp : report.getParameters()) {
		if (qp.getName().equals(parameterName)) {
			return getChildDependentParameters(report.getParameters(), qp);
		}
	}
	return new HashMap<String, QueryParameter>();        
}
 

import ro.nextreports.engine.Report; //導入方法依賴的package包/類
private static Map<String, QueryParameter> getUsedParametersMap(Report report, boolean withHidden, boolean onlyHidden) {  
 	if (report == null) {
 		return new HashMap<String, QueryParameter>();
 	}
     String sql = report.getSql();
     if (sql == null) {
         sql = report.getQuery().toString();
     }
     Query query = new Query(sql);

     String[] paramNames = query.getParameterNames();
     LinkedHashMap<String, QueryParameter> params = new LinkedHashMap<String, QueryParameter>();
     for (QueryParameter qp : report.getParameters()) {
         String name = qp.getName();
         boolean found = false;
         for (String pName : paramNames) {
             if (pName.equals(name)) {
             	if (onlyHidden) {
             		if (qp.isHidden()) {
             			found = true;
             			break;
             		}
             	} else if (!qp.isHidden() || (qp.isHidden() && withHidden)) {
                     found = true;
                     break;
                 }
             }
         }
         // parameter is not used inside query but it is used inside other parameter
         if (!found) {
         	if (getChildDependentParameters(report, qp).size() > 0) {
         		found = true;            	
         	} 
         }
         
         if (onlyHidden) {
         	if  (found) {
         		params.put(name, qp);
         	}
} else {
	if (found || (qp.isHidden() && withHidden)) {
		params.put(name, qp);
	}
}
     }
     return params;
 }