import javax.swing.*;
import java.awt.*;
import javax.sql.rowset.*;

public class NamePanel extends JPanel{
	private JList nameList;
	private String[] name;
	private int number;
	private static CachedRowSet rs;
	
	public NamePanel(){
		super(new BorderLayout());
		nameList = new JList(new DefaultListModel());
		nameList.setListData(getAllName());
		nameList.setBorder(BorderFactory.createTitledBorder("我的聯系人"));
		nameList.setFixedCellWidth(120); 
		add(new JScrollPane(nameList,ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED,ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER));
	}
	
	public String[] getAllName(){
		int i=0,size = 1;
		DbOperation forName = new DbOperation();
		String sql = "SELECT * FROM 聯系方式";
		rs = forName.executeQuery(sql);
		size = rs.size();
		name = new String[size];
		try{
			while(rs.next()){
				name[i++] = rs.getString("name");
			}
		}
		catch(Exception e){}
		return name;
	}
	
	public String[] getListName(){
		return name;
	}
	
	public JList getNameList(){
		return nameList;
	}
	
	public static CachedRowSet getRowSet(){
		return rs;
	}	
}