1753jsp健身房数据管理系统Myeclipse开发mysql数据库web结构java编程计算机网页项目源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jspjsf Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2021-06-17 20:04:57 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for bfsm -- ---------------------------- DROP TABLE IF EXISTS `bfsm`; CREATE TABLE `bfsm` ( `bfsmid` int(11) NOT NULL auto_increment, `qc` varchar(40) default NULL COMMENT '器材', `bfsm` varchar(4000) default NULL COMMENT '报废说明', `djr` varchar(40) default NULL COMMENT '登记人', `djrq` varchar(40) default NULL COMMENT '登记日期', PRIMARY KEY (`bfsmid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of bfsm -- ---------------------------- INSERT INTO `bfsm` VALUES ('1', '哑铃', '撒旦法', '123', '2021-06-17 16:43:58'); INSERT INTO `bfsm` VALUES ('2', '拉力器', '123', 'qx', '2021-06-17 20:03:33'); -- ---------------------------- -- Table structure for byqk -- ---------------------------- DROP TABLE IF EXISTS `byqk`; CREATE TABLE `byqk` ( `byqkid` int(11) NOT NULL auto_increment, `qc` varchar(40) default NULL COMMENT '器材', `bt` varchar(40) default NULL COMMENT '标题', `bynr` varchar(40) default NULL COMMENT '保养内容', `djr` varchar(40) default NULL COMMENT '登记人', `djrq` varchar(40) default NULL COMMENT '登记日期', PRIMARY KEY (`byqkid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of byqk -- ---------------------------- INSERT INTO `byqk` VALUES ('1', '哑铃', '保养阿', '保养阿保养阿保养阿', '123', '2021-06-17 16:22:25'); INSERT INTO `byqk` VALUES ('2', '拉力器', '沙发', '阿斯顿发放', 'qx', '2021-06-17 20:03:25'); -- ---------------------------- -- Table structure for huiyuan -- ---------------------------- DROP TABLE IF EXISTS `huiyuan`; CREATE TABLE `huiyuan` ( `hyid` int(11) NOT NULL auto_increment, `kh` varchar(40) default NULL COMMENT '卡号', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `xb` varchar(40) default NULL COMMENT '性别', `hyrq` varchar(40) default NULL COMMENT '会员日期', `gqrq` varchar(40) default NULL COMMENT '过期日期', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`hyid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of huiyuan -- ---------------------------- INSERT INTO `huiyuan` VALUES ('1', '123', '123', '123', '男', '2021-06-16', '2022-06-29', '正常'); INSERT INTO `huiyuan` VALUES ('2', '06172002001', '333', '333', '男', '2021-06-25', '2022-06-30', '正常'); -- ---------------------------- -- Table structure for hybl -- ---------------------------- DROP TABLE IF EXISTS `hybl`; CREATE TABLE `hybl` ( `hyblid` int(11) NOT NULL auto_increment, `hy` varchar(40) default NULL COMMENT '会员', `blrq` varchar(40) default NULL COMMENT '办理日期', `yxq` varchar(40) default NULL COMMENT '有效期', `djr` varchar(40) default NULL COMMENT '登记人', `djsj` varchar(40) default NULL COMMENT '登记时间', PRIMARY KEY (`hyblid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of hybl -- ---------------------------- INSERT INTO `hybl` VALUES ('1', '123', '2021-06-17', '2022-06-29', '123', '2021-06-17 10:06:47'); INSERT INTO `hybl` VALUES ('2', '06172002001', '2021-06-17', '2022-06-30', 'qt', '2021-06-17 20:02:20'); -- ---------------------------- -- Table structure for jsqc -- ---------------------------- DROP TABLE IF EXISTS `jsqc`; CREATE TABLE `jsqc` ( `jsqcid` int(11) NOT NULL auto_increment, `qcmc` varchar(40) default NULL COMMENT '器材名称', `cs` varchar(40) default NULL COMMENT '厂商', `scrq` varchar(40) default NULL COMMENT '生产日期', `zjwhrq` varchar(40) default NULL COMMENT '最近维护日期', `sm` varchar(4000) default NULL COMMENT '说明', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`jsqcid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jsqc -- ---------------------------- INSERT INTO `jsqc` VALUES ('1', '哑铃', '珠海', '2021-06-18', '2021-06-17', 'null', '已报废'); INSERT INTO `jsqc` VALUES ('3', '拉力器', '长江', '2021-06-24', '2021-06-17', 'null', '已报废'); -- ---------------------------- -- Table structure for kecheng -- ---------------------------- DROP TABLE IF EXISTS `kecheng`; CREATE TABLE `kecheng` ( `kcid` int(11) NOT NULL auto_increment, `kcmc` varchar(40) default NULL COMMENT '课程名称', `jl` varchar(40) default NULL COMMENT '教练', `sm` varchar(4000) default NULL COMMENT '说明', `sksj` varchar(4000) default NULL COMMENT '上课时间', PRIMARY KEY (`kcid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of kecheng -- ---------------------------- INSERT INTO `kecheng` VALUES ('1', '游泳课', 'jl', '初级', '每周2次'); INSERT INTO `kecheng` VALUES ('2', '举重课程', 'jl', '举重课程', '每周上课2天，一共5天'); INSERT INTO `kecheng` VALUES ('3', '减肥课', 'jl', '12312', '3123'); -- ---------------------------- -- Table structure for shangke -- ---------------------------- DROP TABLE IF EXISTS `shangke`; CREATE TABLE `shangke` ( `skid` int(11) NOT NULL auto_increment, `sjd` varchar(40) default NULL COMMENT '时间段', `kc` varchar(40) default NULL COMMENT '课程', `rq` varchar(40) default NULL COMMENT '日期', `hy` varchar(40) default NULL COMMENT '会员', `djsj` varchar(40) default NULL COMMENT '登记时间', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`skid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of shangke -- ---------------------------- INSERT INTO `shangke` VALUES ('1', '9:00~11:00', '游泳课', '2021-06-24', '123', '2021-06-17 19:41:27', '已上课'); INSERT INTO `shangke` VALUES ('2', '13:00~14:00', '举重课程', '2021-06-25', '123', '2021-06-17 20:01:29', '未上课'); -- ---------------------------- -- Table structure for sjd -- ---------------------------- DROP TABLE IF EXISTS `sjd`; CREATE TABLE `sjd` ( `sjdid` int(11) NOT NULL auto_increment, `sjd` varchar(40) default NULL COMMENT '时间段', PRIMARY KEY (`sjdid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of sjd -- ---------------------------- INSERT INTO `sjd` VALUES ('1', '9:00~11:00'); INSERT INTO `sjd` VALUES ('2', '11:00~12:00'); INSERT INTO `sjd` VALUES ('3', '13:00~14:00'); INSERT INTO `sjd` VALUES ('4', '14:00~15:00'); -- ---------------------------- -- Table structure for wxqk -- ---------------------------- DROP TABLE IF EXISTS `wxqk`; CREATE TABLE `wxqk` ( `wxqkid` int(11) NOT NULL auto_increment, `qc` varchar(40) default NULL COMMENT '器材', `bt` varchar(40) default NULL COMMENT '标题', `wxnr` varchar(4000) default NULL COMMENT '维修内容', `djr` varchar(40) default NULL COMMENT '登记人', `djrq` varchar(40) default NULL COMMENT '登记日期', PRIMARY KEY (`wxqkid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of wxqk -- ---------------------------- INSERT INTO `wxqk` VALUES ('1', '哑铃', '维护按时发达是', 'null', '123', '2021-06-17'); INSERT INTO `wxqk` VALUES ('2', '哑铃', '阿道夫', '阿道夫', '123', '2021-06-17'); INSERT INTO `wxqk` VALUES ('3', '拉力器', '1231', '23123', 'qx'