node.js mysql cheerio superagent 小爬虫 nodemailer

　　

 

const mysql=require('mysql')
const link=mysql.createConnection({
    host:'localhost',
    port:3306,
    user:'root',
    password:'cruces',
    database:'abate',
})

// link.query('select * from users',(err,data)=>{
//     if(err) return console.log(err)
//     console.log(data)
// })
link.query('select * from users where username=? and password=?',['bb','uiop'],(err,data)=>{
    if(err) return console.log(err)
    console.log(data)
})
console.log('end')

 

const superagent=require('superagent')
const cheerio=require('cheerio')
const mysql=require('mysql')

const list=[]

const link=mysql.createConnection({
    host:'localhost',
    port:3306,
    user:'root',
    password:'cruces',
    database:'abate'
})
const sql='insert into wares values (null,?,?,?,?)'

superagent.get('https://list.jd.com/list.html?cat=670,671,672&go=0&cu=true',(err,res)=>{
    if(err) return console.log(err)
    // console.log(res.text)
    parsePage(res.text)
    // console.log(list)obj.
})

function parsePage(page){
    const $=cheerio.load(page)
    $('ul.gl-warp>li').each(function(index,value){
        const obj={
            goods_img:$(value).find('.p-img img').prop('src'),
            goods_price:$(value).find('.p-price i').text(),
            goods_title:$(value).find('.p-name em').text(),
            goods_name:$(value).find('.p-name i').text(),
            goods_commit:$(value).find('.p-commit a').text()
        }
        list.push(obj)
        console.log(obj)
        link.query(sql,[obj.goods_img,obj.goods_price,obj.goods_title,obj.goods_name],(err,data)=>{
            if(err) return console.log(11,err)
            console.log(data)
        })
    })
}

 

const nodemailer=require('nodemailer')
const transport=nodemailer.createTransport({
    'host':'smtp.qq.com',
    'port':465,
    'secure':true,
    auth:{
        user:'49340505@qq.com',
        pass:'ydnquriryxgkbjgd'
    }
})

transport.sendMail({
    from:'493405058@qq.com',
    to:['109264963@qq.com'],
    subject:'code',
    html:`
        <h1 style="color:red;">234</h1>
        <br>
        ++++++++++++++
        <br>
        company
    `
},(err,data)=>{
    if(err) return console.log(err)
    console.log(data)
})