使用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实现列表显示和分页功能实例代码的详细内容,更多请关注其它相关文章!