NodeJs Express MySQL 实现用户简单注入

不念不忘少年蓝@ 2023-10-18 16:23 127阅读 0赞

第一步：使用express 创建student 应用

express student \# 创建student 应用

第二步：student 应用依赖第三方功能模块(mysql 和 body-parser)

mysql :mysql 数据库连接

body-parser：解析post请求的参数

本地安装第三方模块(mysql 和 body-parser)

cnpm install mysql

cnpm install body-parser

编辑package.json 文件

{
      "name": "student",
      "version": "0.0.0",
      "private": true,
      "scripts": {
        "start": "node ./bin/www"
      },
      "dependencies": {
        "cookie-parser": "~1.4.3",
        "debug": "~2.6.9",
        "express": "~4.16.0",
        "http-errors": "~1.6.2",
        "jade": "~1.11.0",
        "morgan": "~1.9.0",
    	"mysql": "~2.16.0",  //依赖mysql
    	"body-parser": "~1.18.3"  //依赖body-parser
      }
    }

第三步：在student文件夹下，创建MySQL数据库模板(db.js)

//student 文件夹下
    var mysql=require("mysql");
    const DB={	    
    	host : '192.168.1.73',	    
    	user : 'root',	    
    	password : 'digipower',   
    	database : 'student'
    }
    const DBConnection=mysql.createConnection({
    	    host:DB.host,	    
    	    user:DB.user,
    	    password:DB.password,
    	    database:DB.database,
    	    multipleStatements:true
    });
    DBConnection.connect();
    module.exports.DBConnection=DBConnection;

第四步：编辑相关页面的路由

编辑student/routes/index.js 文件，引入自定义DB 模块和 body-parser模块

第五步：编辑user.html 文件

在student/views文件夹下新增user.html 文件

第六步：student 应用加载项目依赖模块和启动student 应用

cnpm install

cnpm start

项目访问地址:[http://localhost:3000/user.html][http_localhost_3000_user.html]

效果截图:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

![20190329121322510.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1][]

[http_localhost_3000_user.html]: http://localhost:3000/user.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190329121254818.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70
[20190329121322510.png]: https://img-blog.csdnimg.cn/20190329121322510.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190329121355175.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70