[ patak_daca @ 21.10.2008. 09:38 ] @
| 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 |