Node-RED中连接Mysql数据库并实现增删改查的操作

最新推荐文章于 2024-02-28 14:24:48 发布
最新推荐文章于 2024-02-28 14:24:48 发布
阅读量5.5k 收藏 28
点赞数 4
分类专栏： 前端那些骚操作 文章标签： nodered
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/124248350
版权

场景

Node-RED中建立静态网页和动态网页内容：

Node-RED中建立静态网页和动态网页内容_霸道流氓气质的博客-CSDN博客

在上面的基础上，怎样实现连接Mysql数据库并将数据库中的数据显示在网页上，以及执行插入、更新、删除操作。

注：

博客：
霸道流氓气质的博客_CSDN博客-C#,架构之路,SpringBoot领域博主
关注公众号
霸道的程序猿
获取编程相关电子书、教程推送与免费下载。

实现

1、安装NodeRED节点

节点管理搜索node-red-node-mysql,安装

安装成功之后就会有Mysql节点了

2、数据库设计一个测试的用户表

流程设计如下

编辑function节点，使其执行查询语句

msg.topic = "SELECT * FROM user";
return msg;

3、编辑Mysql节点

编辑连接输入数据库连接信息

4、编辑template节点修改html显示模板

<html>
    <head>
        <title>用户</title>
    </head>
    <body>
      <table border="1">
       {{#payload}}
          <tr><td>{{name}}</td><td>{{pass}}</td></tr>
       {{/payload}}
      </table>
    </body>
</html>

5、部署运行访问

http://127.0.0.1:1880/allUser

6、查询流程json数据

[
    {
        "id": "f4a4d8eab7935bc8",
        "type": "tab",
        "label": "流程 3",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "c428312d1f6165d1",
        "type": "mqtt-broker",
        "name": "mqtt",
        "broker": "127.0.0.1",
        "port": "1883",
        "clientid": "",
        "autoConnect": true,
        "usetls": false,
        "protocolVersion": "4",
        "keepalive": "60",
        "cleansession": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthPayload": "",
        "birthMsg": {},
        "closeTopic": "",
        "closeQos": "0",
        "closePayload": "",
        "closeMsg": {},
        "willTopic": "",
        "willQos": "0",
        "willPayload": "",
        "willMsg": {},
        "sessionExpiry": ""
    },
    {
        "id": "51eee50b4ec9422f",
        "type": "ui_group",
        "name": "dashboardDemo",
        "tab": "29ae4c620f43ee0d",
        "order": 1,
        "disp": true,
        "width": "6",
        "collapse": false,
        "className": ""
    },
    {
        "id": "29ae4c620f43ee0d",
        "type": "ui_tab",
        "name": "Home",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    },
    {
        "id": "a506c767a5c1edbd",
        "type": "ui_base",
        "theme": {
            "name": "theme-light",
            "lightTheme": {
                "default": "#0094CE",
                "baseColor": "#0094CE",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
                "edited": true,
                "reset": false
            },
            "darkTheme": {
                "default": "#097479",
                "baseColor": "#097479",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
                "edited": false
            },
            "customTheme": {
                "name": "Untitled Theme 1",
                "default": "#4B7930",
                "baseColor": "#4B7930",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
            },
            "themeState": {
                "base-color": {
                    "default": "#0094CE",
                    "value": "#0094CE",
                    "edited": false
                },
                "page-titlebar-backgroundColor": {
                    "value": "#0094CE",
                    "edited": false
                },
                "page-backgroundColor": {
                    "value": "#fafafa",
                    "edited": false
                },
                "page-sidebar-backgroundColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "group-textColor": {
                    "value": "#1bbfff",
                    "edited": false
                },
                "group-borderColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "group-backgroundColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "widget-textColor": {
                    "value": "#111111",
                    "edited": false
                },
                "widget-backgroundColor": {
                    "value": "#0094ce",
                    "edited": false
                },
                "widget-borderColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "base-font": {
                    "value": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
                }
            },
            "angularTheme": {
                "primary": "indigo",
                "accents": "blue",
                "warn": "red",
                "background": "grey",
                "palette": "light"
            }
        },
        "site": {
            "name": "Node-RED Dashboard",
            "hideToolbar": "false",
            "allowSwipe": "false",
            "lockMenu": "false",
            "allowTempTheme": "true",
            "dateFormat": "DD/MM/YYYY",
            "sizes": {
                "sx": 48,
                "sy": 48,
                "gx": 6,
                "gy": 6,
                "cx": 6,
                "cy": 6,
                "px": 0,
                "py": 0
            }
        }
    },
    {
        "id": "248cbbb0.18e794",
        "type": "ui_group",
        "name": "MyGroup",
        "tab": "3f79c420.cfc1bc",
        "order": 1,
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "3f79c420.cfc1bc",
        "type": "ui_tab",
        "name": "Home",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    },
    {
        "id": "a0954be5.a7f7e8",
        "type": "ui_group",
        "name": "MyInput",
        "tab": "3f79c420.cfc1bc",
        "order": 2,
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "508bd6f8398ab80f",
        "type": "ui_group",
        "name": "OpenWeatherMap",
        "tab": "3f79c420.cfc1bc",
        "order": 3,
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "8824dea1.83e31",
        "type": "websocket-client",
        "path": "ws://localhost:9898/",
        "tls": "",
        "wholemsg": "false"
    },
    {
        "id": "51c3503.61936b",
        "type": "MySQLdatabase",
        "name": "",
        "host": "127.0.0.1",
        "port": "3306",
        "db": "test",
        "tz": "",
        "charset": "UTF8"
    },
    {
        "id": "571a8ee8.5883d",
        "type": "http in",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "url": "/allUser",
        "method": "get",
        "upload": false,
        "swaggerDoc": "",
        "x": 210,
        "y": 160,
        "wires": [
            [
                "71ec3368.c3cf5c"
            ]
        ]
    },
    {
        "id": "7eb81f73.1710c",
        "type": "template",
        "z": "f4a4d8eab7935bc8",
        "name": "HTML网页",
        "field": "payload",
        "fieldType": "msg",
        "format": "handlebars",
        "syntax": "mustache",
        "template": "<html>\n    <head>\n        <title>用户</title>\n    </head>\n    <body>\n      <table border=\"1\">\n       {{#payload}}\n          <tr><td>{{name}}</td><td>{{pass}}</td></tr>\n       {{/payload}}\n      </table>\n    </body>\n</html>",
        "x": 570,
        "y": 160,
        "wires": [
            [
                "766f42f9.87fbcc"
            ]
        ]
    },
    {
        "id": "71ec3368.c3cf5c",
        "type": "function",
        "z": "f4a4d8eab7935bc8",
        "name": "SQL Query",
        "func": "msg.topic = \"SELECT * FROM user\";\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 290,
        "y": 240,
        "wires": [
            [
                "1c7d1dcf.bb2ad2"
            ]
        ]
    },
    {
        "id": "766f42f9.87fbcc",
        "type": "http response",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "statusCode": "",
        "headers": {},
        "x": 610,
        "y": 240,
        "wires": []
    },
    {
        "id": "1c7d1dcf.bb2ad2",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 410,
        "y": 160,
        "wires": [
            [
                "7eb81f73.1710c"
            ]
        ]
    }
]

7、实现插入操作

新增插入数据的流程设计

编辑function节点，编辑插入语句

执行查看效果

插入流程json数据

[
    {
        "id": "1d9518ddb606e944",
        "type": "inject",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payloadType": "date",
        "x": 210,
        "y": 380,
        "wires": [
            [
                "e28fd0d0403014e0"
            ]
        ]
    },
    {
        "id": "e28fd0d0403014e0",
        "type": "function",
        "z": "f4a4d8eab7935bc8",
        "name": "INSERT",
        "func": "\nvar user = 'insertUser';\nvar pass = '123456';\n\nmsg.topic = \"INSERT INTO user \" +\n     \"(name,pass)\" +\n     \"VALUES ('\" + user +\n     \"','\"+ pass + \"' )\";\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 340,
        "y": 380,
        "wires": [
            [
                "fdde79cf9a1b1722"
            ]
        ]
    },
    {
        "id": "fdde79cf9a1b1722",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 480,
        "y": 380,
        "wires": [
            [
                "5ea56f3eec020d0f"
            ]
        ]
    },
    {
        "id": "5ea56f3eec020d0f",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 380,
        "wires": []
    },
    {
        "id": "51c3503.61936b",
        "type": "MySQLdatabase",
        "name": "",
        "host": "127.0.0.1",
        "port": "3306",
        "db": "test",
        "tz": "",
        "charset": "UTF8",
        "credentials": {}
    }
]

8、新增更新语句执行流程设计如下

模板值可以在字符找那个嵌入运算式或变量。

但是注意的是字符串是使用反引号，在Tab上方的按钮括起，而不是使用单引号括起。

编辑function节点

var id = 3;
var name = 'updateName';
var pass = '5555';
msg.topic = `UPDATE user SET name='${name}',` +
            `pass='${pass}' WHERE id=${id}`;
return msg;

部署运行看效果

更新流程json数据

[
    {
        "id": "5426aed100d65d31",
        "type": "inject",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 210,
        "y": 520,
        "wires": [
            [
                "a911307ea6b68a16"
            ]
        ]
    },
    {
        "id": "a911307ea6b68a16",
        "type": "function",
        "z": "f4a4d8eab7935bc8",
        "name": "UPDATE",
        "func": "var id = 3;\nvar name = 'updateName';\nvar pass = '5555';\nmsg.topic = `UPDATE user SET name='${name}',` +\n            `pass='${pass}' WHERE id=${id}`;\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 340,
        "y": 520,
        "wires": [
            [
                "eb4b3bd2a53dbb37",
                "d991b7f159d90812"
            ]
        ]
    },
    {
        "id": "eb4b3bd2a53dbb37",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 480,
        "y": 520,
        "wires": [
            [
                "c83545834bc01135"
            ]
        ]
    },
    {
        "id": "c83545834bc01135",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 520,
        "wires": []
    },
    {
        "id": "d991b7f159d90812",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "topic",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 480,
        "y": 600,
        "wires": []
    },
    {
        "id": "51c3503.61936b",
        "type": "MySQLdatabase",
        "name": "",
        "host": "127.0.0.1",
        "port": "3306",
        "db": "test",
        "tz": "",
        "charset": "UTF8"
    }
]

9、设计删除流程布局

编辑template节点

DELETE FROM user WHERE id='{{payload}}'

部署运行查看效果

 

删除流程json数据

[
    {
        "id": "883fb789f22f352f",
        "type": "inject",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "1",
        "payloadType": "str",
        "x": 210,
        "y": 720,
        "wires": [
            [
                "15479540478f4720"
            ]
        ]
    },
    {
        "id": "fd30c40a7a9d0baf",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 480,
        "y": 720,
        "wires": [
            [
                "6eb37dd7c809dd01"
            ]
        ]
    },
    {
        "id": "6eb37dd7c809dd01",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 720,
        "wires": []
    },
    {
        "id": "15479540478f4720",
        "type": "template",
        "z": "f4a4d8eab7935bc8",
        "name": "DELETE",
        "field": "topic",
        "fieldType": "msg",
        "format": "handlebars",
        "syntax": "mustache",
        "template": "DELETE FROM user WHERE id='{{payload}}'",
        "output": "str",
        "x": 340,
        "y": 720,
        "wires": [
            [
                "fd30c40a7a9d0baf"
            ]
        ]
    },
    {
        "id": "51c3503.61936b",
        "type": "MySQLdatabase",
        "name": "",
        "host": "127.0.0.1",
        "port": "3306",
        "db": "test",
        "tz": "",
        "charset": "UTF8"
    }
]

10、增删改查全流程json数据

[
    {
        "id": "f4a4d8eab7935bc8",
        "type": "tab",
        "label": "流程 3",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "c428312d1f6165d1",
        "type": "mqtt-broker",
        "name": "mqtt",
        "broker": "127.0.0.1",
        "port": "1883",
        "clientid": "",
        "autoConnect": true,
        "usetls": false,
        "protocolVersion": "4",
        "keepalive": "60",
        "cleansession": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthPayload": "",
        "birthMsg": {},
        "closeTopic": "",
        "closeQos": "0",
        "closePayload": "",
        "closeMsg": {},
        "willTopic": "",
        "willQos": "0",
        "willPayload": "",
        "willMsg": {},
        "sessionExpiry": ""
    },
    {
        "id": "51eee50b4ec9422f",
        "type": "ui_group",
        "name": "dashboardDemo",
        "tab": "29ae4c620f43ee0d",
        "order": 1,
        "disp": true,
        "width": "6",
        "collapse": false,
        "className": ""
    },
    {
        "id": "29ae4c620f43ee0d",
        "type": "ui_tab",
        "name": "Home",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    },
    {
        "id": "a506c767a5c1edbd",
        "type": "ui_base",
        "theme": {
            "name": "theme-light",
            "lightTheme": {
                "default": "#0094CE",
                "baseColor": "#0094CE",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
                "edited": true,
                "reset": false
            },
            "darkTheme": {
                "default": "#097479",
                "baseColor": "#097479",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
                "edited": false
            },
            "customTheme": {
                "name": "Untitled Theme 1",
                "default": "#4B7930",
                "baseColor": "#4B7930",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
            },
            "themeState": {
                "base-color": {
                    "default": "#0094CE",
                    "value": "#0094CE",
                    "edited": false
                },
                "page-titlebar-backgroundColor": {
                    "value": "#0094CE",
                    "edited": false
                },
                "page-backgroundColor": {
                    "value": "#fafafa",
                    "edited": false
                },
                "page-sidebar-backgroundColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "group-textColor": {
                    "value": "#1bbfff",
                    "edited": false
                },
                "group-borderColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "group-backgroundColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "widget-textColor": {
                    "value": "#111111",
                    "edited": false
                },
                "widget-backgroundColor": {
                    "value": "#0094ce",
                    "edited": false
                },
                "widget-borderColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "base-font": {
                    "value": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
                }
            },
            "angularTheme": {
                "primary": "indigo",
                "accents": "blue",
                "warn": "red",
                "background": "grey",
                "palette": "light"
            }
        },
        "site": {
            "name": "Node-RED Dashboard",
            "hideToolbar": "false",
            "allowSwipe": "false",
            "lockMenu": "false",
            "allowTempTheme": "true",
            "dateFormat": "DD/MM/YYYY",
            "sizes": {
                "sx": 48,
                "sy": 48,
                "gx": 6,
                "gy": 6,
                "cx": 6,
                "cy": 6,
                "px": 0,
                "py": 0
            }
        }
    },
    {
        "id": "248cbbb0.18e794",
        "type": "ui_group",
        "name": "MyGroup",
        "tab": "3f79c420.cfc1bc",
        "order": 1,
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "3f79c420.cfc1bc",
        "type": "ui_tab",
        "name": "Home",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    },
    {
        "id": "a0954be5.a7f7e8",
        "type": "ui_group",
        "name": "MyInput",
        "tab": "3f79c420.cfc1bc",
        "order": 2,
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "508bd6f8398ab80f",
        "type": "ui_group",
        "name": "OpenWeatherMap",
        "tab": "3f79c420.cfc1bc",
        "order": 3,
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "8824dea1.83e31",
        "type": "websocket-client",
        "path": "ws://localhost:9898/",
        "tls": "",
        "wholemsg": "false"
    },
    {
        "id": "51c3503.61936b",
        "type": "MySQLdatabase",
        "name": "",
        "host": "127.0.0.1",
        "port": "3306",
        "db": "test",
        "tz": "",
        "charset": "UTF8"
    },
    {
        "id": "571a8ee8.5883d",
        "type": "http in",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "url": "/allUser",
        "method": "get",
        "upload": false,
        "swaggerDoc": "",
        "x": 210,
        "y": 160,
        "wires": [
            [
                "71ec3368.c3cf5c"
            ]
        ]
    },
    {
        "id": "7eb81f73.1710c",
        "type": "template",
        "z": "f4a4d8eab7935bc8",
        "name": "HTML网页",
        "field": "payload",
        "fieldType": "msg",
        "format": "handlebars",
        "syntax": "mustache",
        "template": "<html>\n    <head>\n        <title>用户</title>\n    </head>\n    <body>\n      <table border=\"1\">\n       {{#payload}}\n          <tr><td>{{name}}</td><td>{{pass}}</td></tr>\n       {{/payload}}\n      </table>\n    </body>\n</html>",
        "x": 570,
        "y": 160,
        "wires": [
            [
                "766f42f9.87fbcc"
            ]
        ]
    },
    {
        "id": "71ec3368.c3cf5c",
        "type": "function",
        "z": "f4a4d8eab7935bc8",
        "name": "SQL Query",
        "func": "msg.topic = \"SELECT * FROM user\";\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 290,
        "y": 240,
        "wires": [
            [
                "1c7d1dcf.bb2ad2"
            ]
        ]
    },
    {
        "id": "766f42f9.87fbcc",
        "type": "http response",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "statusCode": "",
        "headers": {},
        "x": 610,
        "y": 240,
        "wires": []
    },
    {
        "id": "1c7d1dcf.bb2ad2",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 410,
        "y": 160,
        "wires": [
            [
                "7eb81f73.1710c"
            ]
        ]
    },
    {
        "id": "1d9518ddb606e944",
        "type": "inject",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payloadType": "date",
        "x": 210,
        "y": 380,
        "wires": [
            [
                "e28fd0d0403014e0"
            ]
        ]
    },
    {
        "id": "e28fd0d0403014e0",
        "type": "function",
        "z": "f4a4d8eab7935bc8",
        "name": "INSERT",
        "func": "\nvar user = 'insertUser';\nvar pass = '123456';\n\nmsg.topic = \"INSERT INTO user \" +\n     \"(name,pass)\" +\n     \"VALUES ('\" + user +\n     \"','\"+ pass + \"' )\";\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 340,
        "y": 380,
        "wires": [
            [
                "fdde79cf9a1b1722"
            ]
        ]
    },
    {
        "id": "fdde79cf9a1b1722",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 480,
        "y": 380,
        "wires": [
            [
                "5ea56f3eec020d0f"
            ]
        ]
    },
    {
        "id": "5ea56f3eec020d0f",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 380,
        "wires": []
    },
    {
        "id": "5426aed100d65d31",
        "type": "inject",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 210,
        "y": 520,
        "wires": [
            [
                "a911307ea6b68a16"
            ]
        ]
    },
    {
        "id": "a911307ea6b68a16",
        "type": "function",
        "z": "f4a4d8eab7935bc8",
        "name": "UPDATE",
        "func": "var id = 3;\nvar name = 'updateName';\nvar pass = '5555';\nmsg.topic = `UPDATE user SET name='${name}',` +\n            `pass='${pass}' WHERE id=${id}`;\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 340,
        "y": 520,
        "wires": [
            [
                "eb4b3bd2a53dbb37",
                "d991b7f159d90812"
            ]
        ]
    },
    {
        "id": "eb4b3bd2a53dbb37",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 480,
        "y": 520,
        "wires": [
            [
                "c83545834bc01135"
            ]
        ]
    },
    {
        "id": "c83545834bc01135",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 520,
        "wires": []
    },
    {
        "id": "d991b7f159d90812",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "topic",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 480,
        "y": 600,
        "wires": []
    },
    {
        "id": "883fb789f22f352f",
        "type": "inject",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "1",
        "payloadType": "str",
        "x": 210,
        "y": 720,
        "wires": [
            [
                "15479540478f4720"
            ]
        ]
    },
    {
        "id": "fd30c40a7a9d0baf",
        "type": "mysql",
        "z": "f4a4d8eab7935bc8",
        "mydb": "51c3503.61936b",
        "name": "",
        "x": 480,
        "y": 720,
        "wires": [
            [
                "6eb37dd7c809dd01"
            ]
        ]
    },
    {
        "id": "6eb37dd7c809dd01",
        "type": "debug",
        "z": "f4a4d8eab7935bc8",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 720,
        "wires": []
    },
    {
        "id": "15479540478f4720",
        "type": "template",
        "z": "f4a4d8eab7935bc8",
        "name": "DELETE",
        "field": "topic",
        "fieldType": "msg",
        "format": "handlebars",
        "syntax": "mustache",
        "template": "DELETE FROM user WHERE id='{{payload}}'",
        "output": "str",
        "x": 340,
        "y": 720,
        "wires": [
            [
                "fd30c40a7a9d0baf"
            ]
        ]
    }
]

霸道流氓气质
关注
专栏目录
node-red与mysql的连接ui（学习笔记）
qq_62118666的博客
01-08 1873
node-red与mysql的交互
Node+Vue3+mysql+ant design实现前后端分离——表格的添加、修改和删除
最新发布
qq_53541336的博客
04-24 896
在上一篇文章中，我们分享了如何运用NodeJS、Vue、MySQL以及其他技术来实现后台管理系统中的表格查询功能。今天，我们将继续探讨另外三个重要的功能实现原则。这些原则在构建后台管理系统时至关重要，同时还有导入和导出这两种功能也必不可少。关于导入和导出功能，我们会在下一次更新中详细介绍。下文中与上一篇文章重复的部分就不再进行详述，不懂的同学可以先看看上篇文章哦。
Node-RED中使用html节点爬取HTML网页资料之爬取Node-RED的最新版本
BADAO_LIUMANG_QIZHI的博客
04-14 2767
场景 Node-RED简介与Windows上安装、启动和运行示例： Node-RED简介与Windows上安装、启动和运行示例_霸道流氓气质的博客-CSDN博客 Node-RED怎样导出导入流程为json文件： Node-RED怎样导出导入流程为json文件_霸道流氓气质的博客-CSDN博客 我们可以使用浏览器的开发人员工具获取指定HTML网页资料的CSS选择器后，使用html 节点以CSS选择器来获取资料。 注： 博客：霸道流氓气质的博客_CSDN博客-C#,架构之路,Spri
node-red-contrib-stackhero-mysql:Node-RED节点，用于读取和写入MySQL或MariaDB数据库。 兼容TLS（SSL）和“缓存SHA2密码”身份验证方法
05-25
节点红色贡献堆栈英雄MySQL 节点，用于读取和写入MySQL或MariaDB数据库。 它使用TLS（SSL）加密，并且与“缓存SHA2密码”身份验证方法兼容（MySQL> = 8）。 请记住：如果喜欢，请加注星标！ :smiling_face_with_hearts: 官方仓库： : 赞助商 node-red-contrib-stackhero-mysql由开发。 如果您正在寻找功能强大的托管服务，例如Node-RED，MySQL或MariaDB，则应认真考虑Stackhero :nerd_face: 用法 这个节点真的很简单。 将查询放在topic变量中，如果有参数，请将其放在payload变量的对象中。 您将在payload输出变量中获得结果。 例子： msg . topic = 'SELECT * FROM `users` WHERE `name` = :name AND `age` > :age;' ; msg . paylo
Node-red操作数据库MySQL
qq_45086597的博客
08-23 8023
使用Node-red 操作MySQL 数据库
【Node Red 】 mysql数据库节点介绍
物联网爱好者
02-28 1731
在之前工作项目中，有这样的项目需求：比如一台自动化设备，内部控制器支持mdobus TCP协议，我们需要与该设备进行数据通讯，采集设备内部生产工艺数据，并将数据传给第三方平台。
NodeRED学习（四）MySql
qq_32812063的博客
04-10 503
【代码】NodeRED学习（四）MySql。
Node-red 操作MySQL 例程 增删改查
08-23
Node-red 操作MySQL 例程 增删改查
node-red-node-mysql-1.0.3.tgz
04-10
这个节点支持四大基本的数据库操作：增（INSERT）、删（DELETE）、改（UPDATE）和查（SELECT）。这使得非程序员也能轻松管理数据库操作。 在使用这个插件之前，你需要确保已经在运行的Node-RED实例和你的系统上安装...
Node-RED中的数据库连接与操作
# 第一章：介绍Node-RED和数据库连接 ## 1.1 Node-RED简介 Node-RED是一个基于Node.js开发的可视化编程工具，主要用于物联网（IoT）应用的快速开发。它通过简单直观的拖拽方式，将各种设备、API和在线服务进行连接...
node-mysql实现增删改查
01-05
node-mysql实现增删改查 环境需求:安装node.js 解压项目npm install 下载项目中所需要的脚手架依赖 npm run 运行项目 测试地址http://127.0.0.1:3000/dist/index.html#/
python达梦数据库_Python 封装 DM 达梦 数据库操作（使用类封装基本的增删改查）...
weixin_39622521的博客
01-14 1481
前面的几篇博客我们看了SQLite、Mysql、Oracle数据库的封装，本篇看下达梦数据库的封装.https://www.cndba.cn/Dave/article/38271 测试环境操作系统本：[root@dm8 dmPython]# cat /etc/redhat-releaseRed Hat Enterprise Linux Server release 7.5 (Maipo)[root...
Node-Red实现MySQL数据库连接
weixin_43195420的博客
08-03 5822
Node-Red连接数据库Node-Red实现MySQL数据库连接Node-Red中控件下载创建数据库创建数据表table_name添加学生信息 Node-Red实现MySQL数据库连接 要想实现Node-red连接数据库（mysql），首先电脑需要在电脑中下载MySQL软件，并安装Navicat便于操作，这里默认已经安装完毕。 Node-Red中控件下载 在Node-Red中需要先下载所需要的mysql控件： 首先在左上角点击设置，并找到节点管理 ； 在节点管理中点击安装； 在安装界面的查询窗口输入no
node-red连接mysql数据库，进行数据的传输存储
weixin_43755851的博客
11-18 7939
node-red连接mysql数据库，进行数据的传输存储 废话不多说，直接上重点。 树莓派安装node-red，在可视化界面安装mysql模块，对mysql模块进行配置。 主要注意的是 （1）database的设置，一定要与数据库的匹配（***）。 （2）数据传输mysql数据库，需要注意程序编写。 var sql = “INSERT INTO url(from,to,status, is_ne...
Node-Red系列教程——NodeRed通过OPC UA读取数据并写入mysql
鲸鱼姐的专栏
08-24 8551
NodeRed通opcua读取西门子数据并存入mysql
node-red mysql的增删改查_node-red mysql的增删改查
weixin_39567943的博客
01-19 390
最近一段时间在学node-red,碰到过很多问题。收获也是很多，下面这个是一个node-red的小案例，主要就是用node-red实现mysql的增删改查。效果图： 查询 源码：[{"id":"24ba3f58.22ccf","type":"inject","z":"ede2a284.edabc","name":"Go","topic":"","payload":"","payloadType":...
Node-Red操作MySql数据库进行增删改查
A_awen的博客
12-27 1376
Node-Red 对Mysql数据进行增删改查
node系列：连接mysql数据库
分享前端开发工程师的一些日常生活、前端知识点、职业发展、对一些问题的看法、感悟等等
09-19 251
第一步 在 https://www.npmjs.com/ 中搜索 mysql，因为这里搜到的都是 node 的包，搜到的以第一个就是啦。 第二步 安装： npm install mysql 使用： var mysql = require('mysql'); var connection = mysql.createConnection({ host : 'localhost'...
node增删改查接口？（接口包括条件搜索，获取数据，分页，）
qq_53509791的博客
05-29 248
【代码】node增删改查接口？（接口包括条件搜索，获取数据，分页，）
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

霸道流氓气质

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值