csvprinter.java

sample目录下是例子程序。 1.分组汇总例子 TestGroupReport.java 2.交叉报表例子 TestCrossReport.java 需要使用crossTabSample.x

package com.lucaslee.report.printer;

import java.io.IOException;
import java.io.OutputStream;

import com.lucaslee.report.Printer;
import com.lucaslee.report.ReportException;
import com.lucaslee.report.model.Report;
import com.lucaslee.report.model.ReportBody;
import com.lucaslee.report.model.Table;
import com.lucaslee.report.model.TableCell;
import com.lucaslee.report.model.TableRow;

/**
 * CSV打印机。
 * <p>
 * Title:
 * </p>
 * <p>
 * Description: 每个单元用”,“分隔，行间用换行符分隔。
 * </p>
 * <p>
 * Copyright: Copyright (c) 2003
 * </p>
 * <p>
 * Company:Lucas-lee Soft
 * </p>
 * 
 * @author Lucas Lee
 * @version 1.0
 */
public class CSVPrinter implements Printer {
	public CSVPrinter() {
	}

	/**
	 * 打印报表到输出流。
	 * 
	 * @param r
	 *            报表
	 * @param result
	 *            输出流
	 * @throws com.lucaslee.report.ReportException
	 * @throws IOException
	 */
	public void print(Report r, OutputStream result)
			throws com.lucaslee.report.ReportException, IOException {
		if (r.getHeaderTable() != null) {
			print(r.getHeaderTable(), result);
		}
		if (r.getBody() != null) {
			print(r.getBody(), result);
		}
		if (r.getFooterTable() != null) {
			print(r.getFooterTable(), result);
		}
	}

	/**
	 * 打印报表主体到输出流。
	 * 
	 * @param body
	 *            报表主体
	 * @param result
	 *            输出流
	 * @throws com.lucaslee.report.ReportException
	 * @throws IOException
	 */
	private void print(ReportBody body, OutputStream result)
			throws com.lucaslee.report.ReportException, IOException {
		Table data = body.getData().cloneAll();
		Table header = body.getTableColHeader();
		if (header != null) {
			for (int i = header.getRowCount() - 1; i >= 0; i--) {
				data.insertRow(0, header.getRow(i));
			}
		}
		print(data, result);

	}

	/**
	 * @todo更正 获得单元格的内容
	 * @param tc
	 * @return
	 * @throws ReportException
	 */
	private String print(TableCell tc) throws ReportException {
		StringBuffer buf = new StringBuffer();
		if (Report.CROSS_HEAD_HEAD_TYPE.equals(tc.getCssClass())) {
			String[] strs = PrinterUtil.getCrossHeadHeadContent(tc);
			for (int i = strs.length - 1; i >= 0; i--) {
				if (i != strs.length - 1)
					buf.append("/");
				buf.append(strs[i]);
			}
		} else {
			String content = (String) tc.getContent();
			buf.append(content == null ? "" : content);
		}
		String result = buf.toString();
		// 替换关键符号。将英文的逗号替换为中文的逗号；将换行符、回车符号替换为空格
		result = result.replaceAll(",", "，");
		result = result.replaceAll("\r\n", " ");
		result = result.replaceAll("\n", " ");
		return result;
	}

	/**
	 * 打印表格到输出流
	 * 
	 * @param t
	 *            表格
	 * @param result
	 *            输出流
	 * @throws com.lucaslee.report.ReportException
	 * @throws IOException
	 */
	private void print(Table t, OutputStream result)
			throws com.lucaslee.report.ReportException, IOException {
		StringBuffer buf = new StringBuffer();
		final String delimiter = ",";
		TableRow tempTR = null;
		TableCell tempCell = null;
		int colCount = 0;
		for (int i = 0; i < t.getRowCount(); i++) {
			tempTR = t.getRow(i);
			colCount = t.getColCount();
			for (int j = 0; j < colCount; j++) {
				tempCell = tempTR.getCell(j);
				if (tempCell.getIsHidden() == false) {
					buf.append(print(tempCell));
				}
				if (j < colCount - 1) {
					buf.append(delimiter);
				} else {
					buf.append("\r\n");
				}
			}
		}
		result.write(buf.toString().getBytes());
	}

}