如何将SQL数据直接带入AngularJS中的控制器？

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

// 导入数据库访问框架和配置数据库连接
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});

// 定义API接口，用于获取SQL数据
app.get('/api/data', (req, res) => {
  const sql = 'SELECT * FROM table_name';
  connection.query(sql, (error, results) => {
    if (error) throw error;
    res.json(results);
  });
});

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

angular.module('myApp', [])
  .controller('myController', function($scope, $http) {
    $http.get('/api/data')
      .then(function(response) {
        $scope.sqlData = response.data;
      });
  });