Member Avatar for ypks_destiny

I want a text field which should have database values....(like dropdown list) from that list i can select text which is in database...

Can any one help me out its very urgent.......

  • 3 Contributors
  • 13 Replies
  • 688 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by ypks_destiny
Member Avatar for ypks_destiny

once see www.justdial.com under "City" text box i want exactly like that ...i also want to match the values like that...

can any one please help me out.its urgent

Member Avatar for ypks_destiny

please please help me out I think we have to use AJAX

Member Avatar for murali.java

please help me out

Using Jsp You can Achive this
-------------------------------
I will provide the sample code hope it might be useful to ypu.


jsp code
-----------

//LET US SUPPOSE YOU WANT TO GET CITY NAMES IN DATABASE FROM TABLE "branches"

<%
Connection con=DriverManager.getConnection("--set DB parameters---");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
       ResultSet rs = st.executeQuery("SELECT  cityname  FROM branches");


%>



<select name="city">

<%
if(rs.next())
{
rs.beforeFirst();
String city=rs.getString("cityname");//get value from database
while(rs.next())
{
{%>
        <option value="<%= city%>"><%= city%></option>
<%
}
}
else
{%>
        <option>No city in Database   </option>
<%}
%>

</select>
Edited by peter_budo because: Keep It Clean - Do wrap your programming code blocks within [code] ... [/code] tags
Member Avatar for ypks_destiny

TO : murali.java

You are using Drop down list actually i want it in live search

Edited by ypks_destiny because: n/a
Member Avatar for peter_budo

@murali.java being your boss I would make sure that you will not be offered new contract when your current expire. :@ making db connection from page. BAD! BAD! BAD! At least do it from servlet if you do not know Persistence or Hibernate

@ypks_destiny have look on Ajax Asynchronous call, something like this article should be helpful

Edited by peter_budo because: Typo
Member Avatar for murali.java

@peter_budo

Thanks for your kind suggestion....
I know the standared way of getting connection to a jsp page using Hibernate or Persistance .....

I just gave a formal approach how to dispaly the data in a dropdown list.....I just mentioned in short how to to achieve this, reagrdless of other things(getting connectn,using DAO ..etc)..

Iam new to this forum ,not new to java technologies...

Member Avatar for peter_budo

@murali.java so why do you suggest something that is a bad coding standard if you wouldn't use it? That logic is wrong.

Member Avatar for ypks_destiny

@peter_budo,murali.java

city.JSP

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

 <script language="javascript" type="text/javascript">
      var xmlHttp
      var xmlHttp
      function showState(str){
      if (typeof XMLHttpRequest != "undefined"){
      xmlHttp= new XMLHttpRequest();
      }
      else if (window.ActiveXObject){
      xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
      }
      if (xmlHttp==null){
      alert("Browser does not support XMLHTTP Request")
      return;
      }
      var url="div_city.jsp";
      url +="?count=" +str;
      xmlHttp.onreadystatechange = stateChange;
      xmlHttp.open("GET", url, true);
      xmlHttp.send(null);
      }

      function stateChange(){
      if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
      document.getElementById("div_city").innerHTML=xmlHttp.responseText
      }
      }


      </script>
 </head>
 <body>
<div id='div_city' >
City<input type="text"  name="city" id="city" onkeyup="showState(this.value)"></td>
 <br>
</div>

 </body></center>
 </html>

div_city.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
 <%
 String name=request.getParameter("count");
 String buffer="<div>";
 Class.forName("com.mysql.jdbc.Driver").newInstance();
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Prashanth","root","");
 Statement stmt = con.createStatement();
 ResultSet rs = stmt.executeQuery("Select cityname from city where cityname LIKE '%"+name+"%'");
   while(rs.next()){
   buffer=buffer+"<input type='text'  onselect='text' name='city' value="+rs.getString("cityname")+">"+"<br>";
   }
 buffer=buffer+"</div>";
 response.getWriter().println(buffer);
 %>

This is my actual code...can u help out by fixing the changes...

Edited by ypks_destiny because: n/a
Member Avatar for peter_budo

waiting..........

Keep waiting, because as I already stated I do hate database connectivity done from page view, therefore I'm not touching it.

Member Avatar for ypks_destiny

originally posted by peter_budo

it is my part of project to have country-state relation in autocomplete search to take database values by using jsp,HTML

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.