I know there were a lot of people out there wanting to make a dynamic tree from a database. Here's the basic idea of what to do. If anyone wants some more concrete examples, I can add some code later.

I was using Struts 2, Spring, Hibernate and a MySQL database.

I wrote an action to parse my database into JSON and send it to the client via HTTP. I actually found a website with a good example, but unfortunately I didn't bookmark it. The basic idea is that you create a JSONObject, call toString on it, create a PrintWrite from the HttpResponse object and write the JSON string to it.

I have used the jpgraph package and prototype to create a page with auto-refreshing graphs that keep updated values from an SQL database. Dojox looks really convincing so I want to give it a try. Can someone please point me out in the right direction of creating a chart, linking it up to a database and then refreshing it?

End Result: A combo box that gets populated from sql

I have been trying to follow the example that is given in the documentation section for creating a combo box whose values are populated from a json store. In my html file, I have put up what was shown in the documentation:


<div dojoType="dojo.data.ItemFileReadStore" jsId="stateStore"
              url="response.php"></div>
             
     <input dojoType="dijit.form.ComboBox"
                store="stateStore"