导出，下载，（如何决定下不下载）

程序员文章站 2022-05-07 19:21:48

...

导出：

1，准备数据写入jsp(可以直接用一个jsp模板承接，也可以后台用流写动态的jsp,outputStream.writer())

2,要让其会下载不展现需要设置响应的头类型：（jsp中设置，动态写入时设置）

<%@ page import="java.util.*"%>

String file_name=java.net.URLEncoder.encode("企业会员信息列表.xls","UTF-8") ;

response.setHeader("Content-disposition","attachment; filename="+file_name);

//以上这行设定传送到前端浏览器时的档名为test1.xls

//就是靠这一行，让前端浏览器以为接收到一个excel档

<%-- <%@ page contentType="text/html;charset=UTF-8" pageEncoding="UTF-8"%> --%>

<%@ page contentType="application/msexcel; charset=UTF-8" %>//这两个都可以，下面这个更正规

//.do请求要不要下载就是设置这个头

model.addAttribute("operateuserList", op);//同样分key会被覆盖，取最后一个

@SuppressWarnings({ "rawtypes", "unchecked" })

@RequestMapping("/account/tbCusFirmChg/customerListXLS")

public String customerListXLS(TbCusFirmChgVo tbCusFirmChg,Model model) throws EsteelException {

Map<String,Object> param = new HashMap<String,Object>();

param.put("pageNum", tbCusFirmChg.getPageNum()+"");

param.put("pageSize", tbCusFirmChg.getPageSize()+"");

tbCusFirmChg.setCusTradeKind("A");

param = getParam(param,tbCusFirmChg);

if (null == tbCusFirmChg.getOrderField() || tbCusFirmChg.getOrderField() == "") {

tbCusFirmChg.setOrderField("CUSTOMER_KEY");

tbCusFirmChg.setOrderDirection("ASC");

}

param.put("orderField", "C."+tbCusFirmChg.getOrderField());

param.put("orderDirection", tbCusFirmChg.getOrderDirection());

List<TbCusFirmChgVo> tbCusFirmWebList= tbCusFirmChgService.getTbCusFirmChgList(param);

// if(tbCusFirmWebList!=null&&tbCusFirmWebList.size()>0){

// for(TbCusFirmChgVo b:tbCusFirmWebList){

Map<String,Object> param1 = new HashMap<String,Object>();

// param1.put("customer_key", b.getCustomerKey()+"");

List<TbCusUserVo> op= tbCusUserService.getOperateUser(param1);

model.addAttribute("operateuserList", op);//子账户

// }

List<TbBasBedSrt> tbBasBedSrtList = new ArrayList<TbBasBedSrt>();

tbBasBedSrtList= tbBasBedSrtService.list();

List<String> companyType= tbCusFirmChgService.getCompanyType();

model.addAttribute("list", tbCusFirmWebList);

model.addAttribute("basbedsrt", tbBasBedSrtList);

model.addAttribute("companyType", companyType);

return "/account/tbCusFirmChg/customerListXLS";

}

样式可以自己拼装

对于我们框架中ajax请求返回要不要下载用

<bean id="mappingJacksonHttpMessageConverter"

class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">

<list>

<value>text/html;charset=UTF-8</value>

</list>

</property>

</bean>

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

<%@ page contentType="application/msexcel; charset=UTF-8" %>

<%@ include file="../common/include.inc.jsp"%>

<%@ page import="java.util.*"%>

String file_name=java.net.URLEncoder.encode("企业会员信息列表.xls","UTF-8") ;

response.setHeader("Content-disposition","attachment; filename="+file_name);

//以上这行设定传送到前端浏览器时的档名为test1.xls

//就是靠这一行，让前端浏览器以为接收到一个excel档

<%-- <form id="pagerForm" method="post"

action="/basBedSrt//edit/${vo.warekind_id}">

</form> onsubmit="return checkForm(this); --%>

table

{mso-displayed-decimal-separator:"\.";

mso-displayed-thousand-separator:"\,";}

.font510891

{color:windowtext;

font-size:9.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;}

.xl1510891

{padding-top:1px;

padding-right:1px;

padding-left:1px;

mso-ignore:padding;

color:windowtext;

font-size:12.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;

mso-number-format:General;

text-align:general;

vertical-align:bottom;

mso-background-source:auto;

mso-pattern:auto;

white-space:nowrap;}

.xl2210891

{padding-top:1px;

padding-right:1px;

padding-left:1px;

mso-ignore:padding;

color:windowtext;

font-size:12.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;

mso-number-format:General;

text-align:general;

vertical-align:bottom;

border:.5pt solid windowtext;

mso-background-source:auto;

mso-pattern:auto;

white-space:nowrap;}

ruby

{ruby-align:left;}

{color:windowtext;

font-size:9.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;

mso-char-type:none;}

</style>

<form method="post"

action="<c:url value='/account/tbCusFirmChg/editJypz?navTabId=tbConFirmFeeNav&callbackType=closeCurrent&flag=${flag}'/>"

class="pageForm required-validate" onsubmit="return validateCallback(this,navTabAjaxDone);" >

<%-- <input type="hidden" name="id" value="${vo.ware_key}" /> --%>

<table x:str border='0' cellpadding='0' cellspacing='0' width='1008'

style='border-collapse: collapse;table-layout:fixed;width:756pt'>

</tr>

<c:forEach items="${list}" var="item" varStatus="s">

<td height='19' class='xl2210891' align='right'

style='height:14.25pt;border-top:none'>

${s.index+1}

</td>

<td height='19' class='xl2210891' align='right'

style='height:14.25pt;border-top:none'>

${item.customerId}

</td>

<td class='xl2210891' align='right'