node.js - Node JS - 'where' 子句查询的 GET 请求抛出错误

Question

尝试对单个员工行发出 GET 请求。但是给出参考错误xxx的代码没有定义

app.get('/employee/:sno',function (req,res) {
    mssqlConnection.query('select * from user_login where sno=?',[req.query.sno] ,(err,rows,fields)=>{
        if(!err){
            res.send(rows)
        }
        else{
            console.log(err)
        }
    })

})

ReferenceError: sno is not defined
    at C:\Users\harsh\WebstormProjects\untitled3\index.js:40:67
    at Layer.handle [as handle_request] (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\layer.js:95:5)
    at next (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\route.js:137:13)
    at Route.dispatch (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\route.js:112:3)
    at Layer.handle [as handle_request] (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\layer.js:95:5)
    at C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\index.js:281:22
    at param (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\index.js:354:14)
    at param (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\index.js:365:14)
    at Function.process_params (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\index.js:410:3)
    at next (C:\Users\harsh\WebstormProjects\untitled3\node_modules\express\lib\router\index.js:275:10)

标签： node.jsexpress

Answer 1

使用快速路由，您可以访问with的:sno部分/employee/:snoreq.params.sno

（不像req.query.sno您在问题中所做的那样。）

请参阅路由参数以供参考。