1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
try {
JasperDesign jasperDesign = JRXmlLoader
.load("D:\\1-LICENCE\\Logiciel\\prjBRS\\rapports\\fiche.jrxml");
String sql = "SELECT * FROM etudiant "
+ "INNER JOIN filiere ON etudiant.code_f=filiere.code_f "
+ "INNER JOIN lieu_nais ON etudiant.code_lieu=lieu_nais.code_lieu "
+ "INNER JOIN montant ON etudiant.code_m=montant.code_m WHERE bac='"
+ numBac + "'";
JRDesignQuery newQuery = new JRDesignQuery();
newQuery.setText(sql);
jasperDesign.setQuery(newQuery);
JasperReport report = JasperCompileManager
.compileReport(jasperDesign);
JasperPrint print = JasperFillManager.fillReport(report, null, cnx);
JasperViewer.viewReport(print);
} catch (Exception e) {
e.printStackTrace();
} |
Partager