dwr分页（转）

在web.xml中配置DWRServlet如下：

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
    version="2.4" id="dwr">
  <display-name>DWR (Direct Web Remoting)</display-name>
  <description>A Simple Demo DWR</description>
  <servlet>
    <servlet-name>dwr-invoker</servlet-name>
    <servlet-class>org.directwebremoting.servlet.DwrServlet</servlet-class>
    <init-param>
      <param-name>debug</param-name>
      <param-value>true</param-value>
    </init-param>
  </servlet>
  <servlet>
    <servlet-name>action</servlet-name>
    <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
    <init-param>
      <param-name>config</param-name>
      <param-value>/WEB-INF/struts-config.xml</param-value>
    </init-param>
    <init-param>
      <param-name>debug</param-name>
      <param-value>3</param-value>
    </init-param>
    <init-param>
      <param-name>detail</param-name>
      <param-value>3</param-value>
    </init-param>
    <load-on-startup>0</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>dwr-invoker</servlet-name>
    <url-pattern>/dwr/*</url-pattern>
  </servlet-mapping>
  <servlet-mapping>
    <servlet-name>action</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>
    <jsp-config>
  <taglib>
    <taglib-uri>/tags/struts-bean</taglib-uri>
    <taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
  </taglib>

  <taglib>
    <taglib-uri>/tags/struts-html</taglib-uri>
    <taglib-location>/WEB-INF/struts-html.tld</taglib-location>
  </taglib>

  <taglib>
    <taglib-uri>/tags/struts-logic</taglib-uri>
    <taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
  </taglib>

  <taglib>
    <taglib-uri>/tags/struts-nested</taglib-uri>
    <taglib-location>/WEB-INF/struts-nested.tld</taglib-location>
  </taglib>

  <taglib>
    <taglib-uri>/tags/struts-tiles</taglib-uri>
    <taglib-location>/WEB-INF/struts-tiles.tld</taglib-location>
  </taglib>
  </jsp-config>
</web-app>

(2)在dwr.xml中配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dwr PUBLIC "-//GetAhead Limited//DTD Direct Web Remoting 2.0//EN" "http://getahead.org/dwr/dwr20.dtd">

<dwr>
    <allow>
         <create javascript="GetPages" creator="new">
               <param name="class" value="cn.com.project.GetPages"></param>
          </create>
           <convert converter="bean" match="cn.com.project.bean.TableGoodsOutputInfo" >
            <param name="include" value="goodsOutputName,goodsModel,goodsOutputTime"></param>
        </convert>
       
       <create creator="struts" javascript="testFrm">
          <param name="formBean" value="testActionForm"/>
          </create>

    </allow>
</dwr>

（3）GetPages类

package cn.com.project;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import cn.com.project.bean.TableGoodsOutputInfo;

public class GetPages ...{
     private int pages = 1;
     
     private int pageCount=20;
     
     public int getFirst(int page) ...{
          pages=page;
          return pages;
     }
     
     public int getNext(int page)...{
          if(page==pageCount)
          ...{
           return pageCount;
          }else...{
           pages=page;
           return pages+1;
          }
     }
     
     public int getUp(int page)
     ...{
      if(page==1)
      ...{
       return pages;
      }else
      ...{
       pages=page;
       return pages-1;
      }
     }
     
     public int getLast()
     ...{
      return pageCount;
     }
     
     @SuppressWarnings("unchecked")
     public List<cn.com.project.bean.TableGoodsOutputInfo> getJobs(int page,int argPage) throws Exception
     ...{
      List list=new ArrayList<TableGoodsOutputInfo>();
      String sql;
      try ...{
       if(page==1)
       ...{
        sql="select top "+argPage+" * from table_goods_input_info";
       }else...{
        sql="select top "+argPage+" * from table_goods_input_info where oder_form_id not in (select top (15*("+page+"-1)) oder_form_id from table_goods_input_info);";
       }
       TestConnction conn = new TestConnction();
       ResultSet rs=conn.excuteQuery(sql);
       while(rs.next())
       ...{
         TableGoodsOutputInfo pb=new TableGoodsOutputInfo();
        pb.setGoodsOutputName(rs.getString(3));
        pb.setGoodsModel(rs.getString(7));
        pb.setGoodsOutputTime(rs.getDate(8));
        list.add(pb);
       }
       conn.closeConnection(rs);
      } catch (SQLException e) 

评论

1 楼 wukele 2009-01-07