sql
SQL-NodeJs-查询留言板数据—条件（全部/显示/隐藏）分页查询
nodejs分页查询留言信息
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051// 查询留言板数据---条件（全部/显示/隐藏）分页查询router.post('/getMessage', async (req, res, next) => {let {type,pageNo,pageSize} = req.body;pageNo = pageNo - 1;try {let totalAll, totalDisplay, totalHide, message, state = true;if (type == 'all') {totalAll = await querySql('select COUNT(*) from message');totalDisplay = await querySql('select COUNT(*) from message where state = ?', [state]);if (state) {totalDisplay = totalDisplay[0]['COUNT(*)'];totalHide = totalAll[0]['COUNT(*)'] - totalDisplay;} else {totalHide = totalDisplay[0]['COUNT(*)'];totalDisplay = totalAll[0]['COUNT(*)'] - totalHide;}message = await querySql('select * from message order by id desc limit ?,?', [pageNo, pageSize]);} else {// 查询显示、隐藏state = type == 'display' ? true : false;totalAll = await querySql('select COUNT(*) from message');totalDisplay = await querySql('select COUNT(*) from message where state = ?', [state]);if (state) {totalDisplay = totalDisplay[0]['COUNT(*)'];totalHide = totalAll[0]['COUNT(*)'] - totalDisplay;} else {totalHide = totalDisplay[0]['COUNT(*)'];totalDisplay = totalAll[0]['COUNT(*)'] - totalHide;}message = await querySql('select * from message where state = ? order by id desc limit ?,?', [state, pageNo, pageSize]);}res.send({code: 200,msg: '成功',pageNo: pageNo + 1,pageSize,totalAll: totalAll[0]['COUNT(*)'], //全部留言数量totalDisplay, //显示的留言-总数量totalHide, //隐藏的留言-总数量type, //全部、显示、隐藏data: message})} catch (e) {console.log(e)next(e)}})
