homework23_2.java

简单的小程序数据库操作

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
class MyWindow1 extends Frame implements ActionListener
{
	TextField englishq,englisha,chineseq,chinesea;
	Button b1,b2;
	MyWindow1()
	{
		super("英汉查询");
		setBounds(150,150,400,300);
		setVisible(true);
		englishq=new TextField(20);
		englisha=new TextField(20);
		chineseq=new TextField(20);
		chinesea=new TextField(20);
		b1 =new Button("OK");
		b2 =new Button("确定");
		Panel p1=new Panel();Panel p2=new Panel();
	
		p1.add(new Label("输入要查询的英语单词:"));
		p1.add(englishq);
		p1.add(new Label("查询结果:"));
		p1.add(chinesea);
		p1.add(b1);
		add(p1,"North");
		p2.add(new Label("输入要查询的汉语词组 :"));
		p2.add(chineseq);
		p2.add(new Label("查询结果:"));
		p2.add(englisha);
		p2.add(b2);
		add(p2,"South");
		b1.addActionListener(this);
		b2.addActionListener(this);
		addWindowListener(new WindowAdapter()
                        {
                        	public void windowClosing(WindowEvent e)
                        	{
                        		System.exit(0);
                        	}
                        });
    }
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==b1)
		{
			try{
				ListChinese();
			}
			catch(SQLException ee){}
		}
		else if(e.getSource()==b2)
		{
			try{
				ListEnglish();
			}
			catch(SQLException ee){}
		}
	}

    public void ListChinese() throws SQLException
    {
	    String cname,ename;
	    String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=translator.mdb;";
	    try{
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }
	    catch(ClassNotFoundException e){}
	    Connection con=DriverManager.getConnection(strurl);
	    Statement sql=con.createStatement();
     	ResultSet rs=sql.executeQuery("SELECT * from EAC ");
    	boolean boo=false;
    	while((boo=rs.next())==true)
	    {
		    ename=rs.getString(1);
		    cname=rs.getString(2);
		    if(ename.equals(englishq.getText()))
		    {
		  	    chinesea.setText(cname);
		        break;
		    }
	    }
	    con.close();
	    if(boo==false)
	    {
		    chinesea.setText("Not Find");
	    }
    }
	  
    public void ListEnglish() throws SQLException
    {
	    String cname,ename;
	    String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=translator.mdb;";
	    try{
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }
	    catch(ClassNotFoundException e){}
	    Connection con=DriverManager.getConnection(strurl);
	    Statement sql=con.createStatement();
	    ResultSet rs=sql.executeQuery("SELECT * from EAC ");
	    boolean boo=false;
	    while((boo=rs.next())==true)
	    {
		    ename=rs.getString(1);
		    cname=rs.getString(2);
		    if(cname.equals(chineseq.getText()))
	    	{
	    	    englisha.setText(ename);
	    	   	break;
		    }
        }
	    con.close();
	    if(boo==false)
	    {
	       englisha.setText("找不到");
	    }
    }
}
public class HomeWork23_2
{
    public static void main(String[] args)
    {
       	MyWindow1 window=new MyWindow1();
       	window.pack();
    }
}