/*
 * @(#)Database.java 1.0 06/06/23
 * @作者：林寶尉
 */
package myprojects.ButtonsAction;

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

public class Delete_Teacher
{
	String sql1,sql2;
	JFrame f=new JFrame();
	JButton Save;
	JButton Exit;
	JTextField textfield_1;
	JTextField textfield_2;
	JTextArea chinesetext=new JTextArea(10,30);
	Object[] options={"確定"};
	Container c=f.getContentPane();
	GridBagLayout gbLayoutObj; 
	GridBagConstraints gbcObj;	
	public Delete_Teacher()
	{
		
		Container c=f.getContentPane();
	    GridBagLayout gbLayoutObj; 
	    GridBagConstraints gbcObj;
	    
	    gbLayoutObj=new GridBagLayout();
	    gbcObj=new GridBagConstraints();	    		
		c.setLayout(gbLayoutObj); 
	    c.setBackground(Color.cyan);
	    FlowLayout flayout;
	    flayout=new FlowLayout(FlowLayout.RIGHT,0,0);	

	    JLabel label_wel=new JLabel("學籍管理系統");
		Font ft=new Font("宋體",Font.BOLD,26);
        label_wel.setFont(ft);
		gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=0;		
		gbLayoutObj.setConstraints(label_wel,gbcObj);
		c.add(label_wel);
	    
	    JLabel label_we=new JLabel("----教師信息刪除");
		Font ftt=new Font("隸書",Font.BOLD,24);
        label_we.setFont(ftt);
		gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=1;		
		gbLayoutObj.setConstraints(label_we,gbcObj);
		c.add(label_we);
		
		JLabel label_1=new JLabel("輸入教師姓名:");
	    textfield_1=new JTextField(10);
	    JPanel panel_1=new JPanel();
	    panel_1.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=2;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_1.add(label_1);
		panel_1.add(textfield_1);
		gbLayoutObj.setConstraints(panel_1,gbcObj);
		c.add(panel_1);
		
	     
	    JPanel panel_button=new JPanel();
	    Save=new JButton("提交");
	    Exit=new JButton("退出");
	    FlowLayout flayout1=new FlowLayout(FlowLayout.CENTER,0,0);	    
	    panel_button.setLayout(flayout1);
	    gbcObj.anchor=GridBagConstraints.CENTER;		
		gbcObj.gridx=0;
		gbcObj.gridy=3;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_button.add(Save);
		panel_button.add(Exit);
		gbLayoutObj.setConstraints(panel_button,gbcObj);
		c.add(panel_button); 
		Save.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent asd)
			{
				if(textfield_1.getText().length()==0)
				{
					String str1=new String("警告！你沒有輸入任何數據.");
				    JOptionPane.showOptionDialog(null,str1,
					"警告窗口！",JOptionPane.DEFAULT_OPTION,
					JOptionPane.WARNING_MESSAGE,null,options,
					options[0]);				
					return;	
					} 
				else
				{
					sql1=new String("delete from teacher where teacher.Teacher ='"+textfield_1.getText()+"' ");
					sql2=new String("delete from course where course.Cteacher ='"+textfield_1.getText()+"' ");
					}
				Connection con;
		        Statement stm;				       				
				try {Class.forName("com.mysql.jdbc.Driver").newInstance(); }
	            catch(Exception e)
	            {  System.out.println(e.getMessage());}
	            try{con=DriverManager.getConnection("jdbc:mysql://localhost/shujuku?user=root&password=linbaowei");            
	            stm=con.createStatement();	
	            stm.executeUpdate(sql1);     
	            stm.executeUpdate(sql2);     
			    stm.close(); 
	            con.close();
	            String str1=new String("已經刪除成功！");
					    JOptionPane.showOptionDialog(null,str1,
						"提示！",JOptionPane.DEFAULT_OPTION,
						JOptionPane.WARNING_MESSAGE,null,options,
						options[0]);
					    return;	
	            }
	            catch(SQLException ep){ System.out.println(	ep.getMessage());
	            
	             }		
		  }});
		Exit.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent asd)
			{	
				System.exit(0);
				}});
		f.setSize(600,600);
		f.setTitle("Delete_Teacher");
		f.setBounds(200,200,500,500); 
		f.setVisible(true);
	}   
}