addwin.java

这是一个用java编写的发音电子词典

/*
 * AddWin.java
 *
 * Created on 2007年12月16日, 下午8:58
 *
 * To change this template, choose Tools | Options and locate the template under
 * the Source Creation and Management node. Right-click the template and choose
 * Open. You can then make changes to the template in the Source Editor.
 */

package 电子词典;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;

/**
 *
 * @author baili
 */
public class AddWin extends JFrame implements ActionListener{
    
    /** Creates a new instance of AddWin */
    JTextField 添加汉语解释_文本条,添加英语单词_文本条;
    JButton addbtn,cancelbtn;
    Connection Con=null;
    Statement Stmt=null;
    public AddWin() 
    {
        super("添加单词");
        this.setBounds(250,250, 250, 200);
        this.setVisible(true);
        添加英语单词_文本条=new JTextField(20);
        添加汉语解释_文本条=new JTextField(20);
        JPanel p1=new JPanel();
        p1.add(new JLabel("输入要添加的单词:"));        
        p1.add(添加英语单词_文本条);
        p1.add(new JLabel("输入添加单词的解释:"));        
        p1.add(添加汉语解释_文本条);
        
        addbtn=new JButton("提交");
        cancelbtn=new JButton("取消");
        addbtn.addActionListener(this);
        cancelbtn.addActionListener(this);
        p1.add(addbtn);
        p1.add(cancelbtn);
        this.getContentPane().add(p1);
        this.validate();
    }
    public void actionPerformed(ActionEvent e)
    {
        if(e.getSource()==addbtn)
        {
            if(添加英语单词_文本条.getText().equals("")||添加汉语解释_文本条.getText().equals(""))
                 JOptionPane.showMessageDialog(this,"添加的单词或解释不能为空!","警告",JOptionPane.WARNING_MESSAGE);
            else 
            {
                try
                {
                    addNewword();
                }
                catch(SQLException ee){}
            }
        }
        else if(e.getSource()==cancelbtn)
            this.dispose();
    }
    
    public void addNewword()throws SQLException
    {
         String cname,ename;
         try
         {
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         }
         catch(ClassNotFoundException e){}
         Con=DriverManager.getConnection("jdbc:odbc:english;","","");
         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();
    }
    
}