Fichier BlogDAO.java
/**Renvoie plusieurs enregistrements en fonction des conditions (par défaut, toutes les données dans une seule table)*/
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; }
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"; }
<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 class="brush:php;toolbar:false">${allblog.content }
${allblog.writer}
阅读(${allblog.reader})
评论(${allblog.discuss})
${allblog.time}
${num_allblog}条数据 共${num_allblogpage}页
Ce qui précède est le contenu détaillé de. pour plus d'informations, suivez d'autres articles connexes sur le site Web de PHP en chinois!