后台
SQL-NodeJs-post提交修改信息
编辑保存婚礼请柬地址信息
1234567891011121314151617181920212223// 编辑婚礼信息router.post('/editInformation', async (req, res, next) => {let {names,time,seating,address,latAndLng,welcome,phoneMale,phoneFemale} = req.body;try {let message = await querySql('update informations set names=?,time=?,seating=?,address=?,latAndLng=?,welcome=?,phoneMale=?,phoneFemale=?', [names, time, seating, address, latAndLng, welcome, phoneMale, phoneFemale]);res.send({code: message.affectedRows ? 200 : 100,msg: message.affectedRows ? '保存成功!' : '保存失败!',})} catch (e) {console.log(e)next(e)}})SQL-NodeJs-删除留言
删除当前这条留言数据
12345678910111213141516// 删除留言板数据router.post('/deleteMessage', async (req, res, next) => {let {id} = req.body;try {let message = await querySql('delete from message where id=?', [id]);res.send({code: message.affectedRows ? 200:100,msg: message.affectedRows ? '删除成功!' : '删除失败!',})} catch (e) {console.log(e)next(e)}})SQL-NodeJs-修改留言状态(显示/隐藏)
修改当前留言是否在用户端显示/隐藏
12345678910111213141516171819// 留言板数据---更新留言显示隐藏router.post('/updateMessage', async (req, res, next) => {let {id,state} = req.body;try {let message = await querySql('update message set state=? where id=?', [state, id]);// message.affectedRows为1时代表数据库有受到影响行数表示操作成功res.send({code: message.affectedRows ? 200 : 100,msg: message.affectedRows ? '恭喜修改状态成功!' : '修改状态失败!',})} catch (e) {console.log(e)next(e)}})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)}})