将数据从登录页面提交到MySQL数据库的代码

// 引入必要的模块
const express = require('express');
const mysql = require('mysql');

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

// 创建Express应用程序
const app = express();

// 处理POST请求
app.post('/login', (req, res) => {
  // 从请求中获取用户名和密码
  const { username, password } = req.body;

  // 将数据插入到数据库中
  const query = `INSERT INTO users (username, password) VALUES ('${username}', '${password}')`;
  connection.query(query, (error, results) => {
    if (error) {
      console.error('Error inserting data: ', error);
      res.status(500).send('Error inserting data');
    } else {
      console.log('Data inserted successfully');
      res.status(200).send('Data inserted successfully');
    }
  });
});

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