java本地缓存存储机制 java本地存储数据方案

一、引入依赖包

<dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>4.2.0</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.24</version>
        </dependency>

二、编写实体类 

@Data
@ToString
public class User {
    //@Excel使属性与列名对应
    @Excel(name = "姓名", width = 15)
    private String name;
    @Excel(name = "年龄", width = 15)
    private int age;
}

三、编写测试类

public class Test {
    public static void main(String[] args) {
       //构建数据
        User usera = new User("小明", 10);
        User userb = new User("小华", 11);
        ArrayList<User> users = new ArrayList<>();
        users.add(usera);
        users.add(userb);
        //构建Excel参数 
        ExportParams params = new ExportParams();
        //构建Excel                                 
        Workbook workbook = ExcelExportUtil.exportExcel(params, User.class, users);
        try {
            FileOutputStream fileOutputStream = new FileOutputStream("E:\\aa\\User.xls");
           //写入输出流
            workbook.write(fileOutputStream);
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            //关流
            if (workbook!=null){
                try {
                    workbook.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }

        }
    }
}

四、结果