koa框架连接mysql数据库

1.根目录创建config/default.js文件

1.1写入数据库配置

const database = {
  HOST: 'localhost', //数据库地址
  USER: 'root',
  PASSWORD: '123456',
  DATABASE: 'shop'    //数据库名称
}
module.exports = { database}

2.根目录下新建db/mysql.js文件

2.1安装mysql依赖

npm install mysql -S

2.2连接数据库

const mysql = require('mysql')
const { database } = require('../config/default')

const pool = mysql.createPool({
  host: database.HOST,
  user: database.USER,
  password: database.PASSWORD,
  database: database.DATABASE
})

exports.query = function (sql, values) {
  return new Promise((resolve, reject) => {
    pool.getConnection(function (err, connection) {
      if (err) {
        reject(err)
        //console.log(err, "数据库连接失败");
        resolve({
          code: 500,
        })
      } else {
        //console.log("数据库连接成功");
        connection.query(sql, values, (err, results) => {
          if (err) {
            reject(err)
            resolve({
              code: 400
            })
          } else {

            resolve({
              code: 200,
              results,
            })
            connection.release()
            //resolve(rows)
          }
          //connection.release() // 释放连接池
        })
      }
    })
  })
}

3.导入连接配置并使用

这里正常写sql语句就可以查询了

const db = require('../db/mysql')

class CommonModel {
  async getUserByName (username) {
    return await db.query(`select * from shop.s_users where username='${username}'`)
  }
  async getUserById (id) {
    return await db.query(`select * from shop.s_users where id='${id}'`)
  }
}

module.exports = new CommonModel()