Jfinal中使用OAuth2.0有没有成熟的框架或是自己实现的主体思路
发布网友
发布时间：2022-07-26 13:44
共1个回答
热心网友
时间：2023-10-20 17:24
加下拉框根据框中的数字 每页显示多少条 这点就可以判断是用SQL分页的。
/**
正序分页 每页20条、第3页 **/
Select * from ( select top 20 * FROM TableName b
WHERE (time <= (SELECT max(time) FROM (
SELECT TOP 60 time FROM TableName b where 1=1 ORDER BY time ) AS T )) 1=1 ORDER BY time desc ) AS T ORDER BY time /**
倒叙分页 每页30条、第2页 **/
Select * from ( select top 30 * FROM TableName b
WHERE (time >= (SELECT min(time) FROM (
SELECT TOP 60 time FROM TableName b where 1=1 ORDER BY time desc ) AS T )) 1=1 ORDER BY time ) AS T ORDER BY time desc
