jsp实现斑马线分页案例

最新推荐文章于 2020-05-25 15:51:46 发布

原创最新推荐文章于 2020-05-25 15:51:46 发布 · 193 阅读

CC 4.0 BY-SA版权

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">

    <title>斑马线</title>
   <meta http-equiv="pragma" content="no-cache">
   <meta http-equiv="cache-control" content="no-cache">
   <meta http-equiv="expires" content="0">
   <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
   <meta http-equiv="description" content="This is my page">
   

</head>

<body>

<table name="score" border="1px black" class="mytable">

<tr>
<td>姓名</td><td>科目</td><td>分数</td>
</tr>

<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
ResultSet rsq = null;
int pageSize=2;
int pageNow=1;//默认显示第一页
int rowCount=0;//该值从数据库中查询
int pageCount=0;//该值是通过pageSize和rowCount
//接受用户希望显示的页数（pageNow）
String s_pageNow=request.getParameter("pageNow");
if(s_pageNow!=null){
//接收到了pageNow
pageNow=Integer.parseInt(s_pageNow);
}

try{
Class.forName("com.mysql.jdbc.Driver");
String dbUrl = "jdbc:mysql://localhost:3306/score?useUnicode=true&characterEncoding=UTF-8";
String dbUser = "root";
String dbPwd = "root";
con = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
out.print("mysql已连接。。。。。");

String sql="select count(*) from grade";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
out.print("ss");
if(rs.next()){
   rowCount=rs.getInt(1);
}
//计算pageCount
if(rowCount%pageSize==0){
pageCount=rowCount/pageSize;
}else{
pageCount=rowCount/pageSize+1;
}
//查询出需要显示的记录
String sql1="select * from grade order by fenshu desc limit "+(pageSize*(pageNow-1))+","+pageSize;
rsq=stmt.executeQuery(sql1);
int i=0;
while(rsq.next()){
   i+=1;
if(i%2==0){
%>

<tr bgcolor="yellow">
<td><%=rsq.getString("name") %></td>
<td><%=rsq.getString("kemu") %></td>
<td><%=rsq.getString("fenshu") %></td>
</tr>
<%
}
else{
%>
<tr bgcolor="red">
<td><%=rsq.getString("name") %></td>
<td><%=rsq.getString("kemu") %></td>
<td><%=rsq.getString("fenshu") %></td>
</tr>
<%
}}
}catch(Exception ex)
{
out.print("连接失败！！<br>"+ex.toString());
}

%>

</table>
<%
//上一页
if(pageNow!=1){
out.println("<a href=index.jsp?pageNow="+(pageNow-1)+">上一页</a>");
}
//显示超链接
for(int i=1;i<=pageCount;i++){
out.println("<a href=index.jsp?pageNow="+i+">["+i+"]</a>");
}
//下一页
if(pageNow!=pageCount){
out.println("<a href=index.jsp?pageNow="+(pageNow+1)+">下一页</a>");
}
%>

</body>
</html>