分页显示（Paging display）.docVIP

分页显示（Paging display） - since the return value is a collection, you must first create a packageg containing the cursor type, which cannot be used in general parameters The first step is to create a package Create or replace package fengyepackage as Type fengye_cursor is ref cursor; -- create a cursor type variable, fengye_cursor End fengyepackage; The second step creates a procedure The create or replace procedure sp_fengye (pageNow in number, pageSise in number, tableName in varchar2, sortOrder in varchar2, pageCount out number, fengye_cursor out fengyepackage.) is V_rowCount number (2); -- total number of records V_pageCount number (2); - the total number of pages V_fromline number (2); -- get the return value from the v_fromline line V_toline number (2); - to the end of the v_toline number line V_sql varchar2 (1000); -- the variable that loads the SQL statement The begin V_sql: = select count (*) from | | tableName; Organize an SQL Execute immediate v_sql into v_rowCount; -- execute the SQL and assign the return value to v_rowCount If mod (v_rowCount, pageSise) = 0 then - the way to take the remainder with v_rowCount % pageSise = 0 is wrong, which is the use in the Java code V_pageCount: = v_rowCount/pageSise; The else V_pageCount: = ceil (v_rowCount/pageSise); -- ceil is equivalent to plus 1 End the if; V_toline: pageNow = * pageSise; V_fromline: = (pageNow - 1) * pageSise; PageCount: = v_pageCount; V_sql: = select * from (select e. *, rownum rn from (select * from | | tableName | | | sortOrder |) e where rownum = | | v_toline |0) where rn |3 |3 The two join symbols should be separated by Spaces, otherwise the Java program cannot recognize them The open fengye_cursor for v_sql; - close fengye_cursor; - close the cursor, but now you cant close it or the Java program cant call the data - the cursor of the result set to JAVA resultset is does not require us to manually close the cursor, because the JAVA the result set after receive come over, if JAVA on the result