java分页导出excel_java导出Excel（适用于分页，导出大量数据）

name="exportWorkerTrades"

class="com.skylink.jixiao.action.ReportAction"

method="exportWorkerTrades" >

name="success">/download/jsp/download.jsp

//=========================== 实例代码

===========================

private String realExportPath;

private String fileName;

public String exportWorkerTrades() {

if (!checkLogin())

return

LOGIN;

try {

SubscribeService

subscribeService = new SubscribeService();

SubscribeInfo

subscribe = subscribeService.getSubscribeInfo(nick);

ReportService

servie = new ReportService();

String

filePath = Tools.getRootTruePath() + "download/files/";

fileName =

"[" + worker + "]订单查询结果(" + beginTime + "至" + endTime + ")";

realExportPath

= servie.exportWorkerTrades(nick, worker, beginTime, endTime,

workerType,

fileName, subscribe.getSalesDifine(), filePath);

LOG.debug("订单查询结果成xls文件成功");

} catch (Exception e) {

e.printStackTrace();

}

return SUCCESS;

}

public String exportWorkerTrades(String nick,

String workNick, String beginTime,

String

endTime, String workerType, String fileName,String salesDifine,

String filepath) {

Export2XLS export2XLS = new

Export2XLS();

StringBuffer sql = new

StringBuffer("");

sql.append("select

distinct(t.TID),t.BUYER_NICK,to_char(t.CREATED,'yyyy-mm-dd

hh24:mi') CREATED");

sql.append(",t.PAYMENT,t.STATUS,t.RECEIVED_PAYMENT,w.WW_NICK

");

if("TRADE_PAY".equals(salesDifine)){

sql.append("

from JX_TRADES_INFO_T t, JX_WORKER_TRADES_PAY_T w ,JX_WORKER_IM_T m

");

sql.append("

where t.TID=w.TID and w.WW_NICK(+)= m.WORK_NICK ");

sql.append("

and t.SELLER_NICK='