Node.js学习之实战express + mssql

• Node.js学习express + mssql + nodemon 1.安装nodemon模块（实现监视文件自动重启服务)

sudo npm install nodemon //Mac下安装加sudo获取管理员权限，否则会报错

2.安装express模块

npm install express

3.安装mssql模块

npm install mssql

const express = require('express')

const app = express()
app.use(express.urlencoded({ extended : true }));
app.use(express.json());

const sql = require('mssql')
//sql server配置文件
const sqlConfig = {
    server: '127.0.0.1',
    database: "This",
    user: "ThisUser",
    password: "1234",
    pool:{
        max:10,
        min:0,
        idleTimeoutMillis: 30000
    },
    options:{
    //encrypt属性设为true时sql地址设IP会报错，需要映射域名
        encrypt: false,
        trustServerCertificate: true
    }
}
//post请求
app.post('/userInfo',  (req, res)=> {
//sql连接方法
    sql.connect(sqlConfig, function (err) {
        if (err) console.log(err);
        //sql方法
        const db = new sql.Request();
        //获取客户端静态参数 get(req.query)
        //                post(req.body)
        //获取客户端静态参数 req.params
        //接收参数赋给sql查询
        let roomNo = req.body
        const sqlStr = "select roomNo,ArrivalDate,ArrivalTime from Guests where status = 'I' and roomNo = " + roomNo.roomNo
        //发起sql查询返回结果给客户端
        db.query(sqlStr, function (err, userInfo) {
            if (err) console.log(err)
            res.send(userInfo.recordset);
        });
    });
});


app.listen(80,()=>{
    console.log("web server running http://127.0.0.1")
})