retrieve select dropdown option value into sql query

Question

Hi folks,

I have one jsp form with 2 select dropdown boxes.

here,requirement is ,how to filterize second dropdown box option values with selected first dropdown box value.

for example,if i select option value as india.then second dropdown box should be populated with states of inida country only.

Thanks

Ravi Gaddam