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测试上传接口
文章来源: segmentfault.com,作者:墨子鱼,版权归原作者所有,如需转载,请联系作者。
原文链接:segmentfault.com/a/1190000037676456