example23_3.java.bak

不错的教程 适合中高级人员的使用

import java.awt.*;import java.net.*;
import java.sql.*;import java.awt.event.*;
class DataWindow extends Frame implements ActionListener
{  TextField englishtext;TextArea chinesetext; Button button;
   DataWindow()
   {  super("英汉小词典");
      setBounds(150,150,300,120); 
      setVisible(true);
      englishtext=new TextField(16);
      chinesetext=new TextArea(5,10);
      button=new Button("确定");
      Panel p1=new Panel(),p2=new Panel();
      p1.add(new Label("输入要查询的英语单词:"));
      p1.add(englishtext);
      p2.add(button);
      add(p1,"North");add(p2,"South");add(chinesetext,"Center");
      button.addActionListener(this);
     addWindowListener(new WindowAdapter()
                      {  public void windowClosing(WindowEvent e)
                             {  System.exit(0);  
                             } 
                      });
   }
   public void actionPerformed(ActionEvent e)
   {  if(e.getSource()==button)
        {  chinesetext.setText("查询结果");
           try{  Liststudent();
              }
           catch(SQLException ee) {}
        }
   }
   public  void Liststudent() throws SQLException
   { String cname,ename;
     try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
     catch(ClassNotFoundException e){}
     Connection Ex1Con=DriverManager.getConnection("jdbc:odbc:test","gxy","ookk");
     Statement Ex1Stmt=Ex1Con.createStatement();
     ResultSet rs=Ex1Stmt.executeQuery("SELECT *  FROM 表1 ");  
     boolean boo=false;
     while((boo=rs.next())==true)
        {  ename=rs.getString("单词"); 
           cname=rs.getString("解释");
           if(ename.equals(englishtext.getText()))
              {
                chinesetext.append('\n'+cname);
                break;
              } 
        }
     Ex1Con.close();
    if(boo==false)
       {  chinesetext.append('\n'+"没有该单词"); 
       }
   }
}
public class Example23_3
{  public static void main(String args[])
     {  DataWindow window=new DataWindow();window.pack();
     }
}