Nodejs使用tedious驱动模块连接SqlServer

app.js代码如下:

var Connection = require('tedious').Connection;
var mongoose = require('mongoose');
var rows = [];

//用户名，密码和数据库服务器,数据库
var config = {
  userName: 'sa',password: '123456',server: '127.0.0.1',options : {
             database  : 'BigDataTest'
            }
  };

  var connection = new Connection(config);
  var Request = require('tedious').Request;

  connection.on('connect',function(err) {
    //错误处理
    if(err)
	{
      console.log("连接出错!");
    }
    else {
      {
        console.log("连接成功!");
      };
    }
    getSqlData();
  });

     function getSqlData() 
	 {
        console.log('从SQL获取数据');
        request = new Request("SELECT * FROM Citys",function(err,rowCount)
        {
          if (err)
          {
            console.log(err);
          }
          else
          {
            console.log("行数: " + rowCount);
			//遍历对象数组，查出数据
			// rows.forEach(function(r){  
			// console.log(r["name"]+"---"+r["code"]);
		    // })  
          }
        });

        request.on('row',function(columns)
        {
          var row = {};
          columns.forEach(function(column)
          {
            row[column.metadata.colName] = column.value;
          });
          rows.push(row); 
		  
		});
 
        connection.execSql(request);
		
		
    }

sqlserver? 建表脚本:

 
CREATE TABLE [dbo].[Citys](
	[id] [int] IDENTITY(1,1) NOT NULL,[name] [nvarchar](100) NULL,[code] [varchar](300) NULL,CONSTRAINT [PK_Citys] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF,STATISTICS_NORECOMPUTE  = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS  = ON,ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

结果如图:

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!