how to set query to jasper via java code?

[newbiejava]

how to set query to jasper via java code?

JasperDesign jasperDesign = JRXmlLoader.load("C:\\project\\learnjava\\myreport1.jrxml");

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

Connection jdbcConn = connectMySQL();

JasperPrint  jasperPrint = JasperFillManager.fillReport(jasperReport, null, jdbcConn);

JasperViewer.viewReport(jasperPrint);

[wsaryada]

Hi,

From what I remembered if you don't want the query in the Jasper report template you can use the JasperFillManager.fillReport() method that accept the JRDataSource instead of the one that accept java.sql.Connection. Using JRDataSource you can inject the report data other than using a direct database query.