- 大学运动会信息管理系统mysql数据库创建语句
- 大学运动会信息管理系统oracle数据库创建语句
- 大学运动会信息管理系统sqlserver数据库创建语句
- 大学运动会信息管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 大学运动会信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
大学运动会信息管理系统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_bs(
id int primary key auto_increment comment '主键',
bsName varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
bsrq varchar(100) comment '比赛日期',
status varchar(100) comment '',
types varchar(100) comment '普通@分组'
) comment '比赛';
比赛规则表创建语句如下：
create table t_bsgz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
showDate varchar(100) comment '日期'
) comment '比赛规则';
比赛记录表创建语句如下：
create table t_bslist(
id int primary key auto_increment comment '主键',
bsId int comment '比赛',
customerId int comment '用户',
cj int comment '成绩',
insertDate datetime comment '申请日期',
isJl varchar(100) comment '是否是记录',
isfs varchar(100) comment '是否复赛',
fscj int comment '复赛成绩',
istd varchar(100) comment '是否团队比赛',
tdbh varchar(100) comment '团队编号'
) comment '比赛记录';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
phone varchar(100) comment '手机',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
address varchar(100) comment '家庭住址',
idcard varchar(100) comment '身份证',
insertDate datetime comment '入库日期',
headPic varchar(100) comment '头像',
mb1 varchar(100) comment '密保1',
mb2 varchar(100) comment '密保2',
mb3 varchar(100) comment '密保3',
js varchar(100) comment '角色'
) comment '用户';
分组比赛表创建语句如下：
create table t_tdbs(
id int primary key auto_increment comment '主键',
bsId int comment '比赛',
customerId1 int comment '用户一',
customerId2 int comment '用户二',
customerId3 int comment '用户三',
customerId4 int comment '用户四',
cj1 int comment '初赛成绩一',
cj2 int comment '初赛成绩二',
cj3 int comment '初赛成绩三',
cj4 int comment '初赛成绩四',
isFs varchar(100) comment '是否复赛',
fscj1 int comment '复赛成绩一',
fscj2 int comment '复赛成绩二',
fscj3 int comment '复赛成绩三',
fscj4 int comment '复赛成绩四'
) comment '分组比赛';
校记录表创建语句如下：
create table t_xjl(
id int primary key auto_increment comment '主键',
bsId int comment '比赛',
xm varchar(100) comment '姓名',
cj int comment '成绩',
bsDate varchar(100) comment '比赛日期',
remark 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_bs(
id integer,
bsName varchar(100),
pic varchar(100),
content varchar(100),
bsrq varchar(100),
status varchar(100),
types varchar(100)
);
--比赛字段加注释
comment on column t_bs.id is '主键';
comment on column t_bs.bsName is '标题';
comment on column t_bs.pic is '图片';
comment on column t_bs.content is '内容';
comment on column t_bs.bsrq is '比赛日期';
comment on column t_bs.status is '';
comment on column t_bs.types is '普通@分组';
--比赛表加注释
comment on table t_bs is '比赛';
比赛规则表创建语句如下：
create table t_bsgz(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate varchar(100)
);
--比赛规则字段加注释
comment on column t_bsgz.id is '主键';
comment on column t_bsgz.title is '标题';
comment on column t_bsgz.pic is '图片';
comment on column t_bsgz.content is '内容';
comment on column t_bsgz.showDate is '日期';
--比赛规则表加注释
comment on table t_bsgz is '比赛规则';
比赛记录表创建语句如下：
create table t_bslist(
id integer,
bsId int,
customerId int,
cj int,
insertDate datetime,
isJl varchar(100),
isfs varchar(100),
fscj int,
istd varchar(100),
tdbh varchar(100)
);
--比赛记录字段加注释
comment on column t_bslist.id is '主键';
comment on column t_bslist.bsId is '比赛';
comment on column t_bslist.customerId is '用户';
comment on column t_bslist.cj is '成绩';
comment on column t_bslist.insertDate is '申请日期';
comment on column t_bslist.isJl is '是否是记录';
comment on column t_bslist.isfs is '是否复赛';
comment on column t_bslist.fscj is '复赛成绩';
comment on column t_bslist.istd is '是否团队比赛';
comment on column t_bslist.tdbh is '团队编号';
--比赛记录表加注释
comment on table t_bslist is '比赛记录';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
phone varchar(100),
sex varchar(100),
age varchar(100),
address varchar(100),
idcard varchar(100),
insertDate datetime,
headPic varchar(100),
mb1 varchar(100),
mb2 varchar(100),
mb3 varchar(100),
js 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.name is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '家庭住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
comment on column t_customer.headPic is '头像';
comment on column t_customer.mb1 is '密保1';
comment on column t_customer.mb2 is '密保2';
comment on column t_customer.mb3 is '密保3';
comment on column t_customer.js is '角色';
--用户表加注释
comment on table t_customer is '用户';
分组比赛表创建语句如下：
create table t_tdbs(
id integer,
bsId int,
customerId1 int,
customerId2 int,
customerId3 int,
customerId4 int,
cj1 int,
cj2 int,
cj3 int,
cj4 int,
isFs varchar(100),
fscj1 int,
fscj2 int,
fscj3 int,
fscj4 int
);
--分组比赛字段加注释
comment on column t_tdbs.id is '主键';
comment on column t_tdbs.bsId is '比赛';
comment on column t_tdbs.customerId1 is '用户一';
comment on column t_tdbs.customerId2 is '用户二';
comment on column t_tdbs.customerId3 is '用户三';
comment on column t_tdbs.customerId4 is '用户四';
comment on column t_tdbs.cj1 is '初赛成绩一';
comment on column t_tdbs.cj2 is '初赛成绩二';
comment on column t_tdbs.cj3 is '初赛成绩三';
comment on column t_tdbs.cj4 is '初赛成绩四';
comment on column t_tdbs.isFs is '是否复赛';
comment on column t_tdbs.fscj1 is '复赛成绩一';
comment on column t_tdbs.fscj2 is '复赛成绩二';
comment on column t_tdbs.fscj3 is '复赛成绩三';
comment on column t_tdbs.fscj4 is '复赛成绩四';
--分组比赛表加注释
comment on table t_tdbs is '分组比赛';
校记录表创建语句如下：
create table t_xjl(
id integer,
bsId int,
xm varchar(100),
cj int,
bsDate varchar(100),
remark varchar(100)
);
--校记录字段加注释
comment on column t_xjl.id is '主键';
comment on column t_xjl.bsId is '比赛';
comment on column t_xjl.xm is '姓名';
comment on column t_xjl.cj is '成绩';
comment on column t_xjl.bsDate is '比赛日期';
comment on column t_xjl.remark is '备注';
--校记录表加注释
comment on table t_xjl is '校记录';
oracle特有，对应序列如下：
create sequence s_t_bs;
create sequence s_t_bsgz;
create sequence s_t_bslist;
create sequence s_t_customer;
create sequence s_t_tdbs;
create sequence s_t_xjl;
大学运动会信息管理系统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_bs(
id int identity(1,1) primary key not null,--主键
bsName varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
bsrq varchar(100),--比赛日期
status varchar(100),--
types varchar(100)--普通@分组
);
比赛规则表创建语句如下：
--比赛规则表注释
create table t_bsgz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
showDate varchar(100)--日期
);
比赛记录表创建语句如下：
--比赛记录表注释
create table t_bslist(
id int identity(1,1) primary key not null,--主键
bsId int,--比赛
customerId int,--用户
cj int,--成绩
insertDate datetime,--申请日期
isJl varchar(100),--是否是记录
isfs varchar(100),--是否复赛
fscj int,--复赛成绩
istd varchar(100),--是否团队比赛
tdbh varchar(100)--团队编号
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
name varchar(100),--姓名
phone varchar(100),--手机
sex varchar(100),--性别
age varchar(100),--年龄
address varchar(100),--家庭住址
idcard varchar(100),--身份证
insertDate datetime,--入库日期
headPic varchar(100),--头像
mb1 varchar(100),--密保1
mb2 varchar(100),--密保2
mb3 varchar(100),--密保3
js varchar(100)--角色
);
分组比赛表创建语句如下：
--分组比赛表注释
create table t_tdbs(
id int identity(1,1) primary key not null,--主键
bsId int,--比赛
customerId1 int,--用户一
customerId2 int,--用户二
customerId3 int,--用户三
customerId4 int,--用户四
cj1 int,--初赛成绩一
cj2 int,--初赛成绩二
cj3 int,--初赛成绩三
cj4 int,--初赛成绩四
isFs varchar(100),--是否复赛
fscj1 int,--复赛成绩一
fscj2 int,--复赛成绩二
fscj3 int,--复赛成绩三
fscj4 int--复赛成绩四
);
校记录表创建语句如下：
--校记录表注释
create table t_xjl(
id int identity(1,1) primary key not null,--主键
bsId int,--比赛
xm varchar(100),--姓名
cj int,--成绩
bsDate varchar(100),--比赛日期
remark varchar(100)--备注
);
登录后主页.jpg?x-oss-process=style/00001)
大学运动会信息管理系统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_bs")
public class Bs {
//主键
@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 bsName;
//图片
private String pic;
//内容
private String content;
//比赛日期
private String bsrq;
//
private String status;
//普通@分组
private String types;
public String getBsName() {return bsName;}
public void setBsName(String bsName) {this.bsName = bsName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBsrq() {return bsrq;}
public void setBsrq(String bsrq) {this.bsrq = bsrq;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}比赛规则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_bsgz")
public class Bsgz {
//主键
@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 pic;
//内容
private String content;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_bslist")
public class Bslist {
//主键
@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 bsId;
//用户
private Integer customerId;
//成绩
private Integer cj;
//申请日期
private Date insertDate;
//是否是记录
private String isJl;
//是否复赛
private String isfs;
//复赛成绩
private Integer fscj;
//是否团队比赛
private String istd;
//团队编号
private String tdbh;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getIsJl() {return isJl;}
public void setIsJl(String isJl) {this.isJl = isJl;}
public String getIsfs() {return isfs;}
public void setIsfs(String isfs) {this.isfs = isfs;}
public Integer getFscj() {return fscj;}
public void setFscj(Integer fscj) {this.fscj = fscj;}
public String getIstd() {return istd;}
public void setIstd(String istd) {this.istd = istd;}
public String getTdbh() {return tdbh;}
public void setTdbh(String tdbh) {this.tdbh = tdbh;}
}用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
//角色
private String js;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}分组比赛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_tdbs")
public class Tdbs {
//主键
@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 bsId;
//用户一
private Integer customerId1;
//用户二
private Integer customerId2;
//用户三
private Integer customerId3;
//用户四
private Integer customerId4;
//初赛成绩一
private Integer cj1;
//初赛成绩二
private Integer cj2;
//初赛成绩三
private Integer cj3;
//初赛成绩四
private Integer cj4;
//是否复赛
private String isFs;
//复赛成绩一
private Integer fscj1;
//复赛成绩二
private Integer fscj2;
//复赛成绩三
private Integer fscj3;
//复赛成绩四
private Integer fscj4;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public Integer getCustomerId1() {return customerId1;}
public void setCustomerId1(Integer customerId1) {this.customerId1 = customerId1;}
public Integer getCustomerId2() {return customerId2;}
public void setCustomerId2(Integer customerId2) {this.customerId2 = customerId2;}
public Integer getCustomerId3() {return customerId3;}
public void setCustomerId3(Integer customerId3) {this.customerId3 = customerId3;}
public Integer getCustomerId4() {return customerId4;}
public void setCustomerId4(Integer customerId4) {this.customerId4 = customerId4;}
public Integer getCj1() {return cj1;}
public void setCj1(Integer cj1) {this.cj1 = cj1;}
public Integer getCj2() {return cj2;}
public void setCj2(Integer cj2) {this.cj2 = cj2;}
public Integer getCj3() {return cj3;}
public void setCj3(Integer cj3) {this.cj3 = cj3;}
public Integer getCj4() {return cj4;}
public void setCj4(Integer cj4) {this.cj4 = cj4;}
public String getIsFs() {return isFs;}
public void setIsFs(String isFs) {this.isFs = isFs;}
public Integer getFscj1() {return fscj1;}
public void setFscj1(Integer fscj1) {this.fscj1 = fscj1;}
public Integer getFscj2() {return fscj2;}
public void setFscj2(Integer fscj2) {this.fscj2 = fscj2;}
public Integer getFscj3() {return fscj3;}
public void setFscj3(Integer fscj3) {this.fscj3 = fscj3;}
public Integer getFscj4() {return fscj4;}
public void setFscj4(Integer fscj4) {this.fscj4 = fscj4;}
}校记录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_xjl")
public class Xjl {
//主键
@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 bsId;
//姓名
private String xm;
//成绩
private Integer cj;
//比赛日期
private String bsDate;
//备注
private String remark;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getBsDate() {return bsDate;}
public void setBsDate(String bsDate) {this.bsDate = bsDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}大学运动会信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
比赛javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//比赛
public class Bs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String bsName;
//图片
private String pic;
//内容
private String content;
//比赛日期
private String bsrq;
//
private String status;
//普通@分组
private String types;
public String getBsName() {return bsName;}
public void setBsName(String bsName) {this.bsName = bsName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBsrq() {return bsrq;}
public void setBsrq(String bsrq) {this.bsrq = bsrq;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}比赛规则javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//比赛规则
public class Bsgz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Bslist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//比赛
private Integer bsId;
//用户
private Integer customerId;
//成绩
private Integer cj;
//申请日期
private Date insertDate;
//是否是记录
private String isJl;
//是否复赛
private String isfs;
//复赛成绩
private Integer fscj;
//是否团队比赛
private String istd;
//团队编号
private String tdbh;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getIsJl() {return isJl;}
public void setIsJl(String isJl) {this.isJl = isJl;}
public String getIsfs() {return isfs;}
public void setIsfs(String isfs) {this.isfs = isfs;}
public Integer getFscj() {return fscj;}
public void setFscj(Integer fscj) {this.fscj = fscj;}
public String getIstd() {return istd;}
public void setIstd(String istd) {this.istd = istd;}
public String getTdbh() {return tdbh;}
public void setTdbh(String tdbh) {this.tdbh = tdbh;}
}用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
//角色
private String js;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}分组比赛javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//分组比赛
public class Tdbs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//比赛
private Integer bsId;
//用户一
private Integer customerId1;
//用户二
private Integer customerId2;
//用户三
private Integer customerId3;
//用户四
private Integer customerId4;
//初赛成绩一
private Integer cj1;
//初赛成绩二
private Integer cj2;
//初赛成绩三
private Integer cj3;
//初赛成绩四
private Integer cj4;
//是否复赛
private String isFs;
//复赛成绩一
private Integer fscj1;
//复赛成绩二
private Integer fscj2;
//复赛成绩三
private Integer fscj3;
//复赛成绩四
private Integer fscj4;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public Integer getCustomerId1() {return customerId1;}
public void setCustomerId1(Integer customerId1) {this.customerId1 = customerId1;}
public Integer getCustomerId2() {return customerId2;}
public void setCustomerId2(Integer customerId2) {this.customerId2 = customerId2;}
public Integer getCustomerId3() {return customerId3;}
public void setCustomerId3(Integer customerId3) {this.customerId3 = customerId3;}
public Integer getCustomerId4() {return customerId4;}
public void setCustomerId4(Integer customerId4) {this.customerId4 = customerId4;}
public Integer getCj1() {return cj1;}
public void setCj1(Integer cj1) {this.cj1 = cj1;}
public Integer getCj2() {return cj2;}
public void setCj2(Integer cj2) {this.cj2 = cj2;}
public Integer getCj3() {return cj3;}
public void setCj3(Integer cj3) {this.cj3 = cj3;}
public Integer getCj4() {return cj4;}
public void setCj4(Integer cj4) {this.cj4 = cj4;}
public String getIsFs() {return isFs;}
public void setIsFs(String isFs) {this.isFs = isFs;}
public Integer getFscj1() {return fscj1;}
public void setFscj1(Integer fscj1) {this.fscj1 = fscj1;}
public Integer getFscj2() {return fscj2;}
public void setFscj2(Integer fscj2) {this.fscj2 = fscj2;}
public Integer getFscj3() {return fscj3;}
public void setFscj3(Integer fscj3) {this.fscj3 = fscj3;}
public Integer getFscj4() {return fscj4;}
public void setFscj4(Integer fscj4) {this.fscj4 = fscj4;}
}校记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//校记录
public class Xjl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//比赛
private Integer bsId;
//姓名
private String xm;
//成绩
private Integer cj;
//比赛日期
private String bsDate;
//备注
private String remark;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getBsDate() {return bsDate;}
public void setBsDate(String bsDate) {this.bsDate = bsDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}