技术:jsp+servlert+mysql+tomcat
角色:管理员,普通用户
主要功能:
管理员管理
用户管理
车位管理
车费标准
停车缴费
车位状态
停车记录查询
CREATE TABLE `t_s_attachment` (
`ID` varchar(32) NOT NULL,
`attachmentcontent` longblob,
`attachmenttitle` varchar(100) DEFAULT NULL,
`businesskey` varchar(32) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`extend` varchar(32) DEFAULT NULL,
`note` longtext,
`realpath` varchar(100) DEFAULT NULL,
`subclassname` longtext,
`swfpath` longtext,
`BUSENTITYNAME` varchar(100) DEFAULT NULL,
`INFOTYPEID` varchar(32) DEFAULT NULL,
`USERID` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `FK_mnq23hlc835n4ufgjl7nkn3bd` (`USERID`),
CONSTRAINT `FK_mnq23hlc835n4ufgjl7nkn3bd` FOREIGN KEY (`USERID`) REFERENCES `t_s_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `t_s_base_user` (
`ID` varchar(32) NOT NULL,
`activitiSync` smallint(6) DEFAULT NULL,
`browser` varchar(20) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`realname` varchar(50) DEFAULT NULL,
`signature` blob,
`status` smallint(6) DEFAULT NULL,
`userkey` varchar(200) DEFAULT NULL,
`username` varchar(10) NOT NULL,
`departid` varchar(32) DEFAULT NULL,
`debit` decimal(5,2) DEFAULT '0.00',
PRIMARY KEY (`ID`),
KEY `FK_15jh1g4iem1857546ggor42et` (`departid`),
CONSTRAINT `FK_15jh1g4iem1857546ggor42et` FOREIGN KEY (`departid`) REFERENCES `t_s_depart` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `t_s_base_user` VALUES ('402881e5455f7eca01455f7f46290044',1,NULL,'c44b01947c9e6e3f','管理员',NULL,1,NULL,'admin','402881e5455f7eca01455f7f45b80015',100.00),('402881e54596fb2e014596fefd8c0001',NULL,NULL,'8f6958dabefcff2f','刘德华',NULL,1,NULL,'liu','402881e54586e3be014586ea3dc70007',100.00),('402881e54596fb2e014596fefefc0004',NULL,NULL,'283e0ba3d8220f7a','李连杰',NULL,1,NULL,'lee','402881e54586e3be014586ea3dc70007',100.00);
DROP TABLE IF EXISTS `t_s_config`;
CREATE TABLE `t_s_config` (
`ID` varchar(32) NOT NULL,
`code` varchar(100) DEFAULT NULL,
`content` longtext,
`name` varchar(100) NOT NULL,
`note` longtext,
`userid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `FK_m3q8r50ror4fl7fjkvd82tqgn` (`userid`),
CONSTRAINT `FK_m3q8r50ror4fl7fjkvd82tqgn` FOREIGN KEY (`userid`) REFERENCES `t_s_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_s_depart`;
CREATE TABLE `t_s_depart` (
`ID` varchar(32) NOT NULL,
`departname` varchar(100) NOT NULL,
`description` longtext,
`parentdepartid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `FK_knnm3wb0bembwvm0il7tf6686` (`parentdepartid`),
CONSTRAINT `FK_knnm3wb0bembwvm0il7tf6686` FOREIGN KEY (`parentdepartid`) REFERENCES `t_s_depart` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `t_s_depart` WRITE;
INSERT INTO `t_s_depart` VALUES ('402881e5455f7eca01455f7f45b80015','信息部','',NULL),('402881e54586e3be014586e9d8600005','教学部','',NULL),('402881e54586e3be014586ea3dc70007','信息工程系','','402881e54586e3be014586e9d8600005'),('402881e54586e3be014586ed46c00009','音乐系','','402881e54586e3be014586e9d8600005');
UNLOCK TABLES;
CREATE TABLE `t_s_document` (
`documentstate` smallint(6) DEFAULT NULL,
`documenttitle` varchar(100) DEFAULT NULL,
`pictureindex` blob,
`showhome` smallint(6) DEFAULT NULL,
`id` varchar(32) NOT NULL,
`typeid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_qr3qlmgkflj35m5ci1xv0vvg3` (`typeid`),
KEY `FK_f2mc12eu0umghp2i70apmtxjl` (`id`),
CONSTRAINT `FK_f2mc12eu0umghp2i70apmtxjl` FOREIGN KEY (`id`) REFERENCES `t_s_attachment` (`ID`),
CONSTRAINT `FK_qr3qlmgkflj35m5ci1xv0vvg3` FOREIGN KEY (`typeid`) REFERENCES `t_s_type` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_s_fileno`;
CREATE TABLE `t_s_fileno` (
`ID` varchar(32) NOT NULL,
`filenobefore` varchar(32) DEFAULT NULL,
`filenonum` int(11) DEFAULT NULL,
`filenotype` varchar(32) DEFAULT NULL,
`filenoYear` date DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_s_function`;
CREATE TABLE `t_s_function` (
`ID` varchar(32) NOT NULL,
`functioniframe` smallint(6) DEFAULT NULL,
`functionlevel` smallint(6) DEFAULT NULL,
`functionname` varchar(50) NOT NULL,
`functionorder