羽毛球运动场管理系统

羽毛球运动场管理系统登录注册界面

羽毛球运动场管理系统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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	pic varchar(100) comment '图片',
	levels varchar(100) comment '等级',
	ye int comment '余额'
) comment '会员';

充值记录表创建语句如下:


create table t_cz(
	id int primary key auto_increment comment '主键',
	customerId int comment '会员',
	je int comment '充值金额',
	insertDate datetime comment '日期'
) comment '充值记录';

计费表创建语句如下:


create table t_jf(
	id int primary key auto_increment comment '主键',
	types varchar(100) comment '类型',
	customerId int comment '会员',
	je int comment '金额',
	beginDate datetime comment '开始时间',
	endDate datetime comment '结束时间',
	zje int comment '',
	zffs varchar(100) comment '支付方式',
	qcId int comment ''
) comment '计费';

球场表创建语句如下:


create table t_qc(
	id int primary key auto_increment comment '主键',
	qcbh varchar(100) comment '球场编号',
	qcszt varchar(100) comment '球场所在厅',
	status varchar(100) comment '球场状态'
) comment '球场';

器材售卖表创建语句如下:


create table t_qcsm(
	id int primary key auto_increment comment '主键',
	types varchar(100) comment '类型',
	je int comment '金额',
	zffs varchar(100) comment '支付方式'
) comment '器材售卖';

羽毛球运动场管理系统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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	idcard varchar(100),
	pic varchar(100),
	levels varchar(100),
	ye int
);
--会员字段加注释
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.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.phone is '电话';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.pic is '图片';
comment on column t_customer.levels is '等级';
comment on column t_customer.ye is '余额';
--会员表加注释
comment on table t_customer is '会员';

充值记录表创建语句如下:


create table t_cz(
	id integer,
	customerId int,
	je int,
	insertDate datetime
);
--充值记录字段加注释
comment on column t_cz.id is '主键';
comment on column t_cz.customerId is '会员';
comment on column t_cz.je is '充值金额';
comment on column t_cz.insertDate is '日期';
--充值记录表加注释
comment on table t_cz is '充值记录';

计费表创建语句如下:


create table t_jf(
	id integer,
	types varchar(100),
	customerId int,
	je int,
	beginDate datetime,
	endDate datetime,
	zje int,
	zffs varchar(100),
	qcId int
);
--计费字段加注释
comment on column t_jf.id is '主键';
comment on column t_jf.types is '类型';
comment on column t_jf.customerId is '会员';
comment on column t_jf.je is '金额';
comment on column t_jf.beginDate is '开始时间';
comment on column t_jf.endDate is '结束时间';
comment on column t_jf.zje is '';
comment on column t_jf.zffs is '支付方式';
comment on column t_jf.qcId is '';
--计费表加注释
comment on table t_jf is '计费';

球场表创建语句如下:


create table t_qc(
	id integer,
	qcbh varchar(100),
	qcszt varchar(100),
	status varchar(100)
);
--球场字段加注释
comment on column t_qc.id is '主键';
comment on column t_qc.qcbh is '球场编号';
comment on column t_qc.qcszt is '球场所在厅';
comment on column t_qc.status is '球场状态';
--球场表加注释
comment on table t_qc is '球场';

器材售卖表创建语句如下:


create table t_qcsm(
	id integer,
	types varchar(100),
	je int,
	zffs varchar(100)
);
--器材售卖字段加注释
comment on column t_qcsm.id is '主键';
comment on column t_qcsm.types is '类型';
comment on column t_qcsm.je is '金额';
comment on column t_qcsm.zffs is '支付方式';
--器材售卖表加注释
comment on table t_qcsm is '器材售卖';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_cz;
create sequence s_t_jf;
create sequence s_t_qc;
create sequence s_t_qcsm;

羽毛球运动场管理系统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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	pic varchar(100),--图片
	levels varchar(100),--等级
	ye int--余额
);

充值记录表创建语句如下:


--充值记录表注释
create table t_cz(
	id int identity(1,1) primary key not null,--主键
	customerId int,--会员
	je int,--充值金额
	insertDate datetime--日期
);

计费表创建语句如下:


--计费表注释
create table t_jf(
	id int identity(1,1) primary key not null,--主键
	types varchar(100),--类型
	customerId int,--会员
	je int,--金额
	beginDate datetime,--开始时间
	endDate datetime,--结束时间
	zje int,--
	zffs varchar(100),--支付方式
	qcId int--
);

球场表创建语句如下:


--球场表注释
create table t_qc(
	id int identity(1,1) primary key not null,--主键
	qcbh varchar(100),--球场编号
	qcszt varchar(100),--球场所在厅
	status varchar(100)--球场状态
);

器材售卖表创建语句如下:


--器材售卖表注释
create table t_qcsm(
	id int identity(1,1) primary key not null,--主键
	types varchar(100),--类型
	je int,--金额
	zffs varchar(100)--支付方式
);

羽毛球运动场管理系统登录后主页

羽毛球运动场管理系统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_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 sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
//图片
private String pic;
//等级
private String levels;
//余额
private Integer ye;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getLevels() {return levels;}
public void setLevels(String levels) {this.levels = levels;}
public Integer getYe() {return ye;}
public void setYe(Integer ye) {this.ye = ye;}
}

充值记录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_cz")
public class Cz {
//主键
@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 Integer je;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

计费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_jf")
public class Jf {
//主键
@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 types;
//会员
private Integer customerId;
//金额
private Integer je;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//
private Integer zje;
//支付方式
private String zffs;
//
private Integer qcId;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
public String getZffs() {return zffs;}
public void setZffs(String zffs) {this.zffs = zffs;}
public Integer getQcId() {return qcId;}
public void setQcId(Integer qcId) {this.qcId = qcId;}
}

球场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_qc")
public class Qc {
//主键
@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 qcbh;
//球场所在厅
private String qcszt;
//球场状态
private String status;
public String getQcbh() {return qcbh;}
public void setQcbh(String qcbh) {this.qcbh = qcbh;}
public String getQcszt() {return qcszt;}
public void setQcszt(String qcszt) {this.qcszt = qcszt;}
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_qcsm")
public class Qcsm {
//主键
@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 types;
//金额
private Integer je;
//支付方式
private String zffs;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public String getZffs() {return zffs;}
public void setZffs(String zffs) {this.zffs = zffs;}
}

羽毛球运动场管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

会员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 sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
//图片
private String pic;
//等级
private String levels;
//余额
private Integer ye;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getLevels() {return levels;}
public void setLevels(String levels) {this.levels = levels;}
public Integer getYe() {return ye;}
public void setYe(Integer ye) {this.ye = ye;}
}

充值记录javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//充值记录
public class Cz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会员
private Integer customerId;
//充值金额
private Integer je;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

计费javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//计费
public class Jf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//会员
private Integer customerId;
//金额
private Integer je;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//
private Integer zje;
//支付方式
private String zffs;
//
private Integer qcId;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
public String getZffs() {return zffs;}
public void setZffs(String zffs) {this.zffs = zffs;}
public Integer getQcId() {return qcId;}
public void setQcId(Integer qcId) {this.qcId = qcId;}
}

球场javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//球场
public class Qc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//球场编号
private String qcbh;
//球场所在厅
private String qcszt;
//球场状态
private String status;
public String getQcbh() {return qcbh;}
public void setQcbh(String qcbh) {this.qcbh = qcbh;}
public String getQcszt() {return qcszt;}
public void setQcszt(String qcszt) {this.qcszt = qcszt;}
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 Qcsm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//金额
private Integer je;
//支付方式
private String zffs;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public String getZffs() {return zffs;}
public void setZffs(String zffs) {this.zffs = zffs;}
}

源代码下载点这里

评论