- 乒乓球竞赛系统mysql数据库创建语句
- 乒乓球竞赛系统oracle数据库创建语句
- 乒乓球竞赛系统sqlserver数据库创建语句
- 乒乓球竞赛系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 乒乓球竞赛系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
乒乓球竞赛系统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_bm(
id int primary key auto_increment comment '主键',
bsId int comment '比赛',
autoId int comment '',
insertDate datetime comment '报名日期',
customerId int comment '用户'
) comment '比赛报名';
比赛表创建语句如下:
create table t_bs(
id int primary key auto_increment comment '主键',
far varchar(100) comment '发起人',
bsName varchar(100) comment '比赛名称',
jb varchar(100) comment '级别',
sex varchar(100) comment '性别',
rs varchar(100) comment '人数',
status varchar(100) comment '状态',
customerId int comment ''
) comment '比赛';
比赛流程表创建语句如下:
create table t_bslist(
id int primary key auto_increment comment '主键',
bsId int comment '比赛',
customerId1 int comment '胜利方',
customerId2 int comment '失败方',
bf varchar(100) comment '比分',
showDate datetime comment '比赛日期',
bslc 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
jf int comment '积分',
jb varchar(100) comment '级别'
) comment '用户';
新闻公告表创建语句如下:
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '新闻公告';
积分段位表创建语句如下:
create table t_jfdw(
id int primary key auto_increment comment '主键',
gz varchar(100) comment '积分段位',
dw varchar(100) comment ''
) comment '积分段位';
积分记录表创建语句如下:
create table t_jflog(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '名称',
types varchar(100) comment '加分减分',
jf int comment '积分',
insertDate datetime comment '日期',
jfall int comment ''
) comment '积分记录';
题目表创建语句如下:
create table t_tm(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '题目',
v2 varchar(100) comment '选项1',
v3 varchar(100) comment '选项2',
v4 varchar(100) comment '选项3',
v5 varchar(100) comment '选项4',
v6 varchar(100) comment '答案',
v7 int comment ''
) comment '题目';
通知表创建语句如下:
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '客户经理',
txName varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '通知';
资讯表创建语句如下:
create table t_zx(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
pic 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_bm(
id integer,
bsId int,
autoId int,
insertDate datetime,
customerId int
);
--比赛报名字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bsId is '比赛';
comment on column t_bm.autoId is '';
comment on column t_bm.insertDate is '报名日期';
comment on column t_bm.customerId is '用户';
--比赛报名表加注释
comment on table t_bm is '比赛报名';
比赛表创建语句如下:
create table t_bs(
id integer,
far varchar(100),
bsName varchar(100),
jb varchar(100),
sex varchar(100),
rs varchar(100),
status varchar(100),
customerId int
);
--比赛字段加注释
comment on column t_bs.id is '主键';
comment on column t_bs.far is '发起人';
comment on column t_bs.bsName is '比赛名称';
comment on column t_bs.jb is '级别';
comment on column t_bs.sex is '性别';
comment on column t_bs.rs is '人数';
comment on column t_bs.status is '状态';
comment on column t_bs.customerId is '';
--比赛表加注释
comment on table t_bs is '比赛';
比赛流程表创建语句如下:
create table t_bslist(
id integer,
bsId int,
customerId1 int,
customerId2 int,
bf varchar(100),
showDate datetime,
bslc varchar(100)
);
--比赛流程字段加注释
comment on column t_bslist.id is '主键';
comment on column t_bslist.bsId is '比赛';
comment on column t_bslist.customerId1 is '胜利方';
comment on column t_bslist.customerId2 is '失败方';
comment on column t_bslist.bf is '比分';
comment on column t_bslist.showDate is '比赛日期';
comment on column t_bslist.bslc is '比赛轮次';
--比赛流程表加注释
comment on table t_bslist is '比赛流程';
用户表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
jf int,
jb 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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.jf is '积分';
comment on column t_customer.jb is '级别';
--用户表加注释
comment on table t_customer is '用户';
新闻公告表创建语句如下:
create table t_gg(
id integer,
v1 varchar(100),
showDate datetime,
v3 varchar(100)
);
--新闻公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--新闻公告表加注释
comment on table t_gg is '新闻公告';
积分段位表创建语句如下:
create table t_jfdw(
id integer,
gz varchar(100),
dw varchar(100)
);
--积分段位字段加注释
comment on column t_jfdw.id is '主键';
comment on column t_jfdw.gz is '积分段位';
comment on column t_jfdw.dw is '';
--积分段位表加注释
comment on table t_jfdw is '积分段位';
积分记录表创建语句如下:
create table t_jflog(
id integer,
customerId int,
title varchar(100),
types varchar(100),
jf int,
insertDate datetime,
jfall int
);
--积分记录字段加注释
comment on column t_jflog.id is '主键';
comment on column t_jflog.customerId is '用户';
comment on column t_jflog.title is '名称';
comment on column t_jflog.types is '加分减分';
comment on column t_jflog.jf is '积分';
comment on column t_jflog.insertDate is '日期';
comment on column t_jflog.jfall is '';
--积分记录表加注释
comment on table t_jflog is '积分记录';
题目表创建语句如下:
create table t_tm(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 int
);
--题目字段加注释
comment on column t_tm.id is '主键';
comment on column t_tm.v1 is '题目';
comment on column t_tm.v2 is '选项1';
comment on column t_tm.v3 is '选项2';
comment on column t_tm.v4 is '选项3';
comment on column t_tm.v5 is '选项4';
comment on column t_tm.v6 is '答案';
comment on column t_tm.v7 is '';
--题目表加注释
comment on table t_tm is '题目';
通知表创建语句如下:
create table t_tongzhi(
id integer,
customerId int,
txName varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '客户经理';
comment on column t_tongzhi.txName is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
资讯表创建语句如下:
create table t_zx(
id integer,
title varchar(100),
content varchar(100),
pic varchar(100)
);
--资讯字段加注释
comment on column t_zx.id is '主键';
comment on column t_zx.title is '标题';
comment on column t_zx.content is '内容';
comment on column t_zx.pic is '图片';
--资讯表加注释
comment on table t_zx is '资讯';
oracle特有,对应序列如下:
create sequence s_t_bm;
create sequence s_t_bs;
create sequence s_t_bslist;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_jfdw;
create sequence s_t_jflog;
create sequence s_t_tm;
create sequence s_t_tongzhi;
create sequence s_t_zx;
乒乓球竞赛系统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_bm(
id int identity(1,1) primary key not null,--主键
bsId int,--比赛
autoId int,--
insertDate datetime,--报名日期
customerId int--用户
);
比赛表创建语句如下:
--比赛表注释
create table t_bs(
id int identity(1,1) primary key not null,--主键
far varchar(100),--发起人
bsName varchar(100),--比赛名称
jb varchar(100),--级别
sex varchar(100),--性别
rs varchar(100),--人数
status varchar(100),--状态
customerId int--
);
比赛流程表创建语句如下:
--比赛流程表注释
create table t_bslist(
id int identity(1,1) primary key not null,--主键
bsId int,--比赛
customerId1 int,--胜利方
customerId2 int,--失败方
bf varchar(100),--比分
showDate datetime,--比赛日期
bslc varchar(100)--比赛轮次
);
用户表创建语句如下:
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
jf int,--积分
jb varchar(100)--级别
);
新闻公告表创建语句如下:
--新闻公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
showDate datetime,--日期
v3 varchar(100)--内容
);
积分段位表创建语句如下:
--积分段位表注释
create table t_jfdw(
id int identity(1,1) primary key not null,--主键
gz varchar(100),--积分段位
dw varchar(100)--
);
积分记录表创建语句如下:
--积分记录表注释
create table t_jflog(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--名称
types varchar(100),--加分减分
jf int,--积分
insertDate datetime,--日期
jfall int--
);
题目表创建语句如下:
--题目表注释
create table t_tm(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--题目
v2 varchar(100),--选项1
v3 varchar(100),--选项2
v4 varchar(100),--选项3
v5 varchar(100),--选项4
v6 varchar(100),--答案
v7 int--
);
通知表创建语句如下:
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--客户经理
txName varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
资讯表创建语句如下:
--资讯表注释
create table t_zx(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content varchar(100),--内容
pic 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_bm")
public class Bm {
//主键
@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 autoId;
//报名日期
private Date insertDate;
//用户
private Integer customerId;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public Integer getAutoId() {return autoId;}
public void setAutoId(Integer autoId) {this.autoId = autoId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}
比赛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 far;
//比赛名称
private String bsName;
//级别
private String jb;
//性别
private String sex;
//人数
private String rs;
//状态
private String status;
//
private Integer customerId;
public String getFar() {return far;}
public void setFar(String far) {this.far = far;}
public String getBsName() {return bsName;}
public void setBsName(String bsName) {this.bsName = bsName;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}
比赛流程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 customerId1;
//失败方
private Integer customerId2;
//比分
private String bf;
//比赛日期
private Date showDate;
//比赛轮次
private String bslc;
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 String getBf() {return bf;}
public void setBf(String bf) {this.bf = bf;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getBslc() {return bslc;}
public void setBslc(String bslc) {this.bslc = bslc;}
}
用户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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//积分
private Integer jf;
//级别
private String jb;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
}
新闻公告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_gg")
public class Gg {
//主键
@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 v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}
积分段位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_jfdw")
public class Jfdw {
//主键
@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 gz;
//
private String dw;
public String getGz() {return gz;}
public void setGz(String gz) {this.gz = gz;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
}
积分记录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_jflog")
public class Jflog {
//主键
@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 title;
//加分减分
private String types;
//积分
private Integer jf;
//日期
private Date insertDate;
//
private Integer jfall;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getJfall() {return jfall;}
public void setJfall(Integer jfall) {this.jfall = jfall;}
}
题目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_tm")
public class Tm {
//主键
@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 v1;
//选项1
private String v2;
//选项2
private String v3;
//选项3
private String v4;
//选项4
private String v5;
//答案
private String v6;
//
private Integer v7;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public Integer getV7() {return v7;}
public void setV7(Integer v7) {this.v7 = v7;}
}
通知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 Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_zx")
public class Zx {
//主键
@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;
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;}
}
乒乓球竞赛系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
比赛报名javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//比赛报名
public class Bm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//比赛
private Integer bsId;
//
private Integer autoId;
//报名日期
private Date insertDate;
//用户
private Integer customerId;
public Integer getBsId() {return bsId;}
public void setBsId(Integer bsId) {this.bsId = bsId;}
public Integer getAutoId() {return autoId;}
public void setAutoId(Integer autoId) {this.autoId = autoId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}
比赛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 far;
//比赛名称
private String bsName;
//级别
private String jb;
//性别
private String sex;
//人数
private String rs;
//状态
private String status;
//
private Integer customerId;
public String getFar() {return far;}
public void setFar(String far) {this.far = far;}
public String getBsName() {return bsName;}
public void setBsName(String bsName) {this.bsName = bsName;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}
比赛流程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 customerId1;
//失败方
private Integer customerId2;
//比分
private String bf;
//比赛日期
private Date showDate;
//比赛轮次
private String bslc;
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 String getBf() {return bf;}
public void setBf(String bf) {this.bf = bf;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getBslc() {return bslc;}
public void setBslc(String bslc) {this.bslc = bslc;}
}
用户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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//积分
private Integer jf;
//级别
private String jb;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
}
新闻公告javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//新闻公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}
积分段位javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//积分段位
public class Jfdw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//积分段位
private String gz;
//
private String dw;
public String getGz() {return gz;}
public void setGz(String gz) {this.gz = gz;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
}
积分记录javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//积分记录
public class Jflog extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//名称
private String title;
//加分减分
private String types;
//积分
private Integer jf;
//日期
private Date insertDate;
//
private Integer jfall;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getJfall() {return jfall;}
public void setJfall(Integer jfall) {this.jfall = jfall;}
}
题目javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//题目
public class Tm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private String v1;
//选项1
private String v2;
//选项2
private String v3;
//选项3
private String v4;
//选项4
private String v5;
//答案
private String v6;
//
private Integer v7;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public Integer getV7() {return v7;}
public void setV7(Integer v7) {this.v7 = v7;}
}
通知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 Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Zx 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;
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;}
}