Use JQuery variable in JSP Dropdown

See more:

SQL

jQuery

JSP

Hi,

I am building my first JSP interface and I have successfully interrogated a SQL Server database to populate a dropdown list box and then using JQuery to take the selected value from the list box and place it in a text box. How do I know use the selected value to build a SQL statement to populate a second list box? Basically the value chosen by the first list box filters the values dispalyed in the second list box.

I have used the taglib directives to build my initial SQL query.

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>

Then assigned its results to the first list box;

<Select name="UserID" id="UserIDs" class="seluserval">
      <c:forEach items="${result.rows}" var="st">
            <option value="1"><c:out value="${st.USER_ID}"/></option>
      </c:forEach>
      </select>

Then used the following JQuery to place the selected value in the text box;

var main = function() {
    $('#UserIDs').on('change',function(){
    var selUser = $('#UserIDs :selected').text();
    $('#selecteduservalue').val(selUser);
});
};

$(document).ready(main);