Java JRDesignQuery.setText方法代码示例

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
@Override
public void dispose() {
	String lang = "";
	int selectionIndex = langCombo.getSelectionIndex();
	if (selectionIndex < 0)
		lang = langCombo.getText().trim();
	else
		lang = langCombo.getItem(selectionIndex);
	String text = queryText.getText();

	if (lang.equals("") && (text == null || text.equals("")))
		value = new MQuery(null, null);
	else {
		JRDesignQuery jrQuery = new JRDesignQuery();
		jrQuery.setLanguage(lang);
		jrQuery.setText(text);
		value = new MQuery(jrQuery, null);
	}
	super.dispose();
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
public void setValue(Object val) throws IllegalAccessException, IllegalArgumentException, InvocationTargetException {
    
        JRDesignQuery oldValue = (JRDesignQuery)dataset.getQuery();
        String lang = (val == null) ? "SQL" : val+"";
        if (lang.trim().length() == 0) lang = "SQL";
        
        JRDesignQuery newValue = new JRDesignQuery();
        if (oldValue != null && oldValue.getText() != null)
        {
            newValue.setText(oldValue.getText());
        }
        
        newValue.setLanguage(lang);
        
        dataset.setQuery(newValue);
    
        ObjectPropertyUndoableEdit urob =
                new ObjectPropertyUndoableEdit(
                    dataset,
                    "Query", 
                    JRDesignQuery.class,
                    oldValue,newValue);
        // Find the undoRedo manager...
        IReportManager.getInstance().addUndoableEdit(urob);
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
public List<JRDesignField> readFields(String query) throws Exception {
    
    SQLFieldsProvider provider = new SQLFieldsProvider();
    List<JRDesignField> result = new ArrayList<JRDesignField>();
    JRDesignDataset dataset = new JRDesignDataset(true);
    JRDesignQuery dquery = new JRDesignQuery();
    dquery.setLanguage("SQL");
    dquery.setText(query);
    dataset.setQuery(dquery);
    JRField[] fields = provider.getFields(this, dataset, new HashMap());
    for (int i=0; i<fields.length; ++i)
    {
        result.add((JRDesignField)fields[i]);
    }
    
    return result;
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
@Override
public List<JRDesignField> readFields(String query) throws Exception {
	MongoDbFieldsProvider provider = new MongoDbFieldsProvider();
	List<JRDesignField> result = new ArrayList<JRDesignField>();
	JRDesignDataset dataset = new JRDesignDataset(true);
	JRDesignQuery designQuery = new JRDesignQuery();
	designQuery.setLanguage(MongoDbDataSource.QUERY_LANGUAGE);
	designQuery.setText(query);
	dataset.setQuery(designQuery);
	Map<String, String> parameters = new HashMap<String, String>();
	JRField[] fields = provider.getFields(this, dataset, parameters);
	for (int i = 0; i < fields.length; ++i) {
		result.add((JRDesignField) fields[i]);
	}
	return result;
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
@SuppressWarnings({ "rawtypes", "unchecked" })
public void gerarRelatorioEstoquePdf(String sql, int totalProdutos){
	try{
		String caminhoSalvar = "";
       	DirectoryChooser directoryChooser = new DirectoryChooser();
           File selectedDirectory = directoryChooser.showDialog(null);
            
           if(selectedDirectory == null){
               System.out.println("N�o selecionou nada");
           }else{
               caminhoSalvar = selectedDirectory.getAbsolutePath();
           }
           if(!caminhoSalvar.isEmpty()){
           	Connection conn = new ConexaoBD().getConnection();
   			HashMap param = new HashMap();
   			param.put("totalProdutos", totalProdutos);
   			JasperDesign jd = JRXmlLoader.load("src/main/java/br/com/buyme/report/VerificaEstoque.jrxml");
   			JRDesignQuery newQuery = new JRDesignQuery();
   			newQuery.setText(sql);
   			jd.setQuery(newQuery);
   			JasperReport jr = JasperCompileManager.compileReport(jd);
   			JasperPrint jp = JasperFillManager.fillReport(jr, param,conn);
   			JasperExportManager.exportReportToPdfFile(jp,caminhoSalvar+"/Estoque.pdf");
   			conn.close();
           }
	}catch(Exception e){
		e.printStackTrace();
	}
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
@SuppressWarnings({ "rawtypes", "unchecked" })
public void gerarRelatorioPdf(String sql){
	try{
		String caminhoSalvar = "";
       	DirectoryChooser directoryChooser = new DirectoryChooser();
           File selectedDirectory = directoryChooser.showDialog(null);
            
           if(selectedDirectory == null){
               System.out.println("N�o selecionou nada");
           }else{
               caminhoSalvar = selectedDirectory.getAbsolutePath();
           }
           if(!caminhoSalvar.isEmpty()){
           	Connection conn = new ConexaoBD().getConnection();
   			HashMap param = new HashMap();
		
			JasperDesign jd = JRXmlLoader.load("src/main/java/br/com/buyme/report/MotivoPerda.jrxml");
   			JRDesignQuery newQuery = new JRDesignQuery();
   			newQuery.setText(sql);
   			jd.setQuery(newQuery);
   			JasperReport jr = JasperCompileManager.compileReport(jd);
   			JasperPrint jp = JasperFillManager.fillReport(jr, param,conn);
   			JasperExportManager.exportReportToPdfFile(jp,caminhoSalvar+"/MotivoPerda.pdf");
		
   			conn.close();
           }
	}catch(Exception e){
		e.printStackTrace();
	}
	
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
/**
 * Creates the jr dataset.
 * 
 * @param jrDesign
 *          the jr design
 * @return the jR design dataset
 */
public static JRDesignDataset createJRDataset(JasperReportsConfiguration jConfig, JasperDesign jrDesign) {
	JRDesignDataset jrDesignDataset = new JRDesignDataset(jConfig, false);
	jrDesignDataset.setName(ModelUtils.getDefaultName(jrDesign.getDatasetMap(), "Dataset")); //$NON-NLS-1$
	JRDesignQuery jrDesignQuery = new JRDesignQuery();
	jrDesignQuery.setLanguage("sql"); //$NON-NLS-1$
	jrDesignQuery.setText(""); //$NON-NLS-1$
	jrDesignDataset.setQuery(jrDesignQuery);
	return jrDesignDataset;
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
public void setPropertyValue(Object id, Object value) {
	JRDesignQuery jrQuery = (JRDesignQuery) getValue();
	if (jrQuery != null) {
		if (id.equals(JRDesignQuery.PROPERTY_TEXT)) {
			jrQuery.setText((String) value);
		} else if (id.equals(JRDesignQuery.PROPERTY_LANGUAGE)) {
			String lang = Misc.nullValue((String) value);
			jrQuery.setLanguage(ModelUtils.getLanguage(lang));
		}
	}
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
protected void doSetQuery(String oldVal, String newVal) {
	if (type1.equals("$P{")) {
		JRDesignQuery query = (JRDesignQuery) dataset.getQuery();
		String q = query.getText();
		// replace $P{} in query
		query.setText(q.replaceAll(type + oldVal + "}", type + newVal + "}"));
	}
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
@Override
public List<JRDesignField> readFields(String query) throws Exception {
	HiveFieldsProvider provider = new HiveFieldsProvider();
	List<JRDesignField> result = new ArrayList<JRDesignField>();
	JRDesignDataset dataset = new JRDesignDataset(true);
	JRDesignQuery designQuery = new JRDesignQuery();
	designQuery.setLanguage(HiveDataSource.QUERY_LANGUAGE);
	designQuery.setText(query);
	dataset.setQuery(designQuery);
	JRField[] fields = provider.getFields(this, dataset, new HashMap<Object, Object>());
	for (int i = 0; i < fields.length; ++i) {
		result.add((JRDesignField) fields[i]);
	}
	return result;
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
public byte[] getTemplate(){
		try{
//			design.remadgetFields().
			design.getFieldsList().clear();
			design.getParametersList().clear();
            design.getFieldsMap().clear();
            design.getParametersMap().clear();
            for (JasperReportFieldDto field : fields) {
				if (field.isEmpty()){
					continue;
				}
				JRDesignField f = new JRDesignField();
				f.setValueClassName(field.getTypeAsString());
				f.setValueClass(Class.forName(field.getTypeAsString()));
				f.setName(field.getName());
				design.addField(f);
			}

			for (JasperReportParameterDto param : parameters) {
				if (param.isEmpty()) {
					continue;
				}
				JRDesignParameter p = new JRDesignParameter();
				p.setValueClassName(param.getTypeAsString());
				p.setValueClass(Class.forName(param.getTypeAsString()));
				p.setName(param.getName());
				p.setForPrompting(param.isForPrompting());
				p.setDescription(param.getDescription());
				p.setNestedTypeName(param.getNestedTypeAsString());
				p.setNestedType(param.getNestedType());
				p.getPropertiesMap().setBaseProperties(param.getJRProperties());
				//			p.getPropertiesMap().setProperty(propName, value);
				design.addParameter(p);
			}

			JasperDesign oldDesign = ReportTypeUtil.loadJasperDesign(jasperReportXml);
			oldDesign.getParametersList().clear();
			oldDesign.getParametersList().addAll(design.getParametersList());

			oldDesign.getFieldsList().clear();
			oldDesign.getFieldsList().addAll(design.getFieldsList());

			JRDesignQuery q = new JRDesignQuery();
			q.setLanguage("mql");
			q.setText(query);
			oldDesign.setQuery(q);

			String reportAsString = JRXmlWriter.writeReport(oldDesign, "UTF-8");
			return Base64.encodeBase64(reportAsString.getBytes("UTF-8"));

		} catch (JRException | ClassNotFoundException | SchemaException | UnsupportedEncodingException ex) {
			throw new IllegalStateException(ex.getMessage(), ex.getCause());
		}
		
	}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
private void cascadingDependencies(ResourceDescriptor ic, Set<String> icNames) {
	List<ResourceDescriptor> children = ic.getChildren();
	for (ResourceDescriptor sub_ic : children) {
		if (!InputControlsManager.isRDQuery(sub_ic))
			continue;
		String queryString = sub_ic.getSql();
		String lang = sub_ic.getResourceProperty(ResourceDescriptor.PROP_QUERY_LANGUAGE).getValue();
		if (!Misc.isNullOrEmpty(queryString)) {
			List<String> parameters = new ArrayList<String>();
			JRDesignQuery query = new JRDesignQuery();
			query.setText(queryString);
			if (lang != null)
				query.setLanguage(lang);
			for (JRQueryChunk chunk : query.getChunks()) {
				switch (chunk.getType()) {
				case JRQueryChunk.TYPE_TEXT:
					break;
				case JRQueryChunk.TYPE_PARAMETER_CLAUSE:
				case JRQueryChunk.TYPE_PARAMETER:
					String paramName = chunk.getText().trim();
					if (!parameters.contains(paramName) && icNames.contains(paramName))
						parameters.add(paramName);
					break;
				case JRQueryChunk.TYPE_CLAUSE_TOKENS:
					String[] tokens = chunk.getTokens();
					if (tokens.length > 2) {
						for (String t : tokens) {
							t = t.trim();
							if (!parameters.contains(t) && icNames.contains(t))
								parameters.add(t);
						}
					}
					break;
				}
			}
			if (!parameters.isEmpty())
				ic.setMasterInputControls(parameters);
		}
		break;
	}
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
protected JRDesignDataset createDataset()
{
    
    try {
            
            JasperDesign jd = IReportManager.getInstance().getActiveReport();


            DatasetWizardIterator iterator = new DatasetWizardIterator();
            WizardDescriptor wizardDescriptor = new WizardDescriptor(iterator);
            iterator.initialize(wizardDescriptor, jd );
            // {0} will be replaced by WizardDescriptor.Panel.getComponent().getName()
            // {1} will be replaced by WizardDescriptor.Iterator.name()
            wizardDescriptor.setTitleFormat(new MessageFormat("{0} ({1})"));
            wizardDescriptor.setTitle("New Dataset");
            Dialog dialog = DialogDisplayer.getDefault().createDialog(wizardDescriptor);
            dialog.setVisible(true);
            dialog.toFront();
            boolean cancelled = wizardDescriptor.getValue() != WizardDescriptor.FINISH_OPTION;
            if (!cancelled) {

                JRDesignDataset newDataset = new JRDesignDataset(false);
                newDataset.setName( (String) wizardDescriptor.getProperty("dataset_name"));

                List<JRDesignField> selectedFields = (List<JRDesignField>) wizardDescriptor.getProperty("selectedFields");
                List<JRDesignField> groupFields = (List<JRDesignField>) wizardDescriptor.getProperty("groupFields");
                String query = (String) wizardDescriptor.getProperty("query");
                String queryLanguage = (String) wizardDescriptor.getProperty("queryLanguage");

                if (selectedFields == null) selectedFields = new ArrayList<JRDesignField>();
                if (groupFields == null) groupFields = new ArrayList<JRDesignField>();

                // Adding fields
                for (JRDesignField f : selectedFields)
                {
                    newDataset.addField(f);
                }

                // Query...
                if (query != null)
                {
                    JRDesignQuery designQuery = new JRDesignQuery();
                    designQuery.setText(query);
                    if (queryLanguage != null)
                    {
                        designQuery.setLanguage(queryLanguage);
                    }

                    newDataset.setQuery(designQuery);
                }

                // Adjusting groups
                for (int i=0; i<groupFields.size(); ++i)
                {
                      JRDesignGroup g =new JRDesignGroup();
                      g.setName(groupFields.get(i).getName());
                      g.setExpression(Misc.createExpression(groupFields.get(i).getValueClassName(), "$F{" + groupFields.get(i).getName() + "}"));
                      newDataset.addGroup(g);
                }


                jd.addDataset(newDataset);
                AddDatasetUndoableEdit edit = new AddDatasetUndoableEdit(newDataset, jd);
                IReportManager.getInstance().addUndoableEdit(edit);
                
                return newDataset;

            }
            
        } catch (JRException ex) {
            Exceptions.printStackTrace(ex);
        }
    
    return null;
    
    
}
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed

        try {
            DatasetWizardIterator iterator = new DatasetWizardIterator();
            WizardDescriptor wizardDescriptor = new WizardDescriptor(iterator);
            iterator.initialize(wizardDescriptor, getJasperDesign() );
            // {0} will be replaced by WizardDescriptor.Panel.getComponent().getName()
            // {1} will be replaced by WizardDescriptor.Iterator.name()
            wizardDescriptor.setTitleFormat(new MessageFormat("{0} ({1})"));
            wizardDescriptor.setTitle("New Dataset");
            Dialog dialog = DialogDisplayer.getDefault().createDialog(wizardDescriptor);
            dialog.setVisible(true);
            dialog.toFront();
            boolean cancelled = wizardDescriptor.getValue() != WizardDescriptor.FINISH_OPTION;
            if (!cancelled) {

                JRDesignDataset newDataset = new JRDesignDataset(false);
                newDataset.setName( (String) wizardDescriptor.getProperty("dataset_name"));

                List<JRDesignField> selectedFields = (List<JRDesignField>) wizardDescriptor.getProperty("selectedFields");
                List<JRDesignField> groupFields = (List<JRDesignField>) wizardDescriptor.getProperty("groupFields");
                String query = (String) wizardDescriptor.getProperty("query");
                String queryLanguage = (String) wizardDescriptor.getProperty("queryLanguage");

                if (selectedFields == null) selectedFields = new ArrayList<JRDesignField>();
                if (groupFields == null) groupFields = new ArrayList<JRDesignField>();

                // Adding fields
                for (JRDesignField f : selectedFields)
                {
                    newDataset.addField(f);
                }

                // Query...
                if (query != null)
                {
                    JRDesignQuery designQuery = new JRDesignQuery();
                    designQuery.setText(query);
                    if (queryLanguage != null)
                    {
                        designQuery.setLanguage(queryLanguage);
                    }

                    newDataset.setQuery(designQuery);
                }

                // Adjusting groups
                for (int i=0; i<groupFields.size(); ++i)
                {
                      JRDesignGroup g =new JRDesignGroup();
                      g.setName(groupFields.get(i).getName());
                      g.setExpression(Misc.createExpression(groupFields.get(i).getValueClassName(), "$F{" + groupFields.get(i).getName() + "}"));
                      newDataset.addGroup(g);
                }

                getJasperDesign().addDataset(newDataset);
                AddDatasetUndoableEdit edit = new AddDatasetUndoableEdit(newDataset, getJasperDesign());
                IReportManager.getInstance().addUndoableEdit(edit);

                updateDatasets();
                jComboBoxDataset.setSelectedItem(newDataset);
                jRadioButton1.setSelected(true);
                jRadioButton2.setSelected(false);

            }

        } catch (JRException ex) {
            Exceptions.printStackTrace(ex);
        }

    }
 

import net.sf.jasperreports.engine.design.JRDesignQuery; //导入方法依赖的package包/类
private void okButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_okButtonActionPerformed
    
    try {
        if (stoppedChanging != null) stoppedChanging.stop();

        if ( this.getDataset() != null)
        {       
            num++; // avoid syncronization problems....

            Object obj = jComboBoxQueryType.getSelectedItem();
            //JRDesignQuery query = (JRDesignQuery)dataset.getQuery();
            JRDesignQuery query = new JRDesignQuery();

            if (obj != null && obj instanceof Tag) 
            {
                query.setLanguage(""+((Tag)obj).getValue());
            }
            else
            {
                query.setLanguage(""+obj);
            }

            query.setText(jEditorPane1.getText());

            ClassLoader origCL = Thread.currentThread().getContextClassLoader();
            Thread.currentThread().setContextClassLoader( IReportManager.getReportClassLoader());

            this.dataset.setQuery(query);

            Thread.currentThread().setContextClassLoader( origCL );

            
            com.jaspersoft.ireport.designer.IReportManager.getInstance().notifyReportChange();

            if ( jTableFields.getRowCount() > 0)
            {
                // Clear all the existing fields.
                this.dataset.getFieldsList().clear(); // This would not be legal...
                this.dataset.getFieldsMap().clear();
                // Add the new fields.
                for (int i=0; i<jTableFields.getRowCount(); ++i)
                {
                    JRDesignField field = (JRDesignField)this.jTableFields.getValueAt(i, 0);
                    Iterator iterFields = this.dataset.getFieldsList().iterator();
                    boolean found = false;
                    while (iterFields.hasNext()) {
                        JRDesignField f = (JRDesignField)iterFields.next();
                        if (f.getName().equalsIgnoreCase(field.getName())) {
                            found = true;
                            break;
                        }
                    }
                    if (!found) {
                        this.dataset.addField(field);
                    }
                }
            } 
       }
   
   } catch (Throwable ex)
        {
            ex.printStackTrace();
        }
   
   this.setVisible(false);
    
}