node.js - 使用 SQL Server Nodejs JSON 格式 OK 但是 angular 6 不显示？

Question

我必须在 Angular 6 中连接到 SQL Server，我使用 node server.js 从 SQL Server 获取数据。当我运行 localhost:8887 时，它以 json 格式显示数据 OK，但是在 Angular 前端，如何让我的数据库结果服务？

服务.js

var conn = new sql.ConnectionPool({
user :'XX',
password :'XXXX',
server :'XXXXXX',
database :'XXXX',
port : 1433,
requestTimeout :300000,
options: {
  encrypt: false
}
});

app.get( "/machinedata",function ( request,response ){
 conn.connect().then(function ()
{
    var sqlQuery = "SELECT * FROM machinedata";
    var req = new sql.Request( conn );
    req.query( sqlQuery ).then(function ( recordset )
    {
        response.json( recordset.recordset );
        conn.close();
    }).catch( function ( err ) {
        conn.close();
        response.status( 400 ).send( err );
    });
    }).catch(function ( err ) {
    conn.close();
    response.status( 400 ).send( err );
    });
   });

数据服务.ts

import {Injectable} from '@angular/core';
import { HttpClient, HttpHeaders } from '@angular/common/http';
import { Machinedata } from './machinedata';
const httpOptions = {
headers: new HttpHeaders({ 'Content-Type': 'application/json' })
};

 @Injectable()

 export class DataService {
 constructor(private http: HttpClient) {}

getmachinedata() {
    return this.http.get( 'http://localhost:8887/machinedata' );
  }
 }

mdata.component.ts

   import { Component, OnInit } from '@angular/core';
   import { DataService } from '../data.service';
   import { Machinedata } from '../machinedata';

  @Component({
   selector: 'app-mdata',
   templateUrl: './mdata.component.html',
   styleUrls: ['./mdata.component.css']
   })
   export class MdataComponent implements OnInit {
    machinedatas: Machinedata[];
   constructor( private dataService: DataService) { }

    ngOnInit() {
     this.dataService.getmachinedata().subscribe((data: Machinedata[])            
     => { this.machinedatas = data;
     });
      }

标签： node.jssql-serverangular