Java QueryUtil.isProcedureCall方法代碼示例

import ro.nextreports.engine.util.QueryUtil; //導入方法依賴的package包/類
/**
 * Execute query This method is useful in case you are not interested about
 * report layout, but only query and you want to make your own business.
 * 
 * @return QueryResult object
 * 
 * @throws ReportRunnerException
 *             if Runner object is not correctly configured
 * @throws InterruptedException
 *             if process was interrupted
 */
public QueryResult executeQuery() throws ReportRunnerException, InterruptedException {
	if (connection == null) {
		throw new ReportRunnerException("Connection is null!");
	}
	if (report == null) {
		throw new ReportRunnerException("Report is null!");
	}

	String sql = getSql();

	// retrieves the report parameters
	Map<String, QueryParameter> parameters = getReportParameters();

	if (QueryUtil.restrictQueryExecution(sql)) {
		throw new ReportRunnerException("You are not allowed to execute queries that modify the database!");
	}

	if (QueryUtil.isProcedureCall(sql)) {
		if (!QueryUtil.isValidProcedureCall(sql, dialect)) {
			throw new ReportRunnerException("Invalid procedure call! Must be of form 'call (${P1}, ?)'");
		}
	}

	QueryResult queryResult = null;
	try {
		Query query = getQuery(sql);
		QueryExecutor executor = new QueryExecutor(query, parameters, parameterValues, connection, count, true,
				csv);
		executor.setMaxRows(0);
		executor.setTimeout(queryTimeout);

		queryResult = executor.execute();

		return queryResult;
	} catch (Exception e) {
		throw new ReportRunnerException(e);
	}

}
 

import ro.nextreports.engine.util.QueryUtil; //導入方法依賴的package包/類
private void setOutParametersValues(PreparedStatement pstmt) throws SQLException, DialectException {
    Dialect dialect = DialectUtil.getDialect(conn);
    if (QueryUtil.isProcedureCall(query.getText())) {
        if (dialect.hasProcedureWithCursor()) {
            ((CallableStatement) pstmt).registerOutParameter(outputParameterPosition,dialect.getCursorSqlType());
        }            
    }
}
 

import ro.nextreports.engine.util.QueryUtil; //導入方法依賴的package包/類
/**
 * Parse query and return a string query  that will be passed to prepared
 * statement(substitute parameter with '?' char).
 */
private String createQueryString() {
       QueryChunk[] chunks = query.getChunks();
	if ((chunks == null) || (chunks.length == 0)) {
		// no query chunks
		return "";
	}

	StringBuffer sb = new StringBuffer();
       QueryChunk chunk = null;
       int position = 1;
       for (int i = 0; i < chunks.length; i++) {
		chunk = chunks[i];
		//System.out.println("chunk = " + chunk);
		switch (chunk.getType()) {
			case QueryChunk.PARAMETER_TYPE: {
                   position++;
                   String paramName = chunk.getText();
				QueryParameter param = parameters.get(paramName);					
				if (QueryParameter.MULTIPLE_SELECTION.equals(param.getSelection())) {
					if (QueryUtil.isProcedureCall(query.getText())) {		
						sb.append("?");
					} else {
						Object[] paramValue = (Object[]) parameterValues.get(paramName);						
						sb.append('(');
						for (int j = 0; j < paramValue.length; j++) {
							if (j > 0) {
								sb.append(',');
							}
							sb.append('?');
						}
						sb.append(')');
					}
				} else {
					sb.append("?");
				}
				break;
			}
			case QueryChunk.TEXT_TYPE:
                   if (chunk.getText().contains("?")) {
                       outputParameterPosition = position;                        
                   }
               default: {
				sb.append(chunk.getText());
				break;
			}
		}
	}        
       return sb.toString();
}