How can I show value in the textarea from the database /based on the selected value?

517 Views Asked by At

I need to view the another column <%=rs1.getString(2)%> depending on the select value. I need to show that value in the text area. How can I implement this? -> pastebin.com/ewSB7KS6

<label for="issue_id"><strong>Select Issue:</strong></label>
<select name="issue_id" id="issue_id" required>
<option class="placeholder" selected disabled value="">Select</option>
<%
while(rs1.next()){ 
%>
<option value="<%=rs1.getString(1)%>"> <%=rs1.getString(1) %> <%=rs1.getString(2) %></option>
<% } %>
</select> 
<label for="minfeed"><strong>Feed:</strong></label>
<textarea id="minfeed" rows="4" cols="50" name="minfeed" disabled="disabled"></textarea>
1

There are 1 best solutions below

6
Swati On

You can use onchange event of jquery to get selected value and then put that selected value to textarea using .text() .Demo code :

$('select').on('change', function() {
  //getting value from select
  var select = $(this).val();
  //splitting both value 
  var v = select.split(",");
  //getting second value after ,
  $("#minfeed").text(v[1]);
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.0/jquery.min.js"></script>
<label for="issue_id"><strong>Select Issue:</strong></label>
<select name="issue_id" id="issue_id" required>
  <option class="placeholder" selected disabled value="">Select</option>
  <%
while(rs1.next()){ 
%>
    <!--here i have added both value in one with seprator ","-->
    <option value="<%=rs1.getString(1)%> ,<%=rs1.getString(2) %>">
      <%=rs1.getString(1) %>
        <%=rs1.getString(2) %>
    </option>
    <% } %>
</select>
<label for="minfeed"><strong>Feed:</strong></label>
<textarea id="minfeed" rows="4" cols="50" name="minfeed" disabled="disabled"></textarea>

Update 1: As i have already commented you can acheieve that by using ajax .So, your jquery code will look like below :

$('select').on('change', function() {
  //getting value from select
  var select = $(this).val();
  $.ajax({
        type:'post',
        url:'yourservleturl',
        data:'select ='+select , //<--passing value to servlet
        success:function(data){
            console.log("success");
       $("#minfeed").text(data);
        }
    }); 

});

Now ,get value of that select in servlet using request.getParameter("select"); in doPost method and then passed this value to your query for selecting required feed .Lastly, use response.getWriter().write("your feed"); to send value back to ajax and show in textarea.