将图片上传到服务器--后台

将图片上传到服务器

const baseURL = 'http://127.0.0.1:8080'
let multiparty = require('multiparty');
const moment=require('moment')
const path = require("path");
class Swiper{
    async query(request,response,next){
        //2 sql语句
        let querySql="SELECT * FROM `swiper`";
        let results = await db.exec(querySql)
        console.log(results)
        try {
            if(results && results.length>=1){
                console.log(results)
                results.forEach(item => {
                    if (item.s_src.length > 0) {
                        item.s_src = baseURL + item.s_src
                    }
                })
                response.json({ status: 0, message: results, affectedRows: 0 })
            }else {
                response.json(
                    { status: 1, message: '获取轮播失败', affectedRows: 0 })
            }
        }catch (error){
            response.json({ msg:"服务器异常",data:results })
        }
    }
    async add(request,response,next){
        let form = new multiparty.Form();
        let msg = {info:'',img:''};
        var imgSrc={}
        form.encoding = 'utf-8';
        form.uploadDir = "./public/images/banner";
        form.maxFilesSize = 2 * 1024 * 1024;
        form.parse(request, function(err, fields, files) {
            if(err){
                console.log(err);
                msg.info = '上传失败';
                return ;
            }
            let char=(files.files[0].path)+'';
            char=char.replace(/\\/g,"/")
            char=char.replace('public',"")
            char=char.replace('//','/')
            imgSrc.src="/"+char
            msg.img=path.join(__dirname,'../public/images/banner/'+files.files[0].originalFilename);
            msg.info = '上传成功'
            msg.len = files.length;
            let params=[
                request.body.title,
                imgSrc.src,
                request.body.sort,
                moment().format("YYYY-MM-DD hh:mm:ss")
            ]
            console.log(params)
            let updateSql = 'INSERT INTO `swiper` (`s_title`, `s_src`,`s_sort`,`s_creare`) VALUES (?,?,?,?);'
            let result= db.exec(updateSql,params)
            try {
                if(result && result.affectedRows>=1){
                    msg.des="轮播成功"
                    response.json(msg)
                }else {
                    msg.des="添加轮播图失败"
                    response.json(msg)
                }
            }catch (error){
                msg.code='服务器异常'
                response.json(msg)
            }
        });
        console.log(imgSrc)
    }
    // async addSwiper(request,response,next){
    //     let form = new multiparty.Form();
    //     let msg = {info:'',img:''};
    //     //console.log(__dirname);
    //     form.encoding = 'utf-8';
    //     form.uploadDir = "./public/images/banner";
    //     form.maxFilesSize = 2 * 1024 * 1024;
    //     form.parse(request, function(err, fields, files) {
    //         if(err){
    //             console.log(err);
    //             msg.info = '上传失败';
    //             response.send(msg);
    //             return ;
    //         }
    //         console.log(files.files[0].originalFilename);
    //         console.log(files.files[0].path)
    //         msg.img=path.join(__dirname,'../public/images/banner/'+files.files[0].originalFilename);
    //         console.log(msg.img);
    //         msg.info = '上传成功'
    //         msg.len = files.length;
    //         response.send(msg);
    //     });
    // }

}
module.exports=new Swiper();//暴露接口