Java项目：JSP+Servlet基于Servlet的体育馆在线预约系统（源码+数据库脚本）

/* SQLyog Ultimate v13.1.1 (64 bit) MySQL - 5.7.33 : Database - stadium_manage ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`stadium_manage` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `stadium_manage`; /*Table structure for table `news` */ DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `title` varchar(255) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `news` */ insert into `news`(`id`,`time`,`title`,`content`) values (1,'2022-04-03 23:48:49','篮球场有活动，查看本站详情！','篮球场有活动，查看本站详情！'); /*Table structure for table `place` */ DROP TABLE IF EXISTS `place`; CREATE TABLE `place` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `ename` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `introduction` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*Data for the table `place` */ insert into `place`(`id`,`name`,`ename`,`location`,`introduction`) values (6,'篮球馆场','Lan Qiu Guan','北京东城区','篮球馆场篮球馆场'); /*Table structure for table `placestadium` */ DROP TABLE IF EXISTS `placestadium`; CREATE TABLE `placestadium` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `num` int(11) DEFAULT NULL, `fare` int(11) DEFAULT NULL, `pid` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_place` (`pid`), CONSTRAINT `fk_place` FOREIGN KEY (`pid`) REFERENCES `place` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*Data for the table `placestadium` */ insert into `placestadium`(`id`,`name`,`num`,`fare`,`pid`) values (4,'篮球馆A场地',3,10,6), (5,'篮球馆B场地',1,10,6); /*Table structure for table `reserve` */ DROP TABLE IF EXISTS `reserve`; CREATE TABLE `reserve` ( `id` int(11) NOT NULL AUTO_INCREMENT, `time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `name` varchar(255) DEFAULT NULL, `fare` int(11) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `uid` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `rs_user` (`uid`), CONSTRAINT `rs_user` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*Data for the table `reserve` */ insert into `reserve`(`id`,`time`,`name`,`fare`,`status`,`uid`) values (1,'2022-04-04 00:13:49','篮球馆场篮球馆A场地',10,'审核通过',7), (4,'2022-04-04 00:13:52','篮球馆场篮球馆A场地',10,'审核通过',7), (5,'2022-04-04 00:19:02','篮球馆场篮球馆A场地',30,'审核通过',7), (6,'2022-04-04 00:13:44','篮球馆场篮球馆A场地',40,'审核通过',7), (7,'2022-04-04 00:07:20','篮球馆场篮球馆A场地',20,'未付款',7); /*Table structure for table `reserveitem` */ DROP TABLE IF EXISTS `reserveitem`; CREATE TABLE `reserveitem` ( `id` int(11) NOT NULL AUTO_INCREMENT, `piid` int(11) DEFAULT NULL, `rid` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_planItem` (`piid`), KEY `fk_reserve` (`rid`), CONSTRAINT `fk_planItem` FOREIGN KEY (`piid`) REFERENCES `stadiumplanitem` (`id`), CONSTRAINT `fk_reserve` FOREIGN KEY (`rid`) REFERENCES `reserve` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; /*Data for the table `reserveitem` */ insert into `reserveitem`(`id`,`piid`,`rid`) values (1,3,1), (4,4,4), (5,5,5), (6,6,5), (7,7,5), (8,200,6), (9,201,6), (10,213,6), (11,214,6), (12,202,7), (13,215,7); /*Table structure for table `stadiumplan` */ DROP TABLE IF EXISTS `stadiumplan`; CREATE TABLE `stadiumplan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `inode` int(11) DEFAULT NULL, `date` date DEFAULT NULL, `psid` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_placeStadium` (`psid`), CONSTRAINT `fk_placeStadium` FOREIGN KEY (`psid`) REFERENCES `placestadium` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; /*Data for the table `stadiumplan` */ insert into `stadiumplan`(`id`,`inode`,`date`,`psid`) values (1,0,'2021-06-29',4), (2,1,'2021-06-29',4), (3,2,'2021-06-29',4), (4,0,'2021-06-29',5), (5,0,'2021-06-30',4), (6,1,'2021-06-30',4), (7,2,'2021-06-30',4), (8,0,'2021-07-01',4), (9,1,'2021-07-01',4), (10,2,'2021-07-01',4), (11,0,'2021-06-30',5), (12,0,'2021-07-01',5), (13,0,'2022-04-03',4), (14,1,'2022-04-03',4), (15,2,'2022-04-03',4), (16,0,'2022-04-04',4), (17,1,'2022-04-04',4), (18,2,'2022-04-04',4), (19,0,'2022-04-05',4), (20,1,'2022-04-05',4), (21,2,'2022-04-05',4), (22,0,'2022-04-03',5), (23,0,'2022-04-04',5), (24,0,'2022-04-05',5), (25,0,'2022-04-06',4), (26,1,'2022-04-06',4), (27,2,'2022-04-06',4); /*Table structure for table `stadiumplanitem` */ DROP TABLE IF EXISTS `stadiumplanitem`; CREATE TABLE `stadiumplanitem` ( `id` int(11) NOT NULL AUTO_INCREMENT, `beg` time DEFAULT NULL, `end` time DEFAULT NULL, `inode` int(11) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `spid` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_stadiumPlan` (`spid`), CONSTRAINT `fk_stadiumPlan` FOREIGN KEY (`spid`) REFERENCES `stadiumplan` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8; /*Data for the table `stadiumplanitem` */ insert into `stadiumplanitem`(`id`,`beg`,`end`,`inode`,`status`,`spid`) values (1,'08:00:00','09:00:00',0,'空闲',1), (2,'09:00:00','10:00:00',1,'空闲',1), (3,'10:00:00','11:00:00',2,'已预约',1), (4,'11:00:00','12:00:00',3,'已预约',1), (5,'12:00:00','13:00:00',4,'空闲',1), (6,'13:00:00','14:00:00',5,'空闲',1), (7,'14:00:00','15:00:00',6,'空闲',1), (8,'15:00:00','16:00:00',7,'审核中',1), (9,'16:00:00','17:00:00',8,'审核中',1), (10,'17:00:00','18:00:00',9,'审核中',1), (11,'18:00:00','19:00:00',10,'审核中',1), (12,'19:00:00','20:00:00',11,'空闲',1), (13,'20:00:00','21:00:00',12,'空闲',1), (14,'08:00:00','09:00:00',0,'空闲',2), (15,'09:00:00','10:00:00',1,'空闲',2), (16,'10:00:00','11:00:00',2,'空闲',2), (17,'11:00:00','12:00:00',3,'空闲',2), (18,'12:00:00','13:00:00',4,'空闲',2), (19,'13:00:00','14:00:00',5,'空闲',2), (20,'14:00:00','15:00:00',6,'空闲',2), (21,'15:00:00','16:00:00',7,'空闲',2), (22,'16:00:00','17:00:00',8,'空闲',2), (23,'17:00:00','18:00:00',9,'空闲',2), (24,'18:00:00','19:00:00',10,'空闲',2), (25,'19:00:00','20:00:00',11,'空闲',2), (26,'20:00:00','21:00:00',12,'空闲',2), (27,'08:00:00','09:00:00',0,'空闲',3), (28,'09:00:00','10:00:00',1,'空闲',3), (29,'10:00:00','11:00:00',2,'空闲',3), (30,'11:00:00','12:00:00',3,'空闲',3), (31,'12:00:00','13:00:00',4,'空闲',3), (32,'13:00:00','14:00:00',5,'空闲',3), (33,'14:00:00','15:00:00',6,'空闲',3), (34,'15:00:00','16:00:00',7,'空闲',3), (35,'16:00:00','17:00:00',8,'空闲',3), (36,'17:00:00','18:00:00',9,'空闲',3), (37,'18:00:00','19:00:00',10,'空闲',3), (38,'19:00:00','20:00:00',11,'空闲',3), (39,'20:00:00','21:00:00',12,'空闲',3), (40,'08:00:00','09:00:00',0,'空闲',4), (41,'09:00:00','10:00:00',1,'空闲',4), (42,'10:00:00','11:00:00',2,'空闲',4), (43,'11:00:00','12:00:00',3,'空闲',4), (44,'12:00:00','13:00:00',4,'空闲',4), (45,'13:00:00','14:00:00',5,'空闲',4), (46,'14:00:00','15:00:00',6,'空闲',4