更多成品,定做java毕业设计,请咨询管理员qq:2812491287

基于web的游泳馆管理系统的设计与实现

基于web的游泳馆管理系统的设计与实现登录注册界面

基于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)--游泳馆信息
);

基于web的游泳馆管理系统的设计与实现登录后主页

基于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;}
}

评论