how to use code from java class in xml file?

[mahmoud saleh]

greetings all
i have java class and xml file for generating report
and i want when user selects 2 from the combobox and button is pressed
the query string in the xml file is changed to 'week5'to'week8'
so i tried to add the xml file and the java class to the same package first,right? or there's another way to use code from java class in xml file?
but it doesn't work i used
<package>
<name>first</name>
.
.
.
</package>

here's the xml file

<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<package>
<name>first</name>
<jasperReport
 name="test"
 columnCount="1"
 printOrder="Vertical"
 orientation="Portrait"
 pageWidth="595"
 pageHeight="842"
 columnWidth="535"
 columnSpacing="0"
 leftMargin="30"
 rightMargin="30"
 topMargin="20"
 bottomMargin="20"
 whenNoDataType="NoPages"
 isTitleNewPage="false"
 isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
 
<queryString><![CDATA[SELECT * FROM report WHERE category BETWEEN 'week1' AND 'week4']]></queryString>
 
<field name="category" class="java.lang.String"/>
<field name="values" class="java.lang.Integer"/>
<field name="series" class="java.lang.String"/>
 
<background>
<band height="0"  isSplitAllowed="true" >
</band>
</background>
<title>
<band height="50"  isSplitAllowed="true" >
<staticText>
<reportElement
x="158"
y="7"
width="183"
height="37"
key="staticText-1"/>
<box></box>
<textElement>
<font size="14"/>
</textElement>
<text><![CDATA[               Report]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="50"  isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="30"  isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="4"  isSplitAllowed="true" >
</band>
</detail>
<columnFooter>
<band height="2"  isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0"  isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="194"  isSplitAllowed="true" >
<stackedBar3DChart>
<chart  hyperlinkTarget="Self" >
<reportElement
x="49"
y="-6"
width="369"
height="200"
key="element-1"/>
<box></box>
<chartLegend textColor="#000000" backgroundColor="#FFFFFF" >
</chartLegend>
</chart>
<categoryDataset>
<dataset >
</dataset>
<categorySeries>
<seriesExpression><![CDATA[$F{series}]]></seriesExpression>
<categoryExpression><![CDATA[$F{category}]]></categoryExpression>
<valueExpression><![CDATA[$F{values}]]></valueExpression>
<itemHyperlink >
</itemHyperlink>
</categorySeries>
</categoryDataset>
<bar3DPlot >
<plot />
<categoryAxisFormat>
<axisFormat >
</axisFormat>
</categoryAxisFormat>
<valueAxisFormat>
<axisFormat >
</axisFormat>
</valueAxisFormat>
</bar3DPlot>
</stackedBar3DChart>
</band>
</summary>
</jasperReport>
</package>

and here's the java class:

package first;
 
import java.sql.*;
import net.sf.jasperreports.view.JasperViewer;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.JasperReport;
import java.io.OutputStream;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
 
 class ReportDriver {
 
public static void createAndShowGUI(){
Object[]obj={"1","2"};
JComboBox combo=new JComboBox(obj);
JFrame frame=new JFrame("Test");
JButton button=new JButton("Show Report");
frame.setLayout(new FlowLayout());
frame.setLocationRelativeTo(null);
frame.add(combo);
frame.add(button);
frame.setSize(150,100);
frame.setVisible(true);
button.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
show_report();
}
});
}
 
public static void show_report(){
try{
         Class.forName("com.mysql.jdbc.Driver");
         Connection c = DriverManager.getConnection("jdbc:mysql://localhost/library", "root", "");
      }catch(Exception ex) {ex.printStackTrace();}
 

    
      try{
         JasperDesign jasperDesign = JRXmlLoader.load("F:\\Program Files\\Xinox Software\\JCreatorV4\\MyProjects\\chart2\\src\\report.xml");
         JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
         Connection c = DriverManager.getConnection("jdbc:mysql://localhost/library", "root", "");
         JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, c);
         JasperViewer.viewReport(jasperPrint);
      }catch(Exception ex) {
         String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();
         System.out.println(connectMsg);
      }
}
      
   public static void main(String[] args) {
    createAndShowGUI();
   }
}

[Darya Akbari]

Originally posted by mahmoud saleh:
... but it doesn't work i used

<package>
<name>first</name>
.
.
.
</package>

You don't need that <package> XML thing around your Jasper XML file. Take the <package><name> off your Jasper XML file. Your Jasper XML contains your report and should look like:

<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport>...</jasperReport>

Then make sure that your Jasper XML file (report.xml) really is in:

F:\Program Files\Xinox Software\JCreatorV4\MyProjects\chart2\src\report.xml

For more on Jasper I can recommend