1.fetchSize流式查询方式,注意值的大小,值大于要查的总量
<select id="queryRegionList" resultType="com.zw.admin.server.model.Regioninfo" fetchSize="3200">
select * from regioninfo t where t.parentid in (select t.id from REGIONINFO t where t.parentid in (select t.id from regioninfo t where t.parentid = '0'))
</select>