- 太原科技大学体育场维护与管理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_cg(
id int primary key auto_increment comment '主键',
cgName varchar(100) comment '场馆名称',
pic varchar(100) comment '图片',
wz varchar(100) comment '场馆位置',
xm varchar(100) comment '场馆项目',
rs int comment '场馆最多人数',
status varchar(100) comment '状态'
) comment '场馆';
场馆器材表创建语句如下：
create table t_cgqc(
id int primary key auto_increment comment '主键',
cgqcName varchar(100) comment '场馆器材',
sl int comment '数量',
pic varchar(100) comment '图片'
) comment '场馆器材';
场馆器材预借表创建语句如下：
create table t_cgqcyy(
id int primary key auto_increment comment '主键',
cgqcId int comment '场馆器材',
customerId int comment '用户',
showDate datetime comment '预借日期',
title varchar(100) comment '预借说明',
yjsl int 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '用户';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
showDate datetime comment '公告日期',
pic varchar(100) comment '图片',
content varchar(100) comment '公告内容'
) comment '公告';
维修管理员表创建语句如下：
create table t_wxadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
wxadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '维修管理员';
维修记录表创建语句如下：
create table t_wxjl(
id int primary key auto_increment comment '主键',
wxjlName varchar(100) comment '维修记录说明',
showDate datetime comment '维修日期',
content varchar(100) comment '详细维修说明',
wxr varchar(100) comment '维修人',
phone varchar(100) comment '电话'
) comment '维修记录';
维修申报表创建语句如下：
create table t_wxsb(
id int primary key auto_increment comment '主键',
cgId int comment '场馆',
wxxm varchar(100) comment '维修项目',
customerId int comment '用户',
insertDate datetime comment '申报日期',
title varchar(100) comment '维修说明',
status varchar(100) comment '状态',
back varchar(100) comment '审核回复'
) comment '维修申报';
消息表创建语句如下：
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
content varchar(100) comment '消息内容',
insertDate datetime comment '发送日期'
) comment '消息';
场馆预约表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
cgId int comment '场馆',
customerId int comment '用户',
showDate datetime comment '预约日期',
title varchar(100) comment '预约说明',
status varchar(100) comment '状态',
back 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_cg(
id integer,
cgName varchar(100),
pic varchar(100),
wz varchar(100),
xm varchar(100),
rs int,
status varchar(100)
);
--场馆字段加注释
comment on column t_cg.id is '主键';
comment on column t_cg.cgName is '场馆名称';
comment on column t_cg.pic is '图片';
comment on column t_cg.wz is '场馆位置';
comment on column t_cg.xm is '场馆项目';
comment on column t_cg.rs is '场馆最多人数';
comment on column t_cg.status is '状态';
--场馆表加注释
comment on table t_cg is '场馆';
场馆器材表创建语句如下：
create table t_cgqc(
id integer,
cgqcName varchar(100),
sl int,
pic varchar(100)
);
--场馆器材字段加注释
comment on column t_cgqc.id is '主键';
comment on column t_cgqc.cgqcName is '场馆器材';
comment on column t_cgqc.sl is '数量';
comment on column t_cgqc.pic is '图片';
--场馆器材表加注释
comment on table t_cgqc is '场馆器材';
场馆器材预借表创建语句如下：
create table t_cgqcyy(
id integer,
cgqcId int,
customerId int,
showDate datetime,
title varchar(100),
yjsl int,
status varchar(100)
);
--场馆器材预借字段加注释
comment on column t_cgqcyy.id is '主键';
comment on column t_cgqcyy.cgqcId is '场馆器材';
comment on column t_cgqcyy.customerId is '用户';
comment on column t_cgqcyy.showDate is '预借日期';
comment on column t_cgqcyy.title is '预借说明';
comment on column t_cgqcyy.yjsl is '预借数量';
comment on column t_cgqcyy.status is '状态';
--场馆器材预借表加注释
comment on table t_cgqcyy 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)
);
--用户字段加注释
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 table t_customer is '用户';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
showDate datetime,
pic varchar(100),
content varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.showDate is '公告日期';
comment on column t_gg.pic is '图片';
comment on column t_gg.content is '公告内容';
--公告表加注释
comment on table t_gg is '公告';
维修管理员表创建语句如下：
create table t_wxadmin(
id integer,
username varchar(100),
password varchar(100),
wxadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--维修管理员字段加注释
comment on column t_wxadmin.id is '主键';
comment on column t_wxadmin.username is '账号';
comment on column t_wxadmin.password is '密码';
comment on column t_wxadmin.wxadminName is '姓名';
comment on column t_wxadmin.phone is '电话';
comment on column t_wxadmin.age is '年龄';
comment on column t_wxadmin.sex is '性别';
--维修管理员表加注释
comment on table t_wxadmin is '维修管理员';
维修记录表创建语句如下：
create table t_wxjl(
id integer,
wxjlName varchar(100),
showDate datetime,
content varchar(100),
wxr varchar(100),
phone varchar(100)
);
--维修记录字段加注释
comment on column t_wxjl.id is '主键';
comment on column t_wxjl.wxjlName is '维修记录说明';
comment on column t_wxjl.showDate is '维修日期';
comment on column t_wxjl.content is '详细维修说明';
comment on column t_wxjl.wxr is '维修人';
comment on column t_wxjl.phone is '电话';
--维修记录表加注释
comment on table t_wxjl is '维修记录';
维修申报表创建语句如下：
create table t_wxsb(
id integer,
cgId int,
wxxm varchar(100),
customerId int,
insertDate datetime,
title varchar(100),
status varchar(100),
back varchar(100)
);
--维修申报字段加注释
comment on column t_wxsb.id is '主键';
comment on column t_wxsb.cgId is '场馆';
comment on column t_wxsb.wxxm is '维修项目';
comment on column t_wxsb.customerId is '用户';
comment on column t_wxsb.insertDate is '申报日期';
comment on column t_wxsb.title is '维修说明';
comment on column t_wxsb.status is '状态';
comment on column t_wxsb.back is '审核回复';
--维修申报表加注释
comment on table t_wxsb is '维修申报';
消息表创建语句如下：
create table t_xiaoxi(
id integer,
customerId int,
title varchar(100),
content varchar(100),
insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '用户';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.content is '消息内容';
comment on column t_xiaoxi.insertDate is '发送日期';
--消息表加注释
comment on table t_xiaoxi is '消息';
场馆预约表创建语句如下：
create table t_yy(
id integer,
cgId int,
customerId int,
showDate datetime,
title varchar(100),
status varchar(100),
back varchar(100)
);
--场馆预约字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.cgId is '场馆';
comment on column t_yy.customerId is '用户';
comment on column t_yy.showDate is '预约日期';
comment on column t_yy.title is '预约说明';
comment on column t_yy.status is '状态';
comment on column t_yy.back is '审核回复';
--场馆预约表加注释
comment on table t_yy is '场馆预约';
oracle特有，对应序列如下：
create sequence s_t_cg;
create sequence s_t_cgqc;
create sequence s_t_cgqcyy;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_wxadmin;
create sequence s_t_wxjl;
create sequence s_t_wxsb;
create sequence s_t_xiaoxi;
create sequence s_t_yy;
太原科技大学体育场维护与管理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_cg(
id int identity(1,1) primary key not null,--主键
cgName varchar(100),--场馆名称
pic varchar(100),--图片
wz varchar(100),--场馆位置
xm varchar(100),--场馆项目
rs int,--场馆最多人数
status varchar(100)--状态
);
场馆器材表创建语句如下：
--场馆器材表注释
create table t_cgqc(
id int identity(1,1) primary key not null,--主键
cgqcName varchar(100),--场馆器材
sl int,--数量
pic varchar(100)--图片
);
场馆器材预借表创建语句如下：
--场馆器材预借表注释
create table t_cgqcyy(
id int identity(1,1) primary key not null,--主键
cgqcId int,--场馆器材
customerId int,--用户
showDate datetime,--预借日期
title varchar(100),--预借说明
yjsl int,--预借数量
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),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
showDate datetime,--公告日期
pic varchar(100),--图片
content varchar(100)--公告内容
);
维修管理员表创建语句如下：
--维修管理员表注释
create table t_wxadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
wxadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
维修记录表创建语句如下：
--维修记录表注释
create table t_wxjl(
id int identity(1,1) primary key not null,--主键
wxjlName varchar(100),--维修记录说明
showDate datetime,--维修日期
content varchar(100),--详细维修说明
wxr varchar(100),--维修人
phone varchar(100)--电话
);
维修申报表创建语句如下：
--维修申报表注释
create table t_wxsb(
id int identity(1,1) primary key not null,--主键
cgId int,--场馆
wxxm varchar(100),--维修项目
customerId int,--用户
insertDate datetime,--申报日期
title varchar(100),--维修说明
status varchar(100),--状态
back varchar(100)--审核回复
);
消息表创建语句如下：
--消息表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
content varchar(100),--消息内容
insertDate datetime--发送日期
);
场馆预约表创建语句如下：
--场馆预约表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
cgId int,--场馆
customerId int,--用户
showDate datetime,--预约日期
title varchar(100),--预约说明
status varchar(100),--状态
back 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_cg")
public class Cg {
//主键
@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 cgName;
//图片
private String pic;
//场馆位置
private String wz;
//场馆项目
private String xm;
//场馆最多人数
private Integer rs;
//状态
private String status;
public String getCgName() {return cgName;}
public void setCgName(String cgName) {this.cgName = cgName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
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_cgqc")
public class Cgqc {
//主键
@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 cgqcName;
//数量
private Integer sl;
//图片
private String pic;
public String getCgqcName() {return cgqcName;}
public void setCgqcName(String cgqcName) {this.cgqcName = cgqcName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}场馆器材预借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_cgqcyy")
public class Cgqcyy {
//主键
@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 cgqcId;
//用户
private Integer customerId;
//预借日期
private Date showDate;
//预借说明
private String title;
//预借数量
private Integer yjsl;
//状态
private String status;
public Integer getCgqcId() {return cgqcId;}
public void setCgqcId(Integer cgqcId) {this.cgqcId = cgqcId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getYjsl() {return yjsl;}
public void setYjsl(Integer yjsl) {this.yjsl = yjsl;}
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 headPic;
//电话
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 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;}
}公告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 title;
//公告日期
private Date showDate;
//图片
private String pic;
//公告内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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;}
}维修管理员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_wxadmin")
public class Wxadmin {
//主键
@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 wxadminName;
//电话
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 getWxadminName() {return wxadminName;}
public void setWxadminName(String wxadminName) {this.wxadminName = wxadminName;}
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_wxjl")
public class Wxjl {
//主键
@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 wxjlName;
//维修日期
private Date showDate;
//详细维修说明
private String content;
//维修人
private String wxr;
//电话
private String phone;
public String getWxjlName() {return wxjlName;}
public void setWxjlName(String wxjlName) {this.wxjlName = wxjlName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getWxr() {return wxr;}
public void setWxr(String wxr) {this.wxr = wxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}维修申报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_wxsb")
public class Wxsb {
//主键
@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 cgId;
//维修项目
private String wxxm;
//用户
private Integer customerId;
//申报日期
private Date insertDate;
//维修说明
private String title;
//状态
private String status;
//审核回复
private String back;
public Integer getCgId() {return cgId;}
public void setCgId(Integer cgId) {this.cgId = cgId;}
public String getWxxm() {return wxxm;}
public void setWxxm(String wxxm) {this.wxxm = wxxm;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}消息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_xiaoxi")
public class Xiaoxi {
//主键
@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 content;
//发送日期
private Date insertDate;
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 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_yy")
public class Yy {
//主键
@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 cgId;
//用户
private Integer customerId;
//预约日期
private Date showDate;
//预约说明
private String title;
//状态
private String status;
//审核回复
private String back;
public Integer getCgId() {return cgId;}
public void setCgId(Integer cgId) {this.cgId = cgId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}太原科技大学体育场维护与管理spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
场馆javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//场馆
public class Cg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆名称
private String cgName;
//图片
private String pic;
//场馆位置
private String wz;
//场馆项目
private String xm;
//场馆最多人数
private Integer rs;
//状态
private String status;
public String getCgName() {return cgName;}
public void setCgName(String cgName) {this.cgName = cgName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
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 Cgqc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆器材
private String cgqcName;
//数量
private Integer sl;
//图片
private String pic;
public String getCgqcName() {return cgqcName;}
public void setCgqcName(String cgqcName) {this.cgqcName = cgqcName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}场馆器材预借javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//场馆器材预借
public class Cgqcyy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆器材
private Integer cgqcId;
//用户
private Integer customerId;
//预借日期
private Date showDate;
//预借说明
private String title;
//预借数量
private Integer yjsl;
//状态
private String status;
public Integer getCgqcId() {return cgqcId;}
public void setCgqcId(Integer cgqcId) {this.cgqcId = cgqcId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getYjsl() {return yjsl;}
public void setYjsl(Integer yjsl) {this.yjsl = yjsl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//电话
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 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;}
}公告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 title;
//公告日期
private Date showDate;
//图片
private String pic;
//公告内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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;}
}维修管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//维修管理员
public class Wxadmin 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 wxadminName;
//电话
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 getWxadminName() {return wxadminName;}
public void setWxadminName(String wxadminName) {this.wxadminName = wxadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}维修记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//维修记录
public class Wxjl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//维修记录说明
private String wxjlName;
//维修日期
private Date showDate;
//详细维修说明
private String content;
//维修人
private String wxr;
//电话
private String phone;
public String getWxjlName() {return wxjlName;}
public void setWxjlName(String wxjlName) {this.wxjlName = wxjlName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getWxr() {return wxr;}
public void setWxr(String wxr) {this.wxr = wxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}维修申报javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//维修申报
public class Wxsb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆
private Integer cgId;
//维修项目
private String wxxm;
//用户
private Integer customerId;
//申报日期
private Date insertDate;
//维修说明
private String title;
//状态
private String status;
//审核回复
private String back;
public Integer getCgId() {return cgId;}
public void setCgId(Integer cgId) {this.cgId = cgId;}
public String getWxxm() {return wxxm;}
public void setWxxm(String wxxm) {this.wxxm = wxxm;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}消息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//消息
public class Xiaoxi 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 content;
//发送日期
private Date insertDate;
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 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 Yy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆
private Integer cgId;
//用户
private Integer customerId;
//预约日期
private Date showDate;
//预约说明
private String title;
//状态
private String status;
//审核回复
private String back;
public Integer getCgId() {return cgId;}
public void setCgId(Integer cgId) {this.cgId = cgId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}