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

àì夳堔傛蜴生んèń 2023-09-30 13:09 10阅读 0赞

## 场景 ##

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

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

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

注：

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

## 实现 ##

1、安装NodeRED节点

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

![179f970942092186063eeca3ace5615b.png][]

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

![36ba91b948fafa458e0376dd34430663.png][]

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

![a3ffdb71a286e438993f1ed6b383b624.png][]

流程设计如下

![3260b8c5ed2f52cccd828d3f0dd22f47.png][]

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

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

![ee4189d8461d938bd64790f84a3f4cb7.png][]

3、编辑Mysql节点

![f6164eb357a82601c25fd77db82cb31f.png][]

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

![9aaad6c868d72c42626d3c21bf0d497f.png][]

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>

![335c432998562fc24572aa476d6a2537.png][]

5、部署运行访问

[http://127.0.0.1:1880/allUser][http_127.0.0.1_1880_allUser]

![8b3a8cda5413f0900c6ab27d6228c4d8.png][]

6、查询流程json数据

7、实现插入操作

新增插入数据的流程设计

![13c77389612899edd2c4d18067bbe2d5.png][]

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

![769b4450aad5ca4c6b34c2f9ab877c09.png][]

执行查看效果

![3deeae06f396491e04530678d0c9b7ff.png][]

插入流程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、新增更新语句执行流程设计如下

![ee3d8149e548ef04c987aa9db56275cd.png][]

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

但是注意的是字符串是使用反引号，在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;

![84aff818ae1d0e45eb116969f55b7372.png][]

部署运行看效果

![0361e874d516692d28e09e00072d17e3.png][]

更新流程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、设计删除流程布局

![4aa476c02dcf2fba506ad6328b35376b.png][]

编辑template节点

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

![18078857097efcf5e2d9f277c7cf012b.png][]

部署运行查看效果

![03e83405c18ed5eb9913b85d9b0165e5.png][]

删除流程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_-CSDN]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/124211653
[CSDN_-C_SpringBoot]: https://blog.csdn.net/badao_liumang_qizhi
[179f970942092186063eeca3ace5615b.png]: https://img-blog.csdnimg.cn/img_convert/179f970942092186063eeca3ace5615b.png
[36ba91b948fafa458e0376dd34430663.png]: https://img-blog.csdnimg.cn/img_convert/36ba91b948fafa458e0376dd34430663.png
[a3ffdb71a286e438993f1ed6b383b624.png]: https://img-blog.csdnimg.cn/img_convert/a3ffdb71a286e438993f1ed6b383b624.png
[3260b8c5ed2f52cccd828d3f0dd22f47.png]: https://img-blog.csdnimg.cn/img_convert/3260b8c5ed2f52cccd828d3f0dd22f47.png
[ee4189d8461d938bd64790f84a3f4cb7.png]: https://img-blog.csdnimg.cn/img_convert/ee4189d8461d938bd64790f84a3f4cb7.png
[f6164eb357a82601c25fd77db82cb31f.png]: https://img-blog.csdnimg.cn/img_convert/f6164eb357a82601c25fd77db82cb31f.png
[9aaad6c868d72c42626d3c21bf0d497f.png]: https://img-blog.csdnimg.cn/img_convert/9aaad6c868d72c42626d3c21bf0d497f.png
[335c432998562fc24572aa476d6a2537.png]: https://img-blog.csdnimg.cn/img_convert/335c432998562fc24572aa476d6a2537.png
[http_127.0.0.1_1880_allUser]: http://127.0.0.1:1880/allUser
[8b3a8cda5413f0900c6ab27d6228c4d8.png]: https://img-blog.csdnimg.cn/img_convert/8b3a8cda5413f0900c6ab27d6228c4d8.png
[13c77389612899edd2c4d18067bbe2d5.png]: https://img-blog.csdnimg.cn/img_convert/13c77389612899edd2c4d18067bbe2d5.png
[769b4450aad5ca4c6b34c2f9ab877c09.png]: https://img-blog.csdnimg.cn/img_convert/769b4450aad5ca4c6b34c2f9ab877c09.png
[3deeae06f396491e04530678d0c9b7ff.png]: https://img-blog.csdnimg.cn/img_convert/3deeae06f396491e04530678d0c9b7ff.png
[ee3d8149e548ef04c987aa9db56275cd.png]: https://img-blog.csdnimg.cn/img_convert/ee3d8149e548ef04c987aa9db56275cd.png
[84aff818ae1d0e45eb116969f55b7372.png]: https://img-blog.csdnimg.cn/img_convert/84aff818ae1d0e45eb116969f55b7372.png
[0361e874d516692d28e09e00072d17e3.png]: https://img-blog.csdnimg.cn/img_convert/0361e874d516692d28e09e00072d17e3.png
[4aa476c02dcf2fba506ad6328b35376b.png]: https://img-blog.csdnimg.cn/img_convert/4aa476c02dcf2fba506ad6328b35376b.png
[18078857097efcf5e2d9f277c7cf012b.png]: https://img-blog.csdnimg.cn/img_convert/18078857097efcf5e2d9f277c7cf012b.png
[03e83405c18ed5eb9913b85d9b0165e5.png]: https://img-blog.csdnimg.cn/img_convert/03e83405c18ed5eb9913b85d9b0165e5.png