sql-server - 如何使用 node.js 从 MSSQL 中插入和获取数据

Question

如何使用mssql和node.js获取信息并输入信息。很多教程都以不同的方式教授，我想学习使用我的代码，因为我已经学会了为我的 express 实现数据库node.js。谢谢你的帮助！

//Database
var myDatabase = require('./public/js/database')
var expressSession = require('express-session');
var SessionStore = require('express-session-sequelize')(expressSession.Store);
var sequelizeSessionStore = new SessionStore({
    db: myDatabase.sequelize,
});

//Database.js
var Sequelize = require('sequelize');
var sequelizeTransforms = require('sequelize-transforms');

const sequelize =new Sequelize({
    dialect: 'mssql',
    dialectModulePath: 'tedious',
    dialectOptions: {
      driver: 'SQL Server Native Client 11.0',
      instanceName: 'SQLEXPRESS02'
    },
    host: 'localhost',
    username: 'shoppingCart',
    password: '12september2012',
    database: 'shoppingCart',
    pool: {
        min: 0,
        max: 10,
        idle: 10000
      }
  });

sequelize.authenticate().then(() => {
    console.log('Connection has been established successfully.');
}).catch(err => {
    console.error('Unable to connect to the database:', err);
});

sequelizeTransforms(sequelize);

module.exports.sequelize = sequelize;
module.exports.Sequelize = Sequelize;

标签： sql-servernode.js