group.java

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

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

public class Group {

	public int id; // number primary_key

	public int person_id; // number foreign key to people

	public String name; // varchar

	private Person person;

	private Connection cnn;

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

	/**
	 * @param args
	 */
	public static void main(String[] args) {

	}

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

	public void insert() throws SQLException {

		insertToDB();
	}

	public void printMe() {

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

	public static synchronized void printMe(ArrayList<Group> groups) {

		for (Group group : groups)
			group.printMe();

	}

	public static synchronized void insert(ArrayList<Group> groups) throws SQLException {
		for (Group group : groups)
			group.insert();
	}

	public static synchronized void appendTo(ArrayList<Group> groups,
			StringBuilder sb) {
		for (Group group : groups) {
			sb.append("\r\n----------------------------\r\n");
			group.appendTo(sb);
		}
	}

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

	}

}