A very simple paging technology MySQL + JSP uses MySQL limit parameters

A very simple paging technologyMySQL+ JSP uses the MySQL limit parameter

Advantages: 1. I figured out 2. I used the MySQL database's own limit.

Disadvantage: only the next page function is implemented.

<%
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.exe cutequery (SQL );
While (RST. Next ()... {%>

<% = RST. getstring ("log_title") %> [

 

<% = RST. getstring ("log_posttime") %> |

<% = RST. getstring ("log_content") %>

<% }%>

Next page on the homepage </div>