koa2項(xiàng)目怎么連接兩個(gè)數(shù)據(jù)庫，一個(gè)數(shù)據(jù)庫存的是網(wǎng)站的配置，另一個(gè)數(shù)據(jù)庫存的是業(yè)務(wù)數(shù)據(jù)

創(chuàng)建兩個(gè)數(shù)據(jù)庫連接就行了, 如下路由代碼

const router = require('koa-router')();
const mysql = require('mysql2/promise');
const configDb = mysql.createConnection({
    host: '192.168.3.56',
    user: 'config',
    database: 'config',
    Promise: Promise
});
const bizDb = mysql.createConnection({
    host: '192.168.3.78',
    user: 'biz',
    database: 'biz',
    Promise: Promise
});

router.get('/', async function(ctx, next) {
    let [configRows, configFields] = await configDb.execute('select * from config');
    let [bizRows, bizFields] = await bizDb.execute('select * from table');

    ctx.body = JSON.stringify([configRows, bizRows]);
});

module.exports = router;

可以將兩個(gè)數(shù)據(jù)庫連接提到共通目錄中，然后引用