- 驾校管理系统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 '主键',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '手机',
sex varchar(100) comment '',
age varchar(100) comment '年龄',
address varchar(100) comment '家庭住址',
idcard varchar(100) comment '身份证',
insertDate datetime comment '入库日期',
headPic varchar(100) comment '头像'
) comment '用户';
试卷表创建语句如下：
create table t_exam(
id int primary key auto_increment comment '主键',
examName varchar(100) comment '名称',
showDate varchar(100) comment '日期',
status varchar(100) comment '状态',
ny varchar(100) comment '难易程度'
) comment '试卷';
答案表创建语句如下：
create table t_examanswer(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
examName varchar(100) comment '试卷名称',
insertDate datetime comment '日期',
tm varchar(100) comment '题目',
da varchar(100) comment '客户答案',
answer varchar(100) comment '正确答案',
batchId varchar(100) comment '批处理id'
) comment '答案';
试卷题目表创建语句如下：
create table t_examlist(
id int primary key auto_increment comment '主键',
examId int comment '试卷',
examtmId int comment '题目'
) comment '试卷题目';
考试题目表创建语句如下：
create table t_examtm(
id int primary key auto_increment comment '主键',
types int comment '类型',
v1 varchar(100) comment '题目标题',
v2 varchar(100) comment '选项A',
v3 varchar(100) comment '选项B',
v4 varchar(100) comment '选项C',
v5 varchar(100) comment '选项D',
v6 varchar(100) comment '答案',
v7 varchar(100) comment '题目',
v8 varchar(100) comment '答案',
v9 varchar(100) comment '题目',
v10 varchar(100) comment '答案'
) comment '考试题目';
驾校表创建语句如下：
create table t_jx(
id int primary key auto_increment comment '主键',
jxName varchar(100) comment '驾校名称',
jxPic varchar(100) comment '图片',
jxContent varchar(100) comment '驾校简介'
) comment '驾校';
考题详解表创建语句如下：
create table t_ktxj(
id int primary key auto_increment comment '主键',
ktxjName varchar(100) comment '考题标题',
ktPic varchar(100) comment '图片',
content varchar(100) comment '详解内容'
) comment '考题详解';
轮播图表创建语句如下：
create table t_lbt(
id int primary key auto_increment comment '主键',
lbtName varchar(100) comment '标题',
lbtPic varchar(100) comment '图片',
url varchar(100) comment '链接'
) comment '轮播图';
评论表创建语句如下：
create table t_pinglun(
id int primary key auto_increment comment '主键',
wdxxId int comment '评论信息',
customerId int comment '评论人',
content varchar(100) comment '评论内容',
insertDate datetime comment '评论日期'
) comment '评论';
视频表创建语句如下：
create table t_radios(
id int primary key auto_increment comment '主键',
radiosName varchar(100) comment '标题',
radiosUrl varchar(100) comment '视频',
radiosContent varchar(100) comment '内容',
radiosDate varchar(100) comment '日期'
) comment '视频';
我的消息表创建语句如下：
create table t_wdxx(
id int primary key auto_increment comment '主键',
customerId int comment '我',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
zan int comment '赞',
insertDate datetime comment '发布日期'
) comment '我的消息';
新闻表创建语句如下：
create table t_xw(
id int primary key auto_increment comment '主键',
xwName varchar(100) comment '标题',
xwPic varchar(100) comment '图片',
xwContent varchar(100) comment '内容',
xwDate varchar(100) comment '日期'
) comment '新闻';
预约练车表创建语句如下：
create table t_yylc(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
content varchar(100) comment '预约练车说明',
yyDate varchar(100) comment '预约时间'
) comment '预约练车';
在线报名表创建语句如下：
create table t_zxbm(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
jxId int comment '驾校',
insertDate datetime 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,
customerName varchar(100),
phone varchar(100),
sex varchar(100),
age varchar(100),
address varchar(100),
idcard varchar(100),
insertDate datetime,
headPic varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '家庭住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
comment on column t_customer.headPic is '头像';
--用户表加注释
comment on table t_customer is '用户';
试卷表创建语句如下：
create table t_exam(
id integer,
examName varchar(100),
showDate varchar(100),
status varchar(100),
ny varchar(100)
);
--试卷字段加注释
comment on column t_exam.id is '主键';
comment on column t_exam.examName is '名称';
comment on column t_exam.showDate is '日期';
comment on column t_exam.status is '状态';
comment on column t_exam.ny is '难易程度';
--试卷表加注释
comment on table t_exam is '试卷';
答案表创建语句如下：
create table t_examanswer(
id integer,
customerId int,
examName varchar(100),
insertDate datetime,
tm varchar(100),
da varchar(100),
answer varchar(100),
batchId varchar(100)
);
--答案字段加注释
comment on column t_examanswer.id is '主键';
comment on column t_examanswer.customerId is '用户';
comment on column t_examanswer.examName is '试卷名称';
comment on column t_examanswer.insertDate is '日期';
comment on column t_examanswer.tm is '题目';
comment on column t_examanswer.da is '客户答案';
comment on column t_examanswer.answer is '正确答案';
comment on column t_examanswer.batchId is '批处理id';
--答案表加注释
comment on table t_examanswer is '答案';
试卷题目表创建语句如下：
create table t_examlist(
id integer,
examId int,
examtmId int
);
--试卷题目字段加注释
comment on column t_examlist.id is '主键';
comment on column t_examlist.examId is '试卷';
comment on column t_examlist.examtmId is '题目';
--试卷题目表加注释
comment on table t_examlist is '试卷题目';
考试题目表创建语句如下：
create table t_examtm(
id integer,
types int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
v8 varchar(100),
v9 varchar(100),
v10 varchar(100)
);
--考试题目字段加注释
comment on column t_examtm.id is '主键';
comment on column t_examtm.types is '类型';
comment on column t_examtm.v1 is '题目标题';
comment on column t_examtm.v2 is '选项A';
comment on column t_examtm.v3 is '选项B';
comment on column t_examtm.v4 is '选项C';
comment on column t_examtm.v5 is '选项D';
comment on column t_examtm.v6 is '答案';
comment on column t_examtm.v7 is '题目';
comment on column t_examtm.v8 is '答案';
comment on column t_examtm.v9 is '题目';
comment on column t_examtm.v10 is '答案';
--考试题目表加注释
comment on table t_examtm is '考试题目';
驾校表创建语句如下：
create table t_jx(
id integer,
jxName varchar(100),
jxPic varchar(100),
jxContent varchar(100)
);
--驾校字段加注释
comment on column t_jx.id is '主键';
comment on column t_jx.jxName is '驾校名称';
comment on column t_jx.jxPic is '图片';
comment on column t_jx.jxContent is '驾校简介';
--驾校表加注释
comment on table t_jx is '驾校';
考题详解表创建语句如下：
create table t_ktxj(
id integer,
ktxjName varchar(100),
ktPic varchar(100),
content varchar(100)
);
--考题详解字段加注释
comment on column t_ktxj.id is '主键';
comment on column t_ktxj.ktxjName is '考题标题';
comment on column t_ktxj.ktPic is '图片';
comment on column t_ktxj.content is '详解内容';
--考题详解表加注释
comment on table t_ktxj is '考题详解';
轮播图表创建语句如下：
create table t_lbt(
id integer,
lbtName varchar(100),
lbtPic varchar(100),
url varchar(100)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.lbtName is '标题';
comment on column t_lbt.lbtPic is '图片';
comment on column t_lbt.url is '链接';
--轮播图表加注释
comment on table t_lbt is '轮播图';
评论表创建语句如下：
create table t_pinglun(
id integer,
wdxxId int,
customerId int,
content varchar(100),
insertDate datetime
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.wdxxId is '评论信息';
comment on column t_pinglun.customerId is '评论人';
comment on column t_pinglun.content is '评论内容';
comment on column t_pinglun.insertDate is '评论日期';
--评论表加注释
comment on table t_pinglun is '评论';
视频表创建语句如下：
create table t_radios(
id integer,
radiosName varchar(100),
radiosUrl varchar(100),
radiosContent varchar(100),
radiosDate varchar(100)
);
--视频字段加注释
comment on column t_radios.id is '主键';
comment on column t_radios.radiosName is '标题';
comment on column t_radios.radiosUrl is '视频';
comment on column t_radios.radiosContent is '内容';
comment on column t_radios.radiosDate is '日期';
--视频表加注释
comment on table t_radios is '视频';
我的消息表创建语句如下：
create table t_wdxx(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
zan int,
insertDate datetime
);
--我的消息字段加注释
comment on column t_wdxx.id is '主键';
comment on column t_wdxx.customerId is '我';
comment on column t_wdxx.title is '标题';
comment on column t_wdxx.pic is '图片';
comment on column t_wdxx.content is '内容';
comment on column t_wdxx.zan is '赞';
comment on column t_wdxx.insertDate is '发布日期';
--我的消息表加注释
comment on table t_wdxx is '我的消息';
新闻表创建语句如下：
create table t_xw(
id integer,
xwName varchar(100),
xwPic varchar(100),
xwContent varchar(100),
xwDate varchar(100)
);
--新闻字段加注释
comment on column t_xw.id is '主键';
comment on column t_xw.xwName is '标题';
comment on column t_xw.xwPic is '图片';
comment on column t_xw.xwContent is '内容';
comment on column t_xw.xwDate is '日期';
--新闻表加注释
comment on table t_xw is '新闻';
预约练车表创建语句如下：
create table t_yylc(
id integer,
customerId int,
content varchar(100),
yyDate varchar(100)
);
--预约练车字段加注释
comment on column t_yylc.id is '主键';
comment on column t_yylc.customerId is '用户';
comment on column t_yylc.content is '预约练车说明';
comment on column t_yylc.yyDate is '预约时间';
--预约练车表加注释
comment on table t_yylc is '预约练车';
在线报名表创建语句如下：
create table t_zxbm(
id integer,
customerId int,
jxId int,
insertDate datetime
);
--在线报名字段加注释
comment on column t_zxbm.id is '主键';
comment on column t_zxbm.customerId is '用户';
comment on column t_zxbm.jxId is '驾校';
comment on column t_zxbm.insertDate is '日期';
--在线报名表加注释
comment on table t_zxbm is '在线报名';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_exam;
create sequence s_t_examanswer;
create sequence s_t_examlist;
create sequence s_t_examtm;
create sequence s_t_jx;
create sequence s_t_ktxj;
create sequence s_t_lbt;
create sequence s_t_pinglun;
create sequence s_t_radios;
create sequence s_t_wdxx;
create sequence s_t_xw;
create sequence s_t_yylc;
create sequence s_t_zxbm;
驾校管理系统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,--主键
customerName varchar(100),--姓名
phone varchar(100),--手机
sex varchar(100),--
age varchar(100),--年龄
address varchar(100),--家庭住址
idcard varchar(100),--身份证
insertDate datetime,--入库日期
headPic varchar(100)--头像
);
试卷表创建语句如下：
--试卷表注释
create table t_exam(
id int identity(1,1) primary key not null,--主键
examName varchar(100),--名称
showDate varchar(100),--日期
status varchar(100),--状态
ny varchar(100)--难易程度
);
答案表创建语句如下：
--答案表注释
create table t_examanswer(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
examName varchar(100),--试卷名称
insertDate datetime,--日期
tm varchar(100),--题目
da varchar(100),--客户答案
answer varchar(100),--正确答案
batchId varchar(100)--批处理id
);
试卷题目表创建语句如下：
--试卷题目表注释
create table t_examlist(
id int identity(1,1) primary key not null,--主键
examId int,--试卷
examtmId int--题目
);
考试题目表创建语句如下：
--考试题目表注释
create table t_examtm(
id int identity(1,1) primary key not null,--主键
types int,--类型
v1 varchar(100),--题目标题
v2 varchar(100),--选项A
v3 varchar(100),--选项B
v4 varchar(100),--选项C
v5 varchar(100),--选项D
v6 varchar(100),--答案
v7 varchar(100),--题目
v8 varchar(100),--答案
v9 varchar(100),--题目
v10 varchar(100)--答案
);
驾校表创建语句如下：
--驾校表注释
create table t_jx(
id int identity(1,1) primary key not null,--主键
jxName varchar(100),--驾校名称
jxPic varchar(100),--图片
jxContent varchar(100)--驾校简介
);
考题详解表创建语句如下：
--考题详解表注释
create table t_ktxj(
id int identity(1,1) primary key not null,--主键
ktxjName varchar(100),--考题标题
ktPic varchar(100),--图片
content varchar(100)--详解内容
);
轮播图表创建语句如下：
--轮播图表注释
create table t_lbt(
id int identity(1,1) primary key not null,--主键
lbtName varchar(100),--标题
lbtPic varchar(100),--图片
url varchar(100)--链接
);
评论表创建语句如下：
--评论表注释
create table t_pinglun(
id int identity(1,1) primary key not null,--主键
wdxxId int,--评论信息
customerId int,--评论人
content varchar(100),--评论内容
insertDate datetime--评论日期
);
视频表创建语句如下：
--视频表注释
create table t_radios(
id int identity(1,1) primary key not null,--主键
radiosName varchar(100),--标题
radiosUrl varchar(100),--视频
radiosContent varchar(100),--内容
radiosDate varchar(100)--日期
);
我的消息表创建语句如下：
--我的消息表注释
create table t_wdxx(
id int identity(1,1) primary key not null,--主键
customerId int,--我
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
zan int,--赞
insertDate datetime--发布日期
);
新闻表创建语句如下：
--新闻表注释
create table t_xw(
id int identity(1,1) primary key not null,--主键
xwName varchar(100),--标题
xwPic varchar(100),--图片
xwContent varchar(100),--内容
xwDate varchar(100)--日期
);
预约练车表创建语句如下：
--预约练车表注释
create table t_yylc(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
content varchar(100),--预约练车说明
yyDate varchar(100)--预约时间
);
在线报名表创建语句如下：
--在线报名表注释
create table t_zxbm(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
jxId int,--驾校
insertDate datetime--日期
);
登录后主页.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 customerName;
//手机
private String phone;
//
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}试卷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_exam")
public class Exam {
//主键
@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 examName;
//日期
private String showDate;
//状态
private String status;
//难易程度
private String ny;
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getNy() {return ny;}
public void setNy(String ny) {this.ny = ny;}
}答案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_examanswer")
public class Examanswer {
//主键
@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 examName;
//日期
private Date insertDate;
//题目
private String tm;
//客户答案
private String da;
//正确答案
private String answer;
//批处理id
private String batchId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTm() {return tm;}
public void setTm(String tm) {this.tm = tm;}
public String getDa() {return da;}
public void setDa(String da) {this.da = da;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public String getBatchId() {return batchId;}
public void setBatchId(String batchId) {this.batchId = batchId;}
}试卷题目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_examlist")
public class Examlist {
//主键
@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 examId;
//题目
private Integer examtmId;
public Integer getExamId() {return examId;}
public void setExamId(Integer examId) {this.examId = examId;}
public Integer getExamtmId() {return examtmId;}
public void setExamtmId(Integer examtmId) {this.examtmId = examtmId;}
}考试题目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_examtm")
public class Examtm {
//主键
@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 types;
//题目标题
private String v1;
//选项A
private String v2;
//选项B
private String v3;
//选项C
private String v4;
//选项D
private String v5;
//答案
private String v6;
//题目
private String v7;
//答案
private String v8;
//题目
private String v9;
//答案
private String v10;
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
}驾校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_jx")
public class Jx {
//主键
@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 jxName;
//图片
private String jxPic;
//驾校简介
private String jxContent;
public String getJxName() {return jxName;}
public void setJxName(String jxName) {this.jxName = jxName;}
public String getJxPic() {return jxPic;}
public void setJxPic(String jxPic) {this.jxPic = jxPic;}
public String getJxContent() {return jxContent;}
public void setJxContent(String jxContent) {this.jxContent = jxContent;}
}考题详解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_ktxj")
public class Ktxj {
//主键
@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 ktxjName;
//图片
private String ktPic;
//详解内容
private String content;
public String getKtxjName() {return ktxjName;}
public void setKtxjName(String ktxjName) {this.ktxjName = ktxjName;}
public String getKtPic() {return ktPic;}
public void setKtPic(String ktPic) {this.ktPic = ktPic;}
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_lbt")
public class Lbt {
//主键
@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 lbtName;
//图片
private String lbtPic;
//链接
private String url;
public String getLbtName() {return lbtName;}
public void setLbtName(String lbtName) {this.lbtName = lbtName;}
public String getLbtPic() {return lbtPic;}
public void setLbtPic(String lbtPic) {this.lbtPic = lbtPic;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}评论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_pinglun")
public class Pinglun {
//主键
@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 wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer 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;}
}视频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_radios")
public class Radios {
//主键
@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 radiosName;
//视频
private String radiosUrl;
//内容
private String radiosContent;
//日期
private String radiosDate;
public String getRadiosName() {return radiosName;}
public void setRadiosName(String radiosName) {this.radiosName = radiosName;}
public String getRadiosUrl() {return radiosUrl;}
public void setRadiosUrl(String radiosUrl) {this.radiosUrl = radiosUrl;}
public String getRadiosContent() {return radiosContent;}
public void setRadiosContent(String radiosContent) {this.radiosContent = radiosContent;}
public String getRadiosDate() {return radiosDate;}
public void setRadiosDate(String radiosDate) {this.radiosDate = radiosDate;}
}我的消息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_wdxx")
public class Wdxx {
//主键
@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 pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
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_xw")
public class Xw {
//主键
@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 xwName;
//图片
private String xwPic;
//内容
private String xwContent;
//日期
private String xwDate;
public String getXwName() {return xwName;}
public void setXwName(String xwName) {this.xwName = xwName;}
public String getXwPic() {return xwPic;}
public void setXwPic(String xwPic) {this.xwPic = xwPic;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}预约练车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_yylc")
public class Yylc {
//主键
@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 content;
//预约时间
private String yyDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
}在线报名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_zxbm")
public class Zxbm {
//主键
@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 Integer jxId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJxId() {return jxId;}
public void setJxId(Integer jxId) {this.jxId = jxId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}驾校管理系统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 customerName;
//手机
private String phone;
//
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}试卷javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//试卷
public class Exam extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String examName;
//日期
private String showDate;
//状态
private String status;
//难易程度
private String ny;
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getNy() {return ny;}
public void setNy(String ny) {this.ny = ny;}
}答案javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//答案
public class Examanswer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//试卷名称
private String examName;
//日期
private Date insertDate;
//题目
private String tm;
//客户答案
private String da;
//正确答案
private String answer;
//批处理id
private String batchId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTm() {return tm;}
public void setTm(String tm) {this.tm = tm;}
public String getDa() {return da;}
public void setDa(String da) {this.da = da;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public String getBatchId() {return batchId;}
public void setBatchId(String batchId) {this.batchId = batchId;}
}试卷题目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//试卷题目
public class Examlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//试卷
private Integer examId;
//题目
private Integer examtmId;
public Integer getExamId() {return examId;}
public void setExamId(Integer examId) {this.examId = examId;}
public Integer getExamtmId() {return examtmId;}
public void setExamtmId(Integer examtmId) {this.examtmId = examtmId;}
}考试题目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试题目
public class Examtm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private Integer types;
//题目标题
private String v1;
//选项A
private String v2;
//选项B
private String v3;
//选项C
private String v4;
//选项D
private String v5;
//答案
private String v6;
//题目
private String v7;
//答案
private String v8;
//题目
private String v9;
//答案
private String v10;
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
}驾校javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//驾校
public class Jx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//驾校名称
private String jxName;
//图片
private String jxPic;
//驾校简介
private String jxContent;
public String getJxName() {return jxName;}
public void setJxName(String jxName) {this.jxName = jxName;}
public String getJxPic() {return jxPic;}
public void setJxPic(String jxPic) {this.jxPic = jxPic;}
public String getJxContent() {return jxContent;}
public void setJxContent(String jxContent) {this.jxContent = jxContent;}
}考题详解javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考题详解
public class Ktxj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//考题标题
private String ktxjName;
//图片
private String ktPic;
//详解内容
private String content;
public String getKtxjName() {return ktxjName;}
public void setKtxjName(String ktxjName) {this.ktxjName = ktxjName;}
public String getKtPic() {return ktPic;}
public void setKtPic(String ktPic) {this.ktPic = ktPic;}
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 Lbt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String lbtName;
//图片
private String lbtPic;
//链接
private String url;
public String getLbtName() {return lbtName;}
public void setLbtName(String lbtName) {this.lbtName = lbtName;}
public String getLbtPic() {return lbtPic;}
public void setLbtPic(String lbtPic) {this.lbtPic = lbtPic;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}评论javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//评论
public class Pinglun extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//评论信息
private Integer wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer 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;}
}视频javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//视频
public class Radios extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String radiosName;
//视频
private String radiosUrl;
//内容
private String radiosContent;
//日期
private String radiosDate;
public String getRadiosName() {return radiosName;}
public void setRadiosName(String radiosName) {this.radiosName = radiosName;}
public String getRadiosUrl() {return radiosUrl;}
public void setRadiosUrl(String radiosUrl) {this.radiosUrl = radiosUrl;}
public String getRadiosContent() {return radiosContent;}
public void setRadiosContent(String radiosContent) {this.radiosContent = radiosContent;}
public String getRadiosDate() {return radiosDate;}
public void setRadiosDate(String radiosDate) {this.radiosDate = radiosDate;}
}我的消息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//我的消息
public class Wdxx 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 pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
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 Xw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String xwName;
//图片
private String xwPic;
//内容
private String xwContent;
//日期
private String xwDate;
public String getXwName() {return xwName;}
public void setXwName(String xwName) {this.xwName = xwName;}
public String getXwPic() {return xwPic;}
public void setXwPic(String xwPic) {this.xwPic = xwPic;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}预约练车javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//预约练车
public class Yylc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//预约练车说明
private String content;
//预约时间
private String yyDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
}在线报名javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//在线报名
public class Zxbm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//驾校
private Integer jxId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJxId() {return jxId;}
public void setJxId(Integer jxId) {this.jxId = jxId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}