代码方向从页面到数据
-
html
-
JavaScript
-
struts + struts config
ClassTreeAction
struts-category-tree.xml
-
hibernate + pojo
Category.java
数据库是用xdoclet生成。
这里也贴出来备份的数据库脚本
/*Table structure for table `category` */
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`viewUrl` varchar(255) DEFAULT NULL,
`sortingCode` int(11) DEFAULT NULL,
`description` longtext,
`moduleUrl` varchar(255) DEFAULT NULL,
`sn` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sn` (`sn`),
KEY `FK302BCFED3B107E4` (`pid`),
CONSTRAINT `FK302BCFED3B107E4` FOREIGN KEY (`pid`) REFERENCES `category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
/*Data for the table `category` */
insert into `category`(`id`,`title`,`url`,`pid`,`viewUrl`,`sortingCode`,`description`,`moduleUrl`,`sn`) values (1,'管理菜单',NULL,NULL,NULL,2010,NULL,NULL,'1'),(2,'景点大全',NULL,1,NULL,2010,NULL,'scenicManager.action','1_2'),(3,'热门活动','',1,NULL,20100107,NULL,'activitys.action','1_3'),(4,'驴客集','',1,NULL,2010,NULL,NULL,'1_4'),(5,'旅游政务资讯',NULL,8,NULL,2010,NULL,'articleManager.action','1_8_5'),(6,'车游天下','',8,NULL,2010,'',NULL,'1_8_6'),(7,'大武汉城市圈',NULL,8,NULL,2010,NULL,NULL,'1_8_7'),(8,'特色专栏',NULL,1,NULL,2010,NULL,NULL,'1_8'),(9,'旅游常识','',1,NULL,20100107,NULL,'articleManager.action','1_9'),(10,'各地指南','',1,NULL,20100107,NULL,'articleManager.action','1_10'),(11,'旅行社','',1,NULL,20100107,NULL,NULL,'1_11'),(12,'旅游线路','',1,NULL,20100107,NULL,'touristRoutes.action','1_12'),(13,'活动分类','classifyDefault.action',3,NULL,20100107,NULL,NULL,'1_3_13'),(14,'活动管理','adminDefault.action',3,NULL,20100107,NULL,NULL,'1_3_14'),(15,'吃喝玩乐','',1,NULL,20100107,'','foodManager.action','1_15'),(16,'景点分类','classifyDefault.action',2,NULL,20100107,NULL,NULL,'1_2_16'),(17,'景点管理','adminDefault.action',2,NULL,20100107,NULL,NULL,'1_2_17'),(18,'国内线路','',12,NULL,20100107,NULL,'touristRoutes.action','1_12_18'),(19,'国际线路','',12,NULL,20100107,NULL,'touristRoutes.action','1_12_19'),(20,'国内旅游线路分类','classifyDefault.action',18,NULL,20100107,NULL,NULL,'1_18_20'),(21,'国内旅游线路管理','adminDefault.action',18,NULL,20100107,NULL,NULL,'1_18_21'),(22,'国际线路分类','classifyDefault.action',19,NULL,20100107,NULL,NULL,'1_19_22'),(23,'国际线路管理','adminDefault.action',19,NULL,20100107,NULL,NULL,'1_19_23'),(24,'指南分类','classifyDefault.action',10,NULL,20100107,NULL,NULL,'1_10_24'),(25,'指南管理','adminDefault.action',10,NULL,20100107,NULL,NULL,'1_10_25'),(26,'酒店','',1,NULL,20100107,NULL,'hotelManager.action','1_26'),(27,'酒店分类','classifyDefault.action',26,NULL,20100107,NULL,NULL,'1_26_27'),(28,'酒店管理','adminDefault.action',26,NULL,20100107,NULL,NULL,'1_26_28'),(29,'旅游常识分类','classifyDefault.action',9,NULL,20100107,NULL,NULL,'1_9_34'),(30,'吃喝玩乐分类','classifyDefault.action',15,NULL,20100107,NULL,NULL,'1_15_30'),(31,'吃喝玩乐管理','adminDefault.action',15,NULL,20100107,NULL,NULL,'1_15_31'),(32,'旅游政务资讯分类','classifyDefault.action',5,NULL,20100107,NULL,NULL,'1_5_32'),(33,'旅游政务资讯管理','adminDefault.action',5,NULL,20100107,NULL,NULL,'1_5_33'),(34,'旅游常识管理','adminDefault.action',9,NULL,20100107,NULL,NULL,'1_9_29'),(35,'照片图库',NULL,1,NULL,20100107,'',NULL,'1_35'),(36,'图库分类',NULL,35,NULL,20100107,'',NULL,'1_35_36'),(37,'图库管理',NULL,35,NULL,20100107,'',NULL,'1_35_37'),(38,'在线交流工具','',1,NULL,20100107,'',NULL,'1_38'),(39,'网店设置',NULL,1,NULL,20100107,'',NULL,'1_39'),(40,'资料管理',NULL,39,NULL,20100107,'',NULL,'1_39_40'),(41,'网店频道配置','',39,NULL,20100107,'',NULL,'1_39_41'),(42,'网店营业参数设置',NULL,39,NULL,20100107,'',NULL,'1_39_42'),(43,'网店首页栏目配置',NULL,39,NULL,20100107,'',NULL,'1_39_43'),(44,'网店通栏配置',NULL,39,NULL,20100107,'',NULL,'1_39_44'),(45,'留言管理','',38,NULL,20100107,'',NULL,'1_38_45');
/*Table structure for table `classify` */
BUG说明:
1:
如果数据一条也没有。显示就会有点问题。
解决:如果一条记录没有就执行插入操作,或手工在数据库添加一条记录
2:这并不是异步加载,算是一次性加载,从数据就库看出来,有一个children字段。
呵呵。。异步加载已经写好了。改天再整,不过一颗树就写了四篇,有点不想再写了
3:按钮基本上没用了,我留着,只是防止顾客挑剔,呵呵。。都给他用。怕他用不习惯右键菜单