fetch value from database on selection of <option> in jsp

Question

I am developing one web based application where I have one list and one dependent textbox. I have added customer names in list. I want customer id to be filled in textbox when I will select customer name in list. I have tried using javascript function but that only helps me to know customer name.

Customer Id is not value of option tag its customer code which I have entered while registration of customer. So I want to fetch customer code from mysql database.

Can any one please suggest me something? This is my jsp code.

        <%   DBConnection dbc=new DBConnection();   
             Connection con=dbc.getNewConnection();

             Statement st = null;
             ResultSet rs = null;

        try
        {
           st=con.createStatement() ;
           rs=st.executeQuery("select cname from CustomerMaster"); 
           %>
<td> 
   <select id="selectBox" >

         <%  while(rs.next()){ %>
                <option ><%= rs.getString(1)%></option>


      <%  } %>

would you like a php solution?

buydadip
– buydadip

2014-12-19 07:54:08 +00:00
Commented Dec 19, 2014 at 7:54 — buydadip
– buydadip, Commented Dec 19, 2014 at 7:54
My project in jsp/servlet Bolboa

Priyanka Pawar
– Priyanka Pawar

2014-12-19 08:00:19 +00:00
Commented Dec 19, 2014 at 8:00 — Priyanka Pawar
– Priyanka Pawar, Commented Dec 19, 2014 at 8:00

Parkash Kumar · Accepted Answer · 2014-12-19 08:20:56Z

3

Priyanka Pawar, you need to fetch customer-id in statement query as following:

<%
    DBConnection dbc = new DBConnection();
    Connection con = dbc.getNewConnection();

    Statement st = null;
    ResultSet rs = null;

    try{
        st = con.createStatement();
        /* You need to get customerId here, suppose your cid is customerId from table */
        rs = st.executeQuery("select cid, cname from CustomerMaster"); 
%>

<td>
    <!-- Changing dropdown value will call javascript method populateCustomerId() -->
    <select id="selectBox" onchange="populateCustomerId();">
        <%while(rs.next()){ %>
            <!-- rs.getString(1) would be your customerId set as option value -->
            <option value="<%=rs.getString(1) %>"><%=rs.getString(2) %></option>
        <%} %>
    </select>
    <input id="customerId" type="text" value="" />
</td>

Javascript:

function populateCustomerId(){
    var selectBox = document.getElementById('selectBox');

    /* selected value of dropdown */
    var selectedCustomerId = selectBox.options[selectBox.selectedIndex].value;

    /* selected value set to input field */
    document.getElementById('customerId').value = selectedCustomerId; 
}

answered Dec 19, 2014 at 8:20

Parkash Kumar

4,7303 gold badges25 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Parkash Kumar Over a year ago

@Priyanka Pawar: This should satisfy your requirement.

Priyanka Pawar Over a year ago

Superb its working. Thank you so much Prakash Kumar.

Priyanka Pawar Over a year ago

Hey in mysql database table customer name values are customer codes instead of name its saves code.

Parkash Kumar Over a year ago

What are these code, may be its related data stored in some other table.

Priyanka Pawar Over a year ago

Actually customer code is foreign key in my sales table. And i want to store customer code and customer name both in my sales table. when my servlet get request it stores customer code in place of customer name

|

Danyal Sandeelo · Accepted Answer · 2014-12-19 07:39:25Z

2

What if 2 customers have the same names?

 <select id="yourSelectId" name="nameSelect" >
  <option value="customerId">values</option>
   ......

get the selected value using javascript/jquery by accessing the id of the select

var customerId=document.getElementById("yourSelectId");

answered Dec 19, 2014 at 7:39

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

2 Comments

Priyanka Pawar Over a year ago

yes using javascript I am getting name of customer but how to retrive that customer's id from mysql

Danyal Sandeelo Over a year ago

select cname from CustomerMaster to select id, cname from CustomerMaster ..I hope id is the column name..the rs.getInt(1) in option's value

Mwangi Thiga · Accepted Answer · 2016-08-01 12:25:31Z

1

Try something like this:

<td class="cell9"><span style="color:#000000;">
<select id="mySelect" name="county"  onchange="myChangeFunction()">
<%
//Counties fetcher
Map<Integer, County> fetchedCounties=CountyFetcher.fetchCounties();

for(County county:fetchedCounties.values()){

String cName=county.getName();  

int id=county.getId();  

%>

<option value="<%=cName%>"><%=cName%></option>

<%}%>

</select></span></td>

answered Aug 1, 2016 at 12:25

Mwangi Thiga

1,37918 silver badges23 bronze badges

Comments

bydsky · Accepted Answer · 2014-12-19 07:40:21Z

0

You can put the id in the option value property, then use js to fill the textbox.

<option value="id">name</option>

answered Dec 19, 2014 at 7:40

bydsky

1,8143 gold badges16 silver badges30 bronze badges

3 Comments

Priyanka Pawar Over a year ago

I am talking about customer id which in my mysql database we can say customer code which I have entered while storing customer information

bydsky Over a year ago

Then you need change you sql: rs=st.executeQuery("select id, cname from CustomerMaster")

Priyanka Pawar Over a year ago

Please take a look at my edited question. And textbox will be filled after selection on list. I am providing only customer names to list.

gfgfdg · Accepted Answer · 2018-03-06 07:42:48Z

0

$(document).ajaxStop(function () {
    var importModel = window.localStorage.getItem('ImportModel');
    localStorage.removeItem('ImportModel');

    if (!importModel) {
        return;
    };

    importModel = JSON.parse(importModel);


    valueDateTextBox.val(importModel.valueDate);
    bookDateTextBox.val(importModel.bookDate);
    referenceNumberInputText.val(importModel.referenceNumber);
    costCenterSelect.val(importModel.costCenter.toString());

    $.each(importModel.table, function (i, v) {
        addRow(v[0], v[1], v[2], v[3], v[4], v[5], v[6], v[7], v[8], v[9]);
    });
});

answered Mar 6, 2018 at 7:42

gfgfdg

1

Collectives™ on Stack Overflow

fetch value from database on selection of <option> in jsp

5 Answers 5

7 Comments

2 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

7 Comments

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related