nodejs用mysql数据库写登录页面

npm init

npm install express mysql

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

const app = express();

app.use(express.urlencoded({ extended: true }));

app.get('/', (req, res) => {
  res.send('<form method="post" action="/login">' +
    '<input type="text" name="username" placeholder="Username">' +
    '<input type="password" name="password" placeholder="Password">' +
    '<button type="submit">Login</button>' +
    '</form>');
});

app.post('/login', (req, res) => {
  const { username, password } = req.body;

  // 在这里进行用户名和密码的验证逻辑
  // 可以使用mysql模块连接到MySQL数据库，执行查询等操作

  // 示例代码中省略了验证逻辑

  res.send('Logged in successfully!');
});

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

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

connection.connect((err) => {
  if (err) {
    console.error('Failed to connect to MySQL database');
    return;
  }

  console.log('Connected to MySQL database');
});

connection.query('SELECT * FROM users', (err, results) => {
  if (err) {
    console.error('Failed to execute query');
    return;
  }

  console.log(results);
});