实例详解node.js如何获取SQLServer数据库

var mssql = require('mssql');
var db = {};
var config = { 
 user: '登陆名', 
 password: '登陆密码', 
 server: '服务器名称', 
 port:1433, 
 driver: 'msnodesql', 
 database: '数据库名称', 
 connectionString: "Driver={SQL Server Native Client 11.0};
 Server=#{server}\\sql;Database=#{database};Uid=#{user};Pwd=#{password};", 
 /* options: { 
 encrypt: true // Use this if you're on Windows Azure 
 },*/ 
 pool: { 
 min: 0, 
 max: 10, 
 idleTimeoutMillis: 3000 
 }
};
db.sql = function (sql, callBack) { 
 var connection = new mssql.ConnectionPool(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;

var db = require('../module/db');//引入mssqlrouter.get('/',(req,res) => {
db.sql('select * from 表的名称',function(err,result){
 var data = result.recordset;//把数据的部分提取出来
 res.render('index.ejs',{data:data});
 if (err) { console.log(err); return; }

 });});module.exports = router;//把router暴露出去

<% for(var i in data){ %>
 <%= data[i]["要展示的字段"] %>
<% } %>