package mainface;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class Deleup implements ActionListener,ItemListener{
	 static	JInternalFrame interd=new JInternalFrame("編輯",true ,true ,true);
	//  interd=new JDialog();
	  Std_face std=new Std_face();
	  
	  Std_face std1=new Std_face();
	  JFrame jf;
	  Connect con;
	  String up="ID";
	  String de="ID";
	  JRadioButton radio=new JRadioButton("刪除");
	  JRadioButton update=new JRadioButton("修改");
	  ButtonGroup gr=new ButtonGroup();
	  JPanel j=new JPanel();
	  JPanel pa=new JPanel();
	  JPanel pan=new JPanel();
	  JPanel pa1=new JPanel();
	  JButton ye=new JButton("確定");
	  JButton bu=new JButton("清除");
	  String s[]=new String[]{"編號","學號","姓名"};//要刪除的列名；
	  String t[]=new String[]{"編號","學號","姓名","生日","數(shù)學","英語","C語言"};//要更新的列名；
	  JComboBox box=new JComboBox(s);//刪除
	  JComboBox pox=new JComboBox(t);//更新
	  JTextField field=new JTextField(15);
	  JTextField field1=new JTextField(15);
	  int n;
	  int m;
	  public Deleup(){
		  
	  }
	 public Deleup(Connect c,JFrame f){
	   con=c;
	   jf=f;
	 }
	public void  deleteS(){
		JPanel  p=(JPanel)interd.getContentPane();
	    interd.setLayout(new GridLayout(3,1));
		 j.setLayout(new GridLayout(3,1));
		 JLabel la=new JLabel("        請選擇更新或刪除:");
		 la.setFont(new Font("",Font.BOLD,20));
		 j.add(la);
		 JPanel n=new JPanel();
		 n.setLayout(new GridLayout(0,4));
		 n.add(new JLabel());
		 pox.setEnabled(false);
		 field1.setEditable(false);
		 n.add(update);
		 n.add(radio) ;
		 radio.setSelected(true);
		 gr.add(radio);
		 gr.add(update);
		 n.add(new JLabel());
		 j.add(n);
		 pan.setLayout(new GridLayout(4,3,0,0));
		 pan.add(new JLabel("   選擇刪除或更新的列名："));
		 pan.add(box);
		 pan.add(new JLabel());
		 pan.add(new JLabel("                輸入內容確定行："));
		 pan.add(field);
		 pan.add(new JLabel());
		 pan.add(new JLabel("            選擇要更新的列名："));
		 pan.add(pox);
		 pan.add(new JLabel());
		 pan.add(new JLabel("                 輸入更新的內容："));
		 pan.add(field1);
		 pan.add(new JLabel());
		 pa.setLayout(new GridLayout(3,3,10,0));
		 pa.add(new JLabel());
		 pa1.add(ye);
		 pa1.add(bu);
		 pa.add(pa1);
		 for(int i=0;i<7;i++)
			 pa.add(new JLabel());
		 std.attention("@恭喜您，操作成功！");
		 std1.attention("有錯誤，請檢查！");
		 radio.addActionListener(this);
		 update.addActionListener(this);
		 ye.addActionListener(this);
		 bu.addActionListener(this);
		 box.addItemListener(this);
		 pox.addItemListener(this);
		 interd.add(j);
		 interd.add(pan);
		 interd.add(pa);
		 interd.setDefaultCloseOperation(WindowConstants.HIDE_ON_CLOSE);
		 interd.setVisible(false);
		// interd.setBounds();
		 interd.setBounds(200,100,500,400);
		 jf.add(interd);
	 }
	public void itemStateChanged(ItemEvent a){
		 n=box.getSelectedIndex();
		 m=pox.getSelectedIndex();
		if(a.getSource()==box){
			switch(n){
			
			case  0:  de="ID";break;
			case  1:  de="xuehao";break;
			case  2:  de="name";
			}
			System.out.println("n的值："+n);
		}
		if(a.getSource()==pox){
			switch(m){
			case 0:  up="ID";break;
			case 1:  up="xuehao";break;
			case 2:  up="name";break;
			case 3:  up="birthday";break;
			case 4:  up="math";break;
			case 5:  up="english";break;
			case 6:  up="Cyuyan";break;
			}
			System.out.println("m的值："+m);
		}
		
	}
	public void actionPerformed(ActionEvent r){
		if(r.getSource()==radio){
			pox.setEnabled(false);
			field1.setEditable(false);
		}
		if(r.getSource()==update){
			pox.setEnabled(true);
			field1.setEditable(true);
		}
		if(r.getSource()==ye){
			String str[];
			if(radio.isSelected())
				con.Delete(de,field.getText());
			   
			str=new String[]{up,field1.getText(),de,field.getText()};
			if(update.isSelected()){
			boolean f=con.upDate(str);
			System.out.println(field1.getText()+"GGG");
			if(f)
				std.d.setVisible(true);
			else
				std1.d.setVisible(true);
			
				
			}
		}
		if(r.getSource()==bu){
			field.setText("");
			field1.setText("");
		}
	}
	public static void main(String args[]){
		new Deleup().deleteS();
	}

}