如何在visual studio代码中连接angular2和sqlserver？

npm install --save @angular/http
npm install --save-dev @types/node

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

// SQL Server连接配置
const config = {
  user: 'your_username',
  password: 'your_password',
  server: 'your_server',
  database: 'your_database',
};

// 创建API路由
app.get('/api/data', (req, res) => {
  sql.connect(config, (err) => {
    if (err) {
      console.log(err);
      res.status(500).send('Database connection error');
    } else {
      const request = new sql.Request();
      request.query('SELECT * FROM your_table', (err, result) => {
        if (err) {
          console.log(err);
          res.status(500).send('Database query error');
        } else {
          res.json(result.recordset);
        }
        sql.close();
      });
    }
  });
});

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

{
  "/api": {
    "target": "http://localhost:3000",
    "secure": false
  }
}

"proxyConfig": "proxy.config.json"

ng serve