学习express搭建管理系统

前言一、新建user表二、安装bcryptjs、MD5、body-parser三、修改config/db.js四、新建config/bcrypt.js五、新建models文件夹和models/user.js五、index.js引入使用body-parser六、修改routes/user.js七、启动项目八、配置Apipost接口/user/register九、访问/user/register总结

一、新建user表

4、设计表添加栏位userID、userName、password

npm

mysql.createPool({host:localhost,ipport:3306,user:root,password:123456,database:express_service

});const

Promise((resolve,reject){pool.getConnection((err,connect){if(err)

reject(err);connect.query(sql,params,(err,result){if(err)

reject(err);return

bcryptJs.hashSync(txt,salt);},compare:(txt,hash){return

bcryptJs.compareSync(txt,hash);},

}module.exports

bcrypt;五、新建models文件夹和models/user.js

user.js

{code:code||500,success:false,msg:msg||操作失败}

}const

{code:200,success:true,msg:msg||操作成功,data,}

}const

{register:async(data){//这里只添加user到数据库不做验证和检验const

userId

md5(data.userNamesecretKey);const

password

bcrypt.hash(data.passwordsecretKey);const

sql

values(${userId},${data.userName},${password});const

result

query(sql);console.log(result)//

return

result;if(resultresult.affectedRows1)return

sucFun(result[0],添加用户成功);return

errFun(添加用户失败);},

userDao;五、index.js引入使用body-parser

const

app.use(bodyParser.urlencoded({

extended:

app.use(bodyParser.json());const

port

1990;require(./config/db);//初始化路由

require(./routes/index)(router);app.use(/,

router);

app.listen(port,(){console.log(http://localhost:port);

})六、修改routes/user.js

(router){router.post(/user/register,async

(req,res){const

userDao.register(req.body);res.json(result);});

module.exports

3、鼠标右键点击express_service新建user子新建接口

5、接口配置

url:http://localhost:1990/user/register

name:/user/register