Repository:
@QueryHints(value = @QueryHint(name = HINT_FETCH_SIZE, value = "" + Integer.MIN_VALUE))
@Query("写sql")
Stream<Object[]> findByXXXX()
使用的方法上必须加:
@Transactional(readOnly = true)
ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
WriteSheet writeSheet = EasyExcel.writerSheet(0, "sheet_1").head(***.class).build();
excelWriter.write(实例对象数据, writeSheet);
数据对象:
@ExcelProperty(value = "订单编号", index = 0)