honor.java

利用多线程从搜索引擎下载网页并提取数据到数据库。

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;

public class Honor {

	public int id;// number primary_key

	public int person_id;// number foreign key to people

	public String name; // varchar ;//

	public Person person;

	private Connection cnn;

	public Honor(String name) {
		this.name = name;
	}

	public Honor(Person person) {
		this.person = person;
		this.cnn = person.cnn;
	}

	public void insert() throws SQLException {
		insertToDB();

	}

	public void printMe() {

		System.out.println(this.name);
	}

	private void insertToDB() throws SQLException {
		PreparedStatement ps;
			ps = cnn
					.prepareStatement("insert into honors(person_id,name) select ?,?");
			ps.setInt(1, person.id);
			ps.setString(2, this.name);
			ps.execute();

	}

	public static synchronized void insert(ArrayList<Honor> honors) throws SQLException {
	
		for (Honor honor : honors)
			honor.insert();
	}

	public static synchronized void printMe(ArrayList<Honor> honors) {
		for (Honor honor : honors)
			honor.printMe();
	}

	public static void appendTo(ArrayList<Honor> honors, StringBuilder sb) {
		for (Honor honor : honors) {
			sb.append("\r\n----------------------------\r\n");
			honor.apendTo(sb);
		}
	}

	private void apendTo(StringBuilder sb) {
		sb.append(name);
		sb.append("\r\n");

	}

}