java+ajax+mysql做的一个树形菜单

CREATE TABLE PRODUCT_CATEGORY ( CATEGORY_ID number(20) default '0', PARENT_CATEGORY_ID number(20) default '0', CATEGORY_NAME varchar(255) default '', ACTIVE_STATUS varchar(4) default 'Y', PRIMARY KEY (CATEGORY_ID) ) TYPE=MyISAM; INSERT INTO PRODUCT_CATEGORY VALUES(0,-1,'All','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(1,0,'Electronics','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(2,0,'Books','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(3,0,'Home & Garden','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(4,1,'Audio & Video ','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(5,1,'Camera & Photo','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(6,1,'Computers','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(7,1,'Software','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(8,2,'Novels','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(9,2,'Entertainment','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(10,2,'Cooking','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(11,6,'Desktops','Y'); INSERT INTO PRODUCT_CATEGORY VALUES(12,6,'Laptops','Y');