Spring使用BeanName视图产生Excel视图

最新推荐文章于 2023-06-08 13:22:47 发布

要争气

最新推荐文章于 2023-06-08 13:22:47 发布

阅读量292

点赞数

分类专栏： spring

本文链接：https://blog.csdn.net/liangwenmail/article/details/78655788

版权

spring 专栏收录该内容

53 篇文章 2 订阅

订阅专栏

引入一些包：

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.11</version>
</dependency>

<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.xsd
		http://www.springframework.org/schema/util
		http://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{

	@Override
	protected 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)
	@ResponseBody
	public 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.