You need to enable JavaScript to run this app. 如何编写处理Apache SS Workbook文件接口的JUnit HTTP请求测试
优惠活动
大模型
产品
解决方案
定价
更多

如何编写处理Apache SS Workbook文件接口的JUnit HTTP请求测试

方案一:真实构造Workbook流实现测试

该方案会生成真实的Excel字节流,完全匹配线上的POI解析逻辑,适合需要校验文件格式、解析逻辑的测试场景。
你需要先引入Mockito依赖用于Mock Servlet相关对象,完整测试代码如下:

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Row;
import org.junit.Test;
import org.mockito.Mockito;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.Part;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.util.Collections;
import static org.junit.Assert.assertEquals;
import static org.mockito.Mockito.when;

public class RestfulServiceTest {

    @Test
    public void testWorkbookProcessing() throws Exception {
        RestfulService rs = new RestfulService();

        // 构造测试用Workbook
        Workbook wb = WorkbookFactory.create(true);
        CreationHelper createHelper = wb.getCreationHelper();
        Sheet sheet = wb.createSheet("Sheet 1");
        Row row = sheet.createRow(0);
        row.createCell(0).setCellValue(createHelper.createRichTextString("Row 1 Cell 1"));
        row.createCell(1).setCellValue(12345678);

        // 将内存Workbook转为字节输入流
        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        wb.write(bos);
        wb.close();
        ByteArrayInputStream workbookInputStream = new ByteArrayInputStream(bos.toByteArray());

        // Mock Part对象,返回构造好的Excel流
        Part mockPart = Mockito.mock(Part.class);
        when(mockPart.getInputStream()).thenReturn(workbookInputStream);

        // Mock HttpServletRequest,返回Mock的Part集合
        HttpServletRequest mockRequest = Mockito.mock(HttpServletRequest.class);
        when(mockRequest.getParts()).thenReturn(Collections.singletonList(mockPart));

        // 执行测试断言
        ResponseEntity re = (ResponseEntity) rs.workbookProcessing(mockRequest);
        assertEquals(200, re.getStatusCodeValue());
    }
}

方案二:Mock Workbook全链路对象实现测试

该方案不需要生成真实的Excel文件,直接Mock Workbook、单元格等对象的返回值,执行速度更快,适合只需要测试业务处理逻辑、不需要校验POI解析逻辑的场景。
需要引入支持静态Mock的Mockito-inline依赖,完整测试代码如下:

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.junit.Test;
import org.mockito.MockedStatic;
import org.mockito.Mockito;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.Part;
import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.util.Collections;
import static org.junit.Assert.assertEquals;
import static org.mockito.ArgumentMatchers.any;
import static org.mockito.Mockito.when;

public class RestfulServiceTest {

    @Test
    public void testWorkbookProcessingWithMockWorkbook() throws Exception {
        RestfulService rs = new RestfulService();

        // Mock Workbook到单元格的全链路对象,自定义单元格返回值
        Workbook mockWorkbook = Mockito.mock(Workbook.class);
        Sheet mockSheet = Mockito.mock(Sheet.class);
        Row mockRow = Mockito.mock(Row.class);
        Cell mockCell1 = Mockito.mock(Cell.class);
        Cell mockCell2 = Mockito.mock(Cell.class);

        when(mockWorkbook.getSheetAt(0)).thenReturn(mockSheet);
        when(mockSheet.getRow(0)).thenReturn(mockRow);
        when(mockRow.getCell(0)).thenReturn(mockCell1);
        when(mockCell1.getStringCellValue()).thenReturn("Row 1 Cell 1");
        when(mockRow.getCell(1)).thenReturn(mockCell2);
        when(mockCell2.getNumericCellValue()).thenReturn(12345678D);

        // Mock Part和HttpServletRequest,此处输入流无实际作用可随便传
        Part mockPart = Mockito.mock(Part.class);
        when(mockPart.getInputStream()).thenReturn(new ByteArrayInputStream(new byte[0]));
        HttpServletRequest mockRequest = Mockito.mock(HttpServletRequest.class);
        when(mockRequest.getParts()).thenReturn(Collections.singletonList(mockPart));

        // 静态Mock WorkbookFactory的create方法,直接返回构造好的Mock Workbook
        try (MockedStatic<WorkbookFactory> mockedWorkbookFactory = Mockito.mockStatic(WorkbookFactory.class)) {
            mockedWorkbookFactory.when(() -> WorkbookFactory.create(any(InputStream.class)))
                    .thenReturn(mockWorkbook);

            // 执行测试断言
            ResponseEntity re = (ResponseEntity) rs.workbookProcessing(mockRequest);
            assertEquals(200, re.getStatusCodeValue());
        }
    }
}

内容的提问来源于stack exchange,提问作者rnoftz

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.15 06:15:06