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
|
<%!String url = "urlBaseDonnées";
%> <%!String login = "login";
%> <%!String password = "motPasse";
%> <%!String id = "";
%> <%!Connection connection = null;
%> <%// - Connexion à la base
com.ibm.as400.access.AS400JDBCDriver monDriver = new com.ibm.as400.access.AS400JDBCDriver();
DriverManager.registerDriver(monDriver);
connection = DriverManager.getConnection(url, login, password);
// - Chargement et compilation du rapport
JasperDesign jasperDesign = JRXmlLoader
.load("c:\\jrxmls\\monJRXML.jrxml");
JasperReport jasperReport = JasperCompileManager
.compileReport(jasperDesign);
// - Paramètres à envoyer au rapport
Map parameters = new HashMap();
id = request.getParameter("representation");
out.println(id);
parameters.put("Titre", "Titre");
parameters.put("PAR1", id);
// - Execution du rapport
JasperPrint jasperPrint = JasperFillManager.fillReport(
jasperReport,parameters, connection);
// - Création du rapport au format html
java.io.OutputStream outputStream = response.getOutputStream();
net.sf.jasperreports.engine.export.JRHtmlExporter exporter = new net.sf.jasperreports.engine.export.JRHtmlExporter();
exporter
.setParameter(
net.sf.jasperreports.engine.export.JRHtmlExporterParameter.IMAGES_URI,
"image.jsp?image=");
exporter
.setParameter(
net.sf.jasperreports.engine.export.JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN,
Boolean.FALSE);
exporter
.setParameter(
net.sf.jasperreports.engine.export.JRHtmlExporterParameter.JASPER_PRINT,
jasperPrint);
exporter
.setParameter(
net.sf.jasperreports.engine.export.JRHtmlExporterParameter.OUTPUT_STREAM,
outputStream);
%> <%exporter.exportReport();
connection.close();
outputStream.close();
%> |
Partager