datawindow.java

数据库的连接 英文小词典 软件工具与环境

package hongni;
import java.awt.*; 
//import java.net.*; 
import java.sql.*; 
import java.awt.event.*; 
//import java.lang.*;

//public class Hongni 
//{
	@SuppressWarnings("serial")
	class DataWindow extends Frame implements ActionListener 
	{ 
	TextField englishtext; 
	TextArea chinesetext; 
	Button button; 
	DataWindow() 
	{ 
	super("英汉小词典"); 
	//setBackground(Color.cyan); 
	setBounds(150,150,300,120); 
	setVisible(true); 
	englishtext=new TextField(16); 
	chinesetext=new TextArea(5,10); 
	button=new Button("确定"); 
	final 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"); 
	//chinesetext.setBackground(Color.pink); 
	button.addActionListener(this); 
	addWindowListener(new WindowAdapter() 
	{ 
	public void windowClosing(WindowEvent e) 
	{ 
	//setVisible(false); 
	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 con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk"); 
	//try{Connection con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk"); }
	//catch(SQLException e){}
	//try{Statement sql=con.createStatement(); }
	//catch(SQLException e){}
	Statement sql=con.createStatement(); 
	ResultSet rs=sql.executeQuery("SELECT * FROM 表1"); 
	while (rs.next()) 
	{ 
	ename=rs.getString("单词"); 
	cname=rs.getString("解释"); 
	if(ename.equals(englishtext.getText())) 
	{ 
	chinesetext.append('\n'+cname);break; 
	} 
	} 
	con.close(); 
	if(chinesetext.getText().trim().equals("查询结果:")) 
	{ 
	chinesetext.append('\n'+"没有该单词"); 
	} 
	} 
	} 
	/*boolean boo=false;
	while (boo=rs.next()==true) 
	{ 
	ename=rs.getString("单词"); 
	cname=rs.getString("解释"); 
	if(ename.equals(englishtext.getText())) 
	{ 
	chinesetext.append('\n'+cname);
	break; 
	} 
	} 
	con.close(); 
	if(boo==false) 
	{ 
	chinesetext.append('\n'+"没有该单词"); 
	} 
	}
	}
//}*/