Kada pokušam da prosledim parametar
u ireport dobijem grešku..
Query parameter not found
Evo coda.
...
Map params = new java.util.HashMap();
String sql = "01";
params.put("sql", sql);
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/recepti";
Connection con = (Connection) DriverManager.getConnection(url,"root", "123");
JasperDesign jasperDesign = JRXmlLoader.load("D:/JAVA/Primeri/DataBase/src/database/report1.jrxml");
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, params, con);
//ili ako hoćeš možeš ga prikayati u pdf// JasperExportManager.exportReportToPdfFile(jasperPrint, "Faktura.pdf");
JasperViewer.viewReport(jasperPrint, false);
}catch(Exception ex) {
String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();
System.out.println(connectMsg);
}
....
A u report.jrxml
...
<queryString language="SQL">
<![CDATA[SELECT
drzava.`id_drzava` AS drzava_id_drzava,
drzava.`nazivd` AS drzava_nazivd
FROM
`drzava` drzava
WHERE
id_drzava='" + $P!{sql} + "' ]]>
...
Molim za pomoć!
Patak daca