EasyExcel、Elastic stack等

快来打我* 2022-02-04 15:21 269阅读 0赞

**一、EasyExcel**  
开源地址:[https://github.com/alibaba/easyexcel][https_github.com_alibaba_easyexcel]

<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>1.1.2-beta5</version>
    </dependency>

导入

package com.alibaba.easyexcel.test;
    
    import com.alibaba.easyexcel.test.listen.ExcelListener;
    import com.alibaba.easyexcel.test.model.ReadModel;
    import com.alibaba.easyexcel.test.model.ReadModel2;
    import com.alibaba.easyexcel.test.util.FileUtil;
    import com.alibaba.excel.EasyExcelFactory;
    import com.alibaba.excel.ExcelReader;
    import com.alibaba.excel.metadata.Sheet;
    import org.junit.Test;
    
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    public class ReadTest {
    
    
        /**
         * 07版本excel读数据量少于1千行数据，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void simpleReadListStringV2007() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2007.xlsx");
            List<Object> data = EasyExcelFactory.read(inputStream, new Sheet(1, 0));
            inputStream.close();
            print(data);
        }
    
    
        /**
         * 07版本excel读数据量少于1千行数据自动转成javamodel，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void simpleReadJavaModelV2007() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2007.xlsx");
            List<Object> data = EasyExcelFactory.read(inputStream, new Sheet(2, 1, ReadModel.class));
            inputStream.close();
            print(data);
        }
    
        /**
         * 07版本excel读数据量大于1千行，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void saxReadListStringV2007() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2007.xlsx");
            ExcelListener excelListener = new ExcelListener();
            EasyExcelFactory.readBySax(inputStream, new Sheet(1, 1), excelListener);
            inputStream.close();
    
        }
        /**
         * 07版本excel读数据量大于1千行，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void saxReadJavaModelV2007() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2007.xlsx");
            ExcelListener excelListener = new ExcelListener();
            EasyExcelFactory.readBySax(inputStream, new Sheet(2, 1, ReadModel.class), excelListener);
            inputStream.close();
        }
    
        /**
         * 07版本excel读取sheet
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void saxReadSheetsV2007() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2007.xlsx");
            ExcelListener excelListener = new ExcelListener();
            ExcelReader excelReader = EasyExcelFactory.getReader(inputStream,excelListener);
            List<Sheet> sheets = excelReader.getSheets();
            System.out.println("llll****"+sheets);
            System.out.println();
            for (Sheet sheet:sheets) {
                if(sheet.getSheetNo() ==1) {
                    excelReader.read(sheet);
                }else if(sheet.getSheetNo() ==2){
                    sheet.setHeadLineMun(1);
                    sheet.setClazz(ReadModel.class);
                    excelReader.read(sheet);
                }else if(sheet.getSheetNo() ==3){
                    sheet.setHeadLineMun(1);
                    sheet.setClazz(ReadModel2.class);
                    excelReader.read(sheet);
                }
            }
            inputStream.close();
        }
    
    
    
        /**
         * 03版本excel读数据量少于1千行数据，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void simpleReadListStringV2003() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2003.xls");
            List<Object> data = EasyExcelFactory.read(inputStream, new Sheet(1, 0));
            inputStream.close();
            print(data);
        }
    
        /**
         * 03版本excel读数据量少于1千行数据转成javamodel，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void simpleReadJavaModelV2003() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2003.xls");
            List<Object> data = EasyExcelFactory.read(inputStream, new Sheet(2, 1, ReadModel.class));
            inputStream.close();
            print(data);
        }
    
        /**
         * 03版本excel读数据量大于1千行数据，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void saxReadListStringV2003() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2003.xls");
            ExcelListener excelListener = new ExcelListener();
            EasyExcelFactory.readBySax(inputStream, new Sheet(2, 1), excelListener);
            inputStream.close();
        }
    
        /**
         * 03版本excel读数据量大于1千行数据转成javamodel，内部采用回调方法.
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void saxReadJavaModelV2003() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2003.xls");
            ExcelListener excelListener = new ExcelListener();
            EasyExcelFactory.readBySax(inputStream, new Sheet(2, 1, ReadModel.class), excelListener);
            inputStream.close();
        }
    
        /**
         * 00版本excel读取sheet
         *
         * @throws IOException 简单抛出异常，真实环境需要catch异常,同时在finally中关闭流
         */
        @Test
        public void saxReadSheetsV2003() throws IOException {
            InputStream inputStream = FileUtil.getResourcesFileInputStream("2003.xls");
            ExcelListener excelListener = new ExcelListener();
            ExcelReader excelReader = EasyExcelFactory.getReader(inputStream,excelListener);
            List<Sheet> sheets = excelReader.getSheets();
            System.out.println();
            for (Sheet sheet:sheets) {
                if(sheet.getSheetNo() == 1) {
                    excelReader.read(sheet);
                }else {
                    sheet.setHeadLineMun(2);
                    sheet.setClazz(ReadModel.class);
                    excelReader.read(sheet);
                }
            }
            inputStream.close();
        }
    
    
        public void print(List<Object> datas){
            int i=0;
            for (Object ob:datas) {
                System.out.println(i++);
                System.out.println(ob);
            }
        }
    
    }

导出

@GetMapping("/a.htm")
        public void cooperation(HttpServletRequest request, HttpServletResponse response) {
            ServletOutputStream out = response.getOutputStream();
            ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLSX, true);
            String fileName = new String(("UserInfo " + new SimpleDateFormat("yyyy-MM-dd").format(new Date()))
                    .getBytes(), "UTF-8");
            Sheet sheet1 = new Sheet(1, 0);
            sheet1.setSheetName("第一个sheet");
            writer.write0(getListString(), sheet1);
            writer.finish();
            response.setContentType("multipart/form-data");
            response.setCharacterEncoding("utf-8");
            response.setHeader("Content-disposition", "attachment;filename="+fileName+".xlsx");
            out.flush();
            }
        }

**二、ChaosBlade**  
开源地址：[https://github.com/chaosblade-io/chaosblade/wiki/新手指南][https_github.com_chaosblade-io_chaosblade_wiki]

我们拿 CPU 满载(CPU 使用率 100%) 演练场景举例（！！注意，在不清楚影响面的情况下，切勿在生产系统机器上执行），执行以下命令实施实验：
    ./blade create cpu fullload
    执行结果返回：
    {"code":200,"success":true,"result":"7c1f7afc281482c8"}
    通过 top 命令查看 CPU 使用率
    CPU usage: 93.79% user, 6.20% sys, 0.0% idle
    此时命令已经生效，停止混沌实验，执行：
    ./blade destroy 7c1f7afc281482c8 
    返回以下结果，表示停止实验成功
    {"code":200,"success":true,"result":"command: cpu fullload --debug false --help false"}
    再去观察 CPU 情况，CPU 负载已回到正常状态：
    CPU usage: 6.36% user, 4.74% sys, 88.88% idle 
    一次 CPU 满载演练完成。

**三、资源队列 `Greenplum Resource Queue`**  
采用`Yarn`和`Mesos`，2种方式进行资源队列配置与实现。

**四、elastic stack**  
开源地址：[https://elasticsearch.cn/topic/Elastic+Stack][https_elasticsearch.cn_topic_Elastic_Stack]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNDQ3MzAx_size_16_color_FFFFFF_t_70]

[https_github.com_alibaba_easyexcel]: https://github.com/alibaba/easyexcel
[https_github.com_chaosblade-io_chaosblade_wiki]: https://github.com/chaosblade-io/chaosblade/wiki/%E6%96%B0%E6%89%8B%E6%8C%87%E5%8D%97
[https_elasticsearch.cn_topic_Elastic_Stack]: https://elasticsearch.cn/topic/Elastic+Stack
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNDQ3MzAx_size_16_color_FFFFFF_t_70]: /images/20220204/32cc416200ef4e5794e571c7673a0ddf.png