spring batch中MyBatisPagingItemReader分頁使用介紹

標籤：inner   pre   ges   mes   isp   from   code   aging   line   

假如是mysql的話，SQL語句

select * from (SELECT so.* FROM t_tm_sales_order so where so.last_modified_time >= to_timestamp(‘2015-05-05‘,‘yyyy-mm-dd hh24:mi:ss‘) order by so.id limit #{_pagesize} OFFSET #{_skiprows}  ) temp_a inner join t_tm_sales_order_line sol on temp_a.id=sol.so_id

假如是oracle的話，SQL語句

select t2.* from(select t1.*,rownum rn from(select * from a) t1 where rownum<= (#{_pagesize} + #{_skiprows})) t2 where t2.rn > #{_skiprows}

 

spring batch中MyBatisPagingItemReader分頁使用介紹