node.js连sqlserver demo

node.js连sqlserver demo

无需多言，直接上代码，因为本例只是简单的测试连接sqlserver(sql 2008 r2),并执行select

1 首先在package.json中添加依赖 

    "dependencies": {
        "koa": "2.0.0",
        "koa-bodyparser": "3.2.0",
        "koa-router": "7.0.0",
        "mssql": "4.0.4",  
        "mysql": "2.11.1",
        "sequelize": "3.24.1",
        "mocha": "3.0.2",
        "mz": "2.4.0",
        "supertest": "3.0.0",
        "ws": "1.1.1"
    }

"mssql": "4.0.4", 这行，其它是用于其它作用的，不用管