亚洲高清视频中文字幕,在线视频1区,三级国产三级在线

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

規則

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

jasper文件和前面幾篇用到的是一樣的(person.jasper),準備數據的文本文件Person.txt其中文件的格式對應模板文件的字段【 "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是怎么識別這些數據的，但是做這個之前我們還要指定數據到底是怎么對應的,定義String類型數組存放模板對應的列名和文本數據對應

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

"department" };

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

JRCsvDataSource jrcsvDataScource = new JRCsvDataSource(JRLoader

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

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

// set record delimiter

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

// set columnName

jrcsvDataScource.setColumnNames(columNames);

至此數據源就準備完了，jasperReport封裝了底層的實現，簡單吧！下來看看完整的代碼：

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數據源也是很簡單，通過讀取xml文件獲得數據

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

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

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();

}

預覽效果就不看了吧！哈哈都是一樣的道理，現在看看jasperReport的API有多強大了吧！

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

常用鏈接

留言簿(11)

我參與的團隊

隨筆分類

隨筆檔案

文章分類

文章檔案

新聞分類

新聞檔案

收藏夾

圍脖

最新隨筆

搜索

最新評論

閱讀排行榜

評論排行榜


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




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