| 12
 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