<html><title>Purchase Reports</title>
<body bgcolor="#C6ECFF">
<strong>Jasper Report</strong>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%@ page import="net.sf.jasperreports.j2ee.servlets.*" %>
<%@ page import="net.sf.jasperreports.engine.util.JRProperties" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.* , net.sf.jasperreports.engine.base.JRBasePrintImage"%>
<%@ page import="net.sf.jasperreports.engine.base.JRBasePrintLine, net.sf.jasperreports.engine.base.JRBasePrintPage,
net.sf.jasperreports.engine.export.JRPrintServiceExporter,
net.sf.jasperreports.engine.export.JRPrintServiceExporterParameter,
net.sf.jasperreports.engine.util.JRLoader,net.sf.jasperreports.engine.util.JRSaver, javax.print.attribute.HashPrintRequestAttributeSet,
javax.print.attribute.HashPrintServiceAttributeSet,
javax.print.attribute.PrintRequestAttributeSet,
javax.print.attribute.PrintServiceAttributeSet,
javax.print.attribute.standard.MediaSizeName,net.sf.jasperreports.engine.util.JRSaver ,java.text.SimpleDateFormat, java.util.Date"%>
<%@ page import="com.lowagie.text.*"%>
<%@ page import="com.lowagie.text.pdf.PdfWriter"%>
<%@ page import="com.lowagie.text.pdf.BaseFont"%>
<%@ page import="com.lowagie.text.pdf.PdfContentByte"%>
<% Class.forName("com.mysql.jdbc.Driver");
Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename", "username", "password");
JasperCompileManager.compileReportToFile(application.getRealPath("/jrxml/jrxmlfile.jrxml"));
File reportFile = new File(application.getRealPath("/jrxml/jrxmlfile.jasper"));
if (!reportFile.exists())
throw new JRRuntimeException("File bookreturn.jrxml not found. The report design must be compiled first.");
JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath());
Map parameters = new HashMap();
parameters.put("ReportTitle", "Address Report");
parameters.put("BaseDir", reportFile.getParentFile());
JasperPrint jasperPrint =JasperFillManager.fillReport(jasperReport,parameters, con);
JRPdfExporter exporter = new JRPdfExporter();
StringBuffer sbuffer = new StringBuffer();
File destFile = new File(reportFile.getParent(), jasperPrint.getName() + ".pdf");
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE, destFile);
exporter.setParameter(JRPdfExporterParameter.IS_ENCRYPTED, Boolean.TRUE);
exporter.setParameter(JRPdfExporterParameter.IS_128_BIT_KEY, Boolean.TRUE);
exporter.setParameter(JRPdfExporterParameter.IS_COMPRESSED , Boolean.TRUE);
//exporter.setParameter(JRPdfExporterParameter.USER_PASSWORD, "jasper");
//exporter.setParameter(JRPdfExporterParameter.OWNER_PASSWORD, "reports");
exporter.setParameter(JRPdfExporterParameter.PERMISSIONS,new Integer(PdfWriter.AllowCopy | PdfWriter.AllowPrinting));
exporter.exportReport();
%>
<jsp:forward page="../../jrxml1/jrxmlfile.pdf"/>
</body>
</html>
No comments:
Post a Comment