public void doPost(List list){
response.setContentType("application/octet-stream;charset=GBK");
response.setHeader("Content-disposition","attachment; filename=order.xls");
PrintWriter out = response.getWriter();
out.print("<html><body><table border='1'>");
if (list != null) {
out.print("<tr><th align='center'>姓名</th>");
out.print("<th align='center'>手机号码</th>");
out.print("<th align='center'>预约金额(单位：万元)</th>");
out.print("<th align='center'>邮箱</th>");
out.print("<th align='center'>家庭住址</th>");
out.print("<th align='center'>邮编</th>");
out.print("<th align='center'>性别</th>");
out.print("<th align='center'>预约产品代码</th>");
out.print("<th align='center'>预约产品简称</th>");
out.print("<th align='center'>预约时间</th>");
out.print("<th align='center'>是否已经处理</th>");
out.print("<th align='center'>处理时间</th></tr>");
for (int i = 0; i < list.size(); i++) {
bean = (OrderBean) list.get(i);
out.print("<tr><td align='center'>"+bean.getName()+"</td>");
out.print("<td align='center'>"+bean.getPhone()+"</td>");
out.print("<td align='center'>"+bean.getAmount()+"</td>");
out.print("<td align='center'>"+bean.getEmail()+"</td>");
out.print("<td align='center'>"+bean.getAdress()+"</td>");
out.print("<td align='center'>"+bean.getPostcode()+"</td>");
if("0".equals(bean.getSex())){
out.print("<td align='center'>男</td>");
}else if("1".equals(bean.getSex())){
out.print("<td align='center'>女</td>");
}
out.print("<td align='center'>" + bean.getFundcode() + "</td>");
out.print("<td align='center'>"+bean.getFundname()+"</td>");
out.print("<td align='center'>"+bean.getOrderDate().substring(0,10)+"</td>");
if("0".equals(bean.getFlag())){
out.print("<td align='center'>未处理</td>");
out.print("<td align='center'></td>");
}else if("1".equals(bean.getFlag())){
out.print("<td align='center'>已处理</td>");
out.print("<td align='center'>"+bean.getDealDate().substring(0,10)+"</td>");
}
}
out.flush();
}
out.print("</table></body></html>");
out.close();
log.debug("导出预约列表!");
return null;
}
4100
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
