mailfactory.java

这是我做的一个收发邮件的软件

package source;

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

public class MailFactory {
	private static DataBase db;
	private static ResultSet rs;
	public static  ArrayList getMailList(String sql)
	{
		ArrayList<Email> list=new ArrayList();
		db=new DataBase();
		db.connectToDB();
		rs=db.executeQuery(sql);
		try {
		while(rs.next())
		{
			Email email;
			email=new Email();
			email.setId(rs.getLong("id"));
			email.setFlag(rs.getInt("flag"));
			email.setFujian_addr(rs.getString("fujian_addr"));
			email.setRead(rs.getBoolean("read"));
			email.setS_name(rs.getString("s_name"));
			email.setS_time(rs.getString("s_time"));
			email.setTitle(rs.getString("title"));
			list.add(email);
		}
		return list;
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
			return list;
			
		}
	}

}