DWR(AJAX的一种Java实现)做的分页!!

最新推荐文章于 2024-07-17 15:06:37 发布

zengbo0710

最新推荐文章于 2024-07-17 15:06:37 发布

阅读量1.9k

点赞数

分类专栏： Struts+Spring+Hibernate DWR(AJAX) 文章标签： dwr ajax java javascript function callback

Struts+Spring+Hibernate 同时被 2 个专栏收录

69 篇文章 0 订阅

订阅专栏

DWR(AJAX)

45 篇文章 0 订阅

订阅专栏

DWR(AJAX的一种Java实现)做的分页!!

1.以下是dwr的配置

(1)在web.xml中配置DWRServlet如下：

<servlet>
         <servlet-name>dwr-invoker</servlet-name>
         <display-name>DWR Servlet</display-name>
         <description>Direct Web Remoter Servlet</description>
         <servlet-class>uk.ltd.getahead.dwr.DWRServlet</servlet-class>
         <init-param>
             <param-name>debug</param-name>
             <param-value>true</param-value>
         </init-param>
     </servlet>

     <servlet-mapping>
         <servlet-name>dwr-invoker</servlet-name>
         <url-pattern>/dwr/*</url-pattern>
     </servlet-mapping>

(2)在dwr.xml中配置

2.编写PageBean以存放要显示的数据

private String job_id;
private String job_desc;
private String min_lvl;
private String max_lvl;

3.编写getPage类实现分页,代码如下:

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(int page)
{
   return pageCount;
}
public List<PageBean> getJobs(int page)
{
   list=new ArrayList<PageBean>();
   String sql;
   con=connect.getCon();
   try {
    stm=con.createStatement();
    if(page==1)
    {
     sql="select top 5 * from jobs";
    }else
    {
     sql="select top 5 * from jobs where job_id not in (select top "+5*(page-1)+" job_id from jobs)";
    }
    rs=stm.executeQuery(sql);
    while(rs.next())
    {
     pb=new PageBean();
     pb.setJob_id(rs.getString("job_id").toString());
     pb.setJob_desc(rs.getString("job_desc").toString());
     pb.setMin_lvl(rs.getString("min_lvl").toString());
     pb.setMax_lvl(rs.getString("max_lvl").toString());
     list.add(pb);
    }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   return list;
}

4.新建个页面调用getPage类中的方法

<html>
   <head>
   <script type="text/javascript" src="dwr/util.js"></script>
   <script type="text/javascript" src="dwr/engine.js"></script>
   <script type="text/javascript" src="dwr/interface/GetPages.js"></script>
     <script type="text/javascript">
      var page=1;

      function first()
      {
       GetPages.getFirst(1,callback);
      }
      function callback(pages)
      {
       page=pages;
       GetPages.getJobs(pages,process);
      }
      function next()
      {
       GetPages.getNext(page,callback);
      }
      function up()
      {
       GetPages.getUp(page,callback);
      }
      function last()
      {
       GetPages.getLast(page,callback);
      }
      function process(item)
      {
       DWRUtil.removeAllRows("job");
        var cell=[
         function(item){return item.job_id},
         function(item){return item.job_desc},
         function(item){return item.min_lvl},
         function(item){return item.max_lvl}
        ];
        DWRUtil.addRows("job",item,cell);
      }

     </script>
   </head>

   <body οnlοad="javaScript:first();">
   <table border="1">
    <tbody id="job">

    </tbody>
   </table>
     <a href="javaScript:first()">第一页</a>  
     <a href="javaScript:up()">上一页</a>  
     <a href="javaScript:next()">下一页</a>  
     <a href="javaScript:last()">最后一页</a>  
   </body>
</html>

zengbo0710

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
DWR(AJAX的一种Java实现)做的分页!!

DWR(AJAX的一种Java实现)做的分页!!1.以下是dwr的配置(1)在web.xml中配置DWRServlet如下： dwr-invoker DWR Servlet Direct Web Remoter Servlet uk.ltd.getahead.dwr.DWRServlet
复制链接

扫一扫