bootstrop分页ssm

最新推荐文章于 2024-10-12 09:00:04 发布

原创最新推荐文章于 2024-10-12 09:00:04 发布 · 422 阅读

0 ·

CC 4.0 BY-SA版权

springmvc ssm 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个基于Ajax的账单分页查询功能实现方法，包括异步数据加载、页面元素绑定及动态分页显示等内容。

//查询列表
function findForAjax(currentPage,userId) 
{
	$.ajax({
		url : "/bills/bill/findForAjax",
		data : {"currentPage": currentPage,"userId" : userId}, 
		type : "post",
		dataType : "json",
		async:false, // 如果为异步加载无法给分页标签绑定事件（执行js的时候ajax数据还未加载完成），如果用异步加载需要使用live动态绑定
		success : function (data)
		{
			dealData(data);
			dealTable(data);
			dealPage(data);
		},
		error : function(XMLHttpRequest, textStatus, errorThrown) 
		{
			alert(textStatus);
			stateCode(XMLHttpRequest);
		}
	});
}


   共
${totalCount}
条
第
${pageNo}
${pageNo}
页

//查询列表
function findForAjax(currentPage,userId) 
{
	$.ajax({
		url : "/bills/bill/findForAjax",
		data : {"currentPage": currentPage,"userId" : userId}, 
		type : "post",
		dataType : "json",
		async:false, // 如果为异步加载无法给分页标签绑定事件（执行js的时候ajax数据还未加载完成），如果用异步加载需要使用live动态绑定
		success : function (data)
		{
			dealData(data);
			dealTable(data);
			dealPage(data);
		},
		error : function(XMLHttpRequest, textStatus, errorThrown) 
		{
			alert(textStatus);
			stateCode(XMLHttpRequest);
		}
	});
}

// 页码展示
function dealPage(data) 
{
	var str = "";
	for ( var i = 1; i <= data.totalPage; i++) 
	{
		var strRed = "";
		var strOther = "";
		//str += ""+i+"
";
		if (i == data.currentPage) 
		{
			strRed = "
"+i+"
";
		}
		else
		{
			strOther = "
"+i+"
";
		}
		str = str + strRed + strOther;
	}
	var str1 = "
共
";
	var str2 = "
"+data.totalCount+"
";
	var str3 = "
条
";
	var str4 = "";
	var str5 = "";
	if (data.totalPage > 0)
	{
		str4 = "
第
";
		str5 = "
页
";
	}
	var strAll = str1 + str2 + str3 + str4 + str + str5; 
	$("#page").html(strAll);
}

// jquery实现动态绑定  分页
	$("#page").off("click").on("click","li[page = 'page']",function()
	{
		//alert("click");
		currentPage = $(this).attr("pageNo");
		findForAjax(currentPage,userId);
	});

// 用户账单总行数
			Integer totalCount = billsServiceImpl.findTotalConut(userId);
			
			// 开始行
			Integer startRow = null;
			
			if (currentPage == null) 
			{
				startRow = (Constant.bill.CURRENTPAGE - 1)*PAGESIZE;
			} 
			else 
			{
				// 开始行
				startRow = (currentPage - 1)*PAGESIZE;
			}
			
			// 总页数
			Integer totalPage = (totalCount % PAGESIZE == 0 ? totalCount/PAGESIZE : totalCount/PAGESIZE + 1);
			
			Map
   
     param = new HashMap
    
     ();
			param.put("userId", userId);
			param.put("start", startRow);
			param.put("pageSize", PAGESIZE);
			
			List
     
       bills = billsServiceImpl.findBillsForPage(param);
			model.put("bills", bills);
			model.put("totalCount", totalCount);
			model.put("pageSize", PAGESIZE);
			model.put("currentPage", currentPage);
			model.put("totalPage", totalPage);


		select b.*, t.id tid, t.name, t.userId from bills b, bill_type t where b.typeId = t.id and b.userId = #{userId} order by b.billTime desc limit #{start} , #{pageSize}