robot.java

java 开发的电子通讯录

package edu.hqu.JYT.addressBook.util;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

import org.eclipse.swt.SWT;
import org.eclipse.swt.widgets.MessageBox;
import org.eclipse.swt.widgets.Shell;

public class Robot {
	private static Shell parent;
	private static Date today;
	private static DataTable table;

	public Robot(Shell parent) throws SQLException {
		Robot.parent = parent;
		today = new Date();
		table = new DataTable("user", "1234567");
	}

	public static void happyBirthday() throws SQLException {
		int month = today.getMonth() + 1;
		int date = today.getDate();
		StringBuffer sb = new StringBuffer("");

		ResultSet rs = table.searchFor(month, date);
		while (rs.next()) {
			sb.append(rs.getString(1) + "\t" + rs.getString(2) + "\t"
					+ rs.getString(3) + "\t" + rs.getString(4) + "\n");
		}

		String str = new String(sb);
		if (str.equals("")) {
			return;
		}

		MessageBox box = new MessageBox(parent, SWT.ICON_INFORMATION);
		box.setText("友情提醒");
		box.setMessage("给下面朋友打个电话吧，今天是他们的生日：\n姓名\t座机号码\t手机号码\t办公室号码" + str);
		box.open();
	}
}