js数据存入mysql数据库

document.getElementById('submitBtn').addEventListener('click', function() {
    const data = {
        name: document.getElementById('name').value,
        email: document.getElementById('email').value
    };

    fetch('/api/saveData', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json'
        },
        body: JSON.stringify(data)
    })
    .then(response => response.json())
    .then(result => {
        console.log('Success:', result);
    })
    .catch(error => {
        console.error('Error:', error);
    });
});

const express = require('express');
const mysql = require('mysql');
const bodyParser = require('body-parser');

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

const db = mysql.createConnection({
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
});

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

app.post('/api/saveData', (req, res) => {
    const { name, email } = req.body;
    const sql = 'INSERT INTO users (name, email) VALUES (?, ?)';
    db.query(sql, [name, email], (err, result) => {
        if (err) return res.status(500).send(err);
        res.json({ message: 'Data saved successfully!' });
    });
});

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