Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Tokenizing Autocomplete Text Entry  jquery

Posted on 2009-07-08
9
Medium Priority
?
2,200 Views
Last Modified: 2012-08-14
I have two jsp page
1) welcomeStruts.jsp
2)tvshows.jsp

the data is prpoerly render now i want the ids of selected list  so that i can store the ids when form is going to submit ..how can i do? please help me...
this is my welcomeStruts.jsp
 
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
 
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %>
 
<html:html locale="true">
   
<head>
    <script type="text/javascript" src="jquery.min.js"></script>
 
    <script type="text/javascript" src="jquery.tokeninput.js"></script>
 
    <link rel="stylesheet" href="token-input.css" type="text/css" />
    <link rel="stylesheet" href="token-input-facebook.css" type="text/css" />
      
 
    <script type="text/javascript">
    $(document).ready(function() {
        $("#tokenize").tokenInput("tvshows.jsp", {
            hintText: "Type in the names of your favorite TV shows",
            noResultsText: "No results",
            searchingText: "Searching..."
           
        });
 
    /*   $("#tokenize2").tokenInput("tvshows.jsp", {
            classes: {
                tokenList: "token-input-list-facebook",
                token: "token-input-token-facebook",
                tokenDelete: "token-input-delete-token-facebook",
                selectedToken: "token-input-selected-token-facebook",
                highlightedToken: "token-input-highlighted-token-facebook",
                dropdown: "token-input-dropdown-facebook",
                dropdownItem: "token-input-dropdown-item-facebook",
                dropdownItem2: "token-input-dropdown-item2-facebook",
                selectedDropdownItem: "token-input-selected-dropdown-item-facebook",
                inputToken: "token-input-input-token-facebook"
            }
        }); */
    });
     
      
  
    </script>
     
       
</head>
 
<body>
    <h1>Jquery Tokenizing Autocomplete Input</h1>
    <form action="">
    <div>
        <h2>List style</h2>
        <input type="text" id="tokenize" name="blah"  />
    </div>
    </form>
  <!--  <div>
        <h2>Facebook style</h2>
        <input type="text" id="tokenize2" name="blah2" />
    </div> -->
</body>
 
 
</html:html>
______________________________________________________________________________
 
This is my tvshows.jsp
 
<%-- 
    Document   : action
    Created on : Dec 12, 2008, 1:09:00 PM
    Author     : Santoshi
--%>
 
<%@page contentType="text/html" pageEncoding="UTF-8" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="org.json.JSONObject" %>
 
<%
Connection con = null;
Statement st = null;
ResultSet rs=null;
ResultSet rs1=null;
int count=0;
%>
 
<%
    try {
     
        Class.forName ("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection("jdbc:mysql:///tvshows_db","root","mysql");
        st = con.createStatement();
     
         
         String query1="select count(*) from serial";
    //      System.out.println("Count  query: "+query1); 
        
         rs1=st.executeQuery(query1);
          while(rs1!=null && rs1.next()){ 
               count=rs1.getInt(1); 
              }
       
          String query = " select * from serial";
 //         System.out.println("Select query: "+query); 
         rs=st.executeQuery(query);
         out.println("["); 
             while(rs!=null && rs.next())
             {   
                 
                     JSONObject obj1=new JSONObject(); 
                     obj1.put("id",rs.getString("serialID"));  
                     obj1.put("name",rs.getString("name"));
                     out.println(obj1);  
                      if(count!=1)
                        {
                         out.print(",");
                          count--;     
                         } 
                 
               } 
       out.println("]"); 
    } catch (Exception e){
        System.out.println("Erorr Message"+e.getMessage());
    }	  
 
%>
 
 --------------------------------------------------------------------------------------------------------------

Open in new window

0
Comment
Question by:Adwait Chitaley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 2
9 Comments
 
LVL 20

Expert Comment

by:a_b
ID: 24811005
Store each id as a hidden input, that way you can do  a getParameter in the next jsp and then retrieve the ids........
0
 

Author Comment

by:Adwait Chitaley
ID: 24811033
how can i do please tell me i dont get.........
0
 
LVL 20

Accepted Solution

by:
a_b earned 1500 total points
ID: 24811109
Scrap the previous suggestion. This solution should wok for you - http://www.experts-exchange.com/Programming/Languages/Java/J2EE/JSP/Q_20518118.html
0
Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

 

Author Comment

by:Adwait Chitaley
ID: 24811252
http://loopj.com/tokeninput/demo.html

please see the link this is my output now i want to get the ids of selected item
and also want to submit the data
0
 

Author Comment

by:Adwait Chitaley
ID: 24812561
hi Experts.
i got the result and now i can able to store the data also
i have just one problem that when i type some words in that list box data the data is coming and also highlight that text what i type but its not filtering

please help me i just one problem away from my resullt..
And i took the javascript as i include in jsp which are same as from jquery download

This is my welcomestruts.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>

<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %>
 
<html:html locale="true">
   
<head>
    <script type="text/javascript" src="jquery.min.js"></script>

    <script type="text/javascript" src="jquery.tokeninput.js"></script>

    <link rel="stylesheet" href="token-input.css" type="text/css" />
    <link rel="stylesheet" href="token-input-facebook.css" type="text/css" />
   
     

    <script type="text/javascript">
    $(document).ready(function() {
        $("#tokenize").tokenInput("tvshows.jsp", {
            hintText: "Type in the names of your favorite TV shows",
            noResultsText: "No results",
            searchingText: "Searching..."
           
        });

   /*    $("#tokenize2").tokenInput("tvshows.jsp", {
            classes: {
                tokenList: "token-input-list-facebook",
                token: "token-input-token-facebook",
                tokenDelete: "token-input-delete-token-facebook",
                selectedToken: "token-input-selected-token-facebook",
                highlightedToken: "token-input-highlighted-token-facebook",
                dropdown: "token-input-dropdown-facebook",
                dropdownItem: "token-input-dropdown-item-facebook",
                dropdownItem2: "token-input-dropdown-item2-facebook",
                selectedDropdownItem: "token-input-selected-dropdown-item-facebook",
                inputToken: "token-input-input-token-facebook"
            }
        });   */
    });
     
       
     
 
    </script>
     
       
</head>

<body>
    <h1>Jquery Tokenizing Autocomplete Demo</h1>
     
           
        <form name="myform" action="demo.do" method="post">
            <input type="text" id="tokenize" name="judgeName" />
              <input type="submit" name="Submit" value="Submit">
        </form>
         
       
   
  <!--  <div>
        <h2>Facebook style</h2>
        <input type="text" id="tokenize2" name="blah2" />
    </div>  -->
</body>
 

</html:html>
__________________________________________________________________________________
This  is  my tvshows.jsp

<%--
    Document   : action
    Created on : Dec 12, 2008, 1:09:00 PM
    Author     : Santoshi
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="org.json.JSONObject" %>

<%
Connection con = null;
Statement st = null;
ResultSet rs=null;
ResultSet rs1=null;
int count=0;
%>

<%
    try {
     
        Class.forName ("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection("jdbc:mysql:///tvshows_db","root","mysql");
        st = con.createStatement();
       
       
         
         String query1="select count(*) from serial";
    //      System.out.println("Count  query: "+query1);
       
         rs1=st.executeQuery(query1);
          while(rs1!=null && rs1.next()){
               count=rs1.getInt(1);
              }
       
          String query = " select * from serial";
 //         System.out.println("Select query: "+query);
         rs=st.executeQuery(query);
         out.println("[");
             while(rs!=null && rs.next())
             {  
                 
                     JSONObject obj1=new JSONObject();
                     obj1.put("id",rs.getString("serialID"));  
                     obj1.put("name",rs.getString("name"));
                     out.println(obj1);  
                      if(count!=1)
                        {
                          out.print(",");
                          count--;    
                         }
                 
               }
       out.println("]");
    } catch (Exception e){
        System.out.println("Erorr Message"+e.getMessage());
    }       

%>

 
0
 

Author Comment

by:Adwait Chitaley
ID: 24812842
Hey Experts please give me any suggestion
0
 

Author Comment

by:Adwait Chitaley
ID: 24876179
hey experts i got the solution..
now i m just one step back for my solution
actaully data is rendering properly in this script and working fine but when the user type some word its highlight the work but its not filtering please help me.
 
please see the link
http://loopj.com/tokeninput/demo.html
0
 

Author Comment

by:Adwait Chitaley
ID: 24923218
i get the solution which is use String a=request,getPameter("q"); and use that a in query for matching by like query
0
 

Author Closing Comment

by:Adwait Chitaley
ID: 31601437
Thanks it wil help me
0

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
This video teaches viewers about errors in exception handling.
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question