基于SSH健身俱乐部会员管理系统（MySql版）

介绍：
基于SSH健身俱乐部会员管理系统（MySql版）
eclipse，mysql，tomcat，Navicat，ssh三大框架

效果截图：








数据库表：

CREATE TABLE t_charge (
id int(11) NOT NULL auto_increment,
amount int(11) NOT NULL,
chargeDate datetime default NULL,
memCard varchar(15) default NULL,
score int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_charge */

/*Table structure for table t_club */

DROP TABLE IF EXISTS t_club;

CREATE TABLE t_club (
name varchar(30) NOT NULL,
introduction varchar(200) default NULL,
place varchar(30) default NULL,
tele varchar(12) default NULL,
PRIMARY KEY (name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_club */

/*Table structure for table t_consume */

DROP TABLE IF EXISTS t_consume;

CREATE TABLE t_consume (
id int(11) NOT NULL auto_increment,
consumeDate datetime default NULL,
expense int(11) NOT NULL,
memCard varchar(15) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_consume */

/*Table structure for table t_employee */

DROP TABLE IF EXISTS t_employee;

CREATE TABLE t_employee (
id varchar(15) NOT NULL,
idCard varchar(25) default NULL,
name varchar(10) default NULL,
nowPlace varchar(30) default NULL,
remark varchar(50) default NULL,
tele varchar(15) default NULL,
workDate date default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_employee */

/*Table structure for table t_facility */

DROP TABLE IF EXISTS t_facility;

CREATE TABLE t_facility (
id varchar(15) NOT NULL,
name varchar(10) default NULL,
purchaseDate date default NULL,
purchasePlace varchar(20) default NULL,
status varchar(12) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_facility */

/*Table structure for table t_member */

DROP TABLE IF EXISTS t_member;

CREATE TABLE t_member (
id varchar(15) NOT NULL,
idCard varchar(25) default NULL,
level varchar(10) default NULL,
money int(11) NOT NULL,
name varchar(10) default NULL,
nowPlace varchar(30) default NULL,
registerDate date default NULL,
score int(11) NOT NULL,
status varchar(6) default NULL,
tele varchar(12) default NULL,
times int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_member */

/*Table structure for table t_user */

DROP TABLE IF EXISTS t_user;

CREATE TABLE t_user (
username varchar(15) NOT NULL,
password varchar(15) default NULL,
type varchar(15) default NULL,
PRIMARY KEY (username)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table t_user */

insert into t_user(username,password,type) values (‘admin’,‘admin’,‘管理员’);