JSP Beginner : Dynamic ComboBox

108 New Member

Greetings,

Im a newbie to JSP/Javascript (unfortunalley).

However I found enough example to create code that connects to my access db and populates two combo boxes.

The selection of the first box is used to populate the second (cascading).
See code below, apologies for the formatting as I wrote it in notepad.

I am assuming the code runs through once and therefor combo box populated only once.

How can I make them dynamic, needing some how to perhaps include a loop. reload form or use an onchange even (I need some advice and guidance with these plase)?

Preferrably without the use of arrays and with a simple structure as below, so I can understand it.

Any help would be appreciated.

Expand|Select|Wrap|Line Numbers

 <!-- the % tag below is what is called a scriptlet tag - allows java to be embedded in the jsp -->

<%@ page import="java.util.*" %>

<%@ page language="java" %>

<%@ page import="java.sql.*" %>

<HTML>

<H1>FAQ</H1>
 
<H3>Please choose a category</H3>

<FORM ACTION="wk465682UserMenu.jsp" METHOD="POST">

<%

String CategoryCombo = null;%>

<SELECT NAME="Category" id = Category>

<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:odbc:FAQ");

Statement statement = conn.createStatement();

ResultSet rs = statement.executeQuery("SELECT DISTINCT CATEGORY FROM FAQ" );

while(rs.next()) {

CategoryCombo = rs.getString("Category");%> 

<OPTION><%out.println(CategoryCombo);%>

</OPTION>

<% } %>

</SELECT>

<BR><BR>

<H3>Please choose a question</H3>

<%

String QuestionCombo = null;%>

<SELECT NAME="Question" id = Question>

<%ResultSet ss = statement.executeQuery("SELECT * FROM FAQ WHERE CATEGORY = ( '" + CategoryCombo + "')");

while(ss.next()) {

QuestionCombo = ss.getString("Question");%> 

<OPTION><%out.println(QuestionCombo);%>

</OPTION>

<% }

//response.sendRedirect("wk465682UserMenu.jsp");

//

%>

</SELECT>

</FORM>

</HTML>

Thanks and hope this makes sense
Rob

Feb 21 '08 #1

Subscribe Reply

9394

robtyketto

108

New Member

Im looking into the onchange function now, is this the right direction to go into?

Feb 22 '08 #2

acoder

16,027

Recognized Expert Moderator MVP

You said you want to avoid arrays. In that case, you have two options. Either refresh the page onchange with the new options, or use Ajax to get the new options to populate the second combo box.

Feb 22 '08 #3

robtyketto

108

New Member

Can you expand on how to refresh the page onchange with the new options please?

Cheers
Rob

Feb 22 '08 #4

acoder

16,027

Recognized Expert Moderator MVP

Change the location.href to point to the same page but with the option, e.g. onchange="location.href='index.jsp?opt='+this.valu e". Then you could check for opt using JSP and use that to populate the combo box.

Feb 22 '08 #5

robtyketto

108

New Member

Thanks for your help (Apologies if my response seems slightly retarted).
Im also googling other example to get a better understand of whats goin on.

I modified my code (see below)
When the value in the dropdown box is changed it reload the jsp and I expected the url to include the value of the option selected:-

This
http://localhost:8080/examples/wk465682UserMenu.jsp?.option=FTP
(Value of combo box)

Not this
http://localhost:8080/examples/wk465682UserMenu.jsp?.option=

I Shouldnt expect this to auto populate the option value on reload should I?
As I believe the SQL will retrieve the values in the combo box and ignore its last value before change.

Expand|Select|Wrap|Line Numbers

 <SELECT NAME="Category" id= Category onChange="location.href='wk465682UserMenu.jsp?.option='+this.value;">

<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:odbc:FAQ");

Statement statement = conn.createStatement();

ResultSet rs = statement.executeQuery("SELECT DISTINCT CATEGORY FROM FAQ" );%>

<OPTION VALUE='nochoice'>Please choose a category</OPTION>";

<%while(rs.next()) {

CategoryCombo = rs.getString("Category");%> 

<OPTION><%out.println(CategoryCombo);%>

</OPTION>

<% } %>

Feb 22 '08 #6

acoder

16,027

Recognized Expert Moderator MVP

The option tags should have value attributes.

Remove the dot after jsp?, i.e. make it "...jsp?option=this.value".

In the JSP, check if the option value is set. If it isn't, display the default options. If it is, display the first combo box as normal (with the selected option set) and populate the second combo box using the passed option.

Feb 25 '08 #7

Similar topics

3384

GrayJay's code for dynamic combo box that sub-selects the sourcebased on characters entered

by: Bob Alston | last post by:

In 2002, "GrayJay" posted the following code: I did this in a jazz record catalogue to find composers - On a form "frmComposers" Create a text box - txtFindComposer, and add the following sub...

Microsoft Access / VBA

1536

beginner question

by: News charter | last post by:

I'm playing with MS Visual Studio C# I have a Combo box that drops down to let me pick a quantity value. called milkQnty However, my understanding is that C# treats this as an object. I want...

C# / C Sharp

10188

PropertyGrid with ComboBox containing dynamic data

by: newbie | last post by:

Hello, I am using a propertygrid to allow users to edit\create objects at runtime, that can update records in a database. There are certain properties (fields) that I wish to display as...

C# / C Sharp

3333

populating dynamic user control (ascx)

by: John Ninan | last post by:

I am creating Dynamic Usercontrol in Asp.net application. In this application I have a combobox(aspx Page). Which contains various items. Based on item selected I am dynamically populating...

ASP.NET

22573

Dynamic variable/object name reference. how to do in VB.NET?

by: simon | last post by:

hello, I have a form that has 10 dropdown lists in one section each of the dropdowns contain the same data what i'm looking to do is that when a user selects a value from one dropdown, change...

Visual Basic .NET

9656

How do I set combobox data source to a dynamic SQL statement?

by: Newbie | last post by:

I have a combobox on a form. Coming from VB, I like to build a dynamic SQL statement and then set the control's data source to the SQL statement. Please tell me how to do that in access using...

Microsoft Access / VBA

862

beginner question about ASP.Net from VStudio 2005.

by: Masamune | last post by:

I have an old page that I've created in ASP, but need to recreate in ASP.NET. The ASP page has a combobox at the top that lets you select between 1 and 10 cars. Below is a <%For Idx = 1 to...

ASP.NET

3204

Dynamic generation on Combobox values

by: fedya | last post by:

I am trying to have the last 12 months to always be the option in the dropdown for a combo box. (Basically a combobox, with dynamic options) I am using Access 2000. What is the function and...

Microsoft Access / VBA

1014

VB6 script Dynamic Combobox in webpage

by: Davilean | last post by:

Hi, I have got a combobox which directs to another page on select and when the submit button is clicked. I am trying to change it into a dynamic combobox which redirects you to another page on...

Visual Basic 4 / 5 / 6

7157

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7379

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7098

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5682

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4745

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3232

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3221

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

798

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

455

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General