package mainface;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;
public class Std_face   implements ActionListener,ItemListener{
   protected static JFrame fame=new JFrame("學生成績管理系統");
   protected JDesktopPane  desktop=new JDesktopPane();
   JPanel jp1=new JPanel();
   JLabel  label[]=new JLabel[28];
   String str[];
   String ss="name";
   int k=1;
   JDialog d;
   JPanel jp2=new JPanel();
   String head[]; 
   DefaultTableModel mod=new DefaultTableModel();
   JMenuItem mitem2;
   JMenuItem bjitem1=new JMenuItem("復制");
   JMenuItem bjitem2=new JMenuItem("剪切");
   JMenuItem bjitem3=new JMenuItem("粘貼");
   JMenuItem bjitem4=new JMenuItem("刪除");
   JMenuItem d1=new JMenuItem("查詢");
   JMenuItem d2=new JMenuItem("編輯");
   JMenuItem d3=new JMenuItem("插入");
   JMenuItem d4=new JMenuItem("查看");
   JMenu  menu=new JMenu("工具");
   JMenuItem item=new JMenuItem("刷新");
   JMenuItem item0=new JMenuItem("注冊");
   JMenuItem item1=new JMenuItem("修該密碼");
    JComboBox box;
   JButton button=new JButton("查詢");
   JTextField  field=new JTextField();
   JTextArea area=new JTextArea();
   JInternalFrame inter;
   protected static Connect connect=new Connect();
   JTable tabel;
   Connect c=new Connect();
   String string[][]=c.ScanL();
   JScrollPane scoll;
   JInternalFrame  interf;
   JButton b=new JButton("確定");
   public Std_face(){
	 
   }
   public void makeFace(){
	     desktop.setDragMode(JDesktopPane.OUTLINE_DRAG_MODE);
	     fame.getContentPane().add(desktop,BorderLayout.CENTER);
	     ((JPanel)fame.getContentPane()).setOpaque(false);
         int a,b;
         GraphicsEnvironment graphicsEnvironment = GraphicsEnvironment.getLocalGraphicsEnvironment();
         GraphicsDevice graphicsDevice = graphicsEnvironment.getDefaultScreenDevice();   
         DisplayMode displayMode = graphicsDevice.getDisplayMode();   
         a=displayMode.getWidth();
         b=displayMode.getHeight();//獲得屏幕的長與寬；
         JMenuBar jmbar=new JMenuBar();
         JMenu m1=new JMenu("文件");//設置文件菜單；
         mitem2=new JMenuItem("退出");
    	 m1.add(mitem2);
         jmbar.add(m1);//添加菜單到菜單條；
         JMenu m3=new JMenu("操作");
         m3.add(d1);
         m3.add(d2);
         menu.add(item);
         menu.add(item0);
         menu.add(item1);
         jmbar.add(menu);
         m3.add(d3);
         m3.add(d4);
         jmbar.add(m3);
         item.addActionListener(this);
         mitem2.addActionListener(this);
         bjitem1.addActionListener(this);
         bjitem2.addActionListener(this);
         bjitem3.addActionListener(this);
         bjitem4.addActionListener(this);
         d1.addActionListener(this);
         d2.addActionListener(this);
         d3.addActionListener(this);
         d4.addActionListener(this);
         JLabel  jlabel=new JLabel(new ImageIcon(getClass().getResource("beixue.jpg")));
         jlabel.setSize(a,b);
         fame.getLayeredPane().add(jlabel,new Integer(Integer.MIN_VALUE));
         jmbar.setOpaque(false);
         fame.setJMenuBar(jmbar);
    	 fame.setLayout(new  BorderLayout());//設置窗體屬性；
         fame.setVisible(true);
         fame.setBounds(0,0,a,b);
         fame.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
        }
     public void  QuieryFace(){
         str=new String[]{"姓名","學號","編號"};
    	 box=new JComboBox(str);
    	 button.addActionListener(this);
    	 inter=new JInternalFrame("查詢",true,true,true);
    	 inter.setLayout(new GridLayout(3,0,10,20));
    	 jp1.setLayout(new BorderLayout());
    	 jp1.add(new JLabel("     "),BorderLayout.NORTH);
    	 jp1.add(new JLabel("     "),BorderLayout.SOUTH);
    	 jp1.add(new JLabel("  "),BorderLayout.EAST);
    	 jp1.add(new JLabel("  "),BorderLayout.WEST);
         area.setBorder(BorderFactory.createLineBorder(new Color(197,215,235),5 ));
         area.setEditable(false);
         jp1.add(area,BorderLayout.CENTER);
         area.setLayout(new GridLayout(4,7,0,0));
         jp2.setLayout(new GridLayout(4,4,10,1));
    	 jp2.add(new JLabel());
    	 jp2.add(new JLabel("選擇查詢方式"));
    	 jp2.add(new JLabel("輸人查詢內容"));
    	 jp2.add(new JLabel());
    	 jp2.add(new JLabel());
    	 jp2.add(new JLabel());
    	 jp2.add(box);
    	 jp2.add(field);
    	 jp2.add(button);
    	 jp2.add(new JLabel());
    	 for(int i=1;i<=8;i++)
    		 jp2.add(new JLabel());
    	 inter.add(jp1);
    	 inter.add(jp2);
    	 inter.setBounds(100,100,500,400);
    	 fame.add(inter);
         box.addItemListener(this);
         
	  }
     public void itemStateChanged(ItemEvent e){
    	 int n;
       	n=box.getSelectedIndex();
       	switch(n){
       	case 0:ss="name";break;
       	case 1:ss="xuehao";break;
       	case 2:ss="ID";break;
       	}
      
     }
     
    
  
    public void makeScan(){
    	//JTableHeader header=tabel.getTableHeader();
        interf=new JInternalFrame("瀏覽",true,true,true);
        head=new String[]{"編號","學號","姓名","生日","數學","英語","C語言"};
        mod=new DefaultTableModel(string,head);
       
        tabel=new JTable();
        tabel.setModel(mod);
        scoll=new JScrollPane(tabel);
        interf.add(scoll);
        interf.setBounds(500,0,524,768);
        interf.setDefaultCloseOperation(WindowConstants.HIDE_ON_CLOSE);
        fame.add(interf);
        }
   public  void  attention(String a){
	    d=new JDialog();
	    d.setLayout(new GridLayout(2,1));
	   // d.add(new JLabel());
	    JLabel ba=new JLabel(a);
	    ba.setFont(new Font("",Font.BOLD,15));
	    d.setBounds(400,500,250,180);
	    b.addActionListener(this);
	    JPanel p=new  JPanel();
	    p.setLayout(new GridLayout(2,3,10,5));
	    for(int i=0;i<6;i++)
	    {   if(i==1)
	    	p.add(b);
	        else
	    	p.add(new JLabel());}
	    d.add(ba);
	    d.add(p);
	    d.setVisible(false);
      }
    public void actionPerformed(ActionEvent a){//菜單觸發事件；
    	if(a.getSource()==bjitem1){
    		
    	}
    	if(a.getSource()==mitem2){
    		System.exit(0);
    	}
    	if(a.getSource()==button){
         area.removeAll();
         str=connect.Quiry(ss,field.getText());
         if(str==null)
         { JLabel label=new JLabel("         未查到檢索內容!");
           area.add(new JLabel("                     "));
           area.add(label);
           area.add(new JLabel("                     "));
           }
         else{
    	 String[] names={"編號","學號","姓名","生日","數學","英語","C語言",str[0],str[1],str[2],str[3],str[4],str[5],str[6]};
         for(int j=0;j<28;j++)
           { if(j<=13)
        	   label[j]=new JLabel(names[j]);  
             else
            	label[j]=new JLabel();
             area.add(label[j]);
    	    }
           }
         area.invalidate();//重新布局，相當于刷新；
         area.validate();//
    	}
    	if(a.getSource()==d1){
    		if(inter.isVisible())
    		inter.setVisible(false);       
    		else
    		inter.setVisible(true);
    	}                                  
    	if(a.getSource()==d4){
    		
    		if(interf.isVisible())
    			interf.setVisible(false);
    		else
    			interf.setVisible(true);
    	}
    	if(a.getSource()==d3){
    		if(Scan.interf.isVisible())
    			Scan.interf.setVisible(false);
    		else
    			Scan.interf.setVisible(true);
    	}
    	if(a.getSource()==d2){
    		if(!Deleup.interd.isVisible())
    	  Deleup.interd.setVisible(true);
    		else
    			 Deleup.interd.setVisible(false);
    	}
    	if(a.getSource()==b){
    		d.setVisible(false);
    	}
    	if(a.getSource()==item){
    		 int y;
    		 int i=c.Cont();
    	   	String s[]=new String[]{"","","","","","",""};
     	     String  str[][]=c.ScanL();
    		 head=new String[]{"編號","學號","姓名","生日","數學","英語","C語言"};
    		 mod=new DefaultTableModel(str,head);
    		
    		 
    		 tabel.setModel(mod);
    		 tabel.repaint();
             tabel.invalidate();//重新布局，相當于刷新；
             tabel.validate();
             k++;
    	}
    }
     public static void main(String args[]){
    	  
          Scan can=new Scan(connect,fame);
    	  Std_face face=new Std_face();
    	  Deleup de=new Deleup(connect, fame);
    	  face.QuieryFace();
    	  face.makeScan();
    	  can.Insert();
    	  de.deleteS();
    	  face.makeFace();
         }
     }