在JasperReports中使用hibernate的查询的步骤 _ 路由器设置|192.168.1.1|无线路由器设置|192.168.0.1

在JasperReports中使用hibernate的查询的步骤

JasperReports 从1.2.0以后的版本开始支持一些其它的查询的实现，如HQL和XPath，在此文中将介绍HQL在JasperReports中的应用。

1.要在报表中使用HQL，当然得将hibernate的一些包将入到你的类路径中，并且有相应的hbm.xml映射文件。

2.在设计报表时，可以直接将你的HQL写在报表模板文件中，注意有以下不同（红色字）

<?xml version="1.0"?>

<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd" [

<!ENTITY reportStyles SYSTEM "./ReportStyles.ent">

<jasperReport

name="AddressesReport"

pageWidth="595"

pageHeight="842"

columnWidth="515"

columnSpacing="0"

leftMargin="40"

rightMargin="40"

topMargin="50"

bottomMargin="50"

whenNoDataType="AllSectionsNoDetail"

isTitleNewPage="false"

isSummaryNewPage="false">

<![CDATA[

select address as address, document.id as documentId, document.total as documentTotal

from Address as address join address.documents as document

where city not in ($P{CityFilter})

order by address.city, address.lastName, address.firstName, address.id]]>

</queryString>

<fieldDescription>address.id</fieldDescription>

</field>

<fieldDescription>address.firstName</fieldDescription>

</field>

<fieldDescription>address.lastName</fieldDescription>

</field>

<fieldDescription>address.street</fieldDescription>

</field>

<fieldDescription>address.city</fieldDescription>

</field>

<variableExpression>$F{documentTotal}</variableExpression>

</variable>

$F{id}

</groupExpression>

<frame>

$F{firstName} + " " + $F{lastName} + " (ID: " + $F{id} + ")"

</textFieldExpression>

</textField>

$F{street} + "," + $F{city}

</textFieldExpression>

</textField>

</frame>

</band>

</groupHeader>

<line>

</line>

<text>Total</text>

</staticText>

$V{AddressGroup_COUNT}

</textFieldExpression>

</textField>

$V{addressTotal}

</textFieldExpression>

</textField>

</band>

</groupFooter>

</group>

<title>

<line>

</line>

</textElement>

<textFieldExpression class="java.lang.String">$P{ReportTitle}</textFieldExpression>

</textField>

</band>

</title>

<text>Document ID</text>

</staticText>

$F{documentId}

</textFieldExpression>

</textField>

<text>Document Total</text>

</staticText>

$F{documentTotal}

</textFieldExpression>

</textField>

</band>

</detail>

<printWhenExpression>$P{IS_IGNORE_PAGINATION}.booleanValue()?Boolean.FALSE:Boolean.TRUE</printWhenExpression>

<line>

</line>

"Page " + String.valueOf($V{PAGE_NUMBER}) + " of"

</textFieldExpression>

</textField>

" " + String.valueOf($V{PAGE_NUMBER})

</textFieldExpression>

</textField>

</band>

</pageFooter>

</jasperReport>

填充报表

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();

Session session = sessionFactory.openSession()

Transaction transaction = session.beginTransaction();

//报表参数

Map parameters = new HashMap();

parameters.put(JRHibernateQueryExecuterFactory.PARAMETER_HIBERNATE_SESSION, session);

parameters.put("ReportTitle", "Address Report");

List cityFilter = new ArrayList(3);

cityFilter.add("Boston");

cityFilter.add("Chicago");

cityFilter.add("Oslo");

parameters.put("CityFilter", cityFilter);

parameters.put("OrderClause", "city");

for(int i = 0; i < reportNames.length; i++)

{

long start = System.currentTimeMillis();

JasperFillManager.fillReportToFile(reportNames[i] + ".jasper", params);

System.err.println("Report : " + reportNames[i] + ". Filling time : " + (System.currentTimeMillis() - start));

}

transaction.rollback();

session.close();

本文地址：http://www.45fan.com/a/question/69984.html

MySQL与Mongo简单的查询实例代码的详细介	公交车“吻上”兰博基尼豪车未查询到保
在mysql中查询两个日期之间最大的连续登	SQL分页查询方式有哪些？
怎么样在PHP库中查询Mongodb中的文档ID？	怎么样优化Mysql Limit分页查询？
如何在SQL中查询数据库中符合条件的记录	如何使用Python实现Sqlite将字段当做索引
查询Oracle中正在执行和执行过的SQL语句	SQL Server树形表非循环递归查询的实例的

45fan.com - 路饭网

在JasperReports中使用hibernate的查询的步骤

Tags：查询 hibernate Jasperreports

45fan.com - 路饭网

在JasperReports中使用hibernate的查询的步骤

Tags： 查询 hibernate Jasperreports

Tags：查询 hibernate Jasperreports