node.js服务器发送各种类型数据

router.get("/getlist", (req, res) => {
    var tid = req.query.tid;
    if (!tid) {
        tid = 1;
    }
    var $pageNum = req.query.pageNum;
    if (!$pageNum) {
        $pageNum = 1;
    } else {
        $pageNum = $pageNum - 0;
    }
    //总条数
    var sql1 = 'SELECT tid FROM news where tid=?';

    function abc(a, b) {
        return new Promise(function (resolve, reject) {
            pool.query(a, b, (err, result) => {
                if (err) throw err;
                resolve(result);
            });
        });
    }

    function totalNum(a, b) {
        return new Promise(function (resolve, reject) {
            pool.query(a, b, (err, result) => {
                if (err) throw err;
                resolve(result.length);
            });
        });
    }

    function totalPageNum(a, b) {
        return new Promise(function (resolve, reject) {
            pool.query(a, b, (err, result) => {
                if (err) throw err;
                resolve(Math.ceil(result.length / 3));
            });
        });
    }

    //开始 = (当前的页码-1)*每页大小
    var offset = parseInt(($pageNum - 1) * 3);
    //每页大小
    var sql2 = 'SELECT nid,tid,title,author,updateTime,click,content,md FROM news LIMIT ?,?';

    //标签
    var sql3 = `select nid,tid,tag from tag where nid=2`;
    var sql4 = `select nid,tid,tag from tag where nid=11`;
    var sql5 = `select nid,tid,tag from tag where nid=16`;

    Promise.all([totalPageNum(sql1, [tid]), totalNum(sql1, [tid]), abc(sql2, [offset, 3]), abc(sql3, [offset, 3]), abc(sql4, [offset, 3]), abc(sql5, [offset, 3])])
        .then(data => {
            let asd = {
                pageNum: $pageNum,
                pageTotal: data[0],
                count: data[1],
                pageSize: 3,
                product: data[2],
                tags:{0:data[3],1:data[4],2:data[5]}
            }
            res.send(asd);
        }).catch(err => {
            console.log(err);
        })

})

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值