java jsoup 网络爬虫 学习例子（四）抓取网页连接插入mysql数据库

java jsoup 网络爬虫 学习例子(四) 抓取网页连接插入mysql数据库

package com.iteye.injavawetrust.jsoup;

import java.io.IOException;
import java.util.Iterator;

import org.jsoup.Jsoup;
import org.jsoup.nodes.Document;
import org.jsoup.nodes.Element;
import org.jsoup.select.Elements;

/**
 * 
 * @author InJavaWeTrust
 *
 */
public class GetLink {
	
	private JsoupUtil ju = JsoupUtil.getInstance();
	
	private DBUtil du = DBUtil.getInstance();
	
	private Link link = new Link();
	
	private String insertSql = "";
	
	public void getLink(String url) {
		try {
			Document document = Jsoup.connect(url).timeout(5000).get();
			Elements hrefs = document.select("a[href]");
			Iterator<Element> hrefIter = hrefs.iterator();
			while (hrefIter.hasNext()) {
				Element href = hrefIter.next();
				link.setId(ju.getUUID());
				link.setUrlName(href.text());
				link.setUrl(href.attr("href"));
				inser