Use the Easyui paging mechanism in the background using the Oracle foreground

The paging property is set in the DataGrid of the foreground Easyui:

pagination:true,//display pagination
Pageposition: ' Bottom ',//page bar position both up and down bottom, top
pagelist:[12,24,36]//Paging Data size

In the background Java code int page, int rows write set, get method.

page = Integer.parseint (request.getparameter ("page"));
rows = Integer.parseint (Request.getparameter ("Rows"));
startindex= (page-1) *rows;

Background Oracle paging uses rownum for paging. SQL statement Instance

SELECT *

From (

Select Id,name,rownum as num

From student

)

where num between and 20

Remember that rownum must use aliases, and you cannot use >= and <=, only between and.

The backend passes JSON data to the foreground, including total and rows.