File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Table Driven menu Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Table Driven menu " Watch "Table Driven menu " New topic

Table Driven menu

Sharadha Sankar

Joined: Feb 15, 2006
Posts: 20
Hello All,

I am tring to write a java method that will create a menu which derives its menu items from a database table.

Current scenario.

When I click on the menu in my XSL file, It pulls the menu items from a XML file. something like this
<tr><td class="head" colspan="2" align="center"><br/>Country of Origin</td></tr>
<tr class="input">
<td colspan="2" align="center" class="input">
<SELECT id="country" name="country">
<xsl:for-each select="//country/CodeList/Entry">
<OPTION class="input">
<xsl:attribute name="value"><xsl:value-of select="code" /></xsl:attribute>
<xsl:value-of select="name"/>

where the list of country is stored in a file called country.xml

My need: Now when I click the menu, the data should be retrieved from a table which contains the various countries.

Any help will be greatly appreciated.


Thanks<br />Sharadha
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
Since you're already set up to handle XML, you may want to write some simple code that will read a database table and turn it into XML. Besides this, Oracle and other RDBs have utilities that you may want to look into that will turn tables into XML.

Consultant, Sima Solutions
Sharadha Sankar

Joined: Feb 15, 2006
Posts: 20
Thanks for the prompt reply, but my requirement here is to avoid handling the data through XML. I just need to create a method which will derive data from the table and listens to the user's selection. Any feedbacks would be appreciated.
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
It seems like just using the standard Struts architecture will work just fine for this:

1-Call a Struts action that gets the information from the database and puts it in an ActionForm bean
2-Have the action forward to a JSP that retrieves the values from the ActionForm bean and creates the menu based on that information.
I agree. Here's the link:
subject: Table Driven menu
Similar Threads
Create a hardcopy of SCEA mock test
mouse hover on multiselect dropdown
xsl - need to select on attribute and limit output
Help me about html:select
xml xls not seeing anything