`
234390216
  • 浏览: 10196442 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
博客专栏
A5ee55b9-a463-3d09-9c78-0c0cf33198cd
Oracle基础
浏览量：460982
Ad26f909-6440-35a9-b4e9-9aea825bd38e
springMVC介绍
浏览量：1772061
Ce363057-ae4d-3ee1-bb46-e7b51a722a4b
Mybatis简介
浏览量：1395705
Bdeb91ad-cf8a-3fe9-942a-3710073b4000
Spring整合JMS
浏览量：393983
5cbbde67-7cd5-313c-95c2-4185389601e7
Ehcache简介
浏览量：678335
Cc1c0708-ccc2-3d20-ba47-d40e04440682
Cas简介
浏览量：529401
51592fc3-854c-34f4-9eff-cb82d993ab3a
Spring Securi...
浏览量：1178940
23e1c30e-ef8c-3702-aa3c-e83277ffca91
Spring基础知识
浏览量：462427
4af1c81c-eb9d-365f-b759-07685a32156e
Spring Aop介绍
浏览量：150257
2f926891-9e7a-3ce2-a074-3acb2aaf2584
JAXB简介
浏览量：66953
社区版块
存档分类
最新评论
收藏列表
标题 标签 来源
第一个JasperReport程序中的jrxml文件 
<?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="report2" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.1"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="25"/>
	<parameter name="reportTitle" class="java.lang.String"/>
	<queryString>
		<![CDATA[select * from t_sysCategory;]]>
	</queryString>
	<field name="id" class="java.lang.Integer"/>
	<field name="name" class="java.lang.String"/>
	<field name="parentId" class="java.lang.Integer"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="79" splitType="Stretch">
			<textField>
				<reportElement x="250" y="32" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$P{reportTitle}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="35" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="48" splitType="Stretch">
			<staticText>
				<reportElement mode="Transparent" x="47" y="2" width="100" height="20" forecolor="#FF0033" backcolor="#FFFF00"/>
				<textElement>
					<font size="13"/>
				</textElement>
				<text><![CDATA[id]]></text>
			</staticText>
			<staticText>
				<reportElement x="236" y="2" width="100" height="20" forecolor="#FF0000"/>
				<textElement>
					<font size="13"/>
				</textElement>
				<text><![CDATA[name]]></text>
			</staticText>
			<staticText>
				<reportElement x="433" y="2" width="100" height="20" forecolor="#FF0000"/>
				<textElement>
					<font size="13"/>
				</textElement>
				<text><![CDATA[parentId]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="26" splitType="Stretch">
			<textField>
				<reportElement x="47" y="6" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="236" y="6" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="433" y="6" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{parentId}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>
我的第一个JasperReport程序 
package com.tiantian.jasperReport;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;

public class Test2 {

	public static void main(String args[]) throws JRException, ClassNotFoundException, SQLException {
		String fileName = "E:\\reports\\report2.jrxml";
		JasperReport jasperReport = null;
		JasperPrint jasperPrint = null;
		jasperReport = JasperCompileManager.compileReport(fileName);
		Map<String, Object> parameters = new HashMap<String, Object>();
		parameters.put("reportTitle", "我的第一个程序");
		jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, getConnection());
		JasperExportManager.exportReportToHtmlFile(jasperPrint, "first.html");
	}
	
	public static Connection getConnection() throws ClassNotFoundException, SQLException {
		Connection conn = null;
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection("jdbc:mysql://localhost/blog", "root", "zhangyilin");
		return conn;
	}
	
}
Global site tag (gtag.js) - Google Analytics