curd操作-文章列表 · node.js开发web应用

# 修改/application/controllers/article.js增加文章列表查询方法 ``` var tools = require('../../libs/tools'); var config = require(tools.rootPath + 'config'); var { connection, pool, model } = require(tools.rootPath + 'libs/model'); var base = require(tools.controllerPath + 'common/base.js'); module.exports = class extends base { constructor() { super(); } async index(req, res) { //页码 var page = req.query.page || 1; page = parseInt(page); //分页 var pagesize = 2; var offset = (page - 1) * pagesize; //总页数 var total_page = Math.ceil(await model.value("select count(*) from article") / pagesize); //数据 var lst = await model.select(`SELECT * from article order by itemid desc limit ${offset},${pagesize}`); //加载模板并进行变量赋值 res.render(req.TPL, { data: lst, url: config.url, total_page: total_page, page: page }); } }; ``` # 编写对应模板文件/application/views/article/index.html ``` <!doctype html> <html> <head> <meta charset="utf-8"> <title>文章列表</title> </head> <body> <div style="text-align:center;"> <h2>文章列表 <span><a href="/article/add">添加</a></span></h2> <%=url%> <% if(data.length){ %> <table width="100%" border="1"> <tbody> <tr> <td>ID</td> <td>标题</td> <td>编辑</td> <td>删除</td> </tr> <% data.forEach(function(item){ %> <tr> <td><%=item.itemid%></td> <td><%=item.title%></td> <td><a href="/article/mod?itemid=<%=item.itemid%>">编辑</a></td> <td><a onClick="return confirm('确定要删除么？');" href="/article/del?itemid=<%=item.itemid%>">删除</a></td> </tr> <% }) %> </tbody> </table> <br> <div> <% var prev_page=page-1;if(prev_page<=1) prev_page=1 %> <% var next_page=page+1;if(next_page>=total_page) next_page=total_page %> <input type="button" value="上一页" onClick="location.href='/article/index?page=<%=prev_page%>'" <%if(page==1){%>disabled<%}%>> <% for(var i=1;i<=total_page;i++){ %> <input type="button" value="<%=i%>" onClick="location.href='/article/index?page=<%=i%>';" <%if(i==page){%>disabled<%}%>> <% } %> <input type="button" value="下一页" onClick="location.href='/article/index?page=<%=next_page%>'" <%if(page==total_page){%>disabled<%}%>> </div> <% } %> </div> </body> </html> ``` # 显示结果 ![](https://img.kancloud.cn/16/d9/16d9e562da259fdee4e182552ccb47fe_899x301.png)