peoplefactory.java

来自「这是我做的一个收发邮件的软件」· Java 代码 · 共 45 行

package source;

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

import javax.swing.JOptionPane;

public class PeopleFactory {
	private static DataBase db;
	private static ResultSet rs;
    public static List getPeoples() 
    { 
        List<PeopleEntity> list = new ArrayList();
        db=new DataBase();
		db.connectToDB();
		String sql="";
		sql="select * from people";
		rs=db.executeQuery(sql);
		try {
			
		while(rs.next())
		{
			PeopleEntity people;
			people=new PeopleEntity();
			Long l=new Long(rs.getLong("id"));
			people.setId(l);
			people.setSex(rs.getBoolean("sex"));
			people.setName(rs.getString("name"));
			people.setMail1(rs.getString("email"));
			people.setNumber(rs.getString("phone"));
			list.add(people);
		}
		return list;
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
			return list;
			
		}
    }

}