本文整理汇总了Java中net.sf.jasperreports.engine.design.JRDesignQuery.setText方法的典型用法代码示例。如果您正苦于以下问题:Java JRDesignQuery.setText方法的具体用法?Java JRDesignQuery.setText怎么用?Java JRDesignQuery.setText使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类net.sf.jasperreports.engine.design.JRDesignQuery
的用法示例。
在下文中一共展示了JRDesignQuery.setText方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: dispose
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();
}
示例2: setValue
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);
}
示例3: readFields
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;
}
示例4: readFields
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;
}
示例5: gerarRelatorioEstoquePdf
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();
}
}
示例6: gerarRelatorioPdf
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();
}
}
示例7: createJRDataset
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;
}
示例8: setPropertyValue
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));
}
}
}
示例9: doSetQuery
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 + "}"));
}
}
示例10: readFields
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;
}
示例11: getTemplate
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());
}
}
示例12: cascadingDependencies
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;
}
}
示例13: createDataset
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;
}
示例14: jButton1ActionPerformed
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);
}
}
示例15: okButtonActionPerformed
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);
}