输出导航条

最新推荐文章于 2024-10-09 11:36:19 发布

最新推荐文章于 2024-10-09 11:36:19 发布 · 122 阅读

文章标签：

#Hibernate #JSP

hibernate 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一个基于Hibernate的导航条分页插件实现方法，该插件可以根据传入的Session对象、HQL查询语句及当前页数等参数生成导航条。插件支持单参数或多参数网页跳转，并能自动计算总页数与记录数。

[code]/**
* <p>
* 输出导航条
* </p>
*
* @author chenwei
* @param ses:org.hibernate.Session对象
* @param HQLsql:HQL语句
* @param page:当前页数
* @param pageSize:每页的记录数
* @param webpage:显示的页面[若带多个参数,可以这样写 a.jsp?r=XX&t=xx ]
* @return java.lang.String
* @throws SessionFactoryException
*/
public String turnpageBar(Session ses, String HQLsql, int page,
int pageSize, String webpage) {
// 总页数
int pageCount = 0;
// 总记录数
int recordCount = 0;

// 是否带多个参数
boolean moreParam = webpage.indexOf("?") == -1 ? false : true;

StringBuffer scriptStr = new StringBuffer();
scriptStr.append("<script language=\"javascript\">");
scriptStr.append("function change(objid){");
scriptStr.append("var p=document.getElementById(objid).value;");
if (!moreParam)
scriptStr.append("window.location=\"" + webpage + "?page=\"+p;");
else
scriptStr.append("window.location=\"" + webpage + "&page=\"+p;");
scriptStr.append("}</script>");

StringBuffer sb = new StringBuffer(scriptStr.toString());

Transaction tran = null;

tran = ses.beginTransaction();
java.util.List list = ses.createQuery(HQLsql).list();
tran.commit();
ses.close();
if (list != null && list.size() > 0)
recordCount = list.size();
if (recordCount == 0)
return "<font color=\"red\">没有记录</font>";
else {
pageCount = recordCount % pageSize == 0 ? recordCount / pageSize
: recordCount / pageSize + 1;
sb.append("第" + page + "页/共" + pageCount + "页  ");
sb.append("共" + recordCount + "条记录每页" + pageSize
+ "条记录  ");
if (!moreParam)
sb.append("<a href=\"" + webpage + "?page=1\">首页</a> ");
else
sb.append("<a href=\"" + webpage + "&page=1\">首页</a> ");
if (page > 1) {
if (!moreParam)
sb.append("<a href=\"" + webpage + "?page=" + (page - 1)
+ "\">上一页</a> ");
else
sb.append("<a href=\"" + webpage + "&page=" + (page - 1)
+ "\">上一页</a> ");
} else
sb.append("上一页 ");
if (page < pageCount) {
if (!moreParam)
sb.append("<a href=\"" + webpage + "?page=" + (page + 1)
+ "\">下一页</a> ");
else
sb.append("<a href=\"" + webpage + "&page=" + (page + 1)
+ "\">下一页</a> ");
} else
sb.append("下一页 ");

if(!moreParam)
sb.append("<a href=\"" + webpage + "?page=" + pageCount
+ "\">尾页</a>  ");
else
sb.append("<a href=\"" + webpage + "&page=" + pageCount
+ "\">尾页</a>  ");

StringBuffer select = new StringBuffer("转到第");
select.append("<select id=\"sel\" onchange=\"change('sel')\">");
for (int i = 1; i <= pageCount; i++) {
if (page == i)
select.append("<option value=\"" + i
+ "\" selected=\"selected\">" + i + "</option>");
else
select.append("<option value=\"" + i + "\">" + i
+ "</option>");
}
select.append("</select>页");

sb.append(select.toString());
return sb.toString();
}
}[/code]