Spring使用BeanName视图产生Excel视图

引入一些包：

<!-- excel视图使用 -->
<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.11</version>
        </dependency>
        <!-- DateFormatUtils工具 -->
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.2</version>
        </dependency>

配置：

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"xmlns:util="http://www.springframework.org/schema/util"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsdhttp://www.springframework.org/schema/utilhttp://www.springframework.org/schema/util/spring-util-4.0.xsd"><!-- 扫描的包 --><context:component-scan base-package="com.smart.web"/><!-- HandlerMapping和HandlerAdapter及数据转换器配置 -->    <mvc:annotation-driven conversion-service="conversionService">    <mvc:message-converters register-defaults="true">    <bean class="org.springframework.http.converter.BufferedImageHttpMessageConverter"/>       <bean class="org.springframework.http.converter.ByteArrayHttpMessageConverter"/>            <bean class="org.springframework.http.converter.StringHttpMessageConverter" />            <bean class="org.springframework.http.converter.support.AllEncompassingFormHttpMessageConverter"/>            <bean class="org.springframework.http.converter.xml.MarshallingHttpMessageConverter"                p:marshaller-ref="xmlMarshaller" p:unmarshaller-ref="xmlMarshaller">            </bean>            <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"/>    </mvc:message-converters>    </mvc:annotation-driven>    <!-- 数据转换器 --><bean id="conversionService" class="org.springframework.context.support.ConversionServiceFactoryBean"><property name="converters"><list><bean class="com.smart.domain.StringToUserConvert" /></list></property></bean>       <!-- xml消息转换器 -->             <bean id="xmlMarshaller" class="org.springframework.oxm.xstream.XStreamMarshaller">        <property name="streamDriver">            <bean class="com.thoughtworks.xstream.io.xml.StaxDriver"/>        </property>        <property name="annotatedClasses">            <list>                <value>com.smart.domain.User</value>            </list>        </property>    </bean>                  <!-- 在使用Excel/PDF/XML的视图时，请先把这个视图解析器注释掉，否则产生视图解析问题-->    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"          p:order="100" p:viewClass="org.springframework.web.servlet.view.JstlView"          p:prefix="/WEB-INF/views/" p:suffix=".jsp"/><!-- FreeMarker基础设施及视图解析器配置 --><bean class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer" p:templateLoaderPath="/WEB-INF/ftl"  p:defaultEncoding="UTF-8"> <property name="freemarkerSettings">            <props>                <prop key="classic_compatible">true</prop>            </props>        </property></bean>  <bean  class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver"            p:order="5" p:suffix=".ftl1" p:contentType="text/html; charset=utf-8"/>             <!-- Excel及PDF视图解析器配置 -->    <bean class="org.springframework.web.servlet.view.BeanNameViewResolver"          p:order="10"/>    <bean id="userListExcel" class="com.smart.web.UserListExcelView"/>            </beans>

自定义视图：

package com.smart.web;import java.util.List;import java.util.Map;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.commons.lang.time.DateFormatUtils;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.springframework.web.servlet.view.document.AbstractExcelView;import com.smart.domain.User;public class UserListExcelView extends AbstractExcelView{@Overrideprotected void buildExcelDocument(Map<String, Object> model,HSSFWorkbook workbook, HttpServletRequest request,HttpServletResponse response) throws Exception {//response.setHeader("Content-Disposition", "attachment; filename="+ //new String("用户列表".getBytes(), "iso8859-1"));          String fileName = "用户列表excel.xls";          response.setCharacterEncoding("UTF-8");          response.setContentType("application/ms-excel");          response.setHeader("Content-Disposition", "inline; filename="+new String(fileName.getBytes(),"iso8859-1"));List<User> userList = (List<User>) model.get("userList");HSSFSheet sheet = (HSSFSheet) workbook.createSheet("users");HSSFRow header = sheet.createRow(0);header.createCell(0).setCellValue("帐号");header.createCell(1).setCellValue("姓名");header.createCell(2).setCellValue("生日");int rowNum = 1;for (User user : userList) {HSSFRow row = sheet.createRow(rowNum++);row.createCell(0).setCellValue(user.getUserName());row.createCell(1).setCellValue(user.getRealName());String createDate = DateFormatUtils.format(user.getBirthday(),"yyyy-MM-dd");row.createCell(2).setCellValue(createDate);}}}

接口：

package com.smart.web;import java.io.UnsupportedEncodingException;import java.util.ArrayList;import java.util.Date;import java.util.List;import org.springframework.http.HttpEntity;import org.springframework.http.HttpStatus;import org.springframework.http.ResponseEntity;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.ResponseBody;import com.smart.domain.User;@Controller@RequestMapping("/sp4")public class Sp4Controller {@RequestMapping(value="m1",method=RequestMethod.GET)@ResponseBodypublic String m1(){return "inm1";}@RequestMapping(value = "/m2",method=RequestMethod.POST)public ResponseEntity<User> m2(HttpEntity<User> requestEntity) throws UnsupportedEncodingException {User user = requestEntity.getBody();System.out.println("######:"+user+"---"+user.getRealName());user.setUserId("1000");return new ResponseEntity<User>(user, HttpStatus.OK);}@RequestMapping(value="/m3",method=RequestMethod.GET)public String m3(ModelMap mm){List<User> list = new ArrayList<User>();User user = new User();user.setUserId("1");user.setUserName("zhangsan");list.add(user);User user1 = new User();user1.setUserId("2");user1.setUserName("lisi");list.add(user1);mm.addAttribute("list", list);return "suc";}@RequestMapping(value="/m4" ,method=RequestMethod.GET)public String m4(ModelMap mm){List<User> list = new ArrayList<User>();User user = new User();user.setUserId("1");user.setUserName("zhangsan");list.add(user);User user1 = new User();user1.setUserId("2");user1.setUserName("lisi");list.add(user1);mm.addAttribute("userList", list);return "userFtl";}@RequestMapping(value="/m5" ,method=RequestMethod.GET)public String m5(ModelMap mm){List<User> list = new ArrayList<User>();User user = new User();user.setUserId("1");user.setUserName("zhangsan");user.setRealName("张三");user.setBirthday(new Date());list.add(user);User user1 = new User();user1.setUserId("2");user1.setUserName("lisi");user1.setRealName("张三");user1.setBirthday(new Date());list.add(user1);mm.addAttribute("userList", list);return "userListExcel";}}

m5方法 返回值要和bean id相同。

此时访问m5，会产生下载excel.