jsp+json+mySql++实现二级级联下拉菜单

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50147 Source Host : localhost:3306 Source Database : bd Target Server Type : MYSQL Target Server Version : 50147 File Encoding : 65001 Date: 2010-07-25 15:53:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `academy` -- ---------------------------- DROP TABLE IF EXISTS `academy`; CREATE TABLE `academy` ( `academy_id` int(3) NOT NULL AUTO_INCREMENT, `academy_name` char(20) DEFAULT NULL COMMENT '学院名称', PRIMARY KEY (`academy_id`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of academy -- ---------------------------- INSERT INTO `academy` VALUES ('1', '建工学院'); INSERT INTO `academy` VALUES ('2', '生化学院'); INSERT INTO `academy` VALUES ('4', '经管学院'); INSERT INTO `academy` VALUES ('5', '信息学院'); INSERT INTO `academy` VALUES ('6', '机械学院'); INSERT INTO `academy` VALUES ('7', '电气学院'); INSERT INTO `academy` VALUES ('8', '轻工学院'); INSERT INTO `academy` VALUES ('9', '艺术学院'); INSERT INTO `academy` VALUES ('10', '理学院'); INSERT INTO `academy` VALUES ('11', '中德学院'); INSERT INTO `academy` VALUES ('12', '语言文学学院'); -- ---------------------------- -- Table structure for `major` -- ---------------------------- DROP TABLE IF EXISTS `major`; CREATE TABLE `major` ( `major_id` int(3) NOT NULL AUTO_INCREMENT, `major_name` char(20) DEFAULT NULL COMMENT '专业名称', `major_academy_id` int(3) DEFAULT NULL COMMENT '所属学院', PRIMARY KEY (`major_id`), KEY `major_academy_id` (`major_academy_id`), CONSTRAINT `major_ibfk_1` FOREIGN KEY (`major_academy_id`) REFERENCES `academy` (`academy_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of major -- ---------------------------- INSERT INTO `major` VALUES ('31', '机械设计制造及其自动化', '6'); INSERT INTO `major` VALUES ('32', '材料成型及控制工程专业', '6'); INSERT INTO `major` VALUES ('33', '车辆工程专业', '6'); INSERT INTO `major` VALUES ('34', '自动化', '7'); INSERT INTO `major` VALUES ('35', '建筑电气与智能化', '7'); INSERT INTO `major` VALUES ('36', '电气工程及其自动化', '7'); INSERT INTO `major` VALUES ('37', '测控技术与仪表', '7'); INSERT INTO `major` VALUES ('38', '软件工程专业', '5'); INSERT INTO `major` VALUES ('39', '信息技术管理双学位班', '5'); INSERT INTO `major` VALUES ('40', '数字媒体技术专业', '5'); INSERT INTO `major` VALUES ('41', '计算机科学与技术专业', '5'); INSERT INTO `major` VALUES ('42', '电子信息科学与技术专业', '5'); INSERT INTO `major` VALUES ('43', '电子信息工程专业', '5'); INSERT INTO `major` VALUES ('44', '通信工程专业', '5'); INSERT INTO `major` VALUES ('45', '教育技术学专业', '5'); INSERT INTO `major` VALUES ('46', '土木工程', '1'); INSERT INTO `major` VALUES ('47', '给水排水工程', '1'); INSERT INTO `major` VALUES ('48', '建筑学', '1'); INSERT INTO `major` VALUES ('49', '城市规划', '1'); INSERT INTO `major` VALUES ('50', '交通工程', '1'); INSERT INTO `major` VALUES ('51', '生物工程', '2'); INSERT INTO `major` VALUES ('52', '化学工程与工艺', '2'); INSERT INTO `major` VALUES ('53', '食品科学与工程', '2'); INSERT INTO `major` VALUES ('54', '制药工程', '2'); INSERT INTO `major` VALUES ('55', '材料科学与工程', '2'); INSERT INTO `major` VALUES ('56', '包装工程', '8'); INSERT INTO `major` VALUES ('57', '印刷工程', '8'); INSERT INTO `major` VALUES ('58', '轻化工程', '8'); INSERT INTO `major` VALUES ('59', '服装艺术设计', '9'); INSERT INTO `major` VALUES ('60', '纺织品艺术设计', '9'); INSERT INTO `major` VALUES ('61', '服装设计与工程', '9'); INSERT INTO `major` VALUES ('62', '环境艺术与设计', '9'); INSERT INTO `major` VALUES ('63', '工业设计', '9'); INSERT INTO `major` VALUES ('64', '视觉传达', '9'); INSERT INTO `major` VALUES ('65', '动画设计', '9'); INSERT INTO `major` VALUES ('66', '服装表演', '9'); INSERT INTO `major` VALUES ('67', '工业工程', '4'); INSERT INTO `major` VALUES ('68', '信息管理与信息系统', '4'); INSERT INTO `major` VALUES ('69', '国际经济与贸易', '4'); INSERT INTO `major` VALUES ('70', '物流工程', '4'); INSERT INTO `major` VALUES ('71', '市场营销', '4'); INSERT INTO `major` VALUES ('72', '经济学', '4'); INSERT INTO `major` VALUES ('73', '财务管理', '4'); INSERT INTO `major` VALUES ('74', '信息与计算科学', '10'); INSERT INTO `major` VALUES ('75', '应用物理学', '10'); INSERT INTO `major` VALUES ('76', '德语语言文学', '11'); INSERT INTO `major` VALUES ('78', '语言文学', '12');