首先发泄一下啊,靠啊靠啊!高了将近一个星期,今天终于出了点小成果,最简单的JSP分页实现了,这次对我的自信心是个极大的打击啊,的确我一直以为我已经怎么怎么样了,靠还是个菜鸟啊!真是的,努力啊!费话少说啊,纯JSP分页代码如下啊:<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="gb2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head><body>
<form action="#">
<%
String sql="select * from news";
Connection conn=null;
Statement state=null;
ResultSet rs=null;
int pagesize=4;
int rowCount=0;
int pagecount;
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager
.getConnection(
"jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=gbk",
"root", "123456");
state=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=state.executeQuery(sql);
}catch(Exception e){
out.println("exception");
}
if(!rs.next()){
out.println("no records!");
}else{
rs.last();
rowCount=rs.getRow();
System.out.println(rowCount);
int showpage=1;
pagecount=((rowCount%pagesize)==0?(rowCount/pagesize):(rowCount/pagesize)+1);
String topage=request.getParameter("topage");
if(topage!=null){
showpage=Integer.parseInt(topage);
if(showpage>pagecount){
showpage=pagecount;
}
else if(showpage<=0){
showpage=1;}
}
rs.absolute((showpage-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
%>
<%=rs.getString(2) %>
<%=rs.getString(3) %>
<br>
<%if(!rs.next())
break;
}
%>
<a href="test.jsp?topage=<%=1%>">首页</a>
<a href="test.jsp?topage=<%=showpage-1%>">上一页</a>
<a href="test.jsp?topage=<%=showpage+1%>">下一页</a>
<a href="test.jsp?topage=<%=pagecount%>">最后一页</a>
<input type="topage" type="text" value="<%=showpage %>"%>页
<%
}
%>
</form> <br>
</body>
</html>
最近我几天都会研究一个更好的方法来实现,首先先应付一下了啊,呵呵!
jsp分页
最新推荐文章于 2024-07-10 01:10:22 发布