将mysql值从节点js传递到angular

const express = require('express');
const app = express();

// 导入MySQL模块
const mysql = require('mysql');

// 创建MySQL连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

// 连接到MySQL数据库
connection.connect();

// 创建API接口
app.get('/api/data', (req, res) => {
  // 查询MySQL数据
  connection.query('SELECT * FROM your_table', (error, results, fields) => {
    if (error) throw error;
    res.send(results);
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});

import { Component, OnInit } from '@angular/core';
import { HttpClient } from '@angular/common/http';

@Component({
  selector: 'app-data',
  templateUrl: './data.component.html',
  styleUrls: ['./data.component.css']
})
export class DataComponent implements OnInit {
  data: any[];

  constructor(private http: HttpClient) { }

  ngOnInit() {
    // 发起HTTP GET请求获取数据
    this.http.get<any[]>('/api/data').subscribe(data => {
      this.data = data;
    });
  }
}

<ul>
  <li *ngFor="let item of data">{{ item.name }}</li>
</ul>