searchall.java

实现从某个网站的全部遍历

package com.yinyueku;

import com.yinyueku.Searcher;
import java.sql.*;
import org.htmlparser.Node;
import org.htmlparser.NodeFilter;
import org.htmlparser.Parser;
import org.htmlparser.filters.HasAttributeFilter;
import org.htmlparser.filters.TagNameFilter;
import org.htmlparser.tags.LinkTag;
import org.htmlparser.util.NodeList;
import org.htmlparser.util.ParserException;

public class Searchall {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		// String htmfile = "C:\\search.htm";
		// String searchUrl = "c:\\45歌曲.txt";
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

			Connection con = DriverManager
					.getConnection(
							"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenlei",
							"sa", "12345");
			System.out.println(con.getCatalog());
			Statement stmt = con.createStatement();
			String sql = "SELECT * FROM SINGERS001";
			System.out.println(sql);
			ResultSet rs = stmt.executeQuery(sql);
			//ResultsetMetaData rsmd=rs.getMetaData();
			// rsmd.getColumnCount(); //返回结果集中的列数
			// rsmd.getColumnLabel(1); //返回第一列的列名（字段名）
			// for(int i=1; i<=rs.getMetaData().getColumnCount(); i++)
			// //跟踪显示各个列的名称
			// { System.out.print(rs. getColumnName(i)+"\t");
			// }
			while (rs.next()) { // 跟踪显示各个列的值
				String searchName=rs.getString("SINGER_NAME");
				String searchUrl=rs.getString("SINGER_URL");
			    System.out.println(searchName +":"+ searchUrl);
			    Searcher search = new Searcher(searchUrl);
			}
			System.out.println("所有歌手所有歌曲信息搜索完毕");
		} catch (Exception e) {
			e.printStackTrace();
		}
		

	}

}