SQL语句
select * from( select ROW_NUMBER() over(order by 主标识 desc)RowId,* FROM
(
--单表分页
select 字段名 from 表名 where 条件
--多表分页
select 字段名 from 表1 as a,表2 as b where a.id=b.id and 条件
) t
) tt
WHERE RowId BETWEEN 数量*(页数-1)+1 and (数量*页数)
--总数量
select count(*) from 表名
--总页数
select (count(*)/条数) from 表名
CSS样式
.page a {
display: inline-block;
width: 50px;
height: 35px;
line-height: 35px;
text-align: center;
margin: 0 0.05rem;
background-color: #fff;
font-family: "Arial";
border-radius: 3px;
border: 1px solid #e8e8ec;
}
HTML代码
<!--当前页码-->
<input type="hidden" value="1" id="index"/>
<!--显示数量-->
<input type="hidden" value="0" id="ListCount" />
<!--总页数-->
<input type="hidden" value="0" id="PageMax" />
<div class="page" style="text-align: center;">
<a href="javascript:;" class="firstPage pagea" onclick="PageClick('1')">首页</a>
<a href="javascript:;" class="prevPage pagea" onclick="PageClick('-')">上一页</a>
<span class="pageBody"></span>
<a href="javascript:;" class="prevPage pagea" onclick="PageClick('+')">下一页</a>
<a href="javascript:;" class="firstPage pagea wy" onclick="PageClick('1')">尾页</a>
</div>
JavaScript代码
$(function () {
//查询数据, Ajax查询数据(获取页数,请求URL传需查询的页数),得出结果数量并赋值隐藏域 $("#ListCount").val(item.Count);
GetList();
//获取 共有几页并绑定分页
getPageMax(1);
})
//分页单机事件
function PageClick(page) {
var index = $("#index").val() * 1;
var PageMax = $("#PageMax").val() * 1;
if (page == "+") {
if (index < PageMax)
$("#index").val(index + 1)
}
else if (page == "-") {
if (index > 1)
$("#index").val(index - 1)
}
else {
$("#index").val(page)
}
index = $("#index").val() * 1;
$(".oncalass").addClass("pagea");
$(".oncalass").removeClass("oncalass");
$(".page_" + index + "").addClass("oncalass").removeClass("pagea");
getPageMax(index);
GetList();
}
//获取 共有几页并绑定分页
function getPageMax(page) {
var ListCount = $("#ListCount").val();
//10表示每次查询数量
var count = Math.ceil(ListCount / 10);
$("#PageMax").val(count);
$(".wy").attr("onclick", "PageClick('" + count + "')");
var CountS = [];
if (count < 6) {
for (var i = 1; i < (count + 1) ; i++) {
CountS.push(i);
}
}
else if (page >= (count - 2)) {
for (var i = (count - 4) ; i < (count + 1) ; i++) {
CountS.push(i);
}
}
else if (page <= 3) {
CountS = [1, 2, 3, 4, 5];
}
else {
var si = page - 2;
var ei = page + 3
for (var i = si ; i < ei ; i++) {
CountS.push(i);
}
}
var htmla = ""
$.each(CountS, function (index, item) {
var cla = "pagea";
if (item == page) cla = "oncalass"
htmla += "<a href=\"javascript:;\" class=\"" + cla + " page_" + item + "\" onclick=\"PageClick('" + item + "')\">" + item + "</a>";
})
$(".pageBody").html(htmla)
}
function GetList() {
$("#List").html("");
var index = $("#index").val();//当前页
var ListCount = $("#ListCount").val();//总数量
var url = "{%#path%}?xmls=xmls/goods.xmls&method=GetList&index=" + index;
$.ajax({
type: 'GET', url: url, async: false, data: { ListCount: ListCount }, success: function (ret) {
var item = JSON.parse(ret)
if (item.ListCount != 0) {
$("#ListCount").val(item.ListCount);
$(".page").show()
} else {
$(".page").hide();
}
var json = JSON.parse(item.center);
$.each(json, function (index, item) {
var html = "";
html += '<tr>';
$("#List").append(html)
})
}
})
}