Java实现数据库数据导出到Excel中并下载到浏览器本地

首先必不可少的在pom.xml文件中导入关于poi的jar包：

<!-- zs  apahce poi -->
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>3.9</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-examples</artifactId>
			<version>3.9</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-scratchpad</artifactId>
			<version>3.9</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>3.9</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml-schemas</artifactId>
			<version>3.9</version>
		</dependency>

1.以ApplyCard实体类为例

package com.capinfo.card.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.CascadeType;
import javax.persistence.ManyToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import org.hibernate.annotations.NotFound;
import org.hibernate.annotations.NotFoundAction;

import com.capinfo.common.model.DictionaryImpl;
import com.capinfo.framework.model.BaseEntity;
import com.capinfo.framework.model.StatusEnabled;

@Entity
@Table(name = "CARD_BUSINESS_INFO")
@SequenceGenerator(allocationSize = 1, name = "seq", sequenceName = "SEQ_CARD_BUSINESS_INFO")
public cla