一个非常简单的分页技术MYSQL+JSP 利用了mysql的LIMIT参数
优点:1自己想出来的 2利用了MYSQL 数据库的本身 LIMIT
缺点:现在仅仅实现了 下一个页面功能
<%
int cateID = 0 ;
if (request.getParameter( " cateID " ) == null )
... {cateID=0;}
else ... {
cateID=Integer.parseInt(request.getParameter("cateID"));
}
int next_page = cateID + 1 ;
int per_page = 5 ;
int pagenum = (cateID * per_page) + 1 ;
if (cateID == 0 ) ... {
sql="select * from BLOG_CONTENT where log_IsTop=0 order by log_ID desc LIMIT 0,"+per_page+" ";
} else ... {
sql="select * from BLOG_CONTENT where log_IsTop=0 order by log_ID desc LIMIT "+pagenum+","+per_page+"";
}
rst = stmt.executeQuery(sql);
while (rst.next()) ... { %>
<div class="content_head"><img src="images/weather/0.gif" alt="" align="absmiddle">
<%=rst.getString("log_Title")%> [
<%=rst.getString("log_PostTime")%> |
<br>
<%=rst.getString("log_Content")%><br>
<br>
<%} %>
< div class = " content_head " align = " right " >< a href = " default.jsp " > 回首页 </ a > < a href = " default.jsp?cateID=<%=next_page%> " > 下一页 </ a ></ div >
< span class = " smalltxt " ></ span ></ td >
</ tr ></ table >
</ td >
</ tr >
</ table >
int cateID = 0 ;
if (request.getParameter( " cateID " ) == null )
... {cateID=0;}
else ... {
cateID=Integer.parseInt(request.getParameter("cateID"));
}
int next_page = cateID + 1 ;
int per_page = 5 ;
int pagenum = (cateID * per_page) + 1 ;
if (cateID == 0 ) ... {
sql="select * from BLOG_CONTENT where log_IsTop=0 order by log_ID desc LIMIT 0,"+per_page+" ";
} else ... {
sql="select * from BLOG_CONTENT where log_IsTop=0 order by log_ID desc LIMIT "+pagenum+","+per_page+"";
}
rst = stmt.executeQuery(sql);
while (rst.next()) ... { %>
<div class="content_head"><img src="images/weather/0.gif" alt="" align="absmiddle">
<%=rst.getString("log_Title")%> [
<%=rst.getString("log_PostTime")%> |
<br>
<%=rst.getString("log_Content")%><br>
<br>
<%} %>
< div class = " content_head " align = " right " >< a href = " default.jsp " > 回首页 </ a > < a href = " default.jsp?cateID=<%=next_page%> " > 下一页 </ a ></ div >
< span class = " smalltxt " ></ span ></ td >
</ tr ></ table >
</ td >
</ tr >
</ table >