ibatis sqlMap :

<select id="getPageOrders" resultMap="order_map">
        call getOrders(#page#, #range#);
 </select>

存储过程:

 create procedure getOrders(in _pno int, in _psize int)
begin
  prepare stmt from "select * from orders limit ?,?";
  set @pno = (_pno - 1) * _psize;
  set @psize = _psize;
  execute stmt using @pno, @psize;
end