Auto complete of word search using ajax with java

I want to display the list of words when I type the first letter of the word in a text box. I am using jsp to design the form. I want ajax sample to achieve this feature. Its like google search. Please help. Thanks in advance.

View Answers

March 12, 2011 at 11:36 AM

JSP Ajax Autocomplete box

1)autocomplete.jsp:

<%@page import="java.sql.*"%>
<html>
<head>
<script type="text/javascript">
function showData(value){ 

xmlHttp=GetXmlHttpObject()
var url="auto.jsp";
url=url+"?name="+value;
xmlHttp.onreadystatechange=stateChanged 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged() { 
if(xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 
    var showdata = xmlHttp.responseText; 
    document.getElementById("mydiv").innerHTML= showdata;
    } 
}
function GetXmlHttpObject(){
var xmlHttp=null;
try {
  xmlHttp=new XMLHttpRequest();
 }
catch (e) {
 try  {
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
 catch (e)  {
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
 }
return xmlHttp;
}
</script>
</head>
<body>
<form name="employee">
<input  type="text" name="name" id="name" onkeyup="showData(this.value);"><br>
<div id="mydiv"></div>

</table>
</body>
</html>

2)auto.jsp:

<%@ page import="java.sql.*" %> 
<%

String name = request.getParameter("name").toString();
String buffer="<div>";  
try{
           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from data where name like '"+name+"%'");
while(rs.next())
{
buffer=buffer+rs.getString("name")+"<br>";
}
buffer=buffer+"</div>";  
response.getWriter().println(buffer);
}
catch (Exception e) {
System.out.println(e);
}
%>

March 20, 2012 at 12:09 PM

hi,

i tried the same code above.

it is displaying the data.

but how can i click and select a specific data from the list? somebody pls help me..

April 1, 2013 at 1:26 PM

thats rite the objective is still not completed , i also want to select the data in textbox when i click on the items coming after search.........plz help thanks

February 6, 2014 at 8:04 AM

Did you guys found any solution for the above.....Even I am looking for the same , please help....

Ads

Advertisements

Auto Search box using ajax
Auto Search box using ajax Hi , i want to implement auto search box functionality like google and linkedin using ajax,jsp,servlet, javascript... this is possible in java. rahul hi, Please go through the link, may

Ajax Auto Complete Tutorial
Auto Complete Example The auto complete feature helps the user to input the data correctly and quickly while submitting the form. An example of auto complete with JQuery is given below, to run this example you need to import two

How to perform search using AJAX?
How to perform search using AJAX? Hi, I have following HTML code... and hit button, there is a Ajax call to retrieve search results from a simple txt...; <td><label for="status">Search Status</td> <td><input

jQuery auto complete through database using JSP shows error
jQuery auto complete through database using JSP shows error The tutorial on jQuery titled "jQuery auto complete through database using JSP" shows error on browser when I try to select the one in the dropdown. Please help

How to merge two word document using java
How to merge two word document using java how to merge two word document using java

convert date month and year into word using java
convert date month and year into word using java convert the date...;continue.... public void pass(int number) { int word, q...; if (word == 0) { q = number / 10

convert date month and year into word using java
convert date month and year into word using java convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

JSF Search Application Using Ajax
JSF Search Application Using Ajax ... using Ajax. This is a simple application in which, you will see two JSF.... This application here using JSF and AJAX technology that mean this is based on the JSF

how to translate english word to marathi using java
how to translate english word to marathi using java I want to translat english word to marathi,how i can develop a code for that ,please sajest me

convert date month and year into word using java
Java Date Month Format convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
convert date month and year convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
convert date month and year Java convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
Match Date format convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
Date Format in Jave convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
Basic format for Date and Month convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
Convert Date Month format convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

convert date month and year into word using java
Convert Date Format convert the date, month,year into word like 12-3-2012 into twelve march two thousands twelve pls send the code write in java. Visit Here

Using Ajax
Using Ajax Hi, How I can use Ajax in web programming? Tell me any example which using Ajax to call server side script? Thanks Hi, Here are examples: PHP Ajax and Database First Ajax Example Getting Started

Merge multiple jasper file to one word Doc using java
Merge multiple jasper file to one word Doc using java how to Merge multiple jasper file to one word Doc using java

AJAX Search
using PHP and MYSQL as the database. Can somebody please suggest me the AJAX...AJAX Search I have to create a project where the user enters...://www.roseindia.net/tutorial/ajax/jquery/autocomplete.html continue

click a word and search it from a file
click a word and search it from a file i want to link a word with a file and search it form the file by clicking it. what could the code for this process

Edit word document Headers and Footers using POI Library in java?
Edit word document Headers and Footers using POI Library in java? Hi All, I need code to modify the Header and Footer contents of a ms-word template using POI or JACOB libraries. Could any one help me? Thanks Advance

ModuleNotFoundError: No module named 'word-search'
ModuleNotFoundError: No module named 'word-search' Hi, My Python... 'word-search' How to remove the ModuleNotFoundError: No module named 'word-search' error? Thanks Hi, In your python environment

Java search word from text file
Java search word from text file In this tutorial, you will learn how to search a word from text file and display data related to that word. Here, we have.... It then scan the whole file to search the name and display the id and marks

Ads