Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Generate menu from a databases

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-04-2009
Member
 
Join Date: Apr 2009
Posts: 90
How to Generate menu from a databases
  

Hello,

It is possible to generate a menu from an XML file? (I will mostly prefer from XML otherwise any other language will also do). I think that if it can be done directly from a database, we avoid creating the XML file in question from the base.
Of course I work with Netbeans 6.5 as IDE, GlassFish v2 application server as, among other things and it does not bother me to import other libraries if necessary.

In short, my question is how to generate the menu dynamically from the database. I always speak as part of a web application in Java.
Thank you very much!

Reply With Quote
  #2  
Old 30-04-2009
Member
 
Join Date: Mar 2008
Posts: 232
Re: How to Generate menu from a databases

The following structure is kept in a single database table with the following fields:
Code:
field name field type	description
id	   int	    unique item identifier (cannot be zero)
parent_id  int	        parent item (or zero for top-level items)
node_name varchar	text of menu item
node_url     varchar	   target URL
The above table is called sample_structure in the sample code. Please note that if you're using a different format for storing the structure, all you need to do is change the SQL queries in the sample code.

Note that you will need to remove the sample lines generated by DHTML Menu Studio. This means a few calls to SSAdd... functions that come after the comment.
Reply With Quote
  #3  
Old 30-04-2009
Member
 
Join Date: Dec 2008
Posts: 112
Re: How to Generate menu from a databases

The fully-qualified key database name must be between 2 and 251 characters and should either have no extension or an extension of '.kdb' (the maximum database name is 247 characters if the name does not end with an extension of 1-3 characters to allow for the addition of an extension when creating the request database or the password stash file).

for more information on the database menu please check here
http://publib.boulder.ibm.com/infoce...gsk1756415.htm
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Generate menu from a databases"
Thread Thread Starter Forum Replies Last Post
How to select data from two different databases in PHP? Linoo Software Development 4 02-03-2010 09:48 PM
ORDER BY behavior in 9i and 10g databases garfield1 Software Development 4 25-02-2010 09:13 PM
Virtualise databases more efficiently Aidan 12 Networking & Security 3 31-10-2009 01:51 PM
Synchronization of databases Dadhij Software Development 4 15-12-2008 06:14 PM
Remote access to databases wazzeledozzle Software Development 2 02-10-2008 07:16 PM


All times are GMT +5.5. The time now is 12:35 PM.