js直接 mysql

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'user',
  password: 'password',
  database: 'database_name'
});

connection.connect();

const sql = 'SELECT * FROM users WHERE username = ? AND password = ?';
const values = ['admin', 'password'];

connection.query(sql, values, (error, results) => {
  if (error) throw error;
  console.log(results);
});

connection.end();

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

app.use((req, res, next) => {
  res.header('Access-Control-Allow-Origin', '*');
  res.header('Access-Control-Allow-Headers', 'Origin, X-Requested-With, Content-Type, Accept');
  next();
});

app.get('/data', (req, res) => {
  // 处理数据库查询
});

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