<%@pageimport="web09.shop.DBUtil"%>
<%@pageimport="java.sql.ResultSet"%>
<%@pageimport="java.sql.PreparedStatement"%>
<%@pageimport="java.sql.Connection"%>
<%@pagelanguage="java"pageEncoding="UTF-8"%>
<!DOCTYPEhtml>
<html>
<head>
<metacharset="UTF-8">
<title>数据分页</title>
<styletype="text/css">
.pagea{
min-width:34px;
height:34px;
border:1pxsolid#e1e2e3;
cursor:pointer;
display:block;
float:left;
text-decoration:none;
text-align:center;
line-height:34px;
}
.pagea:HOVER{
background:#f2f8ff;
border:1pxsolid#38f;
}
.pagea.prev{
width:50px;
}
.pagespan{
width:34px;
height:34px;
border:1pxsolidtransparent;
cursor:pointer;
display:block;
float:left;
text-decoration:none;
text-align:center;
line-height:34px;
cursor:default;
}
</style>
</head>
<body>
<tableclass="tt"border="1"align="center"width="80%"cellpadding="10">
<tr>
<th>ID</th>
<th>姓名</th>
<th>年龄</th>
<th>专业</th>
</tr>
<%
DBUtildbutil=newDBUtil();
Connectionconn=dbutil.getCon();
//Connectionconn=newDBUtil().getCon();
PreparedStatementpstmt1=conn.prepareStatement("selectcount(*)fromstudent");
ResultSetrs1=pstmt1.executeQuery();
rs1.next();
intrecordCount=rs1.getInt(1);//记录总数
intpageSize=10;//每页记录数
intstart=1;//显示开始页
intend=10;//显示结束页
intpageCount=recordCount%pageSize==0?recordCount/pageSize:recordCount/pageSize+1;
intcurrPage=request.getParameter("p")==null?1:Integer.parseInt(request.getParameter("p"));
currPage=currPage<1?1:currPage;
currPage=currPage>pageCount?pageCount:currPage;
PreparedStatementpst=conn.prepareStatement("select*fromstudentlimit?,?");
pst.setInt(1,currPage*pageSize-pageSize);
pst.setInt(2,pageSize);
ResultSetrs=pst.executeQuery();
while(rs.next()){
%>
<tralign="center">
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getInt("age")%></td>
<td><%=rs.getString(4)%></td>
</tr>
<%
}
%>
<tr>
<thcolspan="4"class="page">
<%
out.print(String.format("<aclass=\"prev\"href=\"?p=%d\">首页</a>",1));
if(currPage>=7){
start=currPage-5;
end=currPage+4;
}
if(start>(pageCount-10)){
start=pageCount-9;
}
if(currPage>1){
out.print(String.format("<aclass=\"prev\"href=\"?p=%d\">上一页</a>",currPage-1));
}
for(inti=start;i<=end;i++){
if(i>pageCount)break;
Stringpageinfo=String.format("<ahref=\"?p=%d\">%d</a>",i,i);
if(i==currPage){
pageinfo=String.format("<span>%d</span>",i);
}
out.print(pageinfo);
}
if(currPage<=pageCount){
out.print(String.format("<aclass=\"prev\"href=\"?p=%d\">下一页</a>",currPage+1));
}
out.print(String.format("<aclass=\"prev\"href=\"?p=%d\">尾页</a>",pageCount));
%>
</th>
</tr>
</table>
</body>
</html>
|