要转换的json数据
[
{
"id": "1",
"name": "张三",
"height": "175.5",
"score": "88.5",
"hobby": "篮球"
},
{
"id": "2",
"name": "李四",
"height": "178.0",
"score": "98.5",
"hobby": "足球"
},
{
"id": "3",
"name": "王五",
"height": "179.0",
"score": "98.5",
"hobby": "乒乓球"
},
{
"id": "4",
"name": "赵六",
"height": "172.5",
"score": "78.5",
"hobby": "篮球"
}
]
把data.json文件中的数据拼接成insert语句
/*
把data.json文件中的数据拼接成insert语句
*/
const path = require('path');
const fs = require('fs');
fs.readFile(path.join(__dirname,'./','data.json'),'utf8',(err,content)=>{ // 读取当前文件夹下的json文件,指定utf8编码格式
if(err) return;
let list = JSON.parse(content); // 解析json数据
let arr = [];
list.forEach((stu)=>{
let sql = `insert into student (name,height,score,hobby) values ('${stu.name}','${stu.height}','${stu.score}','${stu.hobby}');`;
arr.push(sql);
});
fs.writeFile(path.join(__dirname,'data.sql'),arr.join(''),'utf8',(err)=>{
console.log('init json data finished!');
});
});
运行结果:
insert into student (name,height,score,hobby) values ('张三','175.5','88.5','篮球');
insert into student (name,height,score,hobby) values ('李四','178.0','98.5','足球');
insert into student (name,height,score,hobby) values ('王五','179.0','98.5','乒乓球');
insert into student (name,height,score,hobby) values ('赵六','172.5','78.5','篮球');