Oracle, mysql, teradata paging method/*** add paging information to the original SQL statement * @ param SQL the SQL statement to add paging * @ param start the start position of the record * @ param limit the record to be displayed number * @ return: converted SQL */public static String addPageForOracle (String SQL, int start, int limit) {int end = start + limit; SQL = "select * from (select t. *, rownum rn from ("+ SQL +") t where rownum <= "+ end +") t1 where t1.rn> "+ start +" "; return SQL ;} /*** add paging information on the original SQL statement * @ param SQL the SQL statement to add paging * @ param start the start position of the record * @ param limit the number of records to be displayed *@ return converted SQL */public static String addPageForMySql (String SQL, int start, int limit) {SQL = SQL + "limit" + start + "," + limit; return SQL;} public String addPageForTeraData (String SQL, int start, int limit) {SQL = SQL + "QUALIFY sum (1) over (rows unbounded preceding) between (" + start + ") and (" + limit + ")"; return SQL ;}