dictapp.java

java练习程序

import java.awt.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
class DICTAppWindow extends Frame implements ActionListener
{
	TextField englishtext;
	TextArea chinesetext;
	Button btn;
	DICTAppWindow()
	{
		super("英汉小词典");
		setBackground(Color.cyan);
		setBounds(150, 150, 300, 120);
		setVisible(true);
		englishtext=new TextField(16);
		chinesetext=new TextArea(5,10);
		btn=new Button("确定");
		Panel p1=new Panel(), p2=new Panel();
		p1.add(new Label("输入要查询的英语单词:"));
		p1.add(englishtext);
		p2.add(btn);
		add(p1,  "North");
		add(p2,  "South");
		add(chinesetext, "Center");
		chinesetext.setBackground(Color.pink);
		btn.addActionListener(this);
		addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				setVisible(false);
				System.exit(0);
			} 
		});
}

public void actionPerformed(ActionEvent e)
{
	if(e.getSource()==btn)
	{
		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:translation","","");
	Statement Ex1Stmt=Ex1Con.createStatement();
	ResultSet rs=Ex1Stmt.executeQuery("SELECT *   FROM tran");
	while(rs.next())
	{
		ename=rs.getString("单词");
		cname=rs.getString("解释");
		if(ename.equals(englishtext.getText()))
		{
			chinesetext.append('\n'+cname);
			break;
		}
	}
	Ex1Con.close();
	if(chinesetext.getText().trim().equals("查询结果"))
	{
		chinesetext.append('\n'+"没有该单词");
	}
}
}

public class DICTApp
{
	public static void main(String args[])
	{
		DICTAppWindow myWin=new DICTAppWindow();
		myWin.pack();
    }
}