测试测试测试

 int pageNum=1,pageSize=2;
 while (true){
     List<Xs0101> xs0101ByPage = xs0101Mapper.findXs0101ByPage(pageNum, pageSize);
     for (Xs0101 xs:xs0101ByPage
          ) {
         xs.setAddress(up(xs.getAddress()));
         xs0101Mapper.update(xs);
     }
     pageNum++;
     System.out.println("当前有"+xs0101ByPage.size());
     if(xs0101ByPage.size()<pageSize){
         break;
     }
 }

public interface Xs0101Mapper {
    public List<Xs0101> findXs0101ByPage(@Param("pageNum")int pageNum,@Param("pageSize")int pageSize);
    public void update(Xs0101 xs0101);
}

<select id="findXs0101ByPage" resultType="xs0101">
select xs0101id,address from ( select row_.*, rownum rownum_ from ( select xs0101id,address from  xs0101 ) row_
  where rownum &lt;=  #{pageNum} * #{pageSize} ) where rownum_ &gt;  (#{pageNum} - 1) * #{pageSize}
</select>
<update id="update">
    update xs0101 set address=#{address} where xs0101id=#{xs0101id}
</update>

<update id="updatePlus">
    <foreach collection="xs0101s" item="xs" index="index" open="begin" close="end;">
        update xs0101 set address=#{xs.address} where xs0101id=#{xs.xs0101id};
    </foreach>
</update>