后台

  • SQL-NodeJs-post提交修改信息 前端

    SQL-NodeJs-post提交修改信息

    编辑保存婚礼请柬地址信息

    JavaScript
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    // 编辑婚礼信息
    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)
        }
    })

    2020年5月14日 109

  • SQL-NodeJs-删除留言

    删除当前这条留言数据

    JavaScript
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    // 删除留言板数据
    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)
        }
    })

     

    前端 2020年5月10日 131

  • SQL-NodeJs-修改留言状态（显示/隐藏）

    修改当前留言是否在用户端显示/隐藏

    JavaScript
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    // 留言板数据---更新留言显示隐藏
    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)
        }
    })

     

    前端 2020年5月10日 325
  • SQL-NodeJs-查询留言板数据---条件（全部/显示/隐藏）分页查询 前端

    SQL-NodeJs-查询留言板数据—条件（全部/显示/隐藏）分页查询

    nodejs分页查询留言信息

    JavaScript
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    // 查询留言板数据---条件（全部/显示/隐藏）分页查询
    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)
        }
    })

     

    2020年5月8日 540

联系我们

咨    询：点击这里给我发消息

邮    箱：cyt_web@163.com

小程序：AI前端