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)
this.doGet(request, response);
}
因為在ireport建了3個parameter,是以paramMap這裡put了3個parameter
注意:map key值要和ireport parameter name一樣.
web.xml
<servlet>
<servlet-name>IreportParameterServlet</servlet-name>
<servlet-class>com.jasper.IreportParameterServlet</servlet-class>
</servlet>
<servlet-mapping>
<url-pattern>/IreportParameterServlet</url-pattern>
</servlet-mapping>
html
<a href="IreportParameterServlet" mce_href="IreportParameterServlet">use parameter in query sql display data</a><br/>
生成pdf結果: