当前位置: 王朝网络 >> java/jsp >> Spring+Hibernate+Struts技术的一个分页程序，共享给大家

Spring+Hibernate+Struts技术的一个分页程序，共享给大家

王朝java/jsp·作者佚名 2006-01-09

我用的是Spring+Hibernate+Struts框架：

这是我的DAO的核心代码

import org.springframework.orm.hibernate.support.HibernateDaoSupport;

// 用Spring支持的Hibernate方法，使Hibernate对数据库的操作继续瘦身

public List getOfficeBySearchCriteria(final String hsql,final int pageNo,final int page_size) throws DataAccessException // hsql 是如："select office1 from Office as office1 order by office1.officename"；pageNo 是第几页；page_size是每页记录数

{

String sql;

int total_count=0;

List offices=new ArrayList();

//offices= getHibernateTemplate().find("from Office office1 where office1.officename like ?", "%"+officeName+"%");

offices= getHibernateTemplate().find(hsql); //为了得到总记录数

total_count=offices.size();

crossPageInfo= crossPageBean.getCrossPageInfo(total_count,pageNo,page_size);

sql=hsql+ " limit " + (pageNo-1)*page_size + "," +page_size;

offices= getHibernateTemplate().find(sql); //为了得到页记录信息 System.out.println("The list offices size: "+offices.size());

return offices;

}

//其中crossPageBean.getCrossPageInfo只是得到页面的如：总页数、供多少页的信息等一般的翻页信息；

我在Action中是这样调用的：

public ActionForward execute(

ActionMapping mapping,

ActionForm form,

HttpServletRequest request,

HttpServletResponse response)

throws Exception

{

CrossPageInfo crossPageInfo=new CrossPageInfo();

String hsql="select office1 from Office office1 order by office1.officename";

String pageNo=request.getParameter("pageNo");

int pageNoi=1;

if(pageNo==null)

pageNo="1";

pageNoi=Integer.parseInt(pageNo);

int pageSize=5;

//List offices=getOfficeService().getAllOffice();

List offices=getOfficeService().getOfficeBySearchCriteria(hsql,pageNoi,pageSize);

crossPageInfo=getOfficeService().getCrossPageInfo();

System.out.println("The CorssPgaeInfo :"+crossPageInfo.getPageNo());

System.out.println(crossPageInfo.getPageSize());

request.setAttribute("offices",offices);

request.setAttribute("pageInfo",crossPageInfo);

return mapping.findForward("success");

//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");

}

//其中getOfficeService()只是提供接口服务的方法。

我的表现页面是这样的：

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>

<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>

<%@ taglib uri="/WEB-INF/struts-template.tld" prefix="template" %>

<%@ page import="com.uplus.util.CrossPageInfo"%>

<html>

<head>

<title>

mySearchCList

</title>

</head>

<tr>

<td>OfficeName:<input name="officeName" type="text"></td><td><input type="submit" name="sb" value="Search"></td>

</tr>

</table>

</form>

<tr><td align="center">OfficeName</td><td align="center">OfficePhone</td></tr>

<logic:iterate id="office" name="offices" >

<td align="center"><a href="officesee.do?id=<bean:write name='office' property='id'/>" target="_blank"><bean:write name="office" property="officename"/></a></td>

<td align="center"><a href="officeedit.do?id=<bean:write name='office' property='id'/>" >Update </a>

<td align="center"><a href="officedel.do?id=<bean:write name='office' property='id'/>" onclick="return confirm('Would You Detele It? ')" >Delete </a>

</tr>

</logic:iterate>

</table>

<%CrossPageInfo cpInfo=(CrossPageInfo)request.getAttribute("pageInfo");%>

<td width=70%>Total <font color="blue"><%=cpInfo.getTotalRow()%></font>&items found,Total&<font color="blue"><%=cpInfo.getTotalPage()%></font> Pages,Current No <font color="blue"><%=cpInfo.getPageNo()%> </font>Page.

Go to <input name="pageNo" type="text" size="5" class="input">Page

</td></form>

<%if(cpInfo.getPageNo()>1){%>

&<a href="officelist.do?pageNo=1">

<%}%>First</a>

<%if(cpInfo.getPageNo()>1){ %>

&<a href="officelist.do?pageNo=<%=cpInfo.getPageNo()-1%>">

<%}%>Previous</a>

<%if(cpInfo.getPageNo()<cpInfo.getTotalPage()){ %>

&<a href="officelist.do?pageNo=<%=cpInfo.getPageNo()+1%>">

<%}%>Next</a>

<%if(cpInfo.getTotalPage()>cpInfo.getPageNo()){%>