querylistener.java

是一个电子词典

import java.awt.event.*;
import SqlConnection.JdbcOdbcConn;

public class QueryListener implements ActionListener{
//...................................................................
//----------------实现查询按钮的监听事件--------------------------------
	    JMenus jm;
	    DataItem dataitem=new DataItem();
	    String []value;String s="";
			public QueryListener(JMenus ac){
				jm=ac;
			}
		
		 public void actionPerformed(ActionEvent e){
	        	 if(e.getSource()==jm.querybtn){// 如果触发的是查询事件
	        		 String text=(String)jm.inbox.getSelectedItem();
	        		 if(text==null){//如果没有输入单词，则没有相应的	        			
	        			jm.tf.setText("您没有输入要查询的单词");
	        		}
	        		else
	        		{if(jm.isChinaWord){
	        			String sql="Select distinct * from 单词项China where 单词原型 like '"+text+"%'";
	        			ConnectionClass ConClass=new ConnectionClass(jm);
	        			if(ConClass.hash.isEmpty()){jm.tf.setText("");}else{
	        				jm.tf.setText(text+"\n");
	        			value=(String[])ConClass.hash.get(text);
	        			for(int i=0;i<value.length;i++){
							 s=s+value[i]+"    ";
						 }
						 jm.tf.append(s+"\n");
						 s="";
	        			text="";
	        		}
	        		}//end else
	        		else{
	        			char a=text.charAt(0);	        			
	        			String sql="Select Top 101 * from view"+a+" where 单词原型 like '"+text+"%'";
	        			ConnectionClass ConClass=new ConnectionClass(jm);
	        			if(ConClass.hash.isEmpty()){jm.tf.setText("");}else{
	        			dataitem=(DataItem)ConClass.hash.get(text);
	        			if(dataitem==null){
							dataitem=(DataItem)ConClass.hash.get(ConClass.key1);
							jm.tf.setText(ConClass.key1+"\n"+dataitem.getWordX()+"\n"+dataitem.getValue()+"\n");
							text="";
	        			}else
	        			jm.tf.setText(text+"\n"+dataitem.getWordX()+"\n"+dataitem.getValue()+"\n");
	        			text="";
	        		}
	        		}//end else
	        		}//end else
	        	 }//end if	  
	   }//end ActionPerformed		 
}//end QueryListener