help me
jenni john
Greenhorn
Posts: 2
posted 9 years ago
anybody please tell me how to add the contents of database to a dropdown menu...i'm using java and mysql..
Akash Deep
Greenhorn
Posts: 2
posted 9 years ago
Hi
In action form, you write a method to populate the dropdown menu in jsp.
in that method get the list of items and add to array list using LabelValueBean. Ex:itemList.add(new LabelValueBean(itemvalue, itemname)).
Put the itemList in to session. In Jsp use
<html:select property="itemname">
<html
ptions collection="itemList" property="value" />
</html:select>
with this you can get.
In action form, you write a method to populate the dropdown menu in jsp.
in that method get the list of items and add to array list using LabelValueBean. Ex:itemList.add(new LabelValueBean(itemvalue, itemname)).
Put the itemList in to session. In Jsp use
<html:select property="itemname">
<html
ptions collection="itemList" property="value" /></html:select>
with this you can get.
posted 9 years ago
Jhenni,
Understand that you need to have the values at hand to populate in the dropdown box or select control in HTML.
We know a way for getting the values at runtime ie., dynamically. JSP helps you to do that.
Now, how you will get the values from database? Obviously a Java code (it can be any class, servlet , model (Java Bean) which is aware of dealing with a database and retrieving).
Once you get the value you can assign the collection of values to a custom tag in case of Struts and other frameworks. In plain JSP, you can make use of scriptlets in the beginner's level with which you can just iterate it using an Iterator as you do in a plain Java class and assign the individual values for each "option" inside your "Select" control.
So your flow should be
Select Box in JSP <---> Java Bean / Servlet <---> Database.
Hope this helps! :thumb:
Understand that you need to have the values at hand to populate in the dropdown box or select control in HTML.
We know a way for getting the values at runtime ie., dynamically. JSP helps you to do that.
Now, how you will get the values from database? Obviously a Java code (it can be any class, servlet , model (Java Bean) which is aware of dealing with a database and retrieving).
Once you get the value you can assign the collection of values to a custom tag in case of Struts and other frameworks. In plain JSP, you can make use of scriptlets in the beginner's level with which you can just iterate it using an Iterator as you do in a plain Java class and assign the individual values for each "option" inside your "Select" control.
So your flow should be
Select Box in JSP <---> Java Bean / Servlet <---> Database.
Hope this helps! :thumb:
Everything has got its own deadline including one's EGO!
[CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines]
