使用SQL Server、nodejs和bycrypt，请求在接收函数之前结束

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

const app = express();
app.use(express.json());

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

// 连接数据库
async function connectDB() {
  try {
    await sql.connect(config);
    console.log('Connected to SQL Server');
  } catch (err) {
    console.error('Database connection failed:', err);
  }
}

// 处理请求的函数
async function handleRequest(req, res) {
  try {
    const { username, password } = req.body;

    // 查询数据库
    const request = new sql.Request();
    request.input('username', sql.VarChar(50), username);
    const result = await request.query('SELECT password FROM users WHERE username = @username');

    if (result.recordset.length === 0) {
      return res.status(404).send('User not found');
    }

    const hashedPassword = result.recordset[0].password;

    // 验证密码
    const match = await bcrypt.compare(password, hashedPassword);
    if (!match) {
      return res.status(401).send('Invalid credentials');
    }

    res.status(200).send('Authentication successful');
  } catch (err) {
    console.error('Error handling request:', err);
    res.status(500).send('Internal Server Error');
  }
}

// 启动服务器
app.post('/login', handleRequest);

connectDB().then(() => {
  app.listen(3000, () => {
    console.log('Server is running on port 3000');
  });
});