mysql koa2的分页查询_koa+ mysql 怎么写分页接口给vue，如下图和代码

mysql.js

// 查找所有用户

let findAllUserData = () =>{

let _sql = `select * from users;`

return query(_sql)

}

module.exports ={

findAllUserData

}

koa

const userModel = require('../lib/mysql.js');

router.get('/findUser',async(ctx,next) => {

await userModel.findAllUserData()

.then(result => {

ctx.body ={

code: 200,

msg: '查询所有数据成功',

data: result

}

});

});

vue

getData() {

axios

.get("http://localhost:3000/findUser")

.then(response => {

console.log(response)

this.userData = response.data.data;

})

.catch(error => {

console.log(error);

});

},