Paging Talk
Ibatis provides such paging query method list list = SQLMap.executeQueryforList ("SQL_Alias", HashMapj, SkipResults, maxResults; but its underlying implementation is in memory, in the absence of RESULTSET, very waste memory is not recommended, SqlMapConfig.xml following settings can be turned off maxRequests this cache
We can hand over the task selected to select a subset to the database. We can use SELECT A. * from (SELECT INDENT_RQ_NO, ROWNUM AS RN from Indent_RQ_MSTR ORDER BYIDENT_RQ_NO) Awhere RN <= 8 and Rn> = 3
Similar features can be obtained with TOP key in MySQL
- == Welcome everyone to discuss this article and interested topics and I discuss == -
