欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  Java

使用Struts2实现列表显示和分页功能实例代码

程序员文章站 2022-04-16 14:45:29
...
BlogDAO.java文件

/** 根据条件(默认一张表所有数据)返回多条记录 */

public List<Blog> list(String kw,Integer pageCur,Integer pageSize) {  
    List<Blog> list = null;  
    Integer limitaInteger = (pageCur-1)*pageSize;  
    Integer limitbInteger = pageCur*pageSize;  
    Object[] params = {limitaInteger,limitbInteger};//代入的参数列表  
    String sqlWhere = "";  
    String sql = "select * from csdn_blog where first=1 ";  
    if(kw!=null && !kw.equals("")) {  
        sqlWhere = " and topic like '%"+kw+"%'";  
    }  
    sql += sqlWhere;  
    sql += " order by id desc limit ?,?";  
    ResultSetHandler<List<Blog>> rsh = new BeanListHandler<Blog>(Blog.class);//把结果集转成BeanList  
    try {  
        list = qr.query(getConn(), sql, rsh, params);   //调用查询接口的查询函数  
    } catch (SQLException e) {  
        e.printStackTrace();  
    }  
    return list;  
}

BlogActin.java文件

private Integer pagenum;//页码  private List<Blog> allblogs;  
//并提供set  get 方法public List<Blog> getAllblogs() {  
    return allblogs;  
}  
public void setAllblogs(List<Blog> allblogs) {  
    this.allblogs = allblogs;  
}  

public Integer getPagenum() {  
    return pagenum;  
}  
public void setPagenum(Integer pagenum) {  
    this.pagenum = pagenum;  
}

--------------列表方法

/** 显示博客列表信息 */   public String alllist() {  
    request=ServletActionContext.getRequest();  
    blogtopic=request.getParameter("blogtopic");  
    allblogs=blogDAO.list(blogtopic, pagenum, 10);  
    num_allblog=blogDAO.countAllNum(blogtopic);  
    num_allblogpage=num_allblog/10+1;  
    return "index";  
}

-----------JSP文件

<p class="content">  
    <c:forEach items="${allblogs}" var="allblog">  
        <p class="blog_list">  
        <h1><a href="#" class="category">[${allblog.topic}]</a>  
            <a name="11519817" href="Blog_getContent.action?id=${allblog.id}" target="_blank">${allblog.title}</a></h1>  
        <dl>  
        <dt><a href="#"><img src="img/oyuntaolianwu.jpg" alt="jackyvincefu"></a></dt>  
        <dd><p class="text_length"><pre>${allblog.content }</pre></p></dd></dl>  
        <p><p class="lable">  
            <a class="tag" href="#">C++</a><a class="tag" href="#" target="_blank">指针常量</a>  
            <a class="tag" href="#">常量指针</a><a class="tag" href="#" target="_blank">常量指针常量</a></p></p>  
        <p class="about_info">  
          <p align="left"><span class="fl">  
          <table width="535" border="0">  
              <tr>  
                <td width="254"><a href="#" target="_blank" class="user_name"><font size="-1">${allblog.writer}</font></a>  
                        <a href="Blog_getContent.action?id=${allblog.id}" target="_blank" class="view"><font size="-1">阅读(${allblog.reader})</font></a>  
                        <a href="Blog_getContent.action?id=${allblog.id}#lookcomment" target="_blank" class="comment"><font size="-1">评论(${allblog.discuss})</font></a></td>  
                <td width="271" align="right"><span class="time"><font size="-1">${allblog.time}</font></span></td>  
            
              </tr></table></span></p>  
        </p>  
    </p>  
    </c:forEach>  </p>  <p class="page_nav">  
      <span> ${num_allblog}条数据  共${num_allblogpage}页  </span>  
      <c:forEach  begin="1" end="${num_allblogpage}" var="pagenum">  
        [<a href="Blog_alllist.action?pagenum=${pagenum}">${pagenum}</a>]   
      </c:forEach>  
      <a href="Blog_alllist.action?pagenum=${pagenum+1}">  下一页  </a>   
      <a href="Blog_alllist.action?pagenum=${num_allblogpage}"> 尾页</a> </p>  </p>

以上就是使用Struts2实现列表显示和分页功能实例代码的详细内容,更多请关注其它相关文章!

相关标签: Struts