<%if(p<pc){%>
<a href="show.jsp?page=<%=p+1%>&txtnaa=<%=txtnaa%>&booktype=<%=booktype%>&type=<%=type%>&mode=<%=mode%>&jcount=<%=jcount%>&ordertype=<%=ordertype%>">下一页</a>
<%}if(p>1){%>
<a href="show.jsp?page=<%=p-1%>&txtnaa=<%=txtnaa%>&booktype=<%=booktype%>&type=<%=type%>&mode=<%=mode%>&jcount=<%=jcount%>&ordertype=<%=ordertype%>">上一页</a>
<a href="show.jsp?page=<%=p+1%>&txtnaa=<%=txtnaa%>&booktype=<%=booktype%>&type=<%=type%>&mode=<%=mode%>&jcount=<%=jcount%>&ordertype=<%=ordertype%>">下一页</a>
<%}if(p>1){%>
<a href="show.jsp?page=<%=p-1%>&txtnaa=<%=txtnaa%>&booktype=<%=booktype%>&type=<%=type%>&mode=<%=mode%>&jcount=<%=jcount%>&ordertype=<%=ordertype%>">上一页</a>
select top (页码-1)*页大小 tid from tb where 条件...)oracle:select t.* from (select t.*,t.rownum r from tb t) where r between m and nmysql:select t.* from tb limit m,n
oralce:select tb2.* from (select t.*,rownum r from tb t) tb2 where r between 3 and 5mysql:select t.* from tb t limit m,n