要写毕业设计,不想一个一个插入数据于是在上课的时候通过AI和自己所学的写出来的
需要进入www.taobao.com官网页面F12打开开发人员工具,在console中复制代码进去就可以了
let a=[];
let div = document.getElementsByClassName("img-wrapper");
let div1 = document.getElementsByClassName("info-wrapper-title-text");
let div2 = document.getElementsByClassName("price-value");
for(let i = 0;i<div.length;i++){
let url = window.getComputedStyle(div[i]).backgroundImage;
let title = div1[i].textContent
let price = div2[i].textContent
a.push("INSERT INTO allshop(shopTitle,shopPrice,shopImg) VALUES("+"'"+title+"'"+",'"+price+"',"+"'"+url.slice(4,-1).replace(/"/g,'')+"');")
}
let blob = new Blob([a.join('\n')],{type:'text/plain'});
let durl = URL.createObjectURL(blob);
let link = document.createElement('a');
link.download='1.txt';
link.href=durl;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
这里对应的是我的数据库表名里面的字段名
搜索商品后的更改:
let a=[];
let div = document.getElementsByClassName("MainPic--mainPic--rcLNaCv");
let div1 = document.getElementsByClassName("Title--title--jCOPvpf");
let div2 = document.getElementsByClassName("Price--priceInt--ZlsSi_M");
for(let i = 0;i<div.length;i++){
let url = div[i].getAttribute("src");
let title = div1[i].getElementsByTagName("span")[0].innerText
console.log(title)
let price = div2[i].textContent
a.push("INSERT INTO allshop(shopTitle,shopPrice,shopImg) VALUES("+"'"+title+"'"+",'"+price+"',"+"'"+url+"');")
}
let blob = new Blob([a.join('\n')],{type:'text/plain'});
let durl = URL.createObjectURL(blob);
let link = document.createElement('a');
link.download='1.txt';
link.href=durl;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);