如何编写处理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
相关产品推荐
相关产品推荐

