|
如果表库有问题的话建如下两个表即可运行项目以及启动示例
CREATE TABLE `resources` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nodeId` int(10) DEFAULT NULL,
`menuName` varchar(45) DEFAULT NULL,
`parantNodeID` int(10) DEFAULT NULL,
`icon` varchar(100) DEFAULT NULL,
`openIcon` varchar(100) DEFAULT NULL,
`actionPath` varchar(300) DEFAULT NULL,
`menuOrder` int(10) DEFAULT NULL,
`isValiDate` char(1) DEFAULT NULL,
`description` varchar(45) DEFAULT NULL,
`jsClassFile` varchar(300) DEFAULT NULL,
`type` varchar(45) DEFAULT NULL,
`namespace` varchar(100) DEFAULT NULL,
`mainClass` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;
CREATE TABLE `sysuser` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(255) NOT NULL,
`userPassword` varchar(50) NOT NULL,
`realName` varchar(255) DEFAULT NULL,
`deptId` int(11) DEFAULT NULL,
`userDuty` varchar(50) DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`creator` varchar(50) DEFAULT NULL,
`userDeptName` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=gbk;
写入几个数据以便测试!
INSERT INTO `resources` VALUES (167,8000,'系统管理',0,'',NULL,'',8000,'1','','','iframe','',''),(168,8001,'资源管理',8000,'../images/setuseridicon.png',NULL,'',8001,'1','asdasd','../basic/ResourcePanel.js','JSClass','com.ms.basic','com.ms.basic.ResourcePanel'),(169,8002,'谷歌',8000,'../images/setuseridicon.png',NULL,'http://www.google.com.hk/',8002,'1','','','iframe','',''),(170,100,'工具',0,'',NULL,'',100,'1','','','iframe','',''),(171,101,'谷歌翻译',100,'../images/setuseridicon.png',NULL,'http://translate.google.com.hk/',101,'1','','','iframe','','');
INSERT INTO `sysuser` VALUES (1,'admin','admin','管理员',5,'系统管理员','2011-05-20 00:00:00',NULL,'综合部');
|
|