81,092
社区成员
发帖
与我相关
我的任务
分享
os = response.getOutputStream();
String title = "發送編號,時間,標題,接收號碼,訊息編號,接收時間,接收狀態"+"\r\n";
os.write(title.getBytes("UTF-8"));
QueryBean qb = (QueryBean) request
.getAttribute(GlobalConstNaming.QUERY_BEAN_NAME);
ResultBean resultBean = null;
resultBean=statReportMag.thrdinfo(qb,jobid,date);
List result = (List)resultBean.getTotalResult();
for(int i=0;i<result.size();i++)
{
StatSendthrdbean bean = (StatSendthrdbean)result.get(i);
String s = bean.getJobid();
s = s + ",";
s = s + bean.getDate();
s = s + ",";
s = s + (bean.getContent()==null?" ":bean.getContent());
s = s + ",";
s = s + (bean.getRecvmobile()==null? " " : bean.getRecvmobile());
s = s + ",";
s = s + (bean.getMsgid()==null ? " " : bean.getMsgid());
s = s + ",";
s = s + (bean.getRecvdate()==null? " " : bean.getRecvdate());
s = s + ",";
s = s + (bean.getStatus()==null ? " " : bean.getStatus());
s = s + "\r\n";
os.write(s.getBytes("UTF-8"));
}
ServletOutputStream os = response.getOutputStream();//输出的Excel文件URL
response.setContentType("application/x-msdownload;charset=UTF-8");
response.setHeader("Content-Disposition","attachment; filename=statreport.xls");
response.setCharacterEncoding("UTF-8");
try {
WritableWorkbook book = Workbook.createWorkbook(os);//创建可写工作薄
// 生成名为“第一页”的工作表,参数0表示这是第一页
WritableSheet sheet=book.createSheet("SUB_ID查詢報表",0);
// 在Label对象的构造子中指名单元格位置是第一列第一行(0,0)
// 以及单元格内容为test
sheet.addCell(new Label(0,0,"發送編號"));
sheet.addCell(new Label(1,0,"時間"));
sheet.addCell(new Label(2,0,"標題"));
sheet.addCell(new Label(3,0,"接收號碼"));
sheet.addCell(new Label(4,0,"訊息編號"));
sheet.addCell(new Label(5,0,"接收時間"));
sheet.addCell(new Label(6,0,"接收狀態"));
QueryBean qb = (QueryBean) request.getAttribute(GlobalConstNaming.QUERY_BEAN_NAME);
ResultBean resultBean = null;
resultBean=statReportMag.thrdinfo(qb,jobid,date);
List result = (List)resultBean.getTotalResult();
for(int i=0;i<result.size();i++){
StatSendthrdbean bean = (StatSendthrdbean)result.get(i);
sheet.addCell(new Label(0,i+1,(String) bean.getJobid()));
sheet.addCell(new Label(1,i+1,(String) bean.getDate()));
sheet.addCell(new Label(2,i+1,(String) bean.getContent()));
sheet.addCell(new Label(3,i+1,(String) bean.getRecvmobile()));
sheet.addCell(new Label(4,i+1,(String) bean.getMsgid()));
sheet.addCell(new Label(6,i+1,(String) bean.getRecvdate()));
sheet.addCell(new Label(5,i+1,(String) bean.getStatus()));
// if (bean.getRecvdate() != null) {
//// // 处理时间变成数字问题
// String ctime = DateUtil.dateToStr2(bean.getRecvdate().toString());
// sheet.addCell(new Label(6,i+1,ctime.substring(0,16)));
// } else
// sheet.addCell(new Label(6,i+1,""));
//
}
// 将工作薄输出到输出流
book.write();
os.flush();
book.close();
PrintWriter out = new PrintWriter(os, true);
out.close();
response.setContentType("application/x-msdownload;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment; filename="+"senddeail"+".csv");
OutputStream os = null;
try {
// byte[] hand=new byte[]{(byte) 0xEF,(byte) 0xBB,(byte) 0xBF};
os = response.getOutputStream();
//response.setContentType(arg0)
// response.setContentType("application/vnd.ms-excel; charset=Big5");
// os.write(hand);
String title = "發送編號,時間,標題,接收號碼,訊息編號,接收時間,接收狀態"+"\r\n";
os.write(title.getBytes("UTF-8"));
QueryBean qb = (QueryBean) request.getAttribute(GlobalConstNaming.QUERY_BEAN_NAME);
ResultBean resultBean = null;
resultBean=statReportMag.thrdinfo(qb,jobid,date);//從數據庫中獲得數據
List result = (List)resultBean.getTotalResult();
for(int i=0;i<result.size();i++)
{
StatSendthrdbean bean = (StatSendthrdbean)result.get(i);
String s = bean.getJobid();
s = s + ",";
s = s + bean.getDate();
s = s + ",";
s = s + (bean.getContent()==null ? " ":bean.getContent());
s = s + ",";
s = s + (bean.getRecvmobile()==null? " " : bean.getRecvmobile());
s = s + ",";
s = s + (bean.getMsgid()==null ? " " : bean.getMsgid());
s = s + ",";
s = s + (bean.getRecvdate()==null? " " : bean.getRecvdate());
s = s + ",";
s = s + (bean.getStatus()==null ? " " : bean.getStatus());
s = s + "\r\n";
os.write(s.getBytes("UTF-8"));
}
} catch (Exception e) {
log.error(e.getMessage());
throw e;
}finally{
if(null != os){
os.close();
}
}
byte[] hand=new byte[]{(byte) 0xEF,(byte) 0xBB,(byte) 0xBF};
os = response.getOutputStream();
os.write(hand);