node.js - 当我的 nodejs 应用程序尝试与 SQL Server 连接时，控制台上没有显示任何内容，即使没有错误

Question

下面的代码属于index.js文件。

当我根据代码转到链接“localhost:300/admins/”时，它应该与 SQL Server 连接并在控制台上取回结果。

我的 Microsoft SQL Server Management Studio 2012 运行良好，并且从 Visual Studio 可以顺利运行。

const express = require('express');
const app = express();
const bodyParser = require('body-parser');
const path = require('path');
const hbs = require('hbs');
const sql = require('mssql');
const sqlConfig = {
  user: 'xxx',
  password: 'xxxx',
  database: 'xxxxx',
  server: '127.0.0.1',
  port: xxxx,
  pool: {
    max: 10,
    min: 0,
    idleTimeoutMillis: 30000,
  },
};

// static file's path set up
app.use(express.static('public'));
app.use('/css', express.static(__dirname + '/public'));
app.use('/images', express.static(__dirname + '/public'));
app.use('/js', express.static(__dirname + '/public'));

const pagespath = path.join(__dirname, './templates/views');
const partialspath = path.join(__dirname, './templates/partials');

// Set Views and view engine

app.set('view engine', 'hbs');
app.set('views', pagespath);
hbs.registerPartials(partialspath);

app.get('/', (req, res) => {
  res.render('home', { title: 'Home' });
});
app.get('/admins', function (req, res) {
  var result;
  async () => {
    try {
      const pool = await sql.ConnectionPool(config);
      const result = await pool.query`select name from tbl_info_p_admin`;
      res._write(result);
      console.log(result);
    } catch (err) {
      console.log(err);
    }
    await sql.close();
  };
  res.render('./admin/masters', { title: 'ADMIN' });
});

app.listen(process.env.PORT || 3000, function (err) {
  if (err) {
    console.log(err);
  } else {
    console.log('Server Started At Port 3000');
  }
});

标签： node.jssql-serverexpresssql-server-2012hbs

Answer 1

1. MSSQL 服务器连接配置。

   const config = {
     user: 'XX', // sql user
     password: 'xxxxxx', //sql user password
     server: '127.0.0.1', // if it does not work try- localhost
     database: 'xxxxxx',
     options: {
       trustServerCertificate: true,
       useColumnNames: true,        
       rowCollectionOnDone: true,
       trustedconnection: true,
       enableArithAbort: false,
       instancename: 'MSSQLSERVER',  // SQL Server instance name
       cryptoCredentialsDetails: {
          minVersion: 'TLSv1'
       },
     },
     port: 1433
   }
   module.exports = config;