- 驾校综合信息系统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');SQL
Copy
车辆表创建语句如下：
create table t_car(
id int primary key auto_increment comment '主键',
carName varchar(100) comment '车辆编号',
pic varchar(100) comment '牌照',
pp varchar(100) comment '品牌',
content text comment '备注'
) comment '车辆';SQL
Copy
场地表创建语句如下：
create table t_cd(
id int primary key auto_increment comment '主键',
cdName varchar(100) comment '场地编号',
pic varchar(100) comment '拍照',
pp varchar(100) comment '详细地址',
content text comment '备注'
) comment '场地';SQL
Copy
学员表创建语句如下：
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 '学员';SQL
Copy
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
ggName varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '日期'
) comment '公告';SQL
Copy
教练评价表创建语句如下：
create table t_pj(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
teacherId int comment '教练',
content text comment '评价',
pf int comment '评分',
insertDate datetime comment '发起日期'
) comment '教练评价';SQL
Copy
培训视频表创建语句如下：
create table t_shipin(
id int primary key auto_increment comment '主键',
shipinName varchar(100) comment '视频名称',
fileUrl varchar(100) comment '视频',
content text comment '视频内容简介'
) comment '培训视频';SQL
Copy
申请项目表创建语句如下：
create table t_sqxm(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
title varchar(100) comment '',
content text comment '申请备注',
insertDate datetime comment '申请日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '申请项目';SQL
Copy
教练表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
teacherName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
headPic varchar(100) comment '头像'
) comment '教练';SQL
Copy
问题表创建语句如下：
create table t_wt(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
wtName varchar(100) comment '问题说明',
content text comment '详细内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '问题';SQL
Copy
预约学车表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
content text comment '预约说明',
showDate datetime comment '预约日期',
teacherId int comment '选择教练',
yyxm varchar(100) comment '',
back text comment '回复',
status varchar(100) comment '状态'
) comment '预约学车';SQL
Copy
课程资源表创建语句如下：
create table t_ziyuan(
id int primary key auto_increment comment '主键',
ziyuanName varchar(100) comment '资源名称',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
content text comment '资源说明'
) comment '课程资源';SQL
Copy
学费资金表创建语句如下：
create table t_zj(
id int primary key auto_increment comment '主键',
customerId int comment '学员',
xf int comment '学费金额',
mm varchar(100) comment '学费名目',
showDate datetime comment '上交日期',
content text comment '备注'
) comment '学费资金';SQL
Copy
驾校综合信息系统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 '超级管理员';SQL
Copy
车辆表创建语句如下：
create table t_car(
id integer,
carName varchar(100),
pic varchar(100),
pp varchar(100),
content text
);
--车辆字段加注释
comment on column t_car.id is '主键';
comment on column t_car.carName is '车辆编号';
comment on column t_car.pic is '牌照';
comment on column t_car.pp is '品牌';
comment on column t_car.content is '备注';
--车辆表加注释
comment on table t_car is '车辆';SQL
Copy
场地表创建语句如下：
create table t_cd(
id integer,
cdName varchar(100),
pic varchar(100),
pp varchar(100),
content text
);
--场地字段加注释
comment on column t_cd.id is '主键';
comment on column t_cd.cdName is '场地编号';
comment on column t_cd.pic is '拍照';
comment on column t_cd.pp is '详细地址';
comment on column t_cd.content is '备注';
--场地表加注释
comment on table t_cd is '场地';SQL
Copy
学员表创建语句如下：
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 '学员';SQL
Copy
公告表创建语句如下：
create table t_gg(
id integer,
ggName varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.ggName is '标题';
comment on column t_gg.content is '内容';
comment on column t_gg.insertDate is '日期';
--公告表加注释
comment on table t_gg is '公告';SQL
Copy
教练评价表创建语句如下：
create table t_pj(
id integer,
customerId int,
teacherId int,
content text,
pf int,
insertDate datetime
);
--教练评价字段加注释
comment on column t_pj.id is '主键';
comment on column t_pj.customerId is '学员';
comment on column t_pj.teacherId is '教练';
comment on column t_pj.content is '评价';
comment on column t_pj.pf is '评分';
comment on column t_pj.insertDate is '发起日期';
--教练评价表加注释
comment on table t_pj is '教练评价';SQL
Copy
培训视频表创建语句如下：
create table t_shipin(
id integer,
shipinName varchar(100),
fileUrl varchar(100),
content text
);
--培训视频字段加注释
comment on column t_shipin.id is '主键';
comment on column t_shipin.shipinName is '视频名称';
comment on column t_shipin.fileUrl is '视频';
comment on column t_shipin.content is '视频内容简介';
--培训视频表加注释
comment on table t_shipin is '培训视频';SQL
Copy
申请项目表创建语句如下：
create table t_sqxm(
id integer,
customerId int,
title varchar(100),
content text,
insertDate datetime,
back text,
status varchar(100)
);
--申请项目字段加注释
comment on column t_sqxm.id is '主键';
comment on column t_sqxm.customerId is '学员';
comment on column t_sqxm.title is '';
comment on column t_sqxm.content is '申请备注';
comment on column t_sqxm.insertDate is '申请日期';
comment on column t_sqxm.back is '回复';
comment on column t_sqxm.status is '状态';
--申请项目表加注释
comment on table t_sqxm is '申请项目';SQL
Copy
教练表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
headPic 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.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '';
comment on column t_teacher.headPic is '头像';
--教练表加注释
comment on table t_teacher is '教练';SQL
Copy
问题表创建语句如下：
create table t_wt(
id integer,
customerId int,
wtName varchar(100),
content text,
insertDate datetime,
back text,
status varchar(100)
);
--问题字段加注释
comment on column t_wt.id is '主键';
comment on column t_wt.customerId is '学员';
comment on column t_wt.wtName is '问题说明';
comment on column t_wt.content is '详细内容';
comment on column t_wt.insertDate is '发起日期';
comment on column t_wt.back is '回复';
comment on column t_wt.status is '状态';
--问题表加注释
comment on table t_wt is '问题';SQL
Copy
预约学车表创建语句如下：
create table t_yy(
id integer,
customerId int,
content text,
showDate datetime,
teacherId int,
yyxm varchar(100),
back text,
status varchar(100)
);
--预约学车字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.customerId is '学员';
comment on column t_yy.content is '预约说明';
comment on column t_yy.showDate is '预约日期';
comment on column t_yy.teacherId is '选择教练';
comment on column t_yy.yyxm is '';
comment on column t_yy.back is '回复';
comment on column t_yy.status is '状态';
--预约学车表加注释
comment on table t_yy is '预约学车';SQL
Copy
课程资源表创建语句如下：
create table t_ziyuan(
id integer,
ziyuanName varchar(100),
pic varchar(100),
fileUrl varchar(100),
content text
);
--课程资源字段加注释
comment on column t_ziyuan.id is '主键';
comment on column t_ziyuan.ziyuanName is '资源名称';
comment on column t_ziyuan.pic is '图片';
comment on column t_ziyuan.fileUrl is '附件';
comment on column t_ziyuan.content is '资源说明';
--课程资源表加注释
comment on table t_ziyuan is '课程资源';SQL
Copy
学费资金表创建语句如下：
create table t_zj(
id integer,
customerId int,
xf int,
mm varchar(100),
showDate datetime,
content text
);
--学费资金字段加注释
comment on column t_zj.id is '主键';
comment on column t_zj.customerId is '学员';
comment on column t_zj.xf is '学费金额';
comment on column t_zj.mm is '学费名目';
comment on column t_zj.showDate is '上交日期';
comment on column t_zj.content is '备注';
--学费资金表加注释
comment on table t_zj is '学费资金';SQL
Copy
oracle特有，对应序列如下：
create sequence s_t_car;
create sequence s_t_cd;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_pj;
create sequence s_t_shipin;
create sequence s_t_sqxm;
create sequence s_t_teacher;
create sequence s_t_wt;
create sequence s_t_yy;
create sequence s_t_ziyuan;
create sequence s_t_zj;SQL
Copy
驾校综合信息系统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');SQL
Copy
车辆表创建语句如下：
--车辆表注释
create table t_car(
id int identity(1,1) primary key not null,--主键
carName varchar(100),--车辆编号
pic varchar(100),--牌照
pp varchar(100),--品牌
content text--备注
);SQL
Copy
场地表创建语句如下：
--场地表注释
create table t_cd(
id int identity(1,1) primary key not null,--主键
cdName varchar(100),--场地编号
pic varchar(100),--拍照
pp varchar(100),--详细地址
content text--备注
);SQL
Copy
学员表创建语句如下：
--学员表注释
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)--
);SQL
Copy
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
ggName varchar(100),--标题
content text,--内容
insertDate datetime--日期
);SQL
Copy
教练评价表创建语句如下：
--教练评价表注释
create table t_pj(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
teacherId int,--教练
content text,--评价
pf int,--评分
insertDate datetime--发起日期
);SQL
Copy
培训视频表创建语句如下：
--培训视频表注释
create table t_shipin(
id int identity(1,1) primary key not null,--主键
shipinName varchar(100),--视频名称
fileUrl varchar(100),--视频
content text--视频内容简介
);SQL
Copy
申请项目表创建语句如下：
--申请项目表注释
create table t_sqxm(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
title varchar(100),--
content text,--申请备注
insertDate datetime,--申请日期
back text,--回复
status varchar(100)--状态
);SQL
Copy
教练表创建语句如下：
--教练表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
headPic varchar(100)--头像
);SQL
Copy
问题表创建语句如下：
--问题表注释
create table t_wt(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
wtName varchar(100),--问题说明
content text,--详细内容
insertDate datetime,--发起日期
back text,--回复
status varchar(100)--状态
);SQL
Copy
预约学车表创建语句如下：
--预约学车表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
content text,--预约说明
showDate datetime,--预约日期
teacherId int,--选择教练
yyxm varchar(100),--
back text,--回复
status varchar(100)--状态
);SQL
Copy
课程资源表创建语句如下：
--课程资源表注释
create table t_ziyuan(
id int identity(1,1) primary key not null,--主键
ziyuanName varchar(100),--资源名称
pic varchar(100),--图片
fileUrl varchar(100),--附件
content text--资源说明
);SQL
Copy
学费资金表创建语句如下：
--学费资金表注释
create table t_zj(
id int identity(1,1) primary key not null,--主键
customerId int,--学员
xf int,--学费金额
mm varchar(100),--学费名目
showDate datetime,--上交日期
content text--备注
);SQL
Copy
驾校综合信息系统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_car")
public class Car {
//主键
@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 carName;
//牌照
private String pic;
//品牌
private String pp;
//备注
private String content;
public String getCarName() {return carName;}
public void setCarName(String carName) {this.carName = carName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
场地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_cd")
public class Cd {
//主键
@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 cdName;
//拍照
private String pic;
//详细地址
private String pp;
//备注
private String content;
public String getCdName() {return cdName;}
public void setCdName(String cdName) {this.cdName = cdName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
学员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;}
}Java
Copy
公告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 ggName;
//内容
private String content;
//日期
private Date insertDate;
public String getGgName() {return ggName;}
public void setGgName(String ggName) {this.ggName = ggName;}
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;}
}Java
Copy
教练评价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_pj")
public class Pj {
//主键
@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 teacherId;
//评价
private String content;
//评分
private Integer pf;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}Java
Copy
培训视频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_shipin")
public class Shipin {
//主键
@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 shipinName;
//视频
private String fileUrl;
//视频内容简介
private String content;
public String getShipinName() {return shipinName;}
public void setShipinName(String shipinName) {this.shipinName = shipinName;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
申请项目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_sqxm")
public class Sqxm {
//主键
@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 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 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;}
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;}
}Java
Copy
教练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 phone;
//年龄
private String age;
//
private String sex;
//头像
private String headPic;
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 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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}Java
Copy
问题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_wt")
public class Wt {
//主键
@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 wtName;
//详细内容
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 getWtName() {return wtName;}
public void setWtName(String wtName) {this.wtName = wtName;}
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;}
}Java
Copy
预约学车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 content;
//预约日期
private Date showDate;
//选择教练
private Long teacherId;
//
private String yyxm;
//回复
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 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 getYyxm() {return yyxm;}
public void setYyxm(String yyxm) {this.yyxm = yyxm;}
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;}
}Java
Copy
课程资源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_ziyuan")
public class Ziyuan {
//主键
@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 ziyuanName;
//图片
private String pic;
//附件
private String fileUrl;
//资源说明
private String content;
public String getZiyuanName() {return ziyuanName;}
public void setZiyuanName(String ziyuanName) {this.ziyuanName = ziyuanName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
学费资金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_zj")
public class Zj {
//主键
@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 Integer xf;
//学费名目
private String mm;
//上交日期
private Date showDate;
//备注
private String content;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public String getMm() {return mm;}
public void setMm(String mm) {this.mm = mm;}
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;}
}Java
Copy
驾校综合信息系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
车辆javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车辆
public class Car extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车辆编号
private String carName;
//牌照
private String pic;
//品牌
private String pp;
//备注
private String content;
public String getCarName() {return carName;}
public void setCarName(String carName) {this.carName = carName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
场地javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//场地
public class Cd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场地编号
private String cdName;
//拍照
private String pic;
//详细地址
private String pp;
//备注
private String content;
public String getCdName() {return cdName;}
public void setCdName(String cdName) {this.cdName = cdName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
学员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;}
}Java
Copy
公告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 ggName;
//内容
private String content;
//日期
private Date insertDate;
public String getGgName() {return ggName;}
public void setGgName(String ggName) {this.ggName = ggName;}
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;}
}Java
Copy
教练评价javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//教练评价
public class Pj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Long customerId;
//教练
private Long teacherId;
//评价
private String content;
//评分
private Integer pf;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}Java
Copy
培训视频javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//培训视频
public class Shipin extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//视频名称
private String shipinName;
//视频
private String fileUrl;
//视频内容简介
private String content;
public String getShipinName() {return shipinName;}
public void setShipinName(String shipinName) {this.shipinName = shipinName;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
申请项目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//申请项目
public class Sqxm 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 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 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;}
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;}
}Java
Copy
教练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 phone;
//年龄
private String age;
//
private String sex;
//头像
private String headPic;
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 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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}Java
Copy
问题javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//问题
public class Wt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Long customerId;
//问题说明
private String wtName;
//详细内容
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 getWtName() {return wtName;}
public void setWtName(String wtName) {this.wtName = wtName;}
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;}
}Java
Copy
预约学车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 content;
//预约日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//选择教练
private Long teacherId;
//
private String yyxm;
//回复
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 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 getYyxm() {return yyxm;}
public void setYyxm(String yyxm) {this.yyxm = yyxm;}
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;}
}Java
Copy
课程资源javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//课程资源
public class Ziyuan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资源名称
private String ziyuanName;
//图片
private String pic;
//附件
private String fileUrl;
//资源说明
private String content;
public String getZiyuanName() {return ziyuanName;}
public void setZiyuanName(String ziyuanName) {this.ziyuanName = ziyuanName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}Java
Copy
学费资金javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学费资金
public class Zj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Long customerId;
//学费金额
private Integer xf;
//学费名目
private String mm;
//上交日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//备注
private String content;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public String getMm() {return mm;}
public void setMm(String mm) {this.mm = mm;}
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;}
}
