1.ORACLE SQL
select * from table where xxx order by xxxx
OFFSET #{_skiprows} ROWS FETCH FIRST #{_pagesize} ROWS ONLY
2.xml配置
<bean id="itemReader" class="org.mybatis.spring.batch.MyBatisPagingItemReader"
p:queryId="oxxxx.querySql"
p:sqlSessionFactory-ref="sqlSessionFactoryl"
scope="step">
<property name="parameterValues">
<map>
<entry key="JobID" value="#{jobParameters['JobID']}">
</entry>
</map>
</property><property name="pageSize" value="1000"/>
</bean>
本文地址:https://blog.csdn.net/piao208/article/details/107668895
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的,请 点击进行留言回复,万千网友为您解惑!
网友评论