koa.js连接MySQL ,nodejs

源码地址：https://github.com/wangshufen/Problem

 

• 配置mysql

//sqlConfig.js
module.exports = {
    mysql: {
        host: '10.1.43.87',
        port:'3306',
        user: 'root',
        password: '123456',
        database: 'problem'
    }
}

• 连接数据库

// server/db.js
const mysql = require('mysql');
const config = require('./mysql_config');
const conn = mysql.createConnection(config.mysql);

let pool=mysql.createPool(config.mysql);


let query = (sql, params) => {

    return new Promise((resolve, reject) => {
        pool.getConnection(function (err, conn) {//设置连接池 
            if (err) {
                //callback(err, null, null);
                throw err;
            } else {
                console.log('mysql 连接成功');

                conn.query(sql, params, (error, result, fields) => {
                    if (error) {
                        reject(error);
                    } else {
                        conn.release();
                      //  console.log(result);
                        resolve(result);
                    }
                })
            }
        })
    })

}
//关闭连接
//conn.end();
module.exports = { conn, query};

• 启动服务

const Koa = require('koa')

app.listen(3000);
console.log('listen at 3000');