NodeJS全栈开发后，实现上传文件并保存到Mysql数据库的功能。安装第三方插件multernpmi--savemulter创建上传接口文件upload.jsvarcreateFolder=function(folder){try{fs.accessSync(folder);}catch(e){fs.mkdirSync(folder);}};varuploadFolder='./uploads/';//文件上传位置createFolder(uploadFolder);varstorage=multer.diskStorage({destination:function(req,file,cb){cb(null,uploadFolder)},filename:function(req,file,cb){cb(null,file.originalname)}})varupload=multer({storage:storage})//上传接口router.post('/upload',upload.single('file'),function(req,res){fs.rename(req.file.path,"uploads/"+req.file.originalname,function(err){如果(err){throwerr;}vardata=req.filevarphoto=req.file.urlres.send({code:CODE_SUCCESS,msg:'上传成功',data:data})//添加到数据库常量查询=`insertintosys_data(photo)values('${photo}')`;querySql(query).then(data=>{res.json({code:CODE_SUCCESS,msg:'添加数据成功',data:null})})})})module.exports=通过postman测试的router上传接口
