'use strict';
const http = require('http');
const cheerio = require('cheerio');
const mysql? = require('mysql');?
const connection = mysql.createConnection({
? host? ? : 'localhost',? ? ?
? ? user? ? : 'root',? ? ? ?
? ? password : 'sjh',? ? ?
? ? port: '3306',? ?
? ? database: 'sjh'
});
var url = 'http://www.runoob.com/nodejs/nodejs-tutorial.html';
var urls = ['http://blog.sina.com.cn/s/blog_9f23a8da010195qx.html','http://www.runoob.com/nodejs/nodejs-tutorial.html'];
connection.connect();
for(var i = 0;i<urls.length;i++){
http.get(urls[i],function(res){
var html = '';
res.on('data',function(data){
html+=data;
});
res.on('erro',function(erro){
console.log('抓取失敗喊括！'+erro.stack);
});
res.on('end',function(){
var htmlBuf = new Buffer(html);
var h = htmlBuf.toString('base64');//緩沖形式經(jīng)過base64加密
var? sql = 'insert into html (result) values("'+h+'")';定義sql爱葵，將加密后的html插入數(shù)據(jù)庫
connection.query(sql,function (err, result) {
? if(err){
console.log('[INSERT ERROR] - ',err.message);
}else{
? console.log('success!');
? ? ? ? ? }
? ? ? });
? ? });
});
}
//數(shù)據(jù)庫連接先不關(guān)閉
