久久久久久久久亚洲,亚洲VA中文字幕无码一二三区,亚洲风情亚Aⅴ在线发布

iReport+jasperReport之CSV、XML數(shù)據(jù)源

jasperReport支持多種格式的數(shù)據(jù)源，CSV(Comma Separated values),是一種用來存儲數(shù)據(jù)的純文本,文件格式，通常用于電子表格或數(shù)據(jù)庫軟件。

規(guī)則

0 開頭是不留空，以行為單位。
1 可含或不含列名，含列名則居文件第一行。
2 一行數(shù)據(jù)不垮行，無空行。
3 以半角符號，作分隔符，列為空也要表達其存在。
4 列內(nèi)容如存在，，則用“”包含起來。
5 列內(nèi)容如存在“”則用“”“”包含。
6 文件讀寫時引號，逗號操作規(guī)則互逆。
7 內(nèi)碼格式不限，可為ASCII、Unicode或者其他。

jasper文件和前面幾篇用到的是一樣的(person.jasper),準備數(shù)據(jù)的文本文件Person.txt其中文件的格式對應(yīng)模板文件的字段【 "pid", "name", "sex", "age", "password", "department"】。

"20000000001","bulktree1","man","21","1111111111","pcisv61"

"20000000002","bulktree2","man","22","2222222222","pcisv62"

"20000000003","bulktree3","man","23","3333333333","pcisv63"

"20000000004","bulktree4","man","24","4444444444","pcisv64"

"20000000005","bulktree5","man","25","5555555555","pcisv65"

"20000000006","bulktree6","man","26","6666666666","pcisv66"

"20000000007","bulktree7","man","27","7777777777","pcisv67"

"20000000008","bulktree8","man","28","8888888888","pcisv68"

"20000000009","bulktree9","man","29","9999999999","pcisv69"

下來我們看看jasperReport的API是怎么識別這些數(shù)據(jù)的，但是做這個之前我們還要指定數(shù)據(jù)到底是怎么對應(yīng)的,定義String類型數(shù)組存放模板對應(yīng)的列名和文本數(shù)據(jù)對應(yīng)

String[] columNames = new String[] { "pid", "name", "sex", "age", "password",

"department" };

識別這些數(shù)據(jù)并不難，下面這一句就可以搞定：

JRCsvDataSource jrcsvDataScource = new JRCsvDataSource(JRLoader

.getLocationInputStream("D:\\workspace\\Person.txt"));

我們怎么才能讓它識別對應(yīng)的列呢？查看API看看對應(yīng)的set方法吧！

// set record delimiter

jrcsvDataScource.setRecordDelimiter("\r\n");

// set columnName

jrcsvDataScource.setColumnNames(columNames);

至此數(shù)據(jù)源就準備完了，jasperReport封裝了底層的實現(xiàn)，簡單吧！下來看看完整的代碼：

package org.bulktree.ireport.csvdata;

import java.util.HashMap;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.engine.data.JRCsvDataSource;

import net.sf.jasperreports.engine.util.JRLoader;

import org.bulktree.ireport.ViewReport;

public class CSVDataSource {

public static void main(String[] args) {

try {

new CSVDataSource().reportView();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

private void reportView() throws Exception {

JasperReport jasperReport = (JasperReport) JRLoader

.loadObject("D:\\workspace\\Person.jasper");

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,

getReportParameter(), getDateSource());

new ViewReport().viewer(jasperPrint);

}

private HashMap getReportParameter() {

HashMap parameters = new HashMap();

parameters.put("reportTitle", "laoshulin");

return parameters;

}

private JRCsvDataSource getDateSource() throws Exception {

String[] columNames = new String[] { "pid", "name", "sex", "age", "password",

"department" };

// get csvdata

JRCsvDataSource jrcsvDataScource = new JRCsvDataSource(JRLoader

.getLocationInputStream("D:\\workspace\\test\\src\\org\\bulktree\\ireport\\csvdata\\Person.txt"));

// set record delimiter

jrcsvDataScource.setRecordDelimiter("\r\n");

// set columnName

jrcsvDataScource.setColumnNames(columNames);

return jrcsvDataScource;

}

還是這樣的效果吧！^_^

至于XML數(shù)據(jù)源也是很簡單，通過讀取xml文件獲得數(shù)據(jù)

Document document = JRXmlUtils.parse(JRLoader.getLocationInputStream(xmlFileName));

不同的是document會作為一個參數(shù)傳遞給報表，fillReport方法就不會出現(xiàn)第三個參數(shù)，完整代碼如下：

package org.bulktree.ireport.xmldata;

import java.util.HashMap;

import java.util.Locale;

import net.sf.jasperreports.engine.JRException;

import net.sf.jasperreports.engine.JRParameter;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.engine.query.JRXPathQueryExecuterFactory;

import net.sf.jasperreports.engine.util.JRLoader;

import net.sf.jasperreports.engine.util.JRXmlUtils;

import org.bulktree.ireport.ViewReport;

import org.w3c.dom.Document;

public class XMLDataSource {

private static final String JASPER_FILE_NAME = "D:\\workspace\\Person.jasper";

private static final String XML_FILE_NAME = "D:\\workspace\\person.xml";

private void viewerReport() throws JRException {

JasperReport jasperReport = (JasperReport) JRLoader.loadObject(JASPER_FILE_NAME);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,

getReportParameter(XML_FILE_NAME));

new ViewReport().viewer(jasperPrint);

}

private HashMap getReportParameter(String xmlFileName) {

HashMap parameters = new HashMap();

try {

parameters.put("reportTitle", "laoshulin");

Document document = JRXmlUtils.parse(JRLoader.getLocationInputStream(xmlFileName));

parameters.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT,

document);

parameters.put(JRXPathQueryExecuterFactory.XML_DATE_PATTERN, "yyyy-MM-dd");

parameters.put(JRXPathQueryExecuterFactory.XML_NUMBER_PATTERN, "#,##0.##");

parameters.put(JRXPathQueryExecuterFactory.XML_LOCALE, Locale.CHINESE);

parameters.put(JRParameter.REPORT_LOCALE, Locale.CHINA);

} catch (JRException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return parameters;

}

public static void main(String[] args) throws Exception {

new XMLDataSource().viewerReport();

}

預(yù)覽效果就不看了吧！哈哈都是一樣的道理，現(xiàn)在看看jasperReport的API有多強大了吧！

posted on 2008-12-15 10:08 凌晨風(fēng) 閱讀(4400) 評論(19) 編輯收藏所屬分類: iReport + JasperReport 系列

常用鏈接

留言簿(11)

我參與的團隊

隨筆分類

隨筆檔案

文章分類

文章檔案

新聞分類

新聞檔案

收藏夾

圍脖

最新隨筆

搜索

最新評論

閱讀排行榜

評論排行榜


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: iReport+jasperReport之客戶端打印 (續(xù)二) ----數(shù)字簽名 iReport+jasperReport之客戶端打印 (續(xù)) iReport+jasperReport之客戶端打印 iReport+jasperReport之i18n國際化支持 iReport+jasperReport之圖片控件 iReport+jasperReport之JFreeChart（圖表報表） iReport+jasperReport之scriptlet（續(xù)） iReport+jasperReport之scriptlet iReport+jasperReport之NoXML iReport+jasperReport之CSV、XML數(shù)據(jù)源