新闻页面（四）

service/news/index.js 文件夹

const mysql = require("mysql2");
const fs = require("fs");
//配置和数据库之间的连接
const connection = mysql.createConnection ({   host:'localhost', user:'root',password:"123321",database:"js04",charset:"utf8" 
});

module.exports = {async addNewsData(request){// console.log(request);//文件如何存储到数据库// 把临时路径进行转存if(!fs.existsSync("static/uploads/")){fs.mkdirSync("static/uploads/");}

fs.writeFileSync("static/uploads/"+request.files.img.name,fs.readFileSync(request.files.img.path));// console.log(request.body);//上传文件后，将对应的数据也传递过去//ctx.request  === requsetlet {title,content,type} = request.body;let imgUrl = "/uploads/" + request.files.img.name;let res = await connection.promise().query("INSERT INTO news (title,content,type,imgUrl) VALUES (?,?,?,?)",[title , content ,type,imgUrl]);// console.log(res);return res;}}

service/admin/index.js 文件夹

const mysql = require("mysql2");
//配置和数据库之间的连接
const connection = mysql.createConnection ({   host:'localhost', user:'root',password:"123321",database:"js04",charset:"utf8" 
});

module.exports = {async getData(){let [data] = await connection.promise().query("SELECT * FROM news");// console.log(data);return data;}
}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！