node.js - POST 请求将空值插入 MS SQL 数据库

Question

这是我的代码 -

onSubmit(){ 
  var headers = new Headers();   
  headers.append('Content-Type', 'application/x-www-form-urlencoded');
  let postParams = {
    firstName : this.firstName, 
    lastName : this.lastName,
    gender: this.myGender,
    myDate : this.myDate
  };

  this.http.post("ip/member", {postParams, headers}).subscribe(data => {
    console.log(data);
  }, error => {
    console.log(error); // Error getting the data
  });
}

我对 Angular 没有太多经验，所以我不太确定发生了什么，但这是将空值插入到我的 MS SQL 数据库中。 Node API 如下所示:

app.post('/member', function(req, res) {
    console.log("creating member\n");
    request = new Request("INSERT INTO [dbo].[tblMemberInfo] VALUES (@firstName, @lastName, @gender, @dateOfBirth);", function(err) {  
        if (err) {  
            console.log(err);}  
        });  
        request.addParameter('firstName', TYPES.VarChar , req.query.firstName);  
        request.addParameter('lastName', TYPES.VarChar, req.query.lastName);  
        request.addParameter('gender', TYPES.VarChar, req.query.gender); 
        request.addParameter('dateOfBirth', TYPES.Date, req.query.dateOfBirth); 

        request.on('doneProc', function(rowCount, more) {  
            console.log('Member added');  
        });       
       connection.execSql(request);      
 })

我尝试使用 Postman 进行插入，效果很好，而且我还确保 Angular 中的所有 postParams 都有值。有人知道发生了什么事吗？

Answer 1

只需更改此行:

this.http.post("ip/member", {postParams, headers})

致:

import { HttpHeaders } from '@angular/common/http';

const httpOptions = {
  headers: new HttpHeaders({
    'Content-Type' : 'application/x-www-form-urlencoded'
  })
};

this.http.post("ip/member", postParams, httpOptions);

<小时/>

根据 Angular 官方文档:

post(url: string, body: any, options?: RequestOptionsArgs)