JasperReport 与iReport 的配置与使用

{ String

reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));

ss1=sql1.Gettongji6_10kvSql(reportsql); }else{ String

reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));

ss1=sql1.Get6_10kvSql(reportsql); }

pdfname=\;

}else if(filepath.equals(bean.getEnglishname(jlflbh)+\)) { String

reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));

ss1=sql1.Getautomaketablesql(reportsql,jlflbh); String titlename=bean.getTitlename(jlflbh);

if(!reportFile.exists() && !bean.getEnglishname(jlflbh).equals(\)) {

System.setProperty(

System.setProperty( }

parameters.put(\,titlename); pdfname=bean.getEnglishname(jlflbh); }

parameters.put(\,ss1); JasperPrint jasperPrint =

JasperFillManager.fillReport(reportFile.getPath(), parameters, con); JRExporter exporter = null;

String exportTo =\;//request.getParameter(\ if(\.equals(exportTo)) {

\, application.getRealPath(\) );

\,

application.getRealPath(\) + System.getProperty(\) + application.getRealPath(\) );

com.paiao.bdpm.system.NoXmlDesignApp.run(reportFile.getPath(),jlflbh);

exporter = new JRHtmlExporter();

exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE); }

else if(\.equals(exportTo))//PDF方式打印 {

exporter = new JRPdfExporter();

response.setContentType(\);

response.setHeader(\,\filename=\+pdfname+\); }

else if(\.equals(exportTo)) {

// exporter = new JRXlsExporter();

response.setContentType(\);

}else if(\.equals(exportTo)) {

//exporter =new JRRtfExporter();

response.setContentType(\);

response.setHeader(\,\filename=\+jasperPrint.getName()+\);

}

else if(\.equals(exportTo)){ response.reset();

// exporter = new JRXlsExporter();

response.setContentType(\); response.setHeader(\,\filename=\+pdfname+\); }

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, \);

exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream()); exporter.exportReport();

}catch(Exception e){ e.printStackTrace(); }finally{

dbbase.freeconnection(con); }

%>

*******************************************************************************

*************************处理自动创建JASPER文件的BEAN********************* package com.paiao.bdpm.system;

import net.sf.jasperreports.engine.*; import net.sf.jasperreports.engine.data.*; import net.sf.jasperreports.engine.design.*; import net.sf.jasperreports.engine.export.*; import net.sf.jasperreports.engine.util.*; import java.sql.*; import java.awt.*; import java.util.*; import java.io.*;

import com.paiao.app.util.ColumnList;

import com.paiao.app.util.ColumnStructure; /**

* @version $Id: NoXmlDesignApp.java,v 1.10 2005/09/26 05:47:37 lihui Exp $ */

public class NoXmlDesignApp { private static final String TASK_COMPILE = \

String taskName = \try {

long start = System.currentTimeMillis();

if (TASK_COMPILE.equals(taskName) && !filePath.equals(\

NoXmlDesignApp design = new NoXmlDesignApp(); JasperDesign jasperDesign = design.getJasperDesign(jlflbh); JasperCompileManager

.compileReportToFile(jasperDesign, filePath);

System.err.println(\

private static final String TASK_WRITE_XML = \

public static void run(String filePath, String jlflbh) { // filePath = // \李辉工作夹\\\\pmproject\\\\coding\\\\defaultroot\\\\reports\\\\test1.jasper\

+ (System.currentTimeMillis() - start));

} else if (TASK_WRITE_XML.equals(taskName)) { JasperCompileManager.writeReportToXmlFile(filePath);

}

System.err.println(\

+ (System.currentTimeMillis() - start)); }

} catch (JRException e) { e.printStackTrace(); } catch (Exception e) { }

e.printStackTrace();

private JasperDesign getJasperDesign(String jlflbh) throws JRException {

Reportjiexiguize bean = new Reportjiexiguize();

ColumnList list = bean.getTableCloumnName(jlflbh); int counttext = 0;

for (int i = 0; i < list.size(); i++) { }

int TextWidth = ((760 - 88) / list.size() - 8) + 40; int ptwidth = 0;

if (list.size() != counttext) { ptwidth = (760 - 96 - TextWidth * counttext) }

/ (list.size() - counttext);

ColumnStructure cloumn = list.get(i);

if (cloumn.getDataType().equalsIgnoreCase(\ System.out.println(\ }

counttext++;

// JasperDesign

JasperDesign jasperDesign = new JasperDesign(); jasperDesign.setName(\jasperDesign.setPageWidth(840); jasperDesign.setPageHeight(842); jasperDesign.setColumnWidth(515); jasperDesign.setColumnSpacing(0); jasperDesign.setLeftMargin(40); jasperDesign.setRightMargin(40); jasperDesign.setTopMargin(50); jasperDesign.setBottomMargin(50); // 自定义Fonts用于列名处的

JRDesignReportFont normalFont = new JRDesignReportFont(); normalFont.setName(\