|  Ajax Examples | 
                           
                            
                               | 
                             
                            
                              
                                
                                  
                                      
                                        | 
                                           Class.forName(driver).newInstance(); 
                                            con = DriverManager.getConnection(url+db, user, pass); 
                                            try{ 
                                            Statement st = con.createStatement(); 
                                            ResultSet res = st.executeQuery(“SELECT distinct(keyword_name) FROM keywords WHERE 
                                            keyword_name like(‘“+search+”%’) ORDER BY keyword_name”); 
                                            while (res.next()) { 
                                            String un = res.getString(“keyword_name”); 
                                            finalSearch+= un+”\n”; 
                                            } 
                                            con.close(); 
                                            } 
                                            catch (SQLException s){ 
                                            System.out.println(“SQL code does not execute.”); 
                                            } 
                                            } 
                                            catch (Exception e){ 
                                            e.printStackTrace(); 
                                            } 
                                            return finalSearch; 
                                            } 
                                            } 
                                            This servlet sends the matched keywords separated with “\n”. After receiving the response from 
                                            the server the JavaScript function “callback()” is called. 
                                            if( xmlHttp.readyState==4 ){ 
                                            if( xmlHttp.status==200 ) { 
                                            var result = document.getElementById(‘result’); 
                                            result.innerHTML = ‘’; 
                                            var respText = xmlHttp.responseText; 
                                            if((respText.length)!=0){ 
                                            show_div(‘result’); 
                                            show_div(‘close’); 
                                            var str = xmlHttp.responseText.split(“\n”); 
                                            var items; 
                                            for(i=0; i < str.length - 1; i++) { 
                                            items = ‘<div onmouseover=”javascript:overText(this);” ‘; 
                                            items += ‘onmouseout=”javascript:outText(this);” ‘; 
                                            items += ‘onclick=”javascript:setText(this.innerHTML);” ‘; 
                                            items += ‘class=”normal”>’ + str[i] + ‘</div>’; 
                                            result.innerHTML += items; 
                                            } 
                                            } 
                                            else{ 
                                            hide_divs(); 
                                            } 
                                            } 
                                            } 
                                          The function first checks if everything is fine. To get the text response, responseText property of 
                                            the xmlHttp object is used. Split the response with “\n” and put each separated value in a div 
                                            component. Now all div components are attached with the div component of id “result”. This 
                                            updated component is displayed on the page. Different JavaScript functions are used to show and 
                                            hide components on different events. 
											  | 
                                        
                                       
                                    | 
                                 
                                | 
                             
                            
                                Apr 2008 | Java Jazz Up | 39  | 
                             
                            
                              
                                
                                  |   | 
                                 
                                
                                   | 
                                 
                                
                                  |   | 
                                 
                                
                                
  
Pages:
1,
 2,
3,
 4,
 5,
 6, 
7, 
8, 
9, 
10, 
11,
 12,
 13, 
 14,
  15,
   16, 
   17,
    18,
	 19,
	 20,
	  21,
	   22,
	    23, 
		24,
		 25,
		  26, 
		  27,
		   28,
		    29,
			  
			  
			 30,
			 
				
	31,
	 32, 
	 33,
	  34, 
	  35, 
	  36,
	   37, 
	   38,
	    39, 
	    40, 
	    41, 
	    42,
	     43, 
		44, 
		45,
		 46, 
		47, 
		48, 
		49,
		 50,
		  51,
		  52, 
		  53 ,
		   54, 
		  55,
		   56, 
		  57,
		    
		   
		  58,
		   59, 
		    
		    60,
		    61,
		    62,
		    63 ,  
		    64,
		    65 ,
		    66 ,
		    67 ,
		    68 ,
		    69 ,
		    70, 
		    71, 
		    72, 
		    73,
		    74,
		    75,
		    76, 
		    77, 
		    78,
			  Download PDF  | 
   
 
                                    | 
                               
                                | 
                             
                          |