Struts2 + JasperReport使用一:导PDF,Excel,HTML显示
Struts2 + JasperReport应用一:导PDF,Excel,HTML显示
我的异常网推荐解决方案:The server encountered an internal error () that prevented it from fulfilling this request.,http://www..net/java-web/317.html
我用的是struts2.1.6,从struts2的自带的demo当中可以看到它的web.xml配置与之前的有点不同,有另外一种配置:
<filter> <filter-name>Struts2</filter-name> <filter-class> org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter </filter-class> </filter> <filter-mapping> <filter-name>Struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>
这样的配置可以在web.xml配置我们的serlvet,如果写成以前的写法你配置上serlvet会报错。
将我们设置的报表文件和编译文件放到WebRoot下面的jasper下面,添加struts2对jasperReport的插件。
构造我们的JavaBean如下(get,set方法省略了):
public class Person { private String person_Id; private String person_name; private String person_age; private String person_address; }
构造我们的service:
public class PersonService { public List<Person> getAllPerson() { List<Person> perList = new ArrayList<Person>(); perList.add(new Person("101", "小博", "22", "湖北")); perList.add(new Person("102", "张三", "21", "湖南")); perList.add(new Person("103", "李四", "23", "江苏")); perList.add(new Person("104", "王五", "22", "上海")); return perList; } }
构造action:
public class PersonAction extends ActionSupport { private List<Person> presonList = null; private Map<String, String> reportParameter = null; @Override public String execute() throws Exception { presonList = new PersonService().getAllPerson(); reportParameter = new HashMap<String, String>(); reportParameter.put("year", "2009"); reportParameter.put("unit_mc", "武汉XX科技有限公司"); return SUCCESS; } public String htmlView(){ return SUCCESS; } public List<Person> getPresonList() { return presonList; } public void setPresonList(List<Person> presonList) { this.presonList = presonList; } public Map<String, String> getReportParameter() { return reportParameter; } public void setReportParameter(Map<String, String> reportParameter) { this.reportParameter = reportParameter; } }
struts配置如下:
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <constant name="struts.action.extension" value="action" /> <package name="jasperReport" extends="struts-default,jasperreports-default"> <action name="PDF" class="com.mengya.action.PersonAction"> <result name="success" type="jasper"> <param name="location">/jasper/preson.jasper</param> <param name="dataSource">presonList</param> <param name="reportParameters">reportParameter</param> <param name="format">PDF</param> </result> </action> <action name="XLS" class="com.mengya.action.PersonAction"> <result name="success" type="jasper"> <param name="location">/jasper/preson.jasper</param> <param name="dataSource">presonList</param> <param name="reportParameters">reportParameter</param> <param name="format">XLS</param> </result> </action> <action name="XML" class="com.mengya.action.PersonAction"> <result name="success" type="jasper"> <param name="location">/jasper/preson.jasper</param> <param name="dataSource">presonList</param> <param name="reportParameters">reportParameter</param> <param name="format">XML</param> </result> </action> <action name="CSV" class="com.mengya.action.PersonAction"> <result name="success" type="jasper"> <param name="location">/jasper/preson.jasper</param> <param name="dataSource">presonList</param> <param name="reportParameters">reportParameter</param> <param name="format">CSV</param> </result> </action> <!-- location:是指我们刚才用iReport编译生成的jasper文件 dataSource:是指我们执行的数据库查询结果,在testAction类里把这个结果查询出来,这个参数必须要有 format:是指需要输出的类型,默认是PDF,其他的输出类型有:XML、HTML、XLS、CSV、RTF ,注意这里一定要大写 reportParameters:jasperreport中的Parameters 除了这几个参数,还有下列参数: delimiter:是指如果输出类型为CSV的话,指定分割符,默认为“,” parse:是指是否解析location参数中的EL表达式,默认为 true contentDisposition:指定disposition,默认为“inline”,如果设为“attachment”就是强制下载 documentName:输出的文件名 imageServletUrl:生成图形的路径 --> </package> </struts>
页面调用:
<a href="PDF.action">PDF</a> <a href="XLS.action">XLS</a> <a href="XML.action">XML</a> <a href="CSV.action">CSV</a>
如果要想以HTML形式显示报表内容则还需要在web.xml配置jasperReport自带的一个servlet如下:
<!-- JasperReport包中自带的Servlet,用来做为HTML形式显示报表的时候报表的图片,要在这里配置上,图片在jasperReport包中 --> <servlet> <servlet-name>JasperReportImageServlet</servlet-name> <servlet-class> net.sf.jasperreports.j2ee.servlets.ImageServlet </servlet-class> </servlet> <servlet-mapping> <servlet-name>JasperReportImageServlet</servlet-name> <url-pattern>/image</url-pattern> </servlet-mapping>
action中不需要修改,只需在struts.xml里添加一个HTML不配置如下:
<action name="HTML" class="com.mengya.action.PersonAction"> <result name="success" type="jasper"> <param name="location">/jasper/preson.jasper</param> <param name="dataSource">presonList</param> <param name="reportParameters">reportParameter</param> <param name="format">HTML</param> <param name="imageServletUrl"> <![CDATA[/image?image=]]> </param> </result> </action>
imageServletUrl的值就是上面的serlvet的路径,该servlet就是生成了一个图形,如果不配置该serlvet则页面上有图片没显示的样子。
页面调用如:
<a href="HTML.action">HTML</a>
1 楼
iejlzh
2010-08-18
谢谢你,,,正需要
2 楼
colver
2011-08-05
ireport 中建立报表是怎么样操作的? 呵呵 模仿你的做尼, 谢谢
3 楼
colver
2011-08-05
在ireport中我的引用变量reportParameter中的值都是null 这个是怎么样配置的 希望高手能指点下
4 楼
csxthui123
2011-09-21
乱码问题 怎么解决啊!?
5 楼
leesenone
2011-09-27
我用iReport-4.1.1 编译你的 preson.jrxml 文件 或者是Preview 没有报错,能显示出来。但是把生成的preson.jasper放到项目中,就会报错
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
net.sf.jasperreports.engine.JRRuntimeException: Unknown hyperlink target 0
net.sf.jasperreports.engine.JRHyperlinkHelper.getLinkTarget(JRHyperlinkHelper.java:273)
net.sf.jasperreports.engine.base.JRBaseTextField.normalizeLinkTarget(JRBaseTextField.java:317)
net.sf.jasperreports.engine.base.JRBaseTextField.readObject(JRBaseTextField.java:381)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1848)
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
java.util.ArrayList.readObject(ArrayList.java:593)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
如果用你的preson.jasper 文件能够正常运行。何解???
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
net.sf.jasperreports.engine.JRRuntimeException: Unknown hyperlink target 0
net.sf.jasperreports.engine.JRHyperlinkHelper.getLinkTarget(JRHyperlinkHelper.java:273)
net.sf.jasperreports.engine.base.JRBaseTextField.normalizeLinkTarget(JRBaseTextField.java:317)
net.sf.jasperreports.engine.base.JRBaseTextField.readObject(JRBaseTextField.java:381)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1848)
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
java.util.ArrayList.readObject(ArrayList.java:593)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
如果用你的preson.jasper 文件能够正常运行。何解???
6 楼
leesenone
2011-09-27
能不能把你怎么制作preson.jrxml 和preson.jasper 截给图显示出来,用最新的iReport 谢谢了。我现在就是生成文件这块总是出问题,编译能显示表格什么的,空数据的情况下。但是放在项目中就不能用了。
我的异常网推荐解决方案:The server encountered an internal error () that prevented it from fulfilling this request.,http://www..net/java-web/317.html