dwr(ajax)分页

最新推荐文章于 2024-06-17 06:24:21 发布

jameswsy

最新推荐文章于 2024-06-17 06:24:21 发布

阅读量317

点赞数

分类专栏： dwr(Ajax)+Jsp 文章标签： dwr ajax javascript function callback string

dwr(Ajax)+Jsp 专栏收录该内容

1 篇文章 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>

5.输入如下地址:http://localhost:8080/page/

效果如下

jameswsy

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
dwr(ajax)分页

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

扫一扫