创建Student实体类
使用的话,建议自己提取公共的代码通过传参来调取
package com.cat.chapter1.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
private String name;
private Integer age;
private String sex;
private String hobby;
private String phoneNumber;
private Double enResult;
private Double maResult;
private Double laResult;
private Date createTime;
private Double sum;
private Double sum1;
}
导入POI依赖
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>5.2.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.2.2</version>
</dependency>
创建TestController
package com.cat.chapter1.controller;
import com.cat.chapter1.pojo.Student;
import org.apache.poi.common.usermodel.HyperlinkType;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.util.IOUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.imageio.ImageIO;
import javax.servlet.http.HttpServletResponse;
import java.awt.image.BufferedImage;
import java.io.*;
import java.net.URLEncoder;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@RestController
public class TestController {
/* Hello World! 测试连接 */
@RequestMapping("/hello")
public String hello(){
return "Hello World!!";
}
/* 生成假数据,不用连接数据库,也可略过这步,使用mybatis连接数据库使用SQL获取集合 */
@RequestMapping("/getList")
public List<Student> getList(){
ArrayList<Student> students = new ArrayList<>();
for (int i = 0; i < 10; i++) {
Student student = new Student();
student.setName("张"+i);
student.setAge(i+(int)Math.random()*10+10+(int)Math.random());
if (i%2==0)
student.setSex("男");
else
student