petreport.jrxml

Jasper Report 报表。用iReport的Nebeans插件制作。包括调用方法。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD JasperReport//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<parameter name="MIN_ID" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="MAX_ID" class="java.lang.Integer" isForPrompting="false"/>
	<queryString language="SQL">
		<![CDATA[SELECT
     PETS."ID" AS ID,
     PETS."NAME" AS NAME,
     PETS."SEX" AS SEX,
     PETS."BIRTHDATE" AS BIRTHDATE,
     PETS."ADOPTIONDATE" AS ADOPTIONDATE,
     PETS."BREED" AS BREED,
     PETS."COLOR" AS COLOR,
     PETS."BREEDERNAME" AS BREEDERNAME,
     PETS."FAVORITEFOOD" AS FAVORITEFOOD,
     PETS."FAVORITETOY" AS FAVORITETOY,
     PETS."LICENSETAGNUMBER" AS LICENSETAGNUMBER,
     PETS."RABIESTAGNUMBER" AS RABIESTAGNUMBER,
     PETS."MICROCHIPID" AS MICROCHIPID,
     PETS."FOODBRAND" AS FOODBRAND,
     PETS."PORTIONSIZE" AS PORTIONSIZE,
     PETS."SERVINGTIMES" AS SERVINGTIMES,
     PETS."SNACKS" AS SNACKS,
     PETS."DIETARYEXCLUSIONS" AS DIETARYEXCLUSIONS,
     PETS."FILEFOLDER" AS FILEFOLDER,
     PETS."PICFILENAME" AS PICFILENAME,
     PETS."PETTYPE" AS PETTYPE
FROM
     "APP"."PETS" PETS
     WHERE
          id >= $P{MIN_ID}
 AND id <= $P{MAX_ID}
ORDER BY
     PETS."ID" ASC]]>
	</queryString>
	<field name="ID" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="NAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SEX" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="BIRTHDATE" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="ADOPTIONDATE" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="BREED" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="COLOR" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="BREEDERNAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FAVORITEFOOD" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FAVORITETOY" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="LICENSETAGNUMBER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="RABIESTAGNUMBER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="MICROCHIPID" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FOODBRAND" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PORTIONSIZE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SERVINGTIMES" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SNACKS" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DIETARYEXCLUSIONS" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FILEFOLDER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PICFILENAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PETTYPE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<group name="PETTYPE" isStartNewPage="true">
		<groupExpression><![CDATA[$F{PETTYPE}]]></groupExpression>
		<groupHeader>
			<band height="27">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="102" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement textAlignment="Right">
						<font size="18"/>
					</textElement>
					<text><![CDATA[PET TYPE: ]]></text>
				</staticText>
				<textField hyperlinkType="None">
					<reportElement mode="Opaque" x="102" y="0" width="453" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement>
						<font size="18" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PETTYPE}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="8">
				<line direction="BottomUp">
					<reportElement key="line" x="1" y="4" width="554" height="4"/>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band/>
	</background>
	<title>
		<band height="58">
			<line>
				<reportElement x="0" y="8" width="555" height="1"/>
			</line>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="51" width="555" height="1"/>
			</line>
			<staticText>
				<reportElement x="65" y="13" width="424" height="35"/>
				<textElement textAlignment="Center">
					<font size="22" isBold="true"/>
				</textElement>
				<text><![CDATA[Pet's Basic Data Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band/>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="658" isSplitAllowed="false">
			<staticText>
				<reportElement x="0" y="254" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[ID: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="257" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ID}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="274" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[NAME: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="277" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="294" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[SEX: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="297" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SEX}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="314" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[BIRTH DATE: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="317" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{BIRTHDATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="334" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[ADOPTION DATE: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="337" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{ADOPTIONDATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="354" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[BREED: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="357" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BREED}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="374" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[COLOR: ]]></text>
			</staticText>