bap.pp.common.service

Class ExportExcel

java.lang.Object

bap.pp.common.service.ExportExcel

@Component
public class ExportExcel
extends java.lang.Object

类: ExportExcel 功能描述: 导出excel公共类 创建人: 陈伟 创建日期: 2012-8-22 上午10:03:17 开发环境: JDK6.0

Constructor Summary

Constructors

Constructor and Description
ExportExcel()

Method Summary

Modifier and Type	Method and Description
void	createCell(java.lang.reflect.Field field, java.lang.Object obj, Staff staff, org.apache.poi.hssf.usermodel.HSSFCell cell, org.apache.poi.hssf.usermodel.HSSFRow row, int columnIndex, org.apache.poi.hssf.usermodel.HSSFCellStyle textCellStyle) 功能描述:根据用户信息创建单元格
org.apache.poi.hssf.usermodel.HSSFWorkbook	exportExcel(java.lang.Class target, java.lang.String searchCondition, java.lang.String orderCondition, javax.servlet.http.HttpServletRequest request) 功能描述:导出excel
bap.core.dao.BaseDao	getBaseDao()
void	setBaseDao(bap.core.dao.BaseDao baseDao)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExportExcel

public ExportExcel()

Method Detail

exportExcel

@Transactional
public org.apache.poi.hssf.usermodel.HSSFWorkbook exportExcel(java.lang.Class target,
                                                                              java.lang.String searchCondition,
                                                                              java.lang.String orderCondition,
                                                                              javax.servlet.http.HttpServletRequest request)

功能描述:导出excel

Parameters:

target要导出的类 -

response -

Throws:

java.lang.Exception

createCell

public void createCell(java.lang.reflect.Field field,
                       java.lang.Object obj,
                       Staff staff,
                       org.apache.poi.hssf.usermodel.HSSFCell cell,
                       org.apache.poi.hssf.usermodel.HSSFRow row,
                       int columnIndex,
                       org.apache.poi.hssf.usermodel.HSSFCellStyle textCellStyle)
                throws java.lang.IllegalArgumentException,
                       java.lang.IllegalAccessException

功能描述:根据用户信息创建单元格

Parameters:

field -

obj -

staff -

cell -

row -

columnIndex -

textCellStyle -

Throws:

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

getBaseDao

public bap.core.dao.BaseDao getBaseDao()

setBaseDao

public void setBaseDao(bap.core.dao.BaseDao baseDao)