koa2中使用的mysql总结

直接上代码：

router.get('/', async (ctx, next) => {
  await ctx.render('index', {
    title: 'Hello Koa 2!'
  })
})

router.get('/string', async (ctx, next) => {
  let ev = 1;
  let age = 60
  /**条件查询 */
  sql.query(`select id from user where id=${ev}&&age=${age}`, (err, result) => {
    console.log(result, err, '-----------addd');
  })
  ctx.body = 'koa2 s tring'
})

router.get('/json', async (ctx, next) => {
  let obj = {
    id: 2,
    name: '锦瑟',
    age: 28
  }
  /**查询修改 */
  sql.query(`UPDATE user SET name='${obj.name}' where id=${obj.id}`, (error, result) => {
    console.log(error, 'error--------------');
    console.log(result, 'result');
  })
  ctx.body = {
    title: 'koa2 json'
  }
})

router.get('/test', async (ctx, next) => {
  let obj = {
    id: 3,
    name: '刘能',
    age: 88
  }
  /**插入 */
  sql.query(`INSERT INTO user (id, name, age) VALUES (${obj.id},'${obj.name}', ${obj.age})`, (error,result) => {
    console.log(error, '错误信息');
    console.log(result, '信息');
  })
  ctx.body = {
    title: '测试'
  }
})

router.get('/ot', async (ctx, next) => {
  /**删除 */
  let id = 3;
  sql.query(`DELETE FROM user WHERE id='${id}'`, (error,result) => {
    console.log(error, '错误信息');
    console.log(result, '信息');
  })
  ctx.body = {
    title: '删除'
  }
})

module.exports = router