使用DisplayTag实现分页-优快云博客

使用diasplaytag组件。

使用mysql5, 有个数据表user,字段有id, username, password。

使用displaytag需导入displaytag-1.1.jar，和

commons-logging
commons-lang
commons-collections
commons-beanutils
log4j
itext (optional, for pdf/rtf export)

然后在JSP页面中放入<%@ taglib uri="http://displaytag.sf.net " prefix="display"%>

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.sql.*,java.util.*,test.User"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ taglib uri="http://displaytag.sf.net" prefix="display"%> <mce:style type="text/css" media="all"></mce:style><style type="text/css" media="all" mce_bogus="1"> @import url("css/screen.css");</style> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>分页测试2(使用diasplaytag组件)</title> </head> <% String driver = "com.mysql.jdbc.Driver"; String username = "root"; String password = "leng"; String url = "jdbc:mysql://localhost/test"; Connection conn = null; Statement stmt = null; ResultSet rs = null; Class.forName(driver); conn = DriverManager.getConnection(url, username, password); stmt = conn.createStatement(); String sql = "select * from user order by id asc"; rs = stmt.executeQuery(sql); List list = new ArrayList(); while(rs.next()){ User user = new User(rs.getInt("id"), rs.getString("username"), rs.getString("password")); list.add(user); } request.setAttribute("list",list); rs.close(); stmt.close(); conn.close(); %> <body> <center> <display:table name="list" pagesize="4" class="ITS" > <display:column property="username" title="用户名" sortable="true"/> <display:column property="password" title="密码" /> <display:column title="操作" > <a href="#" mce_href="#">修改</a>| <a href="#" mce_href="#">删除</a> </display:column> </display:table> </center> </body> </html>

例子程序中还用到了displaytag主页上的CSS，运行结果

页面显示中的"11 items found, displaying 1 to 4. [First/Prev] 1 , 2 , 3 [Next /Last ]"，可以通过修改displaytag.properties文件修改。

paging.banner.placement=both
paging.banner.items_name=条记录

paging.banner.no_items_found=没有 {0} 找到.
paging.banner.one_item_found=一条 {0} 找到.
paging.banner.all_items_found={0} {1} 找到, 显示所有 {2}.
paging.banner.some_items_found={0} {1} 找到, 显示 {2} 到 {3}.

paging.banner.full=[<a href="{1}">首页</a>/<a href="{2}">上一页</a>] {0} [<a href="{3}">下一页</a>/<a href="{4}">尾页</a>]
paging.banner.first=[首页/上一页] {0} [<a href="{3}">下一页</a>/<a href="{4}">尾页</a>]
paging.banner.last=[<a href="{1}">首页</a>/<a href="{2}">上一页</a>] {0} [下一页/尾页]
paging.banner.onepage={0}

paging.banner.page.selected={0}
paging.banner.page.link=<a href="{1}" title="Go to page {0}">{0}</a>
paging.banner.page.separator=, \

displaytag.properties中的中文字符需要转换成utf-8形式。