Html页面分页算法和后台与数据库的交互

Html页面分页算法和后台与数据库的交互

var pageTotal=1;

var lastPage="a1";

var infoType="";

var infoTypeList=null;

var timesNum=10; //每页显示的条数

indexAction.getInfoMaster(loginUserMap,{

async : false,

callback : function(data){

if(data!=null&&data.length!=0){

var html="";

pageTotal=data[0].pageTotal;

if(pageTotal<7){

if(pageTotal!=1){

html="

style='cursor:pointer;color:blue;'

onclick='pageClick(this)'>1   ";

for(var i=2;i

{

html+="

onclick='pageClick(this)'>"+i+"   ";

}

html+="

style='cursor:pointer;'

onclick='pageClick(this)'>"+pageTotal+"   ";

html+="

style='cursor:pointer;' onclick='pageClick(this)'>下一页";

}else{

html="";

}

document.getElementById("page").innerHTML=html;

}else{

html="

onclick='pageClick(this)'>1   ";

for(var i=2;i<5;i++)

{

html+="

onclick='pageClick(this)'>"+i+"   "; }

html+="

onclick='pageClick(this)'>5...";

html+="

onclick='pageClick(this)'>"+pageTotal+"   ";

html+="

style='cursor:pointer;' onclick='pageClick(this)'>下一页";

document.getElementById("page").innerHTML=html;

}

for(var i=0;i

{

html="";

if(data[i].THUMBNAIL_URL1!=null&&data[i].THUMBNAIL_URL1!=""&&data[i].THUMBNAIL_URL1!="null")

{

html="

src='<%=basePath%>"+data[i].THUMBNAIL_URL1+"'

width='176' height='99' />";

}else{

html="

width='176' height='99'' />";

}

document.getElementById("b"+i).innerHTML=html;

html="";

html="

name='d"+data[i].INFO_MASTER_ID+"'

href='javascript:void(0)'

onclick='infoChecked(this)'>

document.getElementById("b"+i+"0").innerHTML=html;

html="";

if(data[i].INFO_CONTENT!=null&&data[i].INFO_CONTENT!=""&&data[i].INFO_CONTENT!="")

{

html=stringChange(data[i].INFO_CONTENT,70);

}

document.getElementById("b"+i+"1").innerHTML=html;

html="";

if(data[i].ORG_NAME!=null&&data[i].ORG_NAME!=undefined&&data[i].ORG_NAME!=""&&data[i].ORG_NAME!="null")

if(data[i].ORG_NAME.length<9)

html=data[i].ORG_NAME+"   "; else

html=data[i].ORG_NAME.substring(0,8)+"...   ";

html+=data[i].PUBLISH_TIME.substring(0,10);

if(data[i].INFO_TYPE_S_NAME!=null&&data[i].INFO_TYPE_S_NAME!=""&&data[i].INFO_TYPE_S_NAME!="null")

html+="   "+data[i].INFO_TYPE_S_NAME;

document.getElementById("b"+i+"2").innerHTML=html;

html="";

if(data[i].COMMENT_TIMES==undefined||data[i].COMMENT_TIMES==""||data[i].COMMENT_TIMES==null||data[i].COMMENT_TIMES=="null")

data[i].COMMENT_TIMES="0";

if(data[i].SUPPORT_TIMES==undefined||data[i].SUPPORT_TIMES==""||data[i].SUPPORT_TIMES==null||data[i].SUPPORT_TIMES=="null")

data[i].SUPPORT_TIMES="0";

if(data[i].CLICK_TIMES==undefined||data[i].CLICK_TIMES==""||data[i].CLICK_TIMES==null||data[i].CLICK_TIMES=="null")

data[i].CLICK_TIMES="0";

html+="评价:"+data[i].COMMENT_TIMES+" 点赞:"+data[i].SUPPORT_TIMES+" 浏览:"+data[i].CLICK_TIMES;

document.getElementById("b"+i+"3").innerHTML=html;

}

if(data.length

$.each($('#b'+(data.length-1)).parent().nextAll(),

function () {

if($(this).hasClass("newsCell")||$(this).hasClass("line"))

$(this).attr("style","display:none");

});

$("div p").removeAttr("style");

}else{

$.each($('#b0').parent().nextAll(), function () {

if($(this).hasClass("newsCell")||$(this).hasClass("line"))

$(this).attr("style","display:none");

});

}

}

});

function pageClick(obj){

var id=0;

if(obj.id=="a0")

{

id="a"+(parseInt(lastPage.substring(1))-1);

}else if(obj.id=="a"+(pageTotal+1)){

id="a"+(parseInt(lastPage.substring(1))+1);

}else{

id=obj.id;

}

var html="";

//执行数据加载

var loginUserId='<%=loginUserId%>';

indexAction.getInfoMaster({num:10,pageNum:id.substring(1),loginUserId:loginUserId},{

async : false,

callback : function(data){

if(data!=null){

var html="";

for(var i=0;i

{

html="";

if(data[i].THUMBNAIL_URL1!=null&&data[i].THUMBNAIL_URL1!=""&&data[i].THUMBNAIL_URL1!="null")

{

html="

src='<%=basePath%>"+data[i].THUMBNAIL_URL1+"' width='176' height='99' />";

}else{

html="

width='176' height='99'' />";

}

/* $(html).appendTo($("#b"+i)); */

document.getElementById("b"+i).innerHTML=html;

html="";

html="

name='d"+data[i].INFO_MASTER_ID+"' href='javascript:void(0)'

onclick='infoChecked(this)'>

document.getElementById("b"+i+"0").innerHTML=html;