Oracle分页:
String sqlcount = "select count(*) from Dictinfo where type =?";
String sql = "SELECT * FROM(SELECT A.*, ROWNUM RN FROM (SELECT * FROM Dictinfo where type =? ORDER BY ID DESC) A WHERE ROWNUM <= ?)WHERE RN >= ?";
mysql分页:
select count(*) from table [查询条件]
select * from table [查询条件] order by id limit ?,?