Example analysis of simple encapsulation operation of nodejs connecting to sqlserver database based on mssql module

This article mainly introduces the simple encapsulation operation of nodejs based on the mssql module to connect to the sqlserver database. It analyzes the installation and operation of the sqlserver database of the mssql module in nodejs with examples. Friends who need it can refer to it. I hope it can help everyone. .

Note: To enable the sqlserver server to allow remote connections, follow the steps of Baidu and a lot of experience. When connecting sqlserver with nodejs, it is best to turn off the inbound rules of the firewall or allow inbound. This package is just a sql statement query. See Understand this, others can be extended by themselves to support connection pooling.

Once you install the mssql module

##

npm install mssql

Second package connection database code

db.js:

/*2017年7月14日17:02:15
 QQ: 12345678
 意外金喜
 mssql模块简单封装
*/
var mssql = require('mssql');
var db = {};
var config = {
 user: 'sa',
 password: '123456',
 server: '10.81.36.167',
 database: 'admanager',
 port:1433,
 options: {
  encrypt: true // Use this if you're on Windows Azure
 },
 pool: {
  min: 0,
  max: 10,
  idleTimeoutMillis: 3000
 }
};
//执行sql,返回数据.
db.sql = function (sql, callBack) {
 var connection = new mssql.Connection(config, function (err) {
  if (err) {
   console.log(err);
   return;
  }
  var ps = new mssql.PreparedStatement(connection);
  ps.prepare(sql, function (err) {
   if (err){
    console.log(err);
    return;
   }
   ps.execute('', function (err, result) {
    if (err){
     console.log(err);
     return;
    }
    ps.unprepare(function (err) {
     if (err){
      console.log(err);
      callback(err,null);
      return;
     }
      callBack(err, result);
    });
   });
  });
 });
};
module.exports = db;

Three tests

dbtest.js

var db = require('./db');
db.sql('select * from XRuserSet',function(err,result){
  if (err) {
    console.log(err);
    return;
  }
  console.log('用户总数为 :',result.length);
});

Four running results

There are 15 users in the XRuserSet table in my admanager library.

Related recommendations:

Detailed explanation of the jQuery encapsulated paging component

Detailed explanation of php encapsulation Mysql operation class

Three ways and writing methods of JavaScript simulation to implement encapsulation

The above is the detailed content of Example analysis of simple encapsulation operation of nodejs connecting to sqlserver database based on mssql module. For more information, please follow other related articles on the PHP Chinese website!