- 驾校学员信息管理系统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_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 '',
sfz varchar(100) comment '身份证'
) comment '学员';
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '公告';
考试表创建语句如下：
create table t_kaoshi(
id int primary key auto_increment comment '主键',
kaoshiName varchar(100) comment '考试名称',
showDate datetime comment '考试时间',
km varchar(100) comment '',
dd varchar(100) comment '考试地点',
remark text comment '备注'
) comment '考试';
考试预约表创建语句如下：
create table t_ksyy(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
kaoshiId int comment '考试名称',
insertDate datetime comment '发起时间',
status varchar(100) comment '状态',
back text comment '审核说明'
) comment '考试预约';
投诉表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
content text comment '投诉内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '投诉';
教练表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
teacherName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
jskm varchar(100) comment '教授科目'
) comment '教练';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '内容',
insertDate datetime comment '发起日期'
) comment '通知';
预约表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
km varchar(100) comment '',
showDate datetime comment '预约日期',
teacherId int comment '预约教练',
dd varchar(100) comment ''
) comment '预约';
驾校学员信息管理系统oracle数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';
学员表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
sfz 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.sfz is '身份证';
--学员表加注释
comment on table t_customer is '学员';
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';
考试表创建语句如下：
create table t_kaoshi(
id integer,
kaoshiName varchar(100),
showDate datetime,
km varchar(100),
dd varchar(100),
remark text
);
--考试字段加注释
comment on column t_kaoshi.id is '主键';
comment on column t_kaoshi.kaoshiName is '考试名称';
comment on column t_kaoshi.showDate is '考试时间';
comment on column t_kaoshi.km is '';
comment on column t_kaoshi.dd is '考试地点';
comment on column t_kaoshi.remark is '备注';
--考试表加注释
comment on table t_kaoshi is '考试';
考试预约表创建语句如下：
create table t_ksyy(
id integer,
customerId int,
kaoshiId int,
insertDate datetime,
status varchar(100),
back text
);
--考试预约字段加注释
comment on column t_ksyy.id is '主键';
comment on column t_ksyy.customerId is '学员';
comment on column t_ksyy.kaoshiId is '考试名称';
comment on column t_ksyy.insertDate is '发起时间';
comment on column t_ksyy.status is '状态';
comment on column t_ksyy.back is '审核说明';
--考试预约表加注释
comment on table t_ksyy is '考试预约';
投诉表创建语句如下：
create table t_ly(
id integer,
customerId int,
content text,
insertDate datetime,
back text,
status varchar(100)
);
--投诉字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '用户';
comment on column t_ly.content is '投诉内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--投诉表加注释
comment on table t_ly is '投诉';
教练表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
jskm varchar(100)
);
--教练字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.headPic is '头像';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '';
comment on column t_teacher.jskm is '教授科目';
--教练表加注释
comment on table t_teacher is '教练';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
title varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';
预约表创建语句如下：
create table t_yy(
id integer,
customerId int,
km varchar(100),
showDate datetime,
teacherId int,
dd varchar(100)
);
--预约字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.customerId is '学员';
comment on column t_yy.km is '';
comment on column t_yy.showDate is '预约日期';
comment on column t_yy.teacherId is '预约教练';
comment on column t_yy.dd is '';
--预约表加注释
comment on table t_yy is '预约';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_kaoshi;
create sequence s_t_ksyy;
create sequence s_t_ly;
create sequence s_t_teacher;
create sequence s_t_tongzhi;
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_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),--
sfz varchar(100)--身份证
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
考试表创建语句如下：
--考试表注释
create table t_kaoshi(
id int identity(1,1) primary key not null,--主键
kaoshiName varchar(100),--考试名称
showDate datetime,--考试时间
km varchar(100),--
dd varchar(100),--考试地点
remark text--备注
);
考试预约表创建语句如下：
--考试预约表注释
create table t_ksyy(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
kaoshiId int,--考试名称
insertDate datetime,--发起时间
status varchar(100),--状态
back text--审核说明
);
投诉表创建语句如下：
--投诉表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
content text,--投诉内容
insertDate datetime,--发起日期
back text,--回复
status varchar(100)--状态
);
教练表创建语句如下：
--教练表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
jskm varchar(100)--教授科目
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--内容
insertDate datetime--发起日期
);
预约表创建语句如下：
--预约表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
km varchar(100),--
showDate datetime,--预约日期
teacherId int,--预约教练
dd 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_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 String sfz;
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 String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}公告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_gonggao")
public class Gonggao {
//主键
@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 Date insertDate;
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_kaoshi")
public class Kaoshi {
//主键
@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 kaoshiName;
//考试时间
private Date showDate;
//
private String km;
//考试地点
private String dd;
//备注
private String remark;
public String getKaoshiName() {return kaoshiName;}
public void setKaoshiName(String kaoshiName) {this.kaoshiName = kaoshiName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}考试预约javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//考试预约
@Table(name = "t_ksyy")
public class Ksyy {
//主键
@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 Long customerId;
//考试名称
private Long kaoshiId;
//发起时间
private Date insertDate;
//状态
private String status;
//审核说明
private String back;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getKaoshiId() {return kaoshiId;}
public void setKaoshiId(Long kaoshiId) {this.kaoshiId = kaoshiId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_ly")
public class Ly {
//主键
@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 Long customerId;
//投诉内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_teacher")
public class Teacher {
//主键
@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 teacherName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//教授科目
private String jskm;
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 String getJskm() {return jskm;}
public void setJskm(String jskm) {this.jskm = jskm;}
}通知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 Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Long customerId;
//
private String km;
//预约日期
private Date showDate;
//预约教练
private Long teacherId;
//
private String dd;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}驾校学员信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
学员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学员
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//身份证
private String sfz;
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 String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao 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 Date insertDate;
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 Kaoshi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//考试名称
private String kaoshiName;
//考试时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//
private String km;
//考试地点
private String dd;
//备注
private String remark;
public String getKaoshiName() {return kaoshiName;}
public void setKaoshiName(String kaoshiName) {this.kaoshiName = kaoshiName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}考试预约javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试预约
public class Ksyy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Long customerId;
//考试名称
private Long kaoshiId;
//发起时间
private Date insertDate;
//状态
private String status;
//审核说明
private String back;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getKaoshiId() {return kaoshiId;}
public void setKaoshiId(Long kaoshiId) {this.kaoshiId = kaoshiId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//投诉内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Teacher 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 teacherName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//教授科目
private String jskm;
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 String getJskm() {return jskm;}
public void setJskm(String jskm) {this.jskm = jskm;}
}通知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 Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Long customerId;
//
private String km;
//预约日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//预约教练
private Long teacherId;
//
private String dd;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}