nodejs数据库初始配置

npm install mysql

var mysql = require('mysql')
const pool = mysql.createPool({
    host: 'localhost',
    user: 'root',
    password: 'root',
    database: '数据库名',
    port: 3306,
})

var query = function(sql, callback) {
    pool.getConnection(function(err, conn) {
        if (err) {
            callback(err, null, null)
        } else {
            conn.query(sql, function(qerr, vals, fields) {
                //释放连接
                conn.release()
                    //事件驱动回调
                callback(qerr, vals, fields)
            })
        }
    })
}

module.exports = query

js文件

var db = require('../db/db.js')

class Administer {
    getcollection(collection) {
        return new Promise((resolve, reject) => {
            let sql = `select * from ${collection} `
            db(sql, function(err, vals, fields) {
                // console.log(vals)
                resolve(vals)
            })
        })
    }
}
let admin = new Administer()
module.exports = admin

在路由index.js文件中

//基于koa
var Router = require('koa-router')
var router = Router()
var admin = require('../model/admin.js')

var uploadfile = require('../public/js/uploadfile.js')

router.get('/admin/getorgadetail', async(ctx, res) => {
    ctx.body = await admin.getcollection('orgadetail')
})
module.exports = router//在app.js入口文件中引入