Examples of net.sf.jasperreports.engine.JRQuery

net.sf.jasperreports.engine.JRQuery
Represents a query used for generation of report data.
Based on the query language, query executer implementations are used to retrieve the data and create a {@link net.sf.jasperreports.engine.JRDataSource JRDataSource} to be used by the filling process.
When using the default SQL connection data source, an SQL query must also be provided for JasperReports to automatically retrieve the data. For SQL queries, a very important aspect is that column names in the result set obtained from the query must match the field names defined in the report template. @author Teodor Danciu (teodord@users.sourceforge.net) @version $Id: JRQuery.java 3033 2009-08-27 11:46:22Z teodord $ @see net.sf.jasperreports.engine.query.JRQueryExecuterFactory

    }
  }


  protected void copyConnectionParameter(Map parameterValues)
  {
    JRQuery query = dataset.getQuery();
    if (query != null)
    {
      String language = query.getLanguage();
      if (connectionExpression == null && 
          (language.equals("sql") || language.equals("SQL")) &&
          !parameterValues.containsKey(JRParameter.REPORT_CONNECTION))
      {
        JRFillParameter connParam = (JRFillParameter) filler.getParametersMap().get(JRParameter.REPORT_CONNECTION);

View Full Code Here

  /**
   *
   */
  private void verifyQuery(JRDesignDataset dataset)
  {
    JRQuery query = dataset.getQuery();
    if (query != null)
    {
      String language = query.getLanguage();
      JRQueryExecuterFactory queryExecuterFactory = null;
      if (language == null || language.length() == 0)
      {
        addBrokenRule("Query language not set.", query);
      }
      else
      {
        try
        {
          queryExecuterFactory = JRQueryExecuterUtils.getQueryExecuterFactory(query.getLanguage());
        }
        catch (JRException e1)
        {
          addBrokenRule("Query executer factory for " + language + " cannot be created.", query);
        }
      }




      JRQueryChunk[] chunks = query.getChunks();
      if (chunks != null && chunks.length > 0)
      {
        Map parametersMap = dataset.getParametersMap();


        for(int j = 0; j < chunks.length; j++)

View Full Code Here

   */
  protected void parseQuery()
  {
    parameterClauseStack = new HashSet();
    
    JRQuery query = dataset.getQuery();
    
    if (query != null)
    {
      JRQueryChunk[] chunks = query.getChunks();
      if (chunks != null && chunks.length > 0)
      {
        StringBuffer sbuffer = new StringBuffer();
        for(int i = 0; i < chunks.length; i++)
        {

View Full Code Here

    // copy the main report's connection parameter to the table subreport
    // this is done for consistency with subdataset runs
    if (!parameterValues.containsKey(JRParameter.REPORT_CONNECTION)
        && getConnectionExpression() == null)
    {
      JRQuery query = tableReport.getQuery();
      if (query != null)
      {
        String language = query.getLanguage();
        if (language.equals("sql") || language.equals("SQL"))
        {
          Connection connection = (Connection) filler.getParameterValuesMap().get(
              JRParameter.REPORT_CONNECTION);
          if (connection != null)

View Full Code Here


        //BeanUtils.copyProperties does not perform deep copy,
      //adding original dataset definitions manually
      if (dr.isTemplateImportDatasets()) {
        // also copy query
        JRQuery query = jd.getQuery();
        if (query instanceof JRDesignQuery) {
          djd.setQuery((JRDesignQuery) query);
          dr.setQuery(new DJQuery(query.getText(), query
              .getLanguage()));
        }


        for (Iterator iter = jd.getDatasetsList().iterator(); iter.hasNext();) {
          JRDesignDataset dataset = (JRDesignDataset) iter.next();

View Full Code Here


        //BeanUtils.copyProperties does not perform deep copy,
      //adding original dataset definitions manually
      if (dr.isTemplateImportDatasets()) {
        // also copy query
        JRQuery query = jd.getQuery();
        if (query instanceof JRDesignQuery) {
          djd.setQuery((JRDesignQuery) query);
          dr.setQuery(new DJQuery(query.getText(), query
              .getLanguage()));
        }


        for (Iterator iter = jd.getDatasetsList().iterator(); iter.hasNext();) {
          JRDesignDataset dataset = (JRDesignDataset) iter.next();

View Full Code Here


        //BeanUtils.copyProperties does not perform deep copy,
      //adding original dataset definitions manually
      if (dr.isTemplateImportDatasets()) {
        // also copy query
        JRQuery query = jd.getQuery();
        if (query instanceof JRDesignQuery) {
          djd.setQuery((JRDesignQuery) query);
          dr.setQuery(new DJQuery(query.getText(), query
              .getLanguage()));
        }


        for (Iterator iter = jd.getDatasetsList().iterator(); iter.hasNext();) {
          JRDesignDataset dataset = (JRDesignDataset) iter.next();

View Full Code Here

TOP

Related Classes of net.sf.jasperreports.engine.JRQuery

ar.com.fdvs.dj.core.DJJRDesignHelper

net.sf.jasperreports.components.table.fill.FillTableSubreport

net.sf.jasperreports.engine.design.JRVerifier

net.sf.jasperreports.engine.fill.JRFillDatasetRun

net.sf.jasperreports.engine.query.JRAbstractQueryExecuter

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.