nodejs mysql登陆

const mysql = require('mysql');

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

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database!');
});

// 登录函数
function login(username, password, callback) {
  const query = 'SELECT * FROM users WHERE username = ? AND password = ?';
  connection.query(query, [username, password], (err, results) => {
    if (err) throw err;
    callback(results);
  });
}

// 示例调用
login('admin', 'password123', (results) => {
  if (results.length > 0) {
    console.log('Login successful!');
  } else {
    console.log('Login failed!');
  }
});

// 关闭连接
connection.end();