Using spring's jdbctemplate to achieve paging functionality

Paging

Recent use of the JdbcTemplate in spring to implement database query and insert operations, the discovery of spring jdbctemplate is not as good as hibernatetemplate, has implemented the paging function. So to implement it yourself, the result set that you get using Getjdbctemplate (). queryForList (String sql) is all.
  
If your query has 10,000 records, or more, the speed must be slow, of course, you can control the start and end of the query through the cursor in the resultset. I'm using an Oracle database that uses pseudo-column rownum to implement pagination. My paging code is as follows:
  
Package Com.deity.ranking.util;import java.util.List;
Import Org.springframework.jdbc.core.JdbcTemplate;
Import Org.springframework.jdbc.core.support.JdbcDaoSupport;
/** * Paging function * * @author Allenpan */public class pagination extends jdbcdaosupport{
public static final int numbers_per_page = 10;
Number of records displayed on one page
private int numperpage;
Total Records
private int totalrows;
Total pages
private int totalpages;
Current page number
private int currentpage;
Number of rows to start
private int startIndex;
End of Line
private int lastindex;
Result set store list
Private List resultlist;
JdbcTemplate jtemplate
Private JdbcTemplate jtemplate;
/**
* The constructor that displays 10 records per page, using this function must first set Currentpage,jtemplate initial value to pagination
* @param SQL Oracle Statements
*/
public pagination (String sql) {
if (jtemplate = = null) {
throw new IllegalArgumentException ("Com.deity.ranking.util.Pagination.jTemplate is null,please initial it");
}else if (Sql.equals ("")) {
throw new IllegalArgumentException ("Com.deity.ranking.util.Pagination.sql is empty,please initial it");
}
New pagination (sql,currentpage,numbers_per_page,jtemplate);
}
/** Paging Constructor
* @param SQL gets some basic paging information based on the incoming SQL statement
* @param currentpage Current page
* @param numperpage The number of records per page
* @param jtemplate JdbcTemplate Example
*/
Public pagination (String sql,int currentpage,int numperpage,jdbctemplate jtemplate) {
if (jtemplate = = null) {
throw new IllegalArgumentException ("Com.deity.ranking.util.Pagination.jTemplate is null,please initial it");
}else if (sql = null | | sql.equals ("")) {
throw new IllegalArgumentException ("Com.deity.ranking.util.Pagination.sql is empty,please initial it");
}
Set the number of records to display per page
Setnumperpage (Numperpage);
Set the number of pages to display
Setcurrentpage (currentpage);
Calculate the total number of records
StringBuffer totalsql = new StringBuffer ("SELECT count (*) from (");
Totalsql.append (SQL);
Totalsql.append (") totaltable");
Assigning Values to JdbcTemplate
Setjdbctemplate (jtemplate);
Total number of records
Settotalrows (Getjdbctemplate (). queryForInt (Totalsql.tostring ()));
Calculate Total Pages
Settotalpages ();
Calculate the number of starting lines
Setstartindex ();
Calculate End Line Count
Setlastindex ();
System.out.println ("lastindex=" +lastindex);//////////////////
To construct a paging statement for an Oracle database
StringBuffer paginationsql = new StringBuffer ("SELECT * from");
Paginationsql.append ("Select temp.*, RowNum num from (");
Paginationsql.append (SQL);
Paginationsql.append (") Temp where rownum <=" + lastindex);
Paginationsql.append (") WHERE num >" + startIndex);
Mount result set
Setresultlist (Getjdbctemplate (). queryForList (Paginationsql.tostring ()));
}
/**
* @param args
*/
public static void Main (string[] args) {
TODO auto-generated Method Stub}
public int getcurrentpage () {
return currentpage;
}
public void setcurrentpage (int currentpage) {
This.currentpage = CurrentPage;
}
public int getnumperpage () {
return numperpage;
}
public void setnumperpage (int numperpage) {
This.numperpage = Numperpage;
}
Public List getresultlist () {
return resultlist; }
public void Setresultlist (List resultlist) {
This.resultlist = resultlist;
}
public int gettotalpages () {
return totalpages;
}