Mysql 分页查询: select * from 表明 where 1=1 limit 0,10
limit 0,10
0 代表数据库里 记录 起始行的下标 =(当前页页码-1)*每页显示的数据量
10代表每页 多少条
SQL Server 语法 :select top 3 * from NEWS where ID not in
(select top 0 ID from NEWS)
内层 select top 0 ID from NEWS 0 代表数据库里 记录 起始行的下标 =(当前页页码-1)*每页显示的数据量
外层 select top 3 代表每次 返回多少条
//page 类用来做分页
public class Page {
//current page 当前页码
private int currPage;
//pagesize 每页数量
private int pageSize;
//total count 总条数
private int totalCount;
//totalpage 总页数
private int totalPageCount;
public int getCurrPage() {
return currPage;
}
public void setCurrPage(int currPage) {
this.currPage = currPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
//设置记录总条数时,顺便计算一下总页数
this.totalCount = totalCount;
if(totalCount%pageSize==0){
this.totalPageCount = totalCount/pageSize;
}else{
this.totalPageCount = totalCount/pageSize+1;
}
}
public int getTotalPageCount() {
return totalPageCount;
}
public Page(int currPage, int pageSize, int totalCount, int totalPageCount) {
super();
this.currPage = currPage;
this.pageSize = pageSize;
this.totalCount = totalCount;
this.totalPageCount = totalPageCount;
}
public Page() {
super();
// TODO Auto-generated constructor stub
}
}