关于node.js:NodejsExpress后端实现上传文件并保存到数据库

NodeJS全栈开发之后端实现上传文件性能并保留到Mysql数据库

装置第三方插件multer
npm i –save multer

创立上传接口文件upload.js
var createFolder = function(folder){

try{
    fs.accessSync(folder); 
}catch(e){
    fs.mkdirSync(folder);
}  

};
var uploadFolder = ‘./uploads/’; //文件上传地位

createFolder(uploadFolder);
var storage = multer.diskStorage({

destination: function (req, file, cb) {
  cb(null, uploadFolder)
},
filename: function (req, file, cb) {
  cb(null, file.originalname)
}

})

var upload = multer({ storage: storage })

//上传接口
router.post(‘/upload’, upload.single(‘file’), function(req, res) {

fs.rename(req.file.path, "uploads/" + req.file.originalname, function(err) {
    if (err) {
        throw err;
    }
    var data= req.file
    var photo=req.file.url
    res.send({
        code:CODE_SUCCESS,
        msg:'上传胜利',
        data:data
      })
   //增加到数据库
    const query = `insert into sys_data(photo) values( '${photo}')`;
    querySql(query)
    .then(data => {

      res.json({ 
          code: CODE_SUCCESS, 
          msg: '增加数据胜利', 
          data: null 
        })
    })
 })

})

module.exports = router

通过postman测试上传接口