java jsp 百度分页_jsp页面数据分页模仿百度分页效果

数据分页

min-width: 34px;

height: 34px;

border: 1px solid #e1e2e3;

display:block;

margin:03px;float: left;

text-decoration: none;

text-align:center;

line-height: 34px;

}

.page a:HOVER {

background: #f2f8ff;

border: 1px solid #38f ;

}

.page a.prev{

width:90px;

}

.page span{

width: 34px;

height: 34px;

border: 1px solid transparent;

cursor: pointer;

display:block;float: left;

text-decoration: none;

text-align:center;

line-height: 34px;

cursor:default;

}

ID	姓名	年龄	专业

Connection conn=dbutil.getCon();//Connection conn = new DBUtil().getCon();

PreparedStatement pstmt1 = conn.prepareStatement("select count(*) from student");

ResultSet rs1=pstmt1.executeQuery();

rs1.next();int recordCount = rs1.getInt(1); //记录总数

int pageSize = 10; //每页记录数

int start=1; //显示开始页

int end=10; //显示结束页

int pageCount = recordCount%pageSize==0 ? recordCount/pageSize : recordCount/pageSize+1;int currPage = request.getParameter("p")==null ? 1 : Integer.parseInt(request.getParameter("p"));

currPage= currPage<1 ? 1: currPage;

currPage= currPage>pageCount ?pageCount : currPage;

PreparedStatement pst= conn.prepareStatement("select * from student limit ?,?");

pst.setInt(1,currPage*pageSize-pageSize);

pst.setInt(2,pageSize);

ResultSet rs=pst.executeQuery();while(rs.next()){%>

if(currPage>=7){

start=currPage-5;

end=currPage+4;

}if(start>(pageCount-10)){

start=pageCount-9;

}if(currPage>1){

out.print(String.format("首页",1));

out.print(String.format("<<上一页",currPage-1));

}for(int i=start;i<=end;i++){if(i>pageCount) break;

String pageinfo=String.format("%d",i,i);if(i==currPage){

pageinfo=String.format("%d",i);

}

out.print(pageinfo);

}if(currPage

out.print(String.format("下一页>>",currPage+1));

out.print(String.format("尾页",pageCount));

}%>