用Nodejs做的小站粗糙的完工

当然可以。以下是一个基于Node.js、Express框架、MySQL数据库和MongoDB数据库的小站示例。我们将展示如何实现用户注册、登录、发布文章、添加评论以及图片上传功能。此外，还将展示如何从MySQL迁移到MongoDB。

1. 使用Node.js和Express搭建基本站点

首先，我们需要安装必要的依赖包：

npm init -y
npm install express mysql2 multer

Express服务器设置

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

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

// 路由设置
app.get('/', (req, res) => {
    res.send('Hello World!');
});

app.listen(port, () => {
    console.log(`Server is running on http://localhost:${port}`);
});

2. 用户注册与登录

假设我们使用MySQL数据库进行用户管理：

const mysql = require('mysql2');

const pool = mysql.createPool({
    host: 'localhost',
    user: 'root',
    database: 'testdb'
});

app.post('/register', (req, res) => {
    const { username, password } = req.body;
    pool.query(
        'INSERT INTO users (username, password) VALUES (?, ?)',
        [username, password],
        (err, result) => {
            if (err) throw err;
            res.send('User registered successfully');
        }
    );
});

app.post('/login', (req, res) => {
    const { username, password } = req.body;
    pool.query(
        'SELECT * FROM users WHERE username = ? AND password = ?',
        [username, password],
        (err, results) => {
            if (results.length > 0) {
                res.send('Login successful');
            } else {
                res.send('Invalid credentials');
            }
        }
    );
});

3. 迁移到MongoDB

接下来，我们将用户管理迁移到MongoDB：

const MongoClient = require('mongodb').MongoClient;

const url = 'mongodb://localhost:27017';
const dbName = 'testdb';

MongoClient.connect(url, function(err, client) {
    if (err) throw err;
    const db = client.db(dbName);
    const collection = db.collection('users');

    app.post('/register', (req, res) => {
        const { username, password } = req.body;
        collection.insertOne({ username, password }, (err, result) => {
            if (err) throw err;
            res.send('User registered successfully');
        });
    });

    app.post('/login', (req, res) => {
        const { username, password } = req.body;
        collection.findOne({ username, password }, (err, result) => {
            if (result) {
                res.send('Login successful');
            } else {
                res.send('Invalid credentials');
            }
        });
    });
});

4. 图片上传

使用multer库来处理文件上传：

npm install multer

const multer = require('multer');
const path = require('path');

const storage = multer.diskStorage({
    destination: function (req, file, cb) {
        cb(null, 'uploads/')
    },
    filename: function (req, file, cb) {
        cb(null, Date.now() + path.extname(file.originalname))
    }
});

const upload = multer({ storage: storage });

app.post('/upload', upload.single('image'), (req, res) => {
    res.send('File uploaded successfully');
});

以上就是用Node.js构建一个简单的网站，并且展示了如何从MySQL迁移到MongoDB的过程。希望这些示例对你有所帮助！