JSP Dropdown from database

Question

0.00/5 (No votes)

See more:

Hi,

In my project I have two dropdowns in my jsp origin and destination .The first dropdown origin gets populated from databse and second one is dependent on first.Please provide the code without ajax using only jdbc and jsp . The data from database is in a resultset .

The following code snippet of for the storage of data from database in a result set :-

Java

while (rsRegions.next())
{
    previousSubRegion = departsSubRegion;
    departsSubRegion = rsRegions.getString("DEPARTS_SUB_REGION");
    arrivesSubRegion = rsRegions.getString("ARRIVES_SUB_REGION");
    reportName = rsRegions.getString("REPORT_NAME");
    downloadLink = roiURL + reportName + roisufix;
}

I want to store the above variables(departsSubRegion) in an arrayList and then bind them to one drop down and then store another variable (arrivesSubRegion) which will be selected on the basis of the first selection (cascading drop-down)

Posted 15-May-13 21:04pm

gryffin31

Updated 16-May-13 19:54pm

Prasad Khandekar

v3

Add a Solution

Comments

Shubhashish_Mandal 16-May-13 4:49am

Do you believe that someone in codeproject will write your code ?

gryffin31 16-May-13 6:01am

I have an idea and have also pened down most of it.wanted to gather some more idea.If I wnt get there is no choice

Shubhashish_Mandal 16-May-13 7:22am

let us know what you have tried and where you stuck.

Prasad Khandekar 17-May-13 2:02am

Hello Gryffin,

How these two data items related to each other? What's the problem in storing the departsSubRegion values in ArrayList? I hope that your query has a ORDER BY DEPARTS_SUB_REGION, ARRIVES_SUB_REGION clause for you to be able to create these two array lists. For arrivesSubRegion try to use a JSON structure with the key as value of previousSubRegion and value being an array of arrivesSubRegion. On change of departsSubRegion you will have to create a new array for arrivesSubRegion and at populate the eariler array in JSON structure. The actual population of arrivesSubRegion combo will be done in javascript using the JSON structure. Your final json structure for arrivesSubRegion will look something like one shown below.
{
"DEPARTS_SUB_REGION_1": [
"ARRIVES_SUB_REGION_1",
"ARRIVES_SUB_REGION_2",
"ARRIVES_SUB_REGION_3",
"ARRIVES_SUB_REGION_4"
],
"DEPARTS_SUB_REGION_2": [
"ARRIVES_SUB_REGION_5",
"ARRIVES_SUB_REGION_6",
"ARRIVES_SUB_REGION_7",
"ARRIVES_SUB_REGION_8"
],
...
}

Regards,

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)