http://blog.csdn.net/young_smile/article/details/6306858
http://www.packtpub.com/article/graphical-report-design-with-ireport-part1
开始本文之前建议先看过java ireport jasperreport 配套使用(一/二)
在ireport中parameter有几种用法:
1,使用在select sql中,作为查询条件.这种使用较多;
2,单纯在report中显示,例如生成报表的人名字.
ireport parameters有写内置的parameter(built-in),其值具体是什么,你可以将其拖拽到report上,preview生成报表看看.
本将进行如下操作:
将scott模式下 emp表中在deptno为30的emp选出来,并在报表尾部显示生成时间和报表作者.
1,准备parameters
如下图:
2,准备select sql 语句
- select * from emp e join dept d
- on e.deptno=d.deptno
- where e.deptno=$P{deptno}
如下图:
$P{deptno}为ireport中表达式的语法.
在ireport写query sql语句时如果要引用parameter,要使用格式$P{param_name};
在Text控件引用field,使用$F{field_name},引用variables,使用$V{var_name}.
3,编辑report
1). 将field ename,dname,job,hiredate,sal 拖拽到details band区域;
2). 在column header band区域为每个field添加列名;
3). 在page header band 区域添加一个Text Field控件,"All Employees in "+$F{DNAME}+" Department"
4). 在page footer band 区域添加 Generated by $P{reportor] on $P{Time}
如下图:
4,最后别忘了修改 report properties:
report language:Java,
when no data:all sections,no detail
5,preview 预览报表.
ireport 3 preview
打开report创建目录,两个文件:
ireport_parameters.jasper
ireport_parameters.jrxml
将其拷贝到com.jasper.report包下.
开始Java代码调用部分.
Servlet(IreportParameterServlet.java)
- package com.jasper;
- import java.io.IOException;
- import java.sql.Connection;
- import java.text.SimpleDateFormat;
- import java.util.Date;
- import java.util.HashMap;
- import java.util.Map;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import com.jasper.connection.JDBCUtils;
- public class IreportParameterServlet extends HttpServlet {
- private static final long serialVersionUID = 1L;
- public void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- Map<String, String> paramMap = new HashMap<String, String>();
- paramMap.put("reportor", "Young Huijun");
- paramMap.put("deptno", "30");
- paramMap.put("generateTime", new SimpleDateFormat("yyyy-MM-dd").format( new Date()));
- Connection conn = JDBCUtils.getInstance().getLocalConnection();
- ReportGenerator generator = new ReportGenerator();
- generator.PDFGenerator(response, "ireport_parameters.jasper", paramMap, conn);
- }
- public void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- this.doGet(request, response);
- }
- }
因为在ireport建了3个parameter,所以paramMap这里put了3个parameter
注意:map key值要和ireport parameter name一样.
ReportGenerator类请参考java ireport jasperreport 配套使用(二)
web.xml
- <servlet>
- <servlet-name>IreportParameterServlet</servlet-name>
- <servlet-class>com.jasper.IreportParameterServlet</servlet-class>
- </servlet>
- <servlet-mapping>
- <servlet-name>IreportParameterServlet</servlet-name>
- <url-pattern>/IreportParameterServlet</url-pattern>
- </servlet-mapping>
html
- <a href="IreportParameterServlet" mce_href="IreportParameterServlet">use parameter in query sql display data</a><br/>
生成pdf结果:
