Dynamically Generate JSON Data.

[zohaib khan]

Hi,

I want to generate following JSON data dynamically using JSP and database.

following is the table and json structure data.

CREATE TABLE JSONMENU
(
  ID        NUMBER  NOT NULL,
  TEXT      VARCHAR2,
  PARENTID  NUMBER
)

var data = [
{
	"text": "Menu1",
	"id": "1",
	"parentid": "-1",
	"subMenuWidth": '250px'
}, {
	"id": "2",
	"parentid": "1",
	"text": "Menu1 Child1"
}, {
	"id": "3",
	"parentid": "1",
	"text": "Menu1 Child2"
}, {
	"id": "4",
	"parentid": "1",
	"text": "Menu1 Child3"
}, {
	"id": "5",
	"parentid": "1",
	"text": "Menu1 Child4"
}, {
	"id": "6",
	"text": "Menu2",
	"parentid": "-1",
	"subMenuWidth": '200px'
}, {
	"id": "7",
	"parentid": "6",
	"text": "Menu2 Child1"
}, {
	"id": "8",
	"text": "Menu2 Child2",
	"parentid": "6"
}, {
	"id": "9",
	"text": "Menu2 Child3",
	"parentid": "6"
}, {
	"id": "10",
	"text": "Menu2 Child4",
	"parentid": "6"
}, {
	"id": "11",
	"text": "Menu2 Child5",
	"parentid": "6"
}, {
	"id": "12",
	"text": "Menu3",
	"parentid": "-1",
	"subMenuWidth": '250px'
}, {
	"id": "13",
	"text": "Menu3 Child1",
	"parentid": "12"
}, {
	"id": "15",
	"text": "Menu3 Child1 - Child1",
	"parentid": "13"
}, {
	"id": "16",
	"text": "Menu3 Child1 - Child2",
	"parentid": "13"
}, {
	"id": "17",
	"text": "Menu3 Child1 - Child3",
	"parentid": "13"
}, {
	"id": "14",
	"text": "Menu3 Child2",
	"parentid": "12"
}]

Any Solution?


- Thanks
Zohaib.

[Ulf Dittmer]

I assume that retrieving the data from the DB presents no problem. For creating JSON I'd use one of the available libraries like http://www.stringtree.org/stringtree-json.html or http://www.json.org/java/.