import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.net.*;
class f1 extends Frame implements ActionListener
{
  Label label;
  TextField text1;
  TextArea text2;
  Button button;
  Panel panel1,panel2;
  f1()
  {
    super("英汉小词典");
    setBackground(Color.cyan);
    setBounds(100,120,800,600);
    setVisible(true); 
    text1=new TextField(15);
    text2=new TextArea(5,10);
    button=new Button("OK");
    label=new Label("输入要查询的单词");
    panel1=new Panel();
    panel2=new Panel();
    add(panel1,"North");add(panel2,"South");add(text2,"Center");
    panel1.add(label);panel1.add(text1);
    panel2.add(button);
    button.addActionListener(this);
  }
  public void  actionPerformed(ActionEvent e)
  {
    if(e.getSource()==button)
    {
      text2.setText("查询结果");
      try{Do();}
      catch(SQLException ee){}
    }
  }
  public void Do() throws SQLException
  {
    String cname,ename;
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
    catch(ClassNotFoundException e){}
    Connection con=DriverManager.getConnection("jdbc.odbc:XYZ","","");
    Statement sql=con.createStatement();
    ResultSet rs=sql.executeQuery("SELECT * FROM chaxun ");
    while (rs.next())
    {
      ename=rs.getString("英文");
      cname=rs.getString("中文");
      if(ename.equals(text1.getText()))
      {
        text2.append('\n'+cname);
      }
    }
    
  } 
}
public class Data
{
  public static void main(String arg[])
  {
    f1 f=new f1();
  }
}

// dbTest.java -- Connect to SQL Server 2000!
import java.sql.*;

public class dbTest {
    public static void main(String args[]) {
        String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";
        String user ="sa";                 // user name
        String password = "sqlserversaps"; // password
        String sqlStr = "select CustomerID, CompanyName, ContactName from Customers";

        try { 
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      // get Connection
            Connection con = DriverManager.getConnection(url, user, password);
            Statement st = con.createStatement();  // create Statement
            ResultSet rs = st.executeQuery(sqlStr);

            while(rs.next()) {
                System.out.print(rs.getString("CustomerID") + "    ");
                System.out.print(outputFormat(rs.getString("CompanyName"), 40));
                System.out.println(rs.getString("ContactName"));
            }
            rs.close();
            st.close();
            con.close();
        }
        catch(Exception err) {
            err.printStackTrace(System.out);
        }
    }
  
  // function for output format
    public static String outputFormat(String s, int x) {
      if(s.length() >= x)
        return s;
      StringBuffer buf = new StringBuffer();
      buf.append(s);
      for(int i = s.length(); i < x; i++)
        buf.append(" ");
      return buf.toString();
    }
}