JSP分页2

来源：互联网发布：面向切面编程什么意思编辑：程序博客网时间：2024/06/06 08:36

使用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形式。