使用Jasperreporter生成入库出库单打印等报表操作

项目需要打印报表：就是那种生成入库单，出库单等的操作。使用到的技术：使用iReport Designer5.1.0设计报表，使用struts2+jasperreporter生成最终填充数据的报表

首先看一下效果图

一、使用iReport Designer 设计报表

　　1、安装iReport Designer，过程比较简单。需要强调一下，5.1.0版本不支持jdk8，我又重新装了jdk7.然后在iReport-5.1.0\etc\ireport.conf下配置一下jdkhome，如下图所示为我的配置截图

使用Jasperreporter生成入库出库单打印等报表操作

　　2、打开iReport后，可以设置一下存储文件的位置,在工具->选项->Compilation and execution 中配置Compilation directory和Virtualizer中的Directory where the paged out data is to be stored为自定义路径。

使用Jasperreporter生成入库出库单打印等报表操作

　　3、创建一个新的空白报表，并添加相关元素。如下右侧为组件面板，通过其中的Static Text，Text Field，Line等设计出简单的报表

使用Jasperreporter生成入库出库单打印等报表操作

如下所示为xml源码：

<?xml version="1.0" encoding="UTF-8"?>

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="OutputReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5d594fbe-e7f6-4ee9-a586-8394b1a91bef">

    <property name="ireport.zoom" value="1.6500000000000001"/>

    <property name="ireport.x" value="0"/>

    <property name="ireport.y" value="0"/>

    <parameter name="id" class="java.lang.String"/>

    <parameter name="outputtime" class="java.util.Date"/>

    <parameter name="operator" class="java.lang.String"/>

    <field name="materialid" class="java.lang.String"/>

    <field name="materialname" class="java.lang.String"/>

    <field name="assetno" class="java.lang.String"/>

    <field name="category" class="java.lang.String"/>

    <field name="model" class="java.lang.String"/>

    <field name="specification" class="java.lang.String"/>

    <field name="unit" class="java.lang.String"/>

    <field name="amount" class="java.lang.String"/>

    <background>

        <band splitType="Stretch"/>

    </background>

    <title>

        <band height="59" splitType="Stretch">

            <staticText>

                <reportElement uuid="9e2e3b53-c9bc-49aa-a4a0-cbcc212b1290" x="193" y="4" width="142" height="32" forecolor="#CC3300"/>

                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">

                    <font fontName="SansSerif" size="18" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>

                </textElement>

                <text><![CDATA[XXX单位出库单]]></text>

            </staticText>

            <line>

                <reportElement uuid="954d8309-d574-469f-8d60-27520f6067ed" x="0" y="46" width="555" height="1"/>

                <graphicElement>

                    <pen lineWidth="5.0"/>

                </graphicElement>

            </line>

        </band>

    </title>

    <pageHeader>

        <band height="31" splitType="Stretch">

            <textField isBlankWhenNull="true">

                <reportElement uuid="1f85a2a7-7cde-4e3a-b485-78700edbc1bb" x="86" y="0" width="130" height="20"/>

                <textElement textAlignment="Left" verticalAlignment="Middle"/>

                <textFieldExpression><![CDATA[$P{id}]]></textFieldExpression>

            </textField>

            <staticText>

                <reportElement uuid="43abcb33-52d3-4ecc-ae8b-1458a5577f59" x="216" y="0" width="64" height="20"/>

                <textElement textAlignment="Center" verticalAlignment="Middle"/>

                <text><![CDATA[出库时间：]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="155052e3-f990-409b-86d1-eaeb1ae65cf1" x="391" y="0" width="64" height="20"/>

                <textElement textAlignment="Center" verticalAlignment="Middle"/>

                <text><![CDATA[操作人员：]]></text>

            </staticText>

            <textField isBlankWhenNull="true">

                <reportElement uuid="1f2ef840-d135-438d-9975-51e6f2856751" x="455" y="0" width="100" height="20"/>

                <textElement verticalAlignment="Middle"/>

                <textFieldExpression><![CDATA[$P{operator}]]></textFieldExpression>

            </textField>

            <staticText>

                <reportElement uuid="cf5353cd-1f0d-4d53-bb56-89c1842f26f4" x="0" y="0" width="86" height="20"/>

                <textElement textAlignment="Center" verticalAlignment="Middle"/>

                <text><![CDATA[出库单号：]]></text>

            </staticText>

            <textField isBlankWhenNull="true">

                <reportElement uuid="e22b2fbe-dc33-4f6c-b302-97d0d34d21c9" x="280" y="0" width="111" height="20"/>

                <textElement verticalAlignment="Middle"/>

                <textFieldExpression><![CDATA[$P{outputtime}]]></textFieldExpression>

            </textField>

            <line>

                <reportElement uuid="28bfcbc5-d841-4cd1-825a-b182740f8785" x="0" y="27" width="555" height="1"/>

            </line>

        </band>

    </pageHeader>

    <columnHeader>

        <band height="61" splitType="Stretch">

            <staticText>

                <reportElement uuid="7081f40d-6df7-475c-ba7d-b5edb2d8f0b1" mode="Transparent" x="165" y="7" width="76" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[资产编号]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="fdd65f3d-3b51-4b5b-8153-e085a30237d8" mode="Transparent" x="471" y="7" width="62" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[出库数量]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="a0568192-b022-4d4a-aa74-7930e6fac339" mode="Transparent" x="2" y="7" width="98" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[物资编号]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="620a6747-442b-42ce-9765-50240120458f" mode="Transparent" x="100" y="7" width="65" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[物资名称]]></text>

            </staticText>

            <line>

                <reportElement uuid="edd268c2-e05a-4afb-a08d-deaefbabd499" x="0" y="55" width="555" height="1"/>

                <graphicElement>

                    <pen lineWidth="2.0" lineStyle="Double"/>

                </graphicElement>

            </line>

            <line>

                <reportElement uuid="c29f438c-54dd-448d-a49f-aadede5719ee" x="0" y="3" width="555" height="1"/>

                <graphicElement>

                    <pen lineWidth="2.0" lineStyle="Double"/>

                </graphicElement>

            </line>

            <staticText>

                <reportElement uuid="995f7687-471d-413e-9400-4335f54c4bfd" mode="Transparent" x="241" y="7" width="76" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[物资类型]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="a90e0bb0-9b7c-4a94-b6cc-0a3d24c79e59" mode="Transparent" x="317" y="7" width="45" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[型号]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="189b7d59-df3a-4f07-a3d3-c2da2ca478e9" mode="Transparent" x="362" y="7" width="47" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[规格]]></text>

            </staticText>

            <staticText>

                <reportElement uuid="3f3c3bd0-81d5-4e97-a088-5396605f62c4" mode="Transparent" x="409" y="7" width="62" height="44" forecolor="#000000" backcolor="#CFFFCC"/>

                <textElement verticalAlignment="Middle"/>

                <text><![CDATA[单位]]></text>

            </staticText>

        </band>

    </columnHeader>

    <detail>

        <band height="35" splitType="Stretch">

            <textField isBlankWhenNull="true">

                <reportElement uuid="6bbf81e8-5f85-4f01-839b-2fdeeae82fb8" x="0" y="4" width="98" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{materialid}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="56fcdc7d-8baa-486c-9c44-e9a6c5c47be3" x="100" y="4" width="65" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{materialname}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="778d0943-5fc2-402e-8a57-f1ff92d1d2b0" x="165" y="4" width="76" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{assetno}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="f2b8e55c-ecf8-4477-a361-14fcd03ca704" x="241" y="4" width="76" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{category}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="08d6ec09-9bf7-4eac-aa1e-f0ac71b5ec8b" x="317" y="4" width="45" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{model}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="83613e2b-2cd6-4e3e-acfd-dee02601c3f0" x="362" y="4" width="47" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{specification}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="0cba1ef6-27d7-4e78-a6a7-6cc9bf6f6e39" x="409" y="4" width="62" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{unit}]]></textFieldExpression>

            </textField>

            <textField isBlankWhenNull="true">

                <reportElement uuid="b23218d6-7bce-4208-bffc-f6743481b9e9" x="471" y="4" width="62" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[$F{amount}]]></textFieldExpression>

            </textField>

        </band>

    </detail>

    <columnFooter>

        <band height="30" splitType="Stretch"/>

    </columnFooter>

    <pageFooter>

        <band height="27" splitType="Stretch">

            <staticText>

                <reportElement uuid="710ece90-d059-493b-ae83-b0d6d9d036cf" x="391" y="3" width="64" height="20"/>

                <textElement/>

                <text><![CDATA[生成时间：]]></text>

            </staticText>

            <textField pattern="EEEEE dd MMMMM yyyy">

                <reportElement uuid="992f84e2-197f-4064-ade0-78c22f75dcbc" x="455" y="3" width="100" height="20"/>

                <textElement/>

                <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>

            </textField>

        </band>

    </pageFooter>

    <summary>

        <band height="42" splitType="Stretch"/>

    </summary>

</jasperReport>

　　4、编译文件为japer格式的文件，用于程序中使用:右键项目Compile Report 生成相应的文件，如下所示。

使用Jasperreporter生成入库出库单打印等报表操作

二、在Struts2中使用上述的jasper文件填充数据生成报表

　　1、需要在项目中添加jar包，如下所示

使用Jasperreporter生成入库出库单打印等报表操作

　　2、编写action文件，我在项目中使用全注解方式配置jasperreporter。重点是（1）、ParentPackage为jasperreports-default。（2）、我使用从程序中获取数据然后填充到jasper文件而不是直接绑定到数据库数据的。所以定义了如下的list和params，分别用于填充$F{}和$P{}。

List list;

HashMap params;

（3）、最重要的是在方法上的@Aciton配置

 @Action(value = "outputOrder", results = { @Result(name = "outputOrder", type = "jasper", params = {

            "location", "/jasper/OutputReport.jasper", "format", "HTML",

            "dataSource", "list", "reportParameters", "params",

            "imageServletUrl", "/servlets/image?image=", "contentDisposition",

            "inline" }) })

其中type为jasper，定义的params中，location表示使用的jasper文件的位置，format表示输出文件的格式为HTML，datasource表示填充的循环的数据$F{...}，reportParmeters为填充数据$P{...}。最后的imageServletUrl
是用来填充网页中的空白的，否则会出现好多的叉叉。 具体需要在web.xml中配置如下的servlet，这是struts2-jasperreports-plugin-2.3.16.1.jar中自带的。

<servlet>

        <servlet-name>ImageServlet</servlet-name>

        <servlet-class>net.sf.jasperreports.j2ee.servlets.ImageServlet</servlet-class>

    </servlet>

    <servlet-mapping>

        <servlet-name>ImageServlet</servlet-name>

        <url-pattern>/servlets/image</url-pattern>

    </servlet-mapping>

最后附上struts2的action实现源代码如下：

package action.japser;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import javax.annotation.Resource;

import org.apache.struts2.convention.annotation.Action;

import org.apache.struts2.convention.annotation.Namespace;

import org.apache.struts2.convention.annotation.ParentPackage;

import org.apache.struts2.convention.annotation.Result;

import org.springframework.stereotype.Controller;

import com.opensymphony.xwork2.ActionSupport;

import annotation.SysControllerLogAnnotation;

import entity.InputDetails;

import entity.InputOrder;

import entity.Material;

import entity.OutputDetails;

import entity.OutputOrder;

import entity.PurchaseDetails;

import entity.PurchaseOrder;

import service.InputService;

import service.OutputService;

@Controller

@ParentPackage("jasperreports-default")

@Namespace("/outputJasper")

public class OutputJasperAction extends ActionSupport {

    private List list;// 循环的参数列表

    private HashMap params;// 非循环的参数map

    private String outputOrderid;

    @Resource

    private OutputService outputService;

    @Action(value = "outputOrder", results = { @Result(name = "outputOrder", type = "jasper", params = {

            "location", "/jasper/OutputReport.jasper", "format", "HTML",

            "dataSource", "list", "reportParameters", "params",

            "imageServletUrl", "/servlets/image?image=", "contentDisposition",

            "inline" }) })

    @SysControllerLogAnnotation(desc = "生成出库单")

    public String inputOrder() {

        OutputOrder ood = outputService.getOrderById(outputOrderid);

        params = new HashMap();

        params.put("id", outputOrderid);

        params.put("outputtime", ood.getOuttime());

        params.put("operator", ood.getCreater().getUsername());

        List<OutputDetails> opdList = outputService

                .getDetailsListById(outputOrderid);

        list = new ArrayList();

        for (OutputDetails outputDetails : opdList) {

            HashMap map = new HashMap();

            Material m = outputDetails.getMaterial();

            map.put("materialid", m.getId());

            map.put("materialname", m.getName());

            map.put("assetno", outputDetails.getAssetno());

            map.put("category", m.getCategory());

            map.put("model", m.getModel());

            map.put("specification", m.getSpecification());

            map.put("unit", m.getUnit());

            map.put("amount", outputDetails.getAmount());

            list.add(map);

        }

        return "outputOrder";

    }

    public List getList() {

        return list;

    }

    public void setList(List list) {

        this.list = list;

    }

    public HashMap getParams() {

        return params;

    }

    public void setParams(HashMap params) {

        this.params = params;

    }

    public String getOutputOrderid() {

        return outputOrderid;

    }

    public void setOutputOrderid(String outputOrderid) {

        this.outputOrderid = outputOrderid;

    }

}

最后，可以到如下网站学习

http://www.yiibai.com/jasper_reports/

秒客网

使用Jasperreporter生成入库出库单打印等报表操作

相关文章