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

public class DealPanel extends JPanel{
	private JButton addButton,deleteButton,alterButton;

	public DealPanel(){
		setLayout(new FlowLayout());
		addButton = new JButton("添加");
		addButton.addActionListener(new Add());
		deleteButton = new JButton("刪除");
		deleteButton.addActionListener(new Delete());
		alterButton = new JButton("修改");
		alterButton.addActionListener(new Alter());
		add(addButton);
		add(deleteButton);
		add(alterButton);
	}
	
	public void setAddButtonText(String name){
		addButton.setText(name);
	}
	
	public void setAlterButtonText(String name){
		alterButton.setText(name);
	}
	
	class Delete implements ActionListener{
		private JList list;
		private String lname[];
		private DbOperation db;
		
		public Delete(){	
			db = new DbOperation();
		}
		public void actionPerformed(ActionEvent event){
			int option = JOptionPane.showConfirmDialog(null,"真的要刪除嗎？","添加聯系人",JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE);
			if(option == JOptionPane.OK_OPTION){
				int index = -1;
				list = PhoneBook.getNamePanel().getNameList();
				index = list.getSelectedIndex();
				if(index!=-1){
					String dname = PhoneBook.getSelectedText();
					String sql = "DELETE FROM 聯系方式 WHERE NAME ='"+dname+"'";
					db.executeUpdate(sql);
					try{
						lname = PhoneBook.getNamePanel().getAllName();	
						list.setSelectedIndex(0);
						PhoneBook.getMainPanel().setFieldText("","","","","","","","");
						list.setListData(lname);			
					}
					catch(Exception e){}
				}
				else{
					JOptionPane.showMessageDialog(null,"必須先選定才能刪除！","提示",JOptionPane.INFORMATION_MESSAGE);
				}
				PhoneBook.refresh();
			}
		}
	}
	
	class Alter implements ActionListener{
		private JList list;
		private String name[],lname[];
		private DbOperation db;
		private MainPanel panel;
		private String nameKey;
		
		public Alter(){
			list = PhoneBook.getList();
			
			db = new DbOperation();
			panel = PhoneBook.getMainPanel();
		}
		
		public void actionPerformed(ActionEvent event){
			name = PhoneBook.getNamePanel().getAllName();
			if(event.getActionCommand().equals("修改")){
				nameKey = PhoneBook.getSelectedText();
				if(nameKey.equals("")){
					JOptionPane.showMessageDialog(null,"請先選擇要修改的聯系人！","提示",JOptionPane.INFORMATION_MESSAGE);
				}
				else{
					setAlterButtonText("保存修改");
					panel.setEditable(true,false);	
				}
			}
			else if(event.getActionCommand().equals("保存修改")){
				setAlterButtonText("修改");
				panel.setEditable(false,false);
				
				String num1 = panel.getNum1Text();
				String num2 = panel.getNum2Text();
				String num3 = panel.getNum3Text();
				String mail = panel.getMailText();
				String qq = panel.getQqText();
				String workunit = panel.getWorkunitText();
				String address = panel.getAddressText();
				String sql = "UPDATE 聯系方式 SET NUM1 ='"+num1+"',NUM2='"+num2+"',NUM3='"+num3+"',MAIL='"+mail+"',QQ='"+qq+"',WORKUNIT='"+workunit+"',ADDRESS='"+address+"' WHERE NAME='"+nameKey+"'";
				db.executeUpdate(sql);
				}
			}
		}

	class Add implements ActionListener{
		private MainPanel panel;
		private DbOperation db;
		private String[] lname;
		private JList list;
		public Add(){
			panel = new MainPanel();
			panel.setEditable(true,true);
			db = new DbOperation();
		}
		public void actionPerformed(ActionEvent event){
			list = PhoneBook.getNamePanel().getNameList();
			panel.setFieldText("","","","","","","","");
			int option = JOptionPane.showConfirmDialog(null,panel,"添加聯系人",JOptionPane.OK_CANCEL_OPTION,JOptionPane.PLAIN_MESSAGE);
			if(option == JOptionPane.OK_OPTION){
				String name = panel.getNameText();
				if(name.equals("")){
					JOptionPane.showMessageDialog(null,"您必須輸入姓名","提示",JOptionPane.INFORMATION_MESSAGE);
				}
				else{
					String num1 = panel.getNum1Text();
					String num2 = panel.getNum2Text();
					String num3 = panel.getNum3Text();
					String mail = panel.getMailText();
					String qq = panel.getQqText();
					String workunit = panel.getWorkunitText();
					String address = panel.getAddressText();
					String sql = "INSERT INTO 聯系方式 VALUES('"+name+"','"+num1+"','"+num2+"','"+num3+"','"+mail+"','"+qq+"','"+workunit+"','"+address+"')";
					db.executeUpdate(sql);
					lname = PhoneBook.getNamePanel().getAllName();
					list.setListData(lname);
				}
			}
			PhoneBook.refresh();
		}
	}
}