前台分页展示

前台jsp页面：

<script language="javascript" type="text/javascript">


function prePage(){ //前一页
	var curPage = parseInt(document.getElementById("curPage").value);
	var prePage = curPage -1;
	if(prePage < 1){
		alert("已经是首页了");
		return;
	}
	$.ajax({
		type: "get",
		dataType: "json",
		url: SetUrlRefresh("<%=request.getContextPath()%>/service/index_move_mxMV_dlmx1.jsp?curPage="+prePage),
		error: function(XmlHttpRequest, textStatus, errorThrown) {
		alert("数据获取失败");
	},
	success: function(d) {
		document.getElementById("curPage").value=prePage;
		switch (d.result) {
		case '0':
			alert(d.returnval);
			break;
		case '1':
			$("#move_mxMV_dlmx").setTemplateElement("mxMV_dlmx", null, { filter_data: false });
			$("#move_mxMV_dlmx").processTemplate(d);
			break;
		default:
			alert(d.result);
			break;
		}
	}
	});
}

// var curPage = 1;
var lastPage = 6;
function nextPage(){ //后一页
	var curPage = parseInt(document.getElementById("curPage").value);
	var lastPage = parseInt(document.getElementById("maxPage").value);
	if(curPage >= lastPage){
		alert("已经是尾页了");
		return;
	}
	var nextPage = curPage + 1;
	$.ajax({
		type: "get",
		dataType: "json",
		url: SetUrlRefresh("<%=request.getContextPath()%>/service/index_move_mxMV_dlmx1.jsp?curPage="+nextPage),
		error: function(XmlHttpRequest, textStatus, errorThrown) {
		alert("已经是尾页了");
	},
	success: function(d) {
		document.getElementById("maxPage").value=d.maxPage;
		document.getElementById("curPage").value=nextPage;
		switch (d.result) {
		case '0':
			alert(d.returnval);
			break;
		case '1':
			$("#move_mxMV_dlmx").setTemplateElement("mxMV_dlmx", null, { filter_data: false });
			$("#move_mxMV_dlmx").processTemplate(d);
			break;
		default:
			alert(d.result);
			break;
		}
	}
	});
}
</script>

//这里是一个table
<table align="center">
 <tr>
   <td align="right">
        <a href="javascript:prePage();" name="prePage">上一页</a>  
    <a href="javascript:nextPage();" name="nextPage" >下一页</a>
<input type="hidden" value="1" id="curPage"/>
<input type="hidden" value="" id="maxPage"/>
   </td>
 </tr>
</table>

这样一来  我们会 通过 Ajax 跳转到  另一个 jsp中， 那么这个jsp一定是进行数据查询的 代码如下：

<%@ page language="java" contentType="text/html;charset=utf-8"%>
<%@page import="com.turing.framework.dao.Dao"%>
<%@page import="com.turing.framework.dao.DaoImpl"%>
<%@page import="java.util.*"%>
<% Dao dao = new DaoImpl();  %>
<%
 int curPage = 1; //起始页
 int maxPage ; 
 int maxRowCount;  //最大页数
 int rowsPerPage = 35; // 每页显示最大也
 maxRowCount = dao.executeQueryForInt("select count(*) from ouou_starmv_mv");
 maxPage = (maxRowCount % rowsPerPage == 0) ? maxRowCount / rowsPerPage : maxRowCount / rowsPerPage + 1;
%>
<% 
java.util.List list = dao.executeQueryForList("select * from(select ff.*,rownum rr from (select * from ouou_starmv_mv pp where classid = 1 order by pp.createdate desc  )ff  )  where rr > "+(curPage-1) * rowsPerPage+" and rr <= "+curPage*rowsPerPage+" ");
java.util.Map map0 = (java.util.Map)list.get(0);
%>
{result:"1",table:[
{id :"1",minPic:"<%=map0.get("PICTURE")%>",name:"<%=map0.get("VIDEONAME")%>",video:"<%=map0.get("funnyvideo")%>",id :"<%=map0.get("IDX")%>"}
<%
if( list != null ){
for(int i=1;i<list.size();i++){
java.util.Map map = (java.util.Map)list.get(i);
%>
,{id :"1",minPic:"<%=map.get("PICTURE")%>",name:"<%=map.get("VIDEONAME")%>",video:"<%=map.get("funnyvideo")%>",id :"<%=map.get("IDX")%>"}
<%}} %>
]}