com.sh.common.util

类 WordExport

java.lang.Object

com.sh.common.util.ExportBase

com.sh.common.util.WordExport

public class WordExport
extends ExportBase

Description: 导出Word

Title:首亨软件 - TSS/CRM等

从以下版本开始:

Dec 18, 2012

版本:

3.0

作者:

江兴春

字段概要

从类继承的字段 com.sh.common.util.ExportBase

CHARSET_GBK, CHARSET_ISSO_8859_1, CHARSET_UTF_8, DEFAULT_CHARSET, ENABLE_DOWNLOAD_MAX_NUM, FTNEXS_DIR, SHEET_MAX_ROW, TO_FTNEXS_FILES, TO_FTNEXS_TASK

构造器概要

构造器

构造器和说明
WordExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[][] wordTitle, java.lang.String[] wordCols) 构造函数
WordExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] wordTitle, java.lang.String[] wordCols) 构造函数
WordExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] wordTitle, java.lang.String[] wordCols) 构造函数
WordExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] wordTitle, java.lang.String[] wordCols) 构造函数
WordExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.File file, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.File file, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.File file, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.File file, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] wordTitle, java.lang.String[] wordCols)
WordExport(javax.servlet.http.HttpServletResponse response)
WordExport(java.io.OutputStream outputStream)

方法概要

限定符和类型	方法和说明
com.lowagie.text.Image	addImg(byte[] buffer)
com.lowagie.text.Image	addImgWithPath(java.lang.String str) 添加图片
com.lowagie.text.Paragraph	addString(java.lang.String str)
com.lowagie.text.Paragraph	addString(java.lang.String str, com.lowagie.text.Font font)
void	beforeExport()
void	beforeExport(java.lang.String fileName) 导出
com.lowagie.text.Cell	createCell(java.lang.String value, com.lowagie.text.Font font)
com.lowagie.text.Cell	createCell(java.lang.String value, com.lowagie.text.Font font, int align)
com.lowagie.text.Cell	createCell(java.lang.String value, com.lowagie.text.Font font, int align, int colspan)
void	doExport(java.lang.String fileName) 导出PDF
void	finishExport()
DataCenter	getDc()
com.lowagie.text.Document	getDocument()
com.lowagie.text.Font	getTextfont()
void	mergeHeaderCells(int col1, int row1, int col2, int row2) 设置合并单元格
void	mergeHeaderCells(PdfMerge mergeCell) 合并表头单元格
void	refresh()
void	setCharset(java.lang.String charset) 设置编码
void	setColumnWidth(int col, int width) 设置宽度
void	setTextfont(com.lowagie.text.Font textfont)

从类继承的方法 com.sh.common.util.ExportBase

getRefreshDsObj, refreshDs, refreshDs, setRefreshDs

从类继承的方法 java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

WordExport

public WordExport(DataCenter dc,
                  java.io.File file,
                  java.lang.String sql,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(DataCenter dc,
                  java.io.OutputStream outputStream,
                  java.lang.String sql,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(DataCenter dc,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String sql,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

wordTitle - word中标题行

wordCols - 每列对应DS中的列名

WordExport

public WordExport(DataCenter dc,
                  java.io.File file,
                  java.lang.String sql,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(DataCenter dc,
                  java.io.OutputStream outputStream,
                  java.lang.String sql,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(DataCenter dc,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String sql,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

wordTitle - word中标题行

wordCols - 每列对应DS中的列名

WordExport

public WordExport(DataCenter dc,
                  java.io.File file,
                  java.lang.String sql,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(DataCenter dc,
                  java.io.OutputStream outputStream,
                  java.lang.String sql,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(DataCenter dc,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String sql,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

colsType - 查询参数类型

obj - 查询参数

wordTitle - word中标题行

wordCols - 每列对应DS中的列名

WordExport

public WordExport(DataCenter dc,
                  java.io.File file,
                  java.lang.String sql,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(DataCenter dc,
                  java.io.OutputStream outputStream,
                  java.lang.String sql,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(DataCenter dc,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String sql,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

colsType - 查询参数类型

obj - 查询参数

wordTitle - word中标题行

wordCols - 每列对应DS中的列名

WordExport

public WordExport(Datastore ds,
                  java.io.File file,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(Datastore ds,
                  java.io.OutputStream outputStream,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  java.io.File file,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(Datastore ds,
                  java.io.OutputStream outputStream,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  java.io.File file,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(Datastore ds,
                  java.io.OutputStream outputStream,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  java.io.File file,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)
           throws java.lang.Exception

抛出:

java.lang.Exception

WordExport

public WordExport(Datastore ds,
                  java.io.OutputStream outputStream,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(Datastore ds,
                  javax.servlet.http.HttpServletRequest request,
                  javax.servlet.http.HttpServletResponse response,
                  java.lang.String[] colsType,
                  java.lang.Object[] obj,
                  java.lang.String[][] wordTitle,
                  java.lang.String[] wordCols)

WordExport

public WordExport(javax.servlet.http.HttpServletResponse response)

WordExport

public WordExport(java.io.OutputStream outputStream)

方法详细资料

setCharset

public void setCharset(java.lang.String charset)

设置编码

参数:

charset - String

setColumnWidth

public void setColumnWidth(int col,
                           int width)

设置宽度

参数:

col - 列号 从0开始

width - 宽度

doExport

public void doExport(java.lang.String fileName)
              throws java.lang.Exception

导出PDF

参数:

fileName - String

抛出:

java.lang.Exception - Exception

beforeExport

public void beforeExport()
                  throws java.lang.Exception

抛出:

java.lang.Exception

beforeExport

public void beforeExport(java.lang.String fileName)
                  throws java.lang.Exception

导出

参数:

fileName - String

抛出:

java.lang.Exception - Exception

refresh

public void refresh()
             throws java.lang.Exception

抛出:

java.lang.Exception

finishExport

public void finishExport()
                  throws java.lang.Exception

抛出:

java.lang.Exception

addString

public com.lowagie.text.Paragraph addString(java.lang.String str,
                                            com.lowagie.text.Font font)

addString

public com.lowagie.text.Paragraph addString(java.lang.String str)

addImgWithPath

public com.lowagie.text.Image addImgWithPath(java.lang.String str)

添加图片

参数:

str - 图片路径

返回:

Image

addImg

public com.lowagie.text.Image addImg(byte[] buffer)

createCell

public com.lowagie.text.Cell createCell(java.lang.String value,
                                        com.lowagie.text.Font font,
                                        int align)
                                 throws com.lowagie.text.BadElementException

抛出:

com.lowagie.text.BadElementException

createCell

public com.lowagie.text.Cell createCell(java.lang.String value,
                                        com.lowagie.text.Font font)
                                 throws com.lowagie.text.BadElementException

抛出:

com.lowagie.text.BadElementException

createCell

public com.lowagie.text.Cell createCell(java.lang.String value,
                                        com.lowagie.text.Font font,
                                        int align,
                                        int colspan)
                                 throws com.lowagie.text.BadElementException

抛出:

com.lowagie.text.BadElementException

mergeHeaderCells

public void mergeHeaderCells(PdfMerge mergeCell)

合并表头单元格

参数:

mergeCell - PdfMerge

mergeHeaderCells

public void mergeHeaderCells(int col1,
                             int row1,
                             int col2,
                             int row2)

设置合并单元格

参数:

col1 - 起始单元格列号 从0开始

row1 - 起始单元格行号 从0开始

col2 - 结束单元格列号 从0开始

row2 - 结束单元格行号 从0开始

getDc

public DataCenter getDc()

getDocument

public com.lowagie.text.Document getDocument()

getTextfont

public com.lowagie.text.Font getTextfont()

setTextfont

public void setTextfont(com.lowagie.text.Font textfont)