example10_5.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,150); 
      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) { 
              System.out.println("SQLException :" + ee.getMessage( ));
			}
        }
    }
   public  void Liststudent() throws SQLException
   { String cname,ename;
     try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
     catch(ClassNotFoundException e){
          System.out.println("ForName :" + e.getMessage( ));
		}
     String conURL="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=TestDB.mdb";
     Connection Ex1Con=DriverManager.getConnection(conURL);
     Statement Ex1Stmt=Ex1Con.createStatement();
     ResultSet rs=Ex1Stmt.executeQuery("SELECT * FROM dic");  
     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 Example10_5
 {  public static void main(String args[])
     { 
	   DataWindow window=new DataWindow();
	   window.validate();
     }
}