//這是從自定義sql中獲取的var sql=[ "insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱) values('",
["94"], //數(shù)組的長(zhǎng)度不確定
"','",
["DDDfffDDD","DDD鹽DDD","DDD海鮮粉DDD","DDD胡椒粉DDD","DDD333DDD"], 數(shù)組的長(zhǎng)度不確定 "','", "", "''\n\n)"
]//最后要得到：(循環(huán)插入使用)[
"insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱) values('94','DDDfffDDD')",
"insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱) values('94','DDD鹽DDD')",
"insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱) values('94','DDD海鮮粉DDD') ",
"insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱) values('94','DDD胡椒粉DDD')",
"insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱) values('94','DDD333DDD')" ]這個(gè)該怎么實(shí)現(xiàn)？
2 回答
冉冉說(shuō)
TA貢獻(xiàn)1877條經(jīng)驗(yàn) 獲得超1個(gè)贊
insert into 產(chǎn)品lr(產(chǎn)品id,產(chǎn)品名稱,供應(yīng)商名稱,型號(hào)) values('94',['DDDfffDDD','DDD鹽DDD','DDD海鮮粉DDD','DDD胡椒粉DDD','DDD333DDD'],['fff','鹽','海鮮粉','胡椒粉','333'],'DDDfffDDD,DDD鹽DDD,DDD海鮮粉DDD,DDD胡椒粉DDD,DDD333DDD')存成這樣，然后找到數(shù)組，雙層for循環(huán)即可。
桃花長(zhǎng)相依
TA貢獻(xiàn)1860條經(jīng)驗(yàn) 獲得超8個(gè)贊
let res1 = []
sql[1].forEach(value => {
sql[3].forEach(value1 => { let item1 = `${sql[0]}${value}','${value1}'),`;
res1.push(item1)
});
})console.log(res1)- 2 回答
- 0 關(guān)注
- 686 瀏覽
添加回答
舉報(bào)
0/150
提交
取消