iReport

iReport小絮
有iReport工具包
JSP
<form name="myform" month="post" action="printfb73.jsp">

查询界面 设计
开始日期：**
结束日期：**
提交按钮

printfb73.jsp
<%
//获取参数
Map parameters=new HashMap();
String startmonth=request.getParameter("startMonth");
String endmonth=request.getParameter("endMonth");
parameters.put("startmonth",startmonth);
parameters.put("endmonth",endmonth);
String url2="d:/jf/djbxt/dg/fb74.jasper";  //调用iReport 生成的 文件

Connection conn=new DBconnect().getConectionByJdbc();

System.out.println(url2);
File exe_rpt=new File(url2);

try{
	JasperPrint jasperPrint=JasperFillManager.fillReport(exe_rpt.getPath(),parameters,conn);//parameters,conn
	ByteArrayOutputStream oStream=new ByteArrayOutputStream();
	JRXlsExporter exporter=new JRXlsExporter();
	exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
	exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,oStream);
	exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING,"GBK");
	exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);
    exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);
    exporter.exportReport();
    byte[] bytes=oStream.toByteArray();
    if(bytes !=null && bytes.length>0 )
    {
    	response.reset();
    	response.setContentType("application/vnd.ms-excel");
    	response.setContentLength(bytes.length);
    	ServletOutputStream ouputStream = response.getOutputStream();
        ouputStream.write(bytes,0,bytes.length);
        ouputStream.flush();
        ouputStream.close();
    }else{
    	out.print("bytes were null");
    }
}catch(JRException ex)
{
	System.out.println(ex.toString());
}
finally
{
	try
	{
		if(conn!=null)
			conn.close();
	}
	catch(Exception ex)
	{
		ex.printStackTrace();
	}
}
%>
其余的工作就是用iReport工具 画图，然后写sql语句和传参了

评论

1 楼 chauncey24 2011-12-02  

尼玛，大半夜的，我搜ireport进你空间了，头像吓死了。