public Map<String, Object> getJasperReportParameters() {
Map<String, Object> jasperReportParameters = Maps.newHashMap();
try {
HttpServletRequest request = ServletActionContext.getRequest();
String reportId = request.getParameter("report");
File targetJasperFile = getTargetJasperFile(reportId);
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(targetJasperFile);
// 根据模板定义转换处理传入参数类型
JRParameter[] params = jasperReport.getParameters();
for (Map.Entry<String, Object> val : reportParameters.entrySet()) {
String key = val.getKey();
if (val.getValue() == null) {
continue;
}
String[] vals = (String[]) val.getValue();
for (JRParameter param : params) {
if (!param.isSystemDefined() && param.isForPrompting()) {
String name = param.getName();
Class<?> clazz = param.getValueClass();
if (!name.equals(key)) {
continue;
}
// TODO: 先初步添加集合处理，后续逐步添加数字、日期等类型转换处理
if (Collection.class.isAssignableFrom(clazz)) {
// 集合类型参数处理，TODO: 可以考虑进一步添加param.getNestedType()处理
jasperReportParameters.put(key, vals);
} else {
// 其余情况把参数转换为普通字符串传入
jasperReportParameters.put(val.getKey(), StringUtils.join(vals, ","));
}
}
}
}
// 设置一些缺省属性供模板内部使用
jasperReportParameters.put("_RPT_ID", reportId);
jasperReportParameters.put("_RPT_FORMAT", this.getFormat());
String url = request.getRequestURL().toString();
logger.debug("Report URL: " + url);
jasperReportParameters.put("_RPT_URL", url);
} catch (Exception e) {
logger.error(e.getMessage(), e);
throw new WebException(e.getMessage(), e);
}
return jasperReportParameters;
}
protected JRBaseParameter(JRParameter parameter, JRBaseObjectFactory factory) {
factory.put(parameter, this);
name = parameter.getName();
description = parameter.getDescription();
valueClassName = parameter.getValueClassName();
nestedTypeName = parameter.getNestedTypeName();
isSystemDefined = parameter.isSystemDefined();
isForPrompting = parameter.isForPrompting();
defaultValueExpression = factory.getExpression(parameter.getDefaultValueExpression());
propertiesMap = parameter.getPropertiesMap().cloneProperties();
}
/**
* Checks if the parameter name is suitable for the current expression context.
*
* @param parameter the parameter to validate
*/
@Check
public void checkParameterName(JRParameterObj parameter) {
ExpressionContext currExpContext =
ExpressionEditorSupportUtil.safeGetCurrentExpressionContext();
List<JRParameter> allParameters =
ExpressionContextUtils.getAllDatasetsParameters(currExpContext);
for (JRParameter p : allParameters) {
if (("{" + p.getName() + "}").equals(parameter.getBracedIdentifier()))
return; //$NON-NLS-1$ //$NON-NLS-2$
}
List<JRParameter> allCrosstabsParameters =
ExpressionContextUtils.getAllCrosstabsParameters(currExpContext);
for (JRParameter p : allCrosstabsParameters) {
if (("{" + p.getName() + "}").equals(parameter.getBracedIdentifier()))
return; //$NON-NLS-1$ //$NON-NLS-2$
}
error(
Messages.JavaJRExpressionJavaValidator_ParameterNotFoundInContextError,
parameter,
JavaJRExpressionPackage.Literals.JR_PARAMETER_OBJ__BRACED_IDENTIFIER,
JavaJRExpressionPackage.JR_PARAMETER_OBJ__BRACED_IDENTIFIER);
}
@SuppressWarnings("unchecked")
public void recalculateKeys() {
List l = (List) lock();
l.clear();
if (IReportManager.getPreferences().getBoolean("filter_parameters", false)) {
List paramsAll = dataset.getParametersList();
for (int i = 0; i < paramsAll.size(); ++i) {
JRParameter p = (JRParameter) paramsAll.get(i);
if (!p.isSystemDefined()) {
l.add(p);
}
}
} else {
l.addAll(dataset.getParametersList());
}
if (getNode() != null && getNode() instanceof ParametersNode) {
if (((ParametersNode) getNode()).isSort()) {
// Order elements by name...
Object[] parameters = l.toArray();
Arrays.sort(
parameters,
new Comparator() {
public int compare(Object o1, Object o2) {
return ((JRDesignParameter) o1)
.getName()
.compareToIgnoreCase(((JRDesignParameter) o2).getName());
}
});
l.clear();
l.addAll(Arrays.asList(parameters));
}
}
update();
}
private String generateExpression(JRExpression expression, byte evaluationType) {
JRParameter jrParameter = null;
JRField jrField = null;
JRVariable jrVariable = null;
StringBuffer sbuffer = new StringBuffer();
JRExpressionChunk[] chunks = expression.getChunks();
JRExpressionChunk chunk = null;
String chunkText = null;
if (chunks != null && chunks.length > 0) {
for (int i = 0; i < chunks.length; i++) {
chunk = chunks[i];
chunkText = chunk.getText();
if (chunkText == null) {
chunkText = "";
}
switch (chunk.getType()) {
case JRExpressionChunk.TYPE_TEXT:
{
sbuffer.append(chunkText);
break;
}
case JRExpressionChunk.TYPE_PARAMETER:
{
jrParameter = (JRParameter) parametersMap.get(chunkText);
sbuffer.append("((");
sbuffer.append(jrParameter.getValueClassName());
sbuffer.append(")super.parameter_");
sbuffer.append(JRStringUtil.getJavaIdentifier(chunkText));
sbuffer.append(".getValue())");
break;
}
case JRExpressionChunk.TYPE_FIELD:
{
jrField = (JRField) fieldsMap.get(chunkText);
sbuffer.append("((");
sbuffer.append(jrField.getValueClassName());
sbuffer.append(")super.field_");
sbuffer.append(JRStringUtil.getJavaIdentifier(chunkText));
sbuffer.append(".get");
sbuffer.append((String) fieldPrefixMap.get(new Byte(evaluationType)));
sbuffer.append("Value())");
break;
}
case JRExpressionChunk.TYPE_VARIABLE:
{
jrVariable = (JRVariable) variablesMap.get(chunkText);
sbuffer.append("((");
sbuffer.append(jrVariable.getValueClassName());
sbuffer.append(")super.variable_");
sbuffer.append(JRStringUtil.getJavaIdentifier(chunkText));
sbuffer.append(".get");
sbuffer.append((String) variablePrefixMap.get(new Byte(evaluationType)));
sbuffer.append("Value())");
break;
}
case JRExpressionChunk.TYPE_RESOURCE:
{
jrParameter = (JRParameter) parametersMap.get(chunkText);
sbuffer.append("super.evaluator.str(\"");
sbuffer.append(chunkText);
sbuffer.append("\")");
break;
}
}
}
}
if (sbuffer.length() == 0) {
sbuffer.append("null");
}
return sbuffer.toString();
}
public JRField[] getFields(IReportConnection irConn, JRDataset reportDataset, Map parameters)
throws JRException, UnsupportedOperationException {
if (irConn == null || !irConn.isJDBCConnection()) {
throw new JRException(
"The active connection is not of type JDBC. Activate a JDBC connection first.");
}
String query = reportDataset.getQuery().getText();
String error_msg = "";
Connection con = null;
PreparedStatement ps = null;
try {
// look for parameters in the query and replace them with default values.
// parameters look something like
// $P{QuoteGroupID}
// or
// $P!{OrderByClause}
java.util.List queryParams = new ArrayList();
JRParameter[] jrParams = reportDataset.getParameters();
for (int k = 0; k < jrParams.length; ++k) {
JRParameter parameter = jrParams[k];
String p1 = "$P{" + parameter.getName() + "}";
String p2 = "$P!{" + parameter.getName() + "}";
Object defValue = parameters.get(parameter.getName());
int ip1 = query.indexOf(p1);
while (ip1 != -1) {
// add a query parameter
if (defValue == null) {
throw new IllegalArgumentException(
"Please set a " + "default value for the parameter '" + parameter.getName() + "'");
}
String before = query.substring(0, ip1);
String after = query.substring(ip1 + p1.length());
query = before + " ? " + after;
queryParams.add(defValue);
ip1 = query.indexOf(p1);
}
int ip2 = query.indexOf(p2);
while (ip2 != -1) {
// String replacement, Altering the SQL statement.
if (defValue == null) {
throw new IllegalArgumentException(
"Please set a " + "default value for the parameter '" + parameter.getName() + "'");
}
String before = query.substring(0, ip2);
String after = query.substring(ip2 + p2.length());
query = before + "" + defValue.toString() + "" + after;
ip2 = query.indexOf(p2);
}
}
con = irConn.getConnection();
ps = con.prepareStatement(query);
// for(int pc=0; pc<queryParams.size(); pc++ ) {
// ps.setObject(pc+1, queryParams.get(pc) );
// }
for (int pc = 0; pc < queryParams.size(); pc++) {
Class parameterType = queryParams.get(pc).getClass();
if (java.lang.Boolean.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.BIT);
} else {
ps.setBoolean(pc + 1, ((Boolean) queryParams.get(pc)).booleanValue());
}
} else if (java.lang.Byte.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.TINYINT);
} else {
ps.setByte(pc + 1, ((Byte) queryParams.get(pc)).byteValue());
}
} else if (java.lang.Double.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.DOUBLE);
} else {
ps.setDouble(pc + 1, ((Double) queryParams.get(pc)).doubleValue());
}
} else if (java.lang.Float.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.FLOAT);
} else {
ps.setFloat(pc + 1, ((Float) queryParams.get(pc)).floatValue());
}
} else if (java.lang.Integer.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.INTEGER);
} else {
ps.setInt(pc + 1, ((Integer) queryParams.get(pc)).intValue());
}
} else if (java.lang.Long.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.BIGINT);
} else {
ps.setLong(pc + 1, ((Long) queryParams.get(pc)).longValue());
}
} else if (java.lang.Short.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.SMALLINT);
} else {
ps.setShort(pc + 1, ((Short) queryParams.get(pc)).shortValue());
}
} else if (java.math.BigDecimal.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.DECIMAL);
} else {
ps.setBigDecimal(pc + 1, (BigDecimal) queryParams.get(pc));
}
} else if (java.lang.String.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.VARCHAR);
} else {
ps.setString(pc + 1, queryParams.get(pc).toString());
}
} else if (java.sql.Timestamp.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.TIMESTAMP);
} else {
ps.setTimestamp(pc + 1, (java.sql.Timestamp) queryParams.get(pc));
}
} else if (java.sql.Time.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.TIME);
} else {
ps.setTime(pc + 1, (java.sql.Time) queryParams.get(pc));
}
} else if (java.util.Date.class.isAssignableFrom(parameterType)) {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.DATE);
} else {
ps.setDate(pc + 1, new java.sql.Date(((java.util.Date) queryParams.get(pc)).getTime()));
}
} else {
if (queryParams.get(pc) == null) {
ps.setNull(pc + 1, Types.JAVA_OBJECT);
} else {
ps.setObject(pc + 1, queryParams.get(pc));
}
}
}
// Some JDBC drivers don't supports this method...
try {
ps.setFetchSize(0);
} catch (Exception e) {
}
ResultSet rs = ps.executeQuery();
// if (in < num) return;
ResultSetMetaData rsmd = rs.getMetaData();
// if (in < num) return;
List columns = new ArrayList();
for (int i = 1; i <= rsmd.getColumnCount(); ++i) {
JRDesignField field = new JRDesignField();
field.setName(rsmd.getColumnLabel(i));
field.setValueClassName(Misc.getJdbcTypeClass(rsmd, i));
field.setDescription("");
columns.add(field);
}
JRField[] final_fields = new JRField[columns.size()];
for (int i = 0; i < final_fields.length; ++i) {
final_fields[i] = (JRField) columns.get(i);
}
return final_fields;
} catch (IllegalArgumentException ie) {
throw new JRException(ie.getMessage());
} catch (NoClassDefFoundError ex) {
ex.printStackTrace();
error_msg = "NoClassDefFoundError!!\nCheck your classpath!";
throw new JRException(error_msg);
} catch (java.sql.SQLException ex) {
error_msg = "SQL problems:\n" + ex.getMessage();
throw new JRException(error_msg);
} catch (Exception ex) {
ex.printStackTrace();
error_msg =
"General problem:\n"
+ ex.getMessage()
+ "\n\nCheck username and password; is the DBMS active ?!";
throw new JRException(error_msg);
} catch (Throwable t) {
throw new JRException(t.getMessage());
} finally {
if (ps != null)
try {
ps.close();
} catch (Exception e) {
}
if (con != null)
try {
con.close();
} catch (Exception e) {
}
}
}
