{"id":49,"date":"2026-02-19T20:11:04","date_gmt":"2026-02-19T12:11:04","guid":{"rendered":"https:\/\/word.ronrin.cn\/?p=49"},"modified":"2026-02-19T20:11:04","modified_gmt":"2026-02-19T12:11:04","slug":"node-js-%e6%93%8d%e4%bd%9c%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e4%b8%89%e7%a7%8d%e4%b8%bb%e8%a6%81%e6%96%b9%e5%bc%8f","status":"publish","type":"post","link":"https:\/\/word.ronrin.cn\/index.php\/2026\/02\/19\/node-js-%e6%93%8d%e4%bd%9c%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e4%b8%89%e7%a7%8d%e4%b8%bb%e8%a6%81%e6%96%b9%e5%bc%8f\/","title":{"rendered":"Node.js \u64cd\u4f5c\u6570\u636e\u5e93\u7684\u4e09\u79cd\u4e3b\u8981\u65b9\u5f0f"},"content":{"rendered":"\n

1.\u00a0\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff08MySQL\/PostgreSQL\uff09<\/strong><\/h2>\n\n\n\n

\u4ee5 MySQL \u4e3a\u4f8b\uff0c\u6700\u5e38\u7528\u7684\u662f mysql2<\/code> \u6216 sequelize<\/code> ORM\uff1a<\/p>\n\n\n\n

\u65b9\u5f0f\u4e00\uff1a\u76f4\u63a5\u4f7f\u7528 mysql2\uff08\u63a8\u8350\uff09<\/h4>\n\n\n\n

javascript<\/p>\n\n\n\n

const mysql = require('mysql2\/promise');  \/\/ \u4f7f\u7528 promise \u7248\u672c\n\n\/\/ 1. \u521b\u5efa\u8fde\u63a5\u6c60\nconst pool = mysql.createPool({\n    host: 'localhost',\n    user: 'root',\n    password: 'password',\n    database: 'myapp',\n    waitForConnections: true,\n    connectionLimit: 10,\n    queueLimit: 0\n});\n\n\/\/ 2. \u4f7f\u7528 async\/await \u67e5\u8be2\uff08\u6700\u73b0\u4ee3\u7684\u65b9\u5f0f\uff09\nasync function getUsers() {\n    try {\n        const [rows, fields] = await pool.query('SELECT * FROM users');\n        return rows;\n    } catch (error) {\n        console.error('\u6570\u636e\u5e93\u67e5\u8be2\u5931\u8d25:', error);\n    }\n}\n\n\/\/ 3. \u5e26\u53c2\u6570\u7684\u67e5\u8be2\uff08\u9632\u6b62 SQL \u6ce8\u5165\uff09\nasync function getUserById(id) {\n    const [rows] = await pool.query('SELECT * FROM users WHERE id = ?', [id]);\n    return rows[0];\n}\n\n\/\/ 4. \u63d2\u5165\u6570\u636e\nasync function createUser(name, email) {\n    const [result] = await pool.query(\n        'INSERT INTO users (name, email) VALUES (?, ?)',\n        [name, email]\n    );\n    return result.insertId;  \/\/ \u8fd4\u56de\u65b0\u63d2\u5165\u7684ID\n}\n\n\/\/ \u4f7f\u7528\u793a\u4f8b\napp.get('\/users', async (req, res) => {\n    const users = await getUsers();\n    res.json(users);\n});<\/pre>\n\n\n\n
\u65b9\u5f0f\u4e8c\uff1a\u4f7f\u7528 ORM\uff08Sequelize\uff09- \u9002\u5408\u5927\u578b\u9879\u76ee<\/h4>\n\n\n\n
javascript<\/p>\n\n\n\n
const { Sequelize, DataTypes } = require('sequelize');\n\n\/\/ 1. \u8fde\u63a5\u6570\u636e\u5e93\nconst sequelize = new Sequelize('database', 'username', 'password', {\n    host: 'localhost',\n    dialect: 'mysql'\n});\n\n\/\/ 2. \u5b9a\u4e49\u6a21\u578b\uff08\u7c7b\u4f3c Python \u7684 Django ORM\uff09\nconst User = sequelize.define('User', {\n    name: {\n        type: DataTypes.STRING,\n        allowNull: false\n    },\n    email: {\n        type: DataTypes.STRING,\n        unique: true,\n        validate: {\n            isEmail: true\n        }\n    }\n});\n\n\/\/ 3. \u540c\u6b65\u6570\u636e\u5e93\uff08\u521b\u5efa\u8868\uff09\nawait sequelize.sync();\n\n\/\/ 4. \u4f7f\u7528 ORM \u64cd\u4f5c\nasync function userOperations() {\n    \/\/ \u521b\u5efa\u7528\u6237\n    const user = await User.create({\n        name: '\u5f20\u4e09',\n        email: 'zhangsan@example.com'\n    });\n    \n    \/\/ \u67e5\u8be2\u7528\u6237\n    const users = await User.findAll();\n    const user2 = await User.findByPk(1);\n    const adults = await User.findAll({\n        where: { age: { [Op.gte]: 18 } }\n    });\n    \n    \/\/ \u66f4\u65b0\n    await user.update({ name: '\u674e\u56db' });\n    \n    \/\/ \u5220\u9664\n    await user.destroy();\n}<\/pre>\n\n\n\n
2. MongoDB\uff08NoSQL\uff09<\/strong><\/h3>\n\n\n\n
MongoDB \u662f Node.js \u7684\u9ec4\u91d1\u642d\u6863\uff0c\u5e38\u7528 mongoose<\/code> ODM\uff1a<\/p>\n\n\n\n
javascript<\/p>\n\n\n\n
const mongoose = require('mongoose');\n\n\/\/ 1. \u8fde\u63a5\u6570\u636e\u5e93\nmongoose.connect('mongodb:\/\/localhost:27017\/myapp', {\n    useNewUrlParser: true,\n    useUnifiedTopology: true\n});\n\n\/\/ 2. \u5b9a\u4e49 Schema\uff08\u7c7b\u4f3c\u8868\u7ed3\u6784\uff09\nconst userSchema = new mongoose.Schema({\n    name: { type: String, required: true },\n    email: { type: String, required: true, unique: true },\n    age: Number,\n    address: {\n        city: String,\n        street: String\n    },\n    tags: [String],  \/\/ \u6570\u7ec4\u5b57\u6bb5\n    createdAt: { type: Date, default: Date.now }\n});\n\n\/\/ 3. \u521b\u5efa Model\nconst User = mongoose.model('User', userSchema);\n\n\/\/ 4. \u4f7f\u7528 Model \u64cd\u4f5c\u6570\u636e\u5e93\nasync function mongoOperations() {\n    \/\/ \u521b\u5efa\n    const user = new User({\n        name: '\u738b\u4e94',\n        email: 'wangwu@example.com',\n        age: 25,\n        address: { city: '\u5317\u4eac', street: '\u957f\u5b89\u8857' },\n        tags: ['\u7a0b\u5e8f\u5458', 'Node.js']\n    });\n    await user.save();\n    \n    \/\/ \u67e5\u8be2\n    const users = await User.find({ age: { $gt: 18 } });\n    const user2 = await User.findOne({ email: 'wangwu@example.com' });\n    \n    \/\/ \u66f4\u65b0\n    await User.updateOne(\n        { name: '\u738b\u4e94' },\n        { $set: { age: 26 } }\n    );\n    \n    \/\/ \u5220\u9664\n    await User.deleteOne({ name: '\u738b\u4e94' });\n    \n    \/\/ \u590d\u6742\u67e5\u8be2\n    const programmers = await User.find({\n        tags: '\u7a0b\u5e8f\u5458',\n        age: { $gte: 20, $lte: 30 }\n    }).sort({ age: -1 }).limit(10);\n}<\/pre>\n\n\n\n
3. Redis\uff08\u7f13\u5b58\u6570\u636e\u5e93\uff09<\/strong><\/h3>\n\n\n\n
javascript<\/p>\n\n\n\n
const Redis = require('ioredis');\n\n\/\/ 1. \u8fde\u63a5 Redis\nconst redis = new Redis({\n    host: 'localhost',\n    port: 6379,\n    password: 'optional'\n});\n\n\/\/ 2. \u57fa\u672c\u64cd\u4f5c\nasync function redisOperations() {\n    \/\/ \u5b57\u7b26\u4e32\n    await redis.set('key', 'value');\n    const value = await redis.get('key');\n    \n    \/\/ \u8bbe\u7f6e\u8fc7\u671f\u65f6\u95f4\uff085\u79d2\uff09\n    await redis.setex('session', 5, 'user_data');\n    \n    \/\/ \u54c8\u5e0c\n    await redis.hset('user:1', 'name', '\u5f20\u4e09');\n    await redis.hset('user:1', 'age', 30);\n    const userName = await redis.hget('user:1', 'name');\n    \n    \/\/ \u5217\u8868\n    await redis.lpush('logs', 'error1', 'error2');\n    const latestLog = await redis.lpop('logs');\n    \n    \/\/ \u81ea\u589e\uff08\u7528\u4e8e\u8ba1\u6570\u5668\uff09\n    const views = await redis.incr('page:views');\n}<\/pre>\n\n\n\n
\u5728 Express \u4e2d\u7684\u5b8c\u6574\u793a\u4f8b<\/h2>\n\n\n\n
javascript<\/p>\n\n\n\n
const express = require('express');\nconst mysql = require('mysql2\/promise');\nconst app = express();\n\napp.use(express.json());\n\n\/\/ \u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5\u6c60\nconst pool = mysql.createPool({\n    host: 'localhost',\n    user: 'root',\n    password: 'password',\n    database: 'myapp'\n});\n\n\/\/ \u83b7\u53d6\u6240\u6709\u7528\u6237\napp.get('\/api\/users', async (req, res) => {\n    try {\n        const [rows] = await pool.query('SELECT * FROM users');\n        res.json(rows);\n    } catch (error) {\n        res.status(500).json({ error: error.message });\n    }\n});\n\n\/\/ \u83b7\u53d6\u5355\u4e2a\u7528\u6237\napp.get('\/api\/users\/:id', async (req, res) => {\n    try {\n        const [rows] = await pool.query(\n            'SELECT * FROM users WHERE id = ?', \n            [req.params.id]\n        );\n        if (rows.length === 0) {\n            return res.status(404).json({ error: '\u7528\u6237\u4e0d\u5b58\u5728' });\n        }\n        res.json(rows[0]);\n    } catch (error) {\n        res.status(500).json({ error: error.message });\n    }\n});\n\n\/\/ \u521b\u5efa\u7528\u6237\napp.post('\/api\/users', async (req, res) => {\n    const { name, email } = req.body;\n    try {\n        const [result] = await pool.query(\n            'INSERT INTO users (name, email) VALUES (?, ?)',\n            [name, email]\n        );\n        res.status(201).json({ \n            id: result.insertId, \n            name, \n            email \n        });\n    } catch (error) {\n        res.status(500).json({ error: error.message });\n    }\n});\n\n\/\/ \u66f4\u65b0\u7528\u6237\napp.put('\/api\/users\/:id', async (req, res) => {\n    const { name, email } = req.body;\n    try {\n        await pool.query(\n            'UPDATE users SET name = ?, email = ? WHERE id = ?',\n            [name, email, req.params.id]\n        );\n        res.json({ message: '\u66f4\u65b0\u6210\u529f' });\n    } catch (error) {\n        res.status(500).json({ error: error.message });\n    }\n});\n\n\/\/ \u5220\u9664\u7528\u6237\napp.delete('\/api\/users\/:id', async (req, res) => {\n    try {\n        await pool.query('DELETE FROM users WHERE id = ?', [req.params.id]);\n        res.json({ message: '\u5220\u9664\u6210\u529f' });\n    } catch (error) {\n        res.status(500).json({ error: error.message });\n    }\n});\n\napp.listen(3000, () => {\n    console.log('Server running on port 3000');\n});<\/pre>\n\n\n\n
\u548c\u5176\u4ed6\u8bed\u8a00\u7684\u5bf9\u6bd4<\/h2>\n\n\n\n
\u64cd\u4f5c<\/th>Python (Flask + SQLAlchemy)<\/th>PHP (Laravel + Eloquent)<\/th>Node.js (Express + Sequelize)<\/th><\/tr><\/thead>
\u8fde\u63a5<\/td>create_engine()<\/code><\/td>DB::connection()<\/code><\/td>new Sequelize()<\/code><\/td><\/tr>
\u67e5\u8be2<\/td>User.query.all()<\/code><\/td>User::all()<\/code><\/td>User.findAll()<\/code><\/td><\/tr>
\u63d2\u5165<\/td>db.session.add(user)<\/code><\/td>User::create($data)<\/code><\/td>User.create(data)<\/code><\/td><\/tr>
\u66f4\u65b0<\/td>user.name = '\u65b0\u540d\u5b57'<\/code><\/td>$user->update($data)<\/code><\/td>user.update({name})<\/code><\/td><\/tr>
\u5220\u9664<\/td>db.session.delete(user)<\/code><\/td>$user->delete()<\/code><\/td>user.destroy()<\/code><\/td><\/tr>
\u4e8b\u52a1<\/td>with db.session.begin():<\/code><\/td>DB::transaction()<\/code><\/td>sequelize.transaction()<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\u5173\u952e\u70b9\u603b\u7ed3<\/h2>\n\n\n\n
    \n
  1. \u5f02\u6b65\u662f\u6838\u5fc3<\/strong>\uff1a\u6240\u6709\u6570\u636e\u5e93\u64cd\u4f5c\u90fd\u662f\u5f02\u6b65\u7684\uff0c\u8981\u7528\u00a0async\/await<\/code><\/li>\n\n\n\n
  2. \u8fde\u63a5\u6c60\u5f88\u91cd\u8981<\/strong>\uff1a\u4e0d\u8981\u6bcf\u6b21\u8bf7\u6c42\u90fd\u521b\u5efa\u65b0\u8fde\u63a5<\/li>\n\n\n\n
  3. \u9632\u6b62 SQL \u6ce8\u5165<\/strong>\uff1a\u6c38\u8fdc\u4f7f\u7528\u53c2\u6570\u5316\u67e5\u8be2\uff08?<\/code>\u00a0\u5360\u4f4d\u7b26\uff09<\/li>\n\n\n\n
  4. ORM vs \u539f\u751f SQL<\/strong>\uff1a\n
      \n
    • \u5c0f\u9879\u76ee\u7528\u539f\u751f SQL \u66f4\u76f4\u63a5<\/li>\n\n\n\n
    • \u5927\u9879\u76ee\u7528 ORM \u66f4\u597d\u7ef4\u62a4<\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • \u9519\u8bef\u5904\u7406<\/strong>\uff1a\u6570\u636e\u5e93\u64cd\u4f5c\u4e00\u5b9a\u8981\u7528 try-catch<\/li>\n<\/ol>\n\n\n\n
      \u65b0\u624b\u63a8\u8350\u8def\u7ebf<\/h2>\n\n\n\n
        \n
      1. \u5148\u4ece\u00a0mysql2<\/code>\u00a0\u7684\u539f\u751f SQL \u5f00\u59cb\uff0c\u7406\u89e3\u6570\u636e\u5e93\u64cd\u4f5c<\/li>\n\n\n\n
      2. \u518d\u7528\u00a0mongoose<\/code>\u00a0\u4f53\u9a8c MongoDB \u7684\u7075\u6d3b<\/li>\n\n\n\n
      3. \u6700\u540e\u7528\u00a0sequelize<\/code>\u00a0ORM \u63d0\u9ad8\u6548\u7387<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
        1.\u00a0\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff08MySQL\/Post […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-49","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":1,"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"predecessor-version":[{"id":50,"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/posts\/49\/revisions\/50"}],"wp:attachment":[{"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/word.ronrin.cn\/index.php\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}