node mssql

参考 https://www.npmjs.com/package/mssql

1 安装 

npm install mssql

2 数据库连接

mssqlSql.js

const mssql = require("mssql");
const config = {
    mssql:{
      user: 'sa',
      password: '123',
      server: '192.168.1.1',
      database: 'test'
    }
}

// connect to your database
const MSSQL = mssql.connect(config.mssql, function (err) {
    if (err) {
        console.log(err);
        appLogger.error(err);
    } else {
        infoLogger.info("连接SQLSever成功");
    }
});

module.exports = MSSQL;

3 数据库操作

 const result = await MSSQL.query`INSERT INTO USER(USERIDCODE) values(${teacherId})`;