package com.cloud.serviceexamine.util.pages;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;
import java.util.List;
import java.util.Map;
@Component
public class PageHelp {
@Autowired
private JdbcTemplate jdbcTemplate;
public PageList findAllbyPager(String sql,String sqlcount,int pagenum, int pagerow) {
PageList pageList = new PageList();
if (pagenum == 0) {
pagenum = 1;
}
if (pagerow == 0) {
pagerow = 30;
}
sql = sql + " LIMIT " + ((pagenum -1)* pagerow) + "," + pagerow;
System.out.println(sql);
List list = jdbcTemplate.queryForList(sql);
Map map = jdbcTemplate.queryForMap(sqlcount);
int TotalRows = Integer.parseInt(map.get("count").toString());
pageList.setPage(pagenum);
pageList.setTotalRows(TotalRows);
int pages = 0;
if (TotalRows % pagerow == 0) {
pages = TotalRows / pagerow;
} else {
pages = TotalRows / pagerow + 1;
}
System.out.println("目前分页的总页数是" + pages);
pageList.setPages(pages);
pageList.setList(list);
return pageList;
}
}
package com.cloud.serviceexamine.util.pages;
import java.util.ArrayList;
import java.util.List;
public class PageList {
private int page;
private int totalRows;
private int pages;
private List list=new ArrayList();
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public int getPages() {
return pages;
}
public void setPages(int pages) {
this.pages = pages;
}
public List getList() {
if(list==null){
list=new ArrayList();
}
return list;
}
public void setList(List list) {
this.list = list;
}
public int getTotalRows() {
return totalRows;
}
public void setTotalRows(int totalRows) {
this.totalRows = totalRows;
}
}