循环读取public void testClub(Map params){ String s loadClob(10002L, 1, 4000); System.out.println(s); } public String loadClob(Long eid, int offset, int chunk) { StringBuilder sb new StringBuilder(); String part; do { part stockStudioAdjustMapper.querySurveyByEid(ImmutableMap.of(eid, eid, offset, offset, chunk, chunk)); if (StrUtil.isNotBlank(part)) { sb.append(part); offset chunk; } } while (StrUtil.isNotBlank(part)); return sb.toString(); } select idquerySurveyByEid resultTypejava.lang.String SELECT DBMS_LOB.SUBSTR(ANSWER, #{chunk}, #{offset}) FROM STOCKIA.USER_SURVEY_SUBMIT WHERE EID #{eid} /select