phonebook.java

PhoneBook主要的功能是查找、添加、删除、编辑用户mainclass WelcomeWindow

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

public class PhoneBook extends JFrame{
	private Container container;
	private static MainPanel panel1;
	private static NamePanel panel2;
	private static JList list;
	private static String name[];
	private DbOperation db;
	private static CachedRowSet crs;
	private DealPanel dealPanel;
	
	public PhoneBook(){
		super("我的电话本");
		db = new DbOperation();
		BorderLayout b = new BorderLayout();
		b.setHgap(15);
		b.setVgap(5);
		panel1 = new MainPanel();
		panel1.setEditable(false,false);
		container = getContentPane();
		container.setLayout(b);
		container.add(panel1);
		dealPanel = new DealPanel();
		panel2 = new NamePanel();
		list = panel2.getNameList();
		name = panel2.getListName();
		list.addListSelectionListener(
		new ListSelectionListener(){
				public void valueChanged(ListSelectionEvent e){
					panel1.setEditable(false,false);
					dealPanel.setAlterButtonText("修改");
					String sql = "SELECT * FROM 联系方式 WHERE name ='"+getSelectedText()+"'";
					try{
					crs = db.executeQuery(sql);
					crs.next();
					String str1 = crs.getString("name");
					String str2 = crs.getString("num1");
					String str3 = crs.getString("num2");
					String str4 = crs.getString("num3");
					String str5 = crs.getString("mail");
					String str6 = crs.getString("QQ");
					String str7 = crs.getString("workunit");
					String str8 = crs.getString("address");
					panel1.setFieldText(str1,str2,str3,str4,str5,str6,str7,str8);
					}
					catch(Exception er){}
					
				}
			}
		);
		container.add(panel2,BorderLayout.WEST);
		container.add(new SearchPanel(),BorderLayout.NORTH);
		container.add(dealPanel,BorderLayout.SOUTH);
		container.add(new JPanel(),BorderLayout.EAST);
		
		setVisible(true);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		pack();
		setResizable(false);
		
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize = getSize();
		setLocation((screenSize.width-frameSize.width)/2,(screenSize.height-frameSize.height)/2);
	}
	
	public static JList getList(){
		return list;
	}
	
	public static String[] getNumName(){
		return name;
	}
	
	public static NamePanel getNamePanel(){
		return panel2;
	}
	
	public static MainPanel getMainPanel(){
		return panel1;
	}
	
	public static String getSelectedText(){
		String str = "";
		if(list.getSelectedIndex()!=-1)
			str = name[list.getSelectedIndex()];
		return str;
	}
	
	public static void refresh(){
		name = panel2.getAllName();
	}
}