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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
|
import java.io.File;
import java.io.IOException;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Map;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.view.JasperViewer;
public class inserer {
public inserer() {
}
public String sortie() throws InstantiationException, IllegalAccessException, ClassNotFoundException, JRException, IOException{
try {
ResultSet res3=null;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String serverName = "localhost";
String mydatabase = "test";
String url = "jdbc:mysql://" + serverName + "/" + mydatabase; // a JDBC url
String user = "root";
String pass = "test";
java.sql.Connection connection = DriverManager.getConnection(url, user, pass);
Statement instruction = ((java.sql.Connection) connection).createStatement();
JasperDesign jDesign = JRXmlLoader.load("C:\\Users\\Mustapha\\workspace\\stage\\WebContent\\1.jrxml");
JasperReport jReport = JasperCompileManager.compileReport(jDesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jReport, null, connection);
byte[] bytes = JasperExportManager.exportReportToPdf(jasperPrint);
FacesContext context = FacesContext.getCurrentInstance();
HttpServletResponse response = (HttpServletResponse) context
.getExternalContext().getResponse();
/***********************************************************************
* Pour afficher une boîte de dialogue pour enregistrer le fichier sous
* le nom rapport.pdf
**********************************************************************/
response.addHeader("Content-disposition","attachment;filename=rapport.pdf");
response.setContentLength(bytes.length);
response.getOutputStream().write(bytes);
response.setContentType("application/pdf");
context.responseComplete();
System.out.println("rachid");
} catch (SQLException e) {
e.printStackTrace();
}
return "retour";
}
} |
Partager