var currentPage=(req.query.pagenum - 1) * req.query.pagesize;
//定义查询分类列表数据的sql语句
const sql= `
select *,name as 'cate_name' from
ev_articles join ev_article_cate on ev_articles.cate_id = ev_article_cate.id
where ev_articles.is_delete=0 order by ev_articles.Id ASC
limit ${currentPage} ,${req.query.pagesize}`
版权声明:本文为weixin_45932157原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。