介绍:
eclipse,mysql,spring,springmvc,mybatis
本健身俱乐部网站系统主要包括系统用户管理、新闻数据管理、用户管理、教练管理、器材管理、教室管理、课程安排管理、选课管理、课程管理、会员卡管理、办卡管理等多个模块。它帮助健身俱乐部网站实现了信息化、网络化,通过测试,实现了系统设计目标,相比传统的管理模式,本系统合理的利用了健身俱乐部网站数据资源,有效的减少了健身俱乐部网站的经济投入,大大提高了健身俱乐部网站的效率。
截图:
数据库表:
CREATE TABLE allusers
(
id
int(11) NOT NULL AUTO_INCREMENT,
username
varchar(50) DEFAULT NULL,
pwd
varchar(50) DEFAULT NULL,
cx
varchar(50) DEFAULT ‘普通管理员’,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
– Records of allusers
INSERT INTO allusers
VALUES (‘2’, ‘hsg’, ‘hsg’, ‘超级管理员’, ‘2020-04-12 09:23:14’);
– Table structure for banka
DROP TABLE IF EXISTS banka
;
CREATE TABLE banka
(
id
int(11) NOT NULL AUTO_INCREMENT,
huiyuankazhonglei
varchar(50) DEFAULT NULL,
dengji
varchar(50) DEFAULT NULL,
zhekou
varchar(50) DEFAULT NULL,
jianjie
varchar(50) DEFAULT NULL,
yonghuming
varchar(50) DEFAULT NULL,
cheng
varchar(50) DEFAULT NULL,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;
– Records of banka
INSERT INTO banka
VALUES (‘2’, ‘’, ‘’, ‘3’, ‘无’, ‘007’, ‘’, ‘2020-04-12 09:23:17’);
INSERT INTO banka
VALUES (‘3’, ‘’, ‘’, ‘4’, ‘abc’, ‘014’, ‘’, ‘2020-04-12 09:23:17’);
INSERT INTO banka
VALUES (‘4’, ‘’, ‘’, ‘2’, ‘没问题’, ‘033’, ‘’, ‘2020-04-12 09:23:17’);
INSERT INTO banka
VALUES (‘5’, ‘’, ‘’, ‘7’, ‘没问题’, ‘016’, ‘’, ‘2020-04-12 09:23:17’);
INSERT INTO banka
VALUES (‘6’, ‘’, ‘’, ‘9’, ‘ok’, ‘001’, ‘’, ‘2020-04-12 09:23:17’);
– Table structure for bankuai
DROP TABLE IF EXISTS bankuai
;
CREATE TABLE bankuai
(
id
int(11) NOT NULL AUTO_INCREMENT,
bianhao
varchar(50) DEFAULT NULL,
mingcheng
varchar(50) DEFAULT NULL,
jianjie
varchar(500) DEFAULT NULL,
banzhu
varchar(50) DEFAULT NULL,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;
– Records of bankuai
INSERT INTO bankuai
VALUES (‘2’, ‘031’, ‘N名称’, ‘无’, ‘’, ‘2020-04-12 09:30:30’);
INSERT INTO bankuai
VALUES (‘3’, ‘027’, ‘L名称’, ‘abc’, ‘’, ‘2020-04-12 09:30:30’);
INSERT INTO bankuai
VALUES (‘4’, ‘030’, ‘Y名称’, ‘无’, ‘’, ‘2020-04-12 09:30:30’);
INSERT INTO bankuai
VALUES (‘5’, ‘015’, ‘J名称’, ‘没问题’, ‘’, ‘2020-04-12 09:30:30’);
INSERT INTO bankuai
VALUES (‘6’, ‘001’, ‘S名称’, ‘没问题’, ‘’, ‘2020-04-12 09:30:31’);
– Table structure for dx
DROP TABLE IF EXISTS dx
;
CREATE TABLE dx
(
ID
int(11) NOT NULL AUTO_INCREMENT,
leibie
varchar(50) DEFAULT NULL,
content
longtext,
PRIMARY KEY (ID
)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
– Records of dx
INSERT INTO dx
VALUES (‘1’, ‘系统公告’, ‘
\r\n 欢迎大家登陆我站,我站主要是为广大朋友精心制作的一个系统,希望大家能够在我站获得一个好心情,谢谢!\r\n
\r\n\r\n 自强不息,海纳百川,努力学习!fff\r\n
’);dx
VALUES (‘2’, ‘系统简介’, ‘系统简介hhrthrrrrr22ggg’);
dx
VALUES (‘3’, ‘关于我们’, ’ 本公司坚持走:以质量求生存,以科技求发展,重合同守信用的道路,生产经营得到迅速发展。我们将以优质的产品和最完善的售后服务来真诚与各界朋友开展广泛的合作,共同创造一个美好的未来!
dx
VALUES (‘4’, ‘联系方式’, ‘联系人:xxxxxxxx
– Table structure for huiyuanka
DROP TABLE IF EXISTS huiyuanka
;
CREATE TABLE huiyuanka
(
id
int(11) NOT NULL AUTO_INCREMENT,
huiyuankazhonglei
varchar(50) DEFAULT NULL,
dengji
varchar(50) DEFAULT NULL,
zhekou
varchar(50) DEFAULT NULL,
jianjie
varchar(500) DEFAULT NULL,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;