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) 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值