分页操作代码,Java代码库,德仔网

代码语言

代码分类

【Java】分页操作

作者:高国清 / 发布于2014/7/7/ 266


	public List getList(int page, int size) throws Exception {
	 String sql = "select * from table order by id desc limit ?,?";
	 Connection conn = DBUtil.getConnection();
	 PreparedStatement pst = conn.prepareStatement(sql);
	 int begin = (page - 1) * size;
	 pst.setInt(1, begin);//
	 pst.setInt(2, size);//
	 ResultSet rs = pst.executeQuery();
	 List list = new ArrayList();

	 while (rs.next()) {
	 X x = new X();
	 x.setId(rs.getInt("id"));
	
	 list.add(x);

	 }
	 conn.close();

	 return list;
	}

	-----------------------------------------------------
	统计最大页数
	public int countMaxPage(int size, String tablename) throws Exception {
	 String sql = "select count(*) from " + tablename;
	 Connection conn = DBUtil.getConnection();
	 PreparedStatement pst = conn.prepareStatement(sql);
	 ResultSet rs = pst.executeQuery();
	 rs.next();
	 int total = rs.getInt(1);//
	 DBUtil.close();
	 int maxPage = 1;
	 if (total % size == 0) {
	 maxPage = total / size;//
	 } else {
	 maxPage = total / size + 1;//
	 }
	 return maxPage;
	}
	---------------------------------------------------------
	jap中填写
	<a href="list.action?page=1">第一页</a>
	
	 <s:if test="page > 1">
	 <a href="list.action?page=${page-1 }">上一页</a>
	 </s:if>
	 <s:else>
	 <a>上一页</a>
	 </s:else>

	 <s:if test="page < maxPage">
	 <a href="list.action?page=${page+1 }">下一页</a>
	 </s:if>
	 <s:else>
	 <a>下一页</a>
	 </s:else>
	 <a href="list.action?page=${maxPage }">最后一页</a> 当前 ${page } |
	 ${maxPage }页

试试其它关键字

　分页　

同语言下

可能有用的

高国清贡献的其它代码(3)