报表导出Excel表格Word文件下载.docx
- 文档编号:1515233
- 上传时间:2023-04-30
- 格式:DOCX
- 页数:29
- 大小:18.68KB
报表导出Excel表格Word文件下载.docx
《报表导出Excel表格Word文件下载.docx》由会员分享,可在线阅读,更多相关《报表导出Excel表格Word文件下载.docx(29页珍藏版)》请在冰点文库上搜索。
importcom.xdgd.epos.table.Acl;
importcom.xdgd.epos.table.Mer_Trans;
importcom.xdgd.epos.table.Merchant;
importcom.xdgd.epos.table.Users;
importcom.xdgd.epos.utils.ExportExcel;
/**
*
*报表Servlet类
*/
publicclassReportServletextendsHttpServlet{
privatestaticfinallongserialVersionUID=1L;
publicstaticfinalLoggerlogger=Logger.getLogger(ReportServlet.class);
@Override
protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp)
throwsServletException,IOException{
Stringuri=req.getRequestURI();
Stringctx=req.getContextPath();
uri=uri.substring(ctx.length());
Stringmethod=req.getParameter("
method"
);
StringsheetName="
商户交易信息"
;
String[]title={"
订单号"
"
建档时间"
商戶号"
交易金额"
订单状态"
商户日期"
网关号"
"
交易类型"
货币类型号"
银行应答代码"
商户私有域"
交易状态"
终端"
对帐日期"
对账状态"
};
HttpSessionsession=req.getSession();
DatebeginDate=null;
DateendDate=null;
StringcxtPath=req.getContextPath();
StringbasePath=req.getScheme()+"
:
//"
+req.getServerName()+"
+req.getServerPort()+cxtPath+"
/"
synchronized(session){
StringmerId=(String)session.getAttribute("
merID"
Usersuser=(Users)session.getAttribute("
login"
StringuserName=user.getUserName();
*跳转到导出商户历史交易信息页面
if("
toExportHisExcel"
.equals(method)){
try{
booleanvalue=Acl.OperatorRightModules(user.getUserId(),
uri+"
?
method=toExportHisExcel"
if(value==false){
req.getRequestDispatcher("
../NoPrivilege.jsp"
).forward(
req,resp);
return;
}
}catch(findDBFailExceptione1){
e1.printStackTrace();
../reportManager/exportHisExcel.jsp"
)
.forward(req,resp);
findAllTrans"
method=findAllTrans"
intcurrPage;
intpageSize;
if(req.getParameter("
currPage"
)!
=null
&
!
.equals(req.getParameter("
))){
currPage=Integer.valueOf(req.getParameter("
));
}else{
currPage=1;
pageSize"
pageSize=Integer.valueOf(req.getParameter("
pageSize=200;
req.setAttribute("
currPage);
pageSize);
Mer_Transmer_Trans=newMer_Trans();
intbalcStatus=Integer.valueOf(req.getParameter("
balcStatus"
inttransStatus=Integer.valueOf(req.getParameter("
transStatus"
balcStatus);
transStatus);
List<
Mer_TransBean>
list=mer_Trans.findAllMer_TransByPage(null,
currPage,pageSize,null,null,2,balcStatus,transStatus);
intcount=Mer_Trans.findTransCount();
count"
count);
if(count%pageSize>
0){
maxPage"
count/pageSize+1);
count/pageSize);
transList"
list);
}catch(findDBFailExceptione){
e.printStackTrace();
req.getRequestDispatcher(
../reportManager/showAllTransactions.jsp"
*跳转到导出商户当前交易信息页面
toExportCurrExcel"
method=toExportCurrExcel"
req
.getRequestDispatcher(
../reportManager/exportCurrExcel.jsp"
*导出商户历史交易信息,下载到指定位置后删除服务器上的文件
exportHisExcel"
method=exportHisExcel"
java.text.SimpleDateFormatformatStr=newjava.text.SimpleDateFormat(
yyyy-MM-dd"
Locale.CHINA);
java.text.SimpleDateFormatformatDate=newjava.text.SimpleDateFormat(
yyyy年MM月dd日"
Stringxls_name=null;
beginDate"
req.getParameter("
="
){
java.util.DatebDate=formatStr.parse(req
.getParameter("
java.util.DateeDate=formatStr.parse(req
endDate"
xls_name=formatDate.format(bDate)+"
-"
+formatDate.format(eDate);
}catch(ParseExceptione1){
Stringtype=(String)req.getParameter("
exportType"
StringmerName=null;
Stringurl=getServletContext().getRealPath("
Stringdir=url+"
download\\"
+userName+"
\\"
Stringpath=dir+xls_name;
if(merId==null){
single"
.equals(type)){
merId=req.getParameter("
merId"
Merchantmerchant=newMerchant(merId);
merName=merchant.getMerName();
path=path+merName;
}catch(NewDBBeanExceptione){
merId=null;
merName="
所有"
path=path+"
商户历史消费记录表.xls"
if(req.getParameter("
)!
=null&
){
beginDate=java.sql.Date
.valueOf(req.getParameter("
=null){
endDate=java.sql.Date.valueOf(req.getParameter("
ExportExcelexport=newExportExcel();
Filefiledir=newFile(dir);
if(!
filedir.exists()){
filedir.mkdirs();
Filefile=newFile(path);
OutputStreamos=null;
os=newFileOutputStream(file);
}catch(FileNotFoundExceptione){
intbalcStatus=0;
inttransStatus=0;
=null||req.getParameter("
="
balcStatus=Integer.valueOf(req.getParameter("
transStatus=Integer.valueOf(req.getParameter("
list=Mer_Trans.findAllMer_Trans(
merId,beginDate,endDate,1,balcStatus,transStatus);
intsize=0;
if(list==null){
}else{
size=list.size();
Stringmessage=null;
message="
总计:
+size+"
条。
生成条件:
导出从"
+req.getParameter("
)+"
到"
的交易"
logger.info(user.getUserName()+"
开始导出商户["
+beginDate
+"
+endDate+"
]历史交易信息!
export.exportExcel(os,sheetName,message,title,list);
//客户端下载时显示的名称
Stringfilenamedisplay="
商户消费记录表.xls"
//生成文件的文件名(绝对路径)
//获取前台传入的参数
filenamedisplay=URLEncoder.encode(filenamedisplay,
UTF-8"
resp.reset();
resp.setContentType("
application/x-msdownload"
resp.addHeader("
Content-Disposition"
attachment;
filename="
+filenamedisplay);
OutputStreamoutput=resp.getOutputStream();
FileInputStreamfis=newFileInputStream(path);
byte[]b=newbyte[1024];
inti=0;
while((i=fis.read(b))>
output.write(b,0,i);
导出商户["
+beginDate+"
+endDate+"
]历史交易信息成功!
output.flush();
fis.close();
output.close();
if(file.exists()){
file.delete();
}catch(Exceptione){
}finally{
os.flush();
os.close();
*分页查询商户历史交易信息
searchHisTrans"
.equals(method)||"
trans"
method=searchHisTrans"
type"
merId);
!
))){
req.getParameter("
*分页的查询
pageSize=200;
beginDate);
endDate);
list=m
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 报表 导出 Excel 表格