mybatis cursor游标查询

在大数量查询处理时，为了避免出现OOM，可以采用cursor查询

1、dao层

import org.apache.ibatis.cursor.Cursor; //导包

//接口
Cursor<ROIReport> queryROIReportsCursor(ROIReportQuery params);

<select id="queryROIReportsCursor" resultType="com.xxx.ROIReport">
xxxxxxxxx对应自己的查询语句
</select>

service层

//service接口
Cursor<ROIReport> queryROIReportsCursor(ROIReportQuery params);

//serviceImpl
@Override
public Cursor<ROIReport> queryROIReportsCursor(ROIReportQuery params) {
	return salesMarketsMapper.queryROIReportsCursor(params);
}

controller层

//记得加上事务，不然游标在查询完就会关闭，报错
@ResponseBody
	@PostMapping("roiReportExport")
	@Transactional(readOnly = true)
	public void roiReportCursor(@RequestBody @Valid ROIReportParams params) throws ParseException {
		ROIReportQuery roiReportQuery = roiReportParams.toROIReportQuery();

		try (Cursor<ROIReport> roiReports = salesMarketsReportService.queryROIReportsCursor(roiReportQuery)) {
			Iterator<ROIReport> iterator = roiReports.iterator();
			while (iterator.hasNext()) {
				ROIReport next = iterator.next();
				System.out.println(next.getMarketName());
				System.out.println(next.getId());
				//xxxx自己业务逻辑
			}
		} catch (Exception e) {
			System.out.println(e);
		}
	}

使用cursor一定要加上事务，不然会报错：java.lang.IllegalStateException: A Cursor is already closed.