<hibernate-mapping>
<class name="com.gdcn.frame.Order" table="Orders">
<id name="orderID" type="long" unsaved-value="null" column="orderID">
<generator class="identity"/>
</id>
<property name="freight" type="float">
<column name="freight" />
</property>
<property name="shipName" type="string">
<column name="shipName" />
</property>
<property name="shipAddress" type="string">
<column name="shipAddress" />
</property>
<property name="shipCity" type="string">
<column name="shipCity" />
</property>
<property name="shipRegion" type="string">
<column name="shipRegion" />
</property>
<property name="shipPostalCode" type="string">
<column name="shipPostalCode" />
</property>
<property name="shipCountry" type="string">
<column name="shipCountry" />
</property>
</class>
</hibernate-mapping>
Pager.java
package com.gdcn.frame;
public class Pager {
private int totalRows; //總條數據
private int pageSize=IConstants.PAGE_NUMBER;//默認頁面條數據
private int currentPage;//當前頁
private int totalPages;//總共頁數
private int startRow; //從數據中取的開始條數據
public Pager(){}
public Pager(int _pageSize,int _totalRows)
{
if(_pageSize!=0)
pageSize=_pageSize;
totalRows=_totalRows;
totalPages=totalRows/pageSize;
int mod=totalRows%pageSize;
if(mod>0)
{
totalPages++;
}
currentPage=1;
startRow=0;
}
public void first()
{
currentPage=1;
startRow=0;
}
public void previous()
{
if(currentPage==1)
{
return;
}
currentPage--;
startRow=(currentPage-1)*pageSize;
}
public void next()
{
if(currentPage<totalPages)
{
currentPage++;
}
startRow=(currentPage-1)*pageSize;
}
public void last()
{
currentPage=totalPages;
startRow=(currentPage-1)*pageSize;
}
public void refresh(int _currentPage)
{
currentPage=_currentPage;
if(currentPage>totalPages)
{
last();
}
if(currentPage<=0)
{
first();
}
}
public void go(int _currentPage)
{
refresh( _currentPage);
startRow=(currentPage-1)*pageSize;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getStartRow() {
return startRow;
}
public void setStartRow(int startRow) {
this.startRow = startRow;
}
public int getTotalPages() {
return totalPages;
}
public void setTotalPages(int totalPages) {
this.totalPages = totalPages;
}
public int getTotalRows() {
return totalRows;
}
public void setTotalRows(int totalRows) {
this.totalRows = totalRows;
}
}
PagerHelper.java
package com.gdcn.frame;
import javax.servlet.http.HttpServletRequest;
public class PagerHelper {
public static Pager getPager(HttpServletRequest request,int totalRows)
{
Integer objInt=null;
//注意,這里有一個擴展,那就是頁面的條數據可以由用戶在頁面中自己定義.
//那么可以用rquest.getParameter("pageNumber")
//要使組件能使用,pageNumber要與開發人員約定好.
if(IConstants.FRAME_IS_FROM_SCREEN.equalsIgnoreCase("yes"))
{
//在登陸action中要設定screen的條數據
//也可以是記錄當前用戶的屏幕分辯率,然后再從IConstants或配置文件中去取中去取
objInt=(Integer)request.getSession().getAttribute("screen");
}
else
{
objInt=new Integer(IConstants.PAGE_NUMBER);
}
int pageSize=0;
if(objInt!=null)
pageSize=objInt.intValue();
Pager pager=new Pager(pageSize,totalRows);
//當前頁currentPage是由我們的taglib中定義的,他相當于頁面的一個關鍵字,就是說在頁面上
//不要定義與currentPage相同名字的控件
String currentPage=request.getParameter("currentPage");
if(currentPage==null||currentPage.equals(""))
{
currentPage="1";
}
if(currentPage!=null)
{
pager.refresh(Integer.parseInt(currentPage));
}
//當前頁pageMethod是由我們的taglib中定義的,他相當于頁面的一個關鍵字,就是說在頁面上
//不要定義與pageMethod相同名字的控件
String pagerMethod=request.getParameter("pageMethod");
if(pagerMethod!=null)
{
if(pagerMethod.equalsIgnoreCase("first"))
pager.first();
else if(pagerMethod.equalsIgnoreCase("previous"))
pager.previous();
else if(pagerMethod.equalsIgnoreCase("next"))
pager.next();
else if(pagerMethod.equalsIgnoreCase("last"))
pager.last();
else if(pagerMethod.equalsIgnoreCase("go"))
pager.go(Integer.parseInt(currentPage));
}
return pager;
}
}
TestAction.java
package com.gdcn.frame;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
public class TestAction extends org.apache.struts.action.Action{
public static final String FORWARD_CodeTypeList = "page111";
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception
{
TestDAO test=new TestDAO();
int rowsCodeType=test.getRows();
Pager pager=PagerHelper.getPager(request,rowsCodeType);
List pageTest=test.findObjectWithPage(pager.getPageSize(),pager.getStartRow());
System.out.println("hfghfgh====="+pageTest);
request.setAttribute("page",pageTest);
request.setAttribute("pager",pager);
return mapping.findForward(FORWARD_CodeTypeList);
}
}
TestDAO.java
package com.gdcn.frame;
import java.util.ArrayList;
import java.util.List;
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;
public class TestDAO {
public int getRows() {
String sql = "from Order as o";
FactoryFrameSession factoryFrameSession=new FactoryFrameSession();
Session session=null;
Transaction tx = null;
Query query=null;
List l=null;
try {
session=factoryFrameSession.getSession();
tx = session.beginTransaction();
query = session.createQuery(sql);
tx.commit();
l = query.list();
if (l == null || l.isEmpty()) {
return 0;
}
} catch (HibernateException e) {
factoryFrameSession.rollbackTransaction(tx);
e.printStackTrace();
}
finally
{
factoryFrameSession.closeSession(session);
}
return l.size();
}
public List findObjectWithPage(int pageSize, int startRow) {
FactoryFrameSession factoryFrameSession=new FactoryFrameSession();
List returnValue = new ArrayList();
Session session = null;
Transaction tx = null;
try {
session = factoryFrameSession.getSession();
tx = session.beginTransaction();
String query="from Order o where 1=1";
Query q = session.createQuery(query);
q.setFirstResult(startRow);
q.setMaxResults(pageSize);
returnValue = q.list();
tx.commit();
} catch (HibernateException ex) {
factoryFrameSession.rollbackTransaction(tx);
} finally {
factoryFrameSession.closeSession(session);
}
return returnValue;
}
}
bb.jsp
<%@ page contentType="text/html; charset=utf-8" language="java"%>
<!--引入系統中要用的類-->
<%@page import="java.util.*"%>
<%@page import="com.gdcn.frame.Order"%>
<%@taglib uri="/WEB-INF/gdcn.tld" prefix="gdcn"%>
<html>
<head>
<link href="<%=request.getContextPath()%>/main.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="<%=request.getContextPath()%>/public.js"></script>
<title>codeType_HELP_000002.htm</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body >
<form action="<%=request.getContextPath()%>/pageTest.do" method="post" name="codeTypeList" id="codeTypeList">
<% String tableStyle="width=\"100%\" border=\"1\" cellSpacing=\"0\" cellpadding=\"3\" bordercolorlight=\"#E2D7CF\" bordercolordark=\"#FAF8F6\"";
%>
<table <%=tableStyle%>>
<tr class="ListTableHeader">
<td colspan="7" ><div align="center"><strong>分頁示例</strong></div></td>
</tr>
</table>
<table <%=tableStyle%> id="codeTypeTable">
<%
List pages=(List)request.getAttribute("page");
System.out.println("pages==="+pages);
if(pages!=null&&!pages.isEmpty())
{
for(int i=0;i<pages.size();i++)
{
Order order=(Order)pages.get(i);
System.out.println(order.getShipAddress());
%>
<tr class=ListTableRow >
<td width="50%" >(<%=i+1%>)</td>
<td width="50%" ><%=order.getShipAddress()%></td>
</tr>
<%}
}
String action=request.getContextPath()+"/pageTest.do";
%>
<gdcn:dispartPage formId="codeTypeList" formAction="<%=action%>" pageNumId="pageNum" cols="2"/>
</table>
</form>
</body>
</html>
main.css
a:link{font-family: "Arial"; color:#000000;text-decoration:underline}
a:visited{font-family: "Arial"; color:#000000;text-decoration:underline}
a:hover{font-family: "Arial"; color:#000000;text-decoration:none}
a:active{font-family: "Arial";color:#000000;text-decoration:underline}
BODY{
background-color:#FAF8F6 ;
margin:0 0 0 0 ;
font-family: "Arial";
font-size:12px ;
SCROLLBAR-FACE-COLOR: #f6f6f6; SCROLLBAR-HIGHLIGHT-COLOR: #ffffff; SCROLLBAR-SHADOW-COLOR: #cccccc; SCROLLBAR-3DLIGHT-COLOR: #cccccc; SCROLLBAR-ARROW-COLOR: #330000; SCROLLBAR-TRACK-COLOR: #f6f6f6; SCROLLBAR-DARKSHADOW-COLOR: #ffffff;
}
td{
line-height:12px ;
font-family: "Arial";
font-size:12px ;
}
.Button2{
border:1px buttonhighlight outset;
background-image:url(../images/ButtonBg.gif);
height:18px ;
width:40px ;
padding-top:0px ;
color:#000099 ;
font-family: "Arial";
font-size:10px;
}
.Button3{
border:1px buttonhighlight outset;
background-image:url(../images/ButtonBg.gif);
height:22px ;
width:60px ;
padding-top:2px ;
color:#000099 ;
font-family: "Arial";
font-size:12px;
}
.Button4{
border:1px buttonhighlight outset;
background-image:url(../images/ButtonBg.gif);
height:22px ;
width:80px ;
padding-top:2px ;
color:#000099 ;
font-family: "Arial";
font-size:12px;
}
.Button5{
border:1px buttonhighlight outset;
background-image:url(../images/ButtonBg.gif);
height:22px ;
width:100px ;
padding-top:2px ;
color:#000099 ;
font-family: "Arial";
font-size:12px;
}
.Button6{
border:1px buttonhighlight outset;
background-image:url(../images/ButtonBg.gif);
height:22px ;
width:120px ;
padding-top:2px ;
color:#000099 ;
font-family: "Arial";
font-size:12px;
}
.ListTableHeader{
background-image:url(../images/ButtonBg.gif) ;
height:22px ;
font-family: "Arial";
font-size:12px ;
}
.ListTableRow{
height:12px ;
background-color:#FAF8F6 ;
color:#000000 ;
font-family: "Arial";
margin:0 0 0 0;
font-size:12px ;
}
.Row1{
height:22px ;
background-color:#e8e8e8 ;
color:#000000 ;
font-family: "Arial";
margin:0 0 0 0;
font-size:12px ;
cursor:hand ;
}
.Row2{
height:22px ;
background-color:#ffffff ;
color:#000000 ;
font-family: "Arial";
margin:0 0 0 0;
font-size:12px ;
cursor:hand ;
}
.Row{
height:10px ;
background-color:#ffffff ;
color:#000000 ;
font-family: "Arial";
margin:0 0 0 0;
font-size:12px ;
cursor:hand ;
}
.formStyleall {
BORDER-RIGHT: #7f7f7f 1px solid; BORDER-TOP: #7f7f7f 1px solid; FONT: 11px Verdana, Arial, Helvetica, sans-serif; BORDER-LEFT: #7f7f7f 1px solid; COLOR: #2f3f5f; BORDER-BOTTOM: #7f7f7f 1px solid; BACKGROUND-COLOR: #ffffff
}
.sort-arrow.descending {
background-image: url("../images/public/down.gif");
}
.sort-arrow.ascending {
background-image: url("../images/public/up.gif");
}
posted on 2008-01-24 13:58
李建軍 閱讀(319)
評論(0) 編輯 收藏 所屬分類:
struts