The paging statement *** @ Title: getMySQLSql * @ Description: generate an SQL paging statement * @ paramsql * @ paramoffset * @ paramlimit * @ returnString * publicStringgetMySQLSql (Stringsql, effecffset, intlimit) {re
Generate paging statements for MySQL, SQL Server, and Oracle Data/*** @ Title: getMySQLSql * @ Description: generate an SQL paging statement * @ param SQL * @ param offset * @ param limit * @ return String */public String getMySQLSql (String SQL, int offset, int limit) suitable for MySQL Dialects) {re
Generate paging statements for MySQL, SQL Server, and Oracle Data
/*** @ Title: getMySQLSql * @ Description: generate an SQL paging statement * @ param SQL * @ param offset * @ param limit * @ return String */public String getMySQLSql (String SQL, int offset, int limit) suitable for MySQL Dialects) {return SQL + "limit" + offset + "," + limit;}/*** @ Title: getSqlServeSql * @ Description: generate an SQL paging statement * @ param SQL * @ param pageNo * @ param pageSize * @ return String */public String getSqlServeSql (String SQL, int pageNo, int pageSize) suitable for dialect) {return "select top" + pageSize + "from (" + SQL + ") t where t. id not in (select top "+ (pageNo-1) * pageSize +" t1.id from ("+ SQL +") t1) ";}/*** @ Title: getOrcaleSql * @ Description: generates an SQL paging statement * @ param SQL * @ param pageNo * @ param pageSize * @ return String */public String getOrcaleSql (String SQL, int pageNo, int pageSize) {return "select * from (select rownum rn, t. * from ("+ SQL +") t where rownum <= "+ (pageNo * pageSize) +") t1 where t1.rn> "+ (pageNo-1) * pageSize );}