基于web的游泳馆管理系统的java毕业设计登录
基于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的游泳馆管理系统的java毕业设计列表
基于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;}}JavaCopy
教练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;}}JavaCopy
培训班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;}}
扫一扫
2262
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
