81,114
社区成员
发帖
与我相关
我的任务
分享<body>
<%
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/news");
Connection con = ds.getConnection();
%>
<%
NewsManager nm = new NewsManager();
int pageSize = 5; //每页显示条数
nm.getConn(con);
int totalpages= nm.getTotalPage("select count(*) from test",pageSize); //最大页数
String currentPage = request.getParameter("pageIndex");
if(currentPage == null )
{
currentPage = "1" ;
}
int pageIndex = Integer.parseInt(currentPage);
if(pageIndex <1)
{
pageIndex =1 ;
}
else if(pageIndex >totalpages )
{
pageIndex = totalpages;
}
//out.println(pageSize*pageIndex +" "+ pageSize*(pageIndex-1));
String sql = "select * from ( select rownum as r ,t.* from ("+
"select test.* from test order by id desc) t"+" where rownum<="+
pageSize*pageIndex+") where r >"+pageSize*(pageIndex-1);
//out.println(sql);
List<Map> list = nm.display(sql);
%>
<ul>
<%
for( int i = 0 ; i <list.size() ; i++)
{
Map<String ,String> map = new HashMap<String ,String>();
map = list.get(i);
%>
<li>
<%
out.println(map.get("name"));
%>
</li>
<%
}
%>
</ul>
<%
if(pageIndex >1 )
{
%>
<a href="index.jsp?pageIndex=1">首页</a>
<a href="index.jsp?pageIndex=<%=pageIndex -1 %>">上一页</a>
<%
}
if(pageIndex <totalpages )
{
%>
<a href="index.jsp?pageIndex=<%=pageIndex +1 %>">下一页</a>
<a href="index.jsp?pageIndex=<%=totalpages %>">末页</a>
<%
}
%>
</body><button onclick="javascript:window.location='NewsList.jsp?cp=<%=currentPage + 1%>'">下一页</button>