- 基于web的游泳馆管理系统的设计与实现mysql数据库创建语句
- 基于web的游泳馆管理系统的设计与实现oracle数据库创建语句
- 基于web的游泳馆管理系统的设计与实现sqlserver数据库创建语句
- 基于web的游泳馆管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于web的游泳馆管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于web的游泳馆管理系统的设计与实现mysql数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '超级管理员账号',
password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');
会员卡表创建语句如下：
create table t_card(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
cardNum varchar(100) comment '卡号',
types varchar(100) comment '月卡还是年卡',
status varchar(100) comment '状态'
) comment '会员卡';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '真实姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '用户';
员工表创建语句如下：
create table t_employee(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
employeeName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '员工';
教练表创建语句如下：
create table t_jiaolian(
id int primary key auto_increment comment '主键',
jiaolianName varchar(100) comment '教练名称',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pic varchar(100) comment '图片',
status varchar(100) comment '状态'
) comment '教练';
教学计划表创建语句如下：
create table t_jxjh(
id int primary key auto_increment comment '主键',
title varchar(100) comment '教学计划标题',
sj varchar(100) comment '时间安排',
teacherName varchar(100) comment '教师',
td varchar(100) comment '特点',
remark varchar(100) comment '备注'
) comment '教学计划';
预定表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
orderDate datetime comment '预定日期',
remark varchar(100) comment '备注',
status varchar(100) comment '状态'
) comment '预定';
培训班表创建语句如下：
create table t_pxb(
id int primary key auto_increment comment '主键',
pxbName varchar(100) comment '培训班名称',
pxls varchar(100) comment '培训老师',
dd varchar(100) comment '地点',
rs varchar(100) comment '人数',
xy varchar(100) comment '学院列表',
status varchar(100) comment '状态'
) comment '培训班';
事故记录表创建语句如下：
create table t_sgjl(
id int primary key auto_increment comment '主键',
sgmc varchar(100) comment '事故标题',
sgdd varchar(100) comment '事故地点',
sgyy varchar(100) comment '事故原因',
sgfx varchar(100) comment '事故分类',
sgrq varchar(100) comment '事故日期'
) comment '事故记录';
通知公告表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
pic varchar(100) comment '图片',
showDate varchar(100) comment '通知日期'
) comment '通知公告';
消费记录表创建语句如下：
create table t_xfjl(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
cardNum varchar(100) comment '卡号',
fee int comment '金额',
bkDate datetime comment '办卡日期',
fzr varchar(100) comment '负责人',
sgrq varchar(100) comment '事故日期'
) comment '消费记录';
游泳馆表创建语句如下：
create table t_yyg(
id int primary key auto_increment comment '主键',
content varchar(100) comment '游泳馆信息'
) comment '游泳馆';
基于web的游泳馆管理系统的设计与实现oracle数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';
会员卡表创建语句如下：
create table t_card(
id integer,
customerId int,
cardNum varchar(100),
types varchar(100),
status varchar(100)
);
--会员卡字段加注释
comment on column t_card.id is '主键';
comment on column t_card.customerId is '用户';
comment on column t_card.cardNum is '卡号';
comment on column t_card.types is '月卡还是年卡';
comment on column t_card.status is '状态';
--会员卡表加注释
comment on table t_card is '会员卡';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '真实姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';
员工表创建语句如下：
create table t_employee(
id integer,
username varchar(100),
password varchar(100),
employeeName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--员工字段加注释
comment on column t_employee.id is '主键';
comment on column t_employee.username is '账号';
comment on column t_employee.password is '密码';
comment on column t_employee.employeeName is '姓名';
comment on column t_employee.phone is '电话';
comment on column t_employee.age is '年龄';
comment on column t_employee.sex is '性别';
--员工表加注释
comment on table t_employee is '员工';
教练表创建语句如下：
create table t_jiaolian(
id integer,
jiaolianName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic varchar(100),
status varchar(100)
);
--教练字段加注释
comment on column t_jiaolian.id is '主键';
comment on column t_jiaolian.jiaolianName is '教练名称';
comment on column t_jiaolian.age is '年龄';
comment on column t_jiaolian.sex is '性别';
comment on column t_jiaolian.phone is '电话';
comment on column t_jiaolian.pic is '图片';
comment on column t_jiaolian.status is '状态';
--教练表加注释
comment on table t_jiaolian is '教练';
教学计划表创建语句如下：
create table t_jxjh(
id integer,
title varchar(100),
sj varchar(100),
teacherName varchar(100),
td varchar(100),
remark varchar(100)
);
--教学计划字段加注释
comment on column t_jxjh.id is '主键';
comment on column t_jxjh.title is '教学计划标题';
comment on column t_jxjh.sj is '时间安排';
comment on column t_jxjh.teacherName is '教师';
comment on column t_jxjh.td is '特点';
comment on column t_jxjh.remark is '备注';
--教学计划表加注释
comment on table t_jxjh is '教学计划';
预定表创建语句如下：
create table t_order(
id integer,
customerId int,
orderDate datetime,
remark varchar(100),
status varchar(100)
);
--预定字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.orderDate is '预定日期';
comment on column t_order.remark is '备注';
comment on column t_order.status is '状态';
--预定表加注释
comment on table t_order is '预定';
培训班表创建语句如下：
create table t_pxb(
id integer,
pxbName varchar(100),
pxls varchar(100),
dd varchar(100),
rs varchar(100),
xy varchar(100),
status varchar(100)
);
--培训班字段加注释
comment on column t_pxb.id is '主键';
comment on column t_pxb.pxbName is '培训班名称';
comment on column t_pxb.pxls is '培训老师';
comment on column t_pxb.dd is '地点';
comment on column t_pxb.rs is '人数';
comment on column t_pxb.xy is '学院列表';
comment on column t_pxb.status is '状态';
--培训班表加注释
comment on table t_pxb is '培训班';
事故记录表创建语句如下：
create table t_sgjl(
id integer,
sgmc varchar(100),
sgdd varchar(100),
sgyy varchar(100),
sgfx varchar(100),
sgrq varchar(100)
);
--事故记录字段加注释
comment on column t_sgjl.id is '主键';
comment on column t_sgjl.sgmc is '事故标题';
comment on column t_sgjl.sgdd is '事故地点';
comment on column t_sgjl.sgyy is '事故原因';
comment on column t_sgjl.sgfx is '事故分类';
comment on column t_sgjl.sgrq is '事故日期';
--事故记录表加注释
comment on table t_sgjl is '事故记录';
通知公告表创建语句如下：
create table t_tongzhi(
id integer,
title varchar(100),
content varchar(100),
pic varchar(100),
showDate varchar(100)
);
--通知公告字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.pic is '图片';
comment on column t_tongzhi.showDate is '通知日期';
--通知公告表加注释
comment on table t_tongzhi is '通知公告';
消费记录表创建语句如下：
create table t_xfjl(
id integer,
customerId int,
cardNum varchar(100),
fee int,
bkDate datetime,
fzr varchar(100),
sgrq varchar(100)
);
--消费记录字段加注释
comment on column t_xfjl.id is '主键';
comment on column t_xfjl.customerId is '用户';
comment on column t_xfjl.cardNum is '卡号';
comment on column t_xfjl.fee is '金额';
comment on column t_xfjl.bkDate is '办卡日期';
comment on column t_xfjl.fzr is '负责人';
comment on column t_xfjl.sgrq is '事故日期';
--消费记录表加注释
comment on table t_xfjl is '消费记录';
游泳馆表创建语句如下：
create table t_yyg(
id integer,
content varchar(100)
);
--游泳馆字段加注释
comment on column t_yyg.id is '主键';
comment on column t_yyg.content is '游泳馆信息';
--游泳馆表加注释
comment on table t_yyg is '游泳馆';
oracle特有，对应序列如下：
create sequence s_t_card;
create sequence s_t_customer;
create sequence s_t_employee;
create sequence s_t_jiaolian;
create sequence s_t_jxjh;
create sequence s_t_order;
create sequence s_t_pxb;
create sequence s_t_sgjl;
create sequence s_t_tongzhi;
create sequence s_t_xfjl;
create sequence s_t_yyg;
基于web的游泳馆管理系统的设计与实现sqlserver数据库版本源码：
超级管理员表创建语句如下：
--超级管理员
create table t_admin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--超级管理员账号
password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');
会员卡表创建语句如下：
--会员卡表注释
create table t_card(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
cardNum varchar(100),--卡号
types varchar(100),--月卡还是年卡
status varchar(100)--状态
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--真实姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
员工表创建语句如下：
--员工表注释
create table t_employee(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
employeeName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
教练表创建语句如下：
--教练表注释
create table t_jiaolian(
id int identity(1,1) primary key not null,--主键
jiaolianName varchar(100),--教练名称
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pic varchar(100),--图片
status varchar(100)--状态
);
教学计划表创建语句如下：
--教学计划表注释
create table t_jxjh(
id int identity(1,1) primary key not null,--主键
title varchar(100),--教学计划标题
sj varchar(100),--时间安排
teacherName varchar(100),--教师
td varchar(100),--特点
remark varchar(100)--备注
);
预定表创建语句如下：
--预定表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
orderDate datetime,--预定日期
remark varchar(100),--备注
status varchar(100)--状态
);
培训班表创建语句如下：
--培训班表注释
create table t_pxb(
id int identity(1,1) primary key not null,--主键
pxbName varchar(100),--培训班名称
pxls varchar(100),--培训老师
dd varchar(100),--地点
rs varchar(100),--人数
xy varchar(100),--学院列表
status varchar(100)--状态
);
事故记录表创建语句如下：
--事故记录表注释
create table t_sgjl(
id int identity(1,1) primary key not null,--主键
sgmc varchar(100),--事故标题
sgdd varchar(100),--事故地点
sgyy varchar(100),--事故原因
sgfx varchar(100),--事故分类
sgrq varchar(100)--事故日期
);
通知公告表创建语句如下：
--通知公告表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content varchar(100),--内容
pic varchar(100),--图片
showDate varchar(100)--通知日期
);
消费记录表创建语句如下：
--消费记录表注释
create table t_xfjl(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
cardNum varchar(100),--卡号
fee int,--金额
bkDate datetime,--办卡日期
fzr varchar(100),--负责人
sgrq varchar(100)--事故日期
);
游泳馆表创建语句如下：
--游泳馆表注释
create table t_yyg(
id int identity(1,1) primary key not null,--主键
content varchar(100)--游泳馆信息
);
登录后主页.jpg?x-oss-process=style/00001)
基于web的游泳馆管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
会员卡javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//会员卡
@Table(name = "t_card")
public class Card {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//月卡还是年卡
private String types;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}用户javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//用户
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//真实姓名
private String customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}员工javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//员工
@Table(name = "t_employee")
public class Employee {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String employeeName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}教练javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//教练
@Table(name = "t_jiaolian")
public class Jiaolian {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教练名称
private String jiaolianName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//图片
private String pic;
//状态
private String status;
public String getJiaolianName() {return jiaolianName;}
public void setJiaolianName(String jiaolianName) {this.jiaolianName = jiaolianName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}教学计划javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//教学计划
@Table(name = "t_jxjh")
public class Jxjh {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教学计划标题
private String title;
//时间安排
private String sj;
//教师
private String teacherName;
//特点
private String td;
//备注
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getTd() {return td;}
public void setTd(String td) {this.td = td;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}预定javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//预定
@Table(name = "t_order")
public class Order {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//预定日期
private Date orderDate;
//备注
private String remark;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getOrderDate() {return orderDate;}
public void setOrderDate(Date orderDate) {this.orderDate = orderDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}培训班javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//培训班
@Table(name = "t_pxb")
public class Pxb {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//培训班名称
private String pxbName;
//培训老师
private String pxls;
//地点
private String dd;
//人数
private String rs;
//学院列表
private String xy;
//状态
private String status;
public String getPxbName() {return pxbName;}
public void setPxbName(String pxbName) {this.pxbName = pxbName;}
public String getPxls() {return pxls;}
public void setPxls(String pxls) {this.pxls = pxls;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}事故记录javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//事故记录
@Table(name = "t_sgjl")
public class Sgjl {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故标题
private String sgmc;
//事故地点
private String sgdd;
//事故原因
private String sgyy;
//事故分类
private String sgfx;
//事故日期
private String sgrq;
public String getSgmc() {return sgmc;}
public void setSgmc(String sgmc) {this.sgmc = sgmc;}
public String getSgdd() {return sgdd;}
public void setSgdd(String sgdd) {this.sgdd = sgdd;}
public String getSgyy() {return sgyy;}
public void setSgyy(String sgyy) {this.sgyy = sgyy;}
public String getSgfx() {return sgfx;}
public void setSgfx(String sgfx) {this.sgfx = sgfx;}
public String getSgrq() {return sgrq;}
public void setSgrq(String sgrq) {this.sgrq = sgrq;}
}通知公告javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//通知公告
@Table(name = "t_tongzhi")
public class Tongzhi {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//通知日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}消费记录javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//消费记录
@Table(name = "t_xfjl")
public class Xfjl {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//金额
private Integer fee;
//办卡日期
private Date bkDate;
//负责人
private String fzr;
//事故日期
private String sgrq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getBkDate() {return bkDate;}
public void setBkDate(Date bkDate) {this.bkDate = bkDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getSgrq() {return sgrq;}
public void setSgrq(String sgrq) {this.sgrq = sgrq;}
}游泳馆javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//游泳馆
@Table(name = "t_yyg")
public class Yyg {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//游泳馆信息
private String content;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}基于web的游泳馆管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
会员卡javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//会员卡
public class Card extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//月卡还是年卡
private String types;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//真实姓名
private String customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}员工javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工
public class Employee extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String employeeName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}教练javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//教练
public class Jiaolian extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教练名称
private String jiaolianName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//图片
private String pic;
//状态
private String status;
public String getJiaolianName() {return jiaolianName;}
public void setJiaolianName(String jiaolianName) {this.jiaolianName = jiaolianName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}教学计划javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//教学计划
public class Jxjh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教学计划标题
private String title;
//时间安排
private String sj;
//教师
private String teacherName;
//特点
private String td;
//备注
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getTd() {return td;}
public void setTd(String td) {this.td = td;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}预定javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//预定
public class Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//预定日期
private Date orderDate;
//备注
private String remark;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getOrderDate() {return orderDate;}
public void setOrderDate(Date orderDate) {this.orderDate = orderDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}培训班javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//培训班
public class Pxb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//培训班名称
private String pxbName;
//培训老师
private String pxls;
//地点
private String dd;
//人数
private String rs;
//学院列表
private String xy;
//状态
private String status;
public String getPxbName() {return pxbName;}
public void setPxbName(String pxbName) {this.pxbName = pxbName;}
public String getPxls() {return pxls;}
public void setPxls(String pxls) {this.pxls = pxls;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}事故记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//事故记录
public class Sgjl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故标题
private String sgmc;
//事故地点
private String sgdd;
//事故原因
private String sgyy;
//事故分类
private String sgfx;
//事故日期
private String sgrq;
public String getSgmc() {return sgmc;}
public void setSgmc(String sgmc) {this.sgmc = sgmc;}
public String getSgdd() {return sgdd;}
public void setSgdd(String sgdd) {this.sgdd = sgdd;}
public String getSgyy() {return sgyy;}
public void setSgyy(String sgyy) {this.sgyy = sgyy;}
public String getSgfx() {return sgfx;}
public void setSgfx(String sgfx) {this.sgfx = sgfx;}
public String getSgrq() {return sgrq;}
public void setSgrq(String sgrq) {this.sgrq = sgrq;}
}通知公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知公告
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//通知日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}消费记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//消费记录
public class Xfjl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//金额
private Integer fee;
//办卡日期
private Date bkDate;
//负责人
private String fzr;
//事故日期
private String sgrq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getBkDate() {return bkDate;}
public void setBkDate(Date bkDate) {this.bkDate = bkDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getSgrq() {return sgrq;}
public void setSgrq(String sgrq) {this.sgrq = sgrq;}
}游泳馆javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//游泳馆
public class Yyg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//游泳馆信息
private String content;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}