JQuery - Populating selection list from database using JDBC

Question

I need to populate in my .jsp file selection from database. As you may see, I build the selection using JQuery (I've created the form earlier and now just append things).

I hoped to use something like this:

    <%
    // Connection to DB using JDBC 
    %>
        <script>
        //JS code here
            $form.append('Enter city name: '
                +'<select id="location">' 
                <%
                    for(i=0;i<rowsNum;i++) {
                    out.println("+'<option>"+cities.get(i)+" - "+streets.get(i)+"</option>'");
                }                   
                %>
                +'</select>');
        //JS code here
        </script>
    <%
    //Connection close
    %>

but it doesn't work. A brief search didn't help much.

Is the problem in this particular part of the code, or it's something else and this part is OK?

Thanks!

"but it doesn't work" - In what way doesn't it work? – DanielBarbarian May 22 '14 at 10:58 — DanielBarbarian, May 22 '14 at 10:58

score 0 · Accepted Answer · edited May 23 '17 at 12:05

0

Your code is totally clumsy , why have you combine scriptlets with script . scriptlets are java codes and these are executed on you server . while jquery is the client side java script library .

You can use ajax to get the values from the datebase and populating it in the servlet.

using java codes in jsp is considered as bad practice see this How to avoid Java code in JSP files?

Hope this helps !!

edited May 23 '17 at 12:05

Community

1
1

answered May 22 '14 at 10:45

Santhosh

8,181
4
29
56

Welcome:) Try that and comment here if you have any trouble in that – Santhosh May 22 '14 at 14:12

JQuery - Populating selection list from database using JDBC

1 Answers1