正在阅读：解决MVC下分页显示的问题解决MVC下分页显示的问题

protected String intiQuerySQL(String sql, int startIndex, int size){
StringBuffer querySQL = new StringBuffer();
if (size != this.MAX_PAGE_SIZE) {
querySQL.append("select * from (select my_table.*,rownum as my_rownum from(")
.append( sql)
.append(") my_table where rownum<").append(startIndex + size)
.append(") where my_rownum>=").append(startIndex);
} else {
querySQL.append("select * from (select my_table.*,rownum as my_rownum from(")
.append(sql)
.append(") my_table ")
.append(") where my_rownum>=").append(startIndex);
}
return querySQL.toString();
}

　　select * from user
　　order by Host
　　limit m, n

　　select * from user
　　order by Host
　　limit 1, 5

　　SELECT *
　　FROM (SELECT TOP m *
　　FROM (SELECT TOP n *
　　FROM Customers) A
　　ORDER BY CustomerID DESC) B
　　ORDER BY CustomerID

　　SELECT *
　　FROM (SELECT TOP 5 *
　　FROM (SELECT TOP 10 *
　　FROM Customers) A
　　ORDER BY CustomerID DESC) B
　　ORDER BY CustomerID

　　select * from (select rownum r ,* from test) tt
　　where tt.r > 50 and tt.r <= 100;