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

public class AddWin extends JFrame implements ActionListener {
      
     JTextField 添加漢語解釋_文本條,添加英語單詞_文本條; 
     
     JButton addbtn,cancelbtn;
     
     Connection Con=null;
     
     Statement Stmt=null;
     
     public AddWin()
     {
     	super("添加單詞");
     	
     	this.setBounds(250,250,250,200);
     	
     	this.setVisible(true);
     	
    	JPanel p1=new JPanel();
     	
     	p1.add(new Label("輸入要添加的單詞:"));
     	
     	添加英語單詞_文本條=new JTextField(20);
     	
     	p1.add(添加英語單詞_文本條);
     	
     	p1.add(new Label("輸入添加的單詞的解釋:"));
     	
     	添加漢語解釋_文本條=new JTextField(20);
     	
     	p1.add(添加漢語解釋_文本條);
     	
     	addbtn = new JButton("提交");
     	
     	cancelbtn = new JButton("取消");
     	
     	p1.add(addbtn); p1.add(cancelbtn);
     	
     	this.add(p1);
     	
     	addbtn.addActionListener(this);
     	
     	cancelbtn.addActionListener(this);
     	
     	this.validate();
     	     	
     }
     
     
     public void actionPerformed(ActionEvent e)
     {
     	if(e.getSource()==addbtn)
     	{
     		if(添加英語單詞_文本條.getText().equals("")||
     		
     		   添加漢語解釋_文本條.getText().equals(""))
     		   
     		   {
     		   	   JOptionPane.showMessageDialog(this,"添加的單詞或解釋不能為空！","警告",
     		   	
                   JOptionPane.WARNING_MESSAGE);

     		   }
     		   
     		   	// 判斷輸入框不能為空
     		   
     		 else{
     		      		
     		        try{
     			           添加();
     			     	     			      
     		            }
     		            
     		         catch(SQLException ee){}  
     		      }   		
     		
     	}
     	
     	else if(e.getSource()==cancelbtn)
     	{
     		dispose();
     	}
     }
     
     
     public void 添加() throws SQLException   //實現添加功能
     {
     	String cname,ename;
     	
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		
		catch(ClassNotFoundException e){}
		
		Con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=english\\english.mdb","","");
				
		Stmt=Con.createStatement();
		
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 表1");
		
		boolean boo=false;
		
		while((boo=rs.next())==true)
		{
			ename=rs.getString("單詞");
			
			cname=rs.getString("解釋");
			
			if(ename.equals(添加英語單詞_文本條.getText()))
			{
				JOptionPane.showMessageDialog(this,"此詞匯已存在！","警告",
				
				JOptionPane.WARNING_MESSAGE);
				
				break;
			}
		}
		
		if(boo==false)
		{
			String s1="'"+添加英語單詞_文本條.getText().trim()+"'",s2="'"+添加漢語解釋_文本條.getText().trim()+"'";
     	
     	    String temp="INSERT INTO 表1 VALUES ("+s1+","+s2+")";
     	     	         	
     	    Stmt.executeUpdate(temp);
									
			JOptionPane.showMessageDialog(this,"添加成功！","恭喜",
			
			JOptionPane.WARNING_MESSAGE);
				
			dispose();
		}
		
		Con.close();
     	
     	     	
     }
}