1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
public void genere(){
try{
String xmlFile = "D:\\1-LICENCE\\Logiciel\\MAGAZINE\\magazine\\mag.jrxml";
String jasperFile = "D:\\1-LICENCE\\Logiciel\\MAGAZINE\\magazine\\magazine.jasper";
String pdfFile = "D:\\1-LICENCE\\Logiciel\\MAGAZINE\\magazine\\magazine.pdf";
JasperDesign jasperDesign = JRXmlLoader
.load(xmlFile);
String sql = "SELECT "
+ "article.n_article AS article_n_article,article.titre AS article_titre,"
+ "article.article AS article_article,article.image AS article_image,"
+ "article.code_domaine_domaine AS article_code_domaine_domaine,"
+ "article.num_mag_magazine AS article_num_mag_magazine,"
+ "article.matricule_auteur AS article_matricule_auteur,"
+ "auteur.matricule AS auteur_matricule,auteur.nom AS auteur_nom,"
+ "domaine.code_domaine AS domaine_code_domaine,domaine.nom_domaine AS domaine_nom_domaine,"
+ "magazine.num_mag AS magazine_num_mag,magazine.date_mag AS magazine_date_mag"
+ " FROM article "
+ "INNER JOIN auteur ON article.matricule_auteur=auteur.matricule "
+ "INNER JOIN domaine ON article.code_domaine_domaine=domaine.code_domaine "
+ "INNER JOIN magazine ON article.num_mag_magazine=magazine.num_mag WHERE num_mag_magazine='"
+ cmbMag.getSelectedItem().toString()+"'";
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,false);
//JasperExportManager.exportReportToPdfFile(print, pdfFile);
}catch(Exception e){
Logger.getLogger(Generator.class.getName()).log(Level.SEVERE, null, e);
}
} |
Partager