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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
import java.io.IOException;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.faces.context.FacesContext;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import com.lowagie.text.pdf.codec.Base64.OutputStream;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporterParameter;
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.export.JRPdfExporter;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
public class imprimer {
public imprimer() {
// TODO Auto-generated constructor stub
}
public String impri() throws InstantiationException, IllegalAccessException, ClassNotFoundException, JRException, IOException{
try {
// Load the JDBC driver
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 = "musta1";
java.sql.Connection connection = DriverManager.getConnection(url, user, pass);
Statement instruction = ((java.sql.Connection) connection).createStatement();
JasperDesign jDesign = JRXmlLoader.load("C:\\Users\\Mustapha\\workspace\\mustapha\\WebContent\\1.jrxml");
JasperReport jReport = JasperCompileManager.compileReport(jDesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jReport, null, connection);
FacesContext facesContext = FacesContext.getCurrentInstance() ;
facesContext.getExternalContext().getResponse();
HttpServletResponse response1 = (HttpServletResponse)facesContext.getExternalContext().getResponse();
// Set response content type
response1.setContentType("application/pdf");
facesContext.responseComplete();
// Create and export PDF to browser window
JRPdfExporter exporter = new JRPdfExporter();
System.out.println("salut97");
exporter.setParameter(
JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response1.getOutputStream());
exporter.exportReport();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
// JasperExportManager.exportReportToPdfFile(jasperPrint, "C://mustapha.pdf");
//JasperViewer.viewReport(jasperPrint,false);
}return "retour";
}
} |
inserer une page dans une autre page
Répondre avec citation
Envoyé par mr1azl
Partager