驾校管理系统设计和实现

驾校管理系统设计和实现登录注册界面

驾校管理系统设计和实现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_fpxy(
	id int primary key auto_increment comment '主键',
	studentId int comment '学员',
	teacherId int comment '教练',
	remark varchar(100) comment '备注'
) comment '分配学员';

考试信息表创建语句如下:


create table t_ksxx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '考试信息';

普通管理员表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '普通管理员';

学员表创建语句如下:


create table t_student(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	studentName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	qq varchar(100) comment 'QQ',
	email varchar(100) comment '邮箱',
	pic varchar(100) 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	clfe varchar(100) comment '车辆分配(牌照)',
	status varchar(100) comment '状态'
) comment '教练';

学员补考表创建语句如下:


create table t_xybk(
	id int primary key auto_increment comment '主键',
	studentId int comment '学员',
	bkDate datetime comment '补考日期',
	fee int comment '补考金额',
	remark varchar(100) comment '备注'
) comment '学员补考';

学员报名表创建语句如下:


create table t_xybm(
	id int primary key auto_increment comment '主键',
	studentId int comment '学员',
	bmrq datetime comment '报名日期',
	fee int comment '金额',
	remark varchar(100) comment '备注'
) comment '学员报名';

学员退学表创建语句如下:


create table t_xytx(
	id int primary key auto_increment comment '主键',
	studentId int comment '学员',
	txrq datetime comment '退学日期',
	fee int comment '回退金额',
	remark varchar(100) comment '备注'
) comment '学员退学';

员工工资表创建语句如下:


create table t_yggz(
	id int primary key auto_increment comment '主键',
	teacherId int comment '教练',
	bkDate datetime comment '工资日期',
	fee int comment '工资额',
	remark varchar(100) comment '备注'
) comment '员工工资';

预约考试表创建语句如下:


create table t_yyks(
	id int primary key auto_increment comment '主键',
	studentId int comment '学员',
	yyDate datetime comment '预约日期',
	kstp varchar(100) comment '考试图片',
	kswj varchar(100) comment '考试文件',
	cj1 int comment '第一科目成绩',
	cj2 int comment '第二科目成绩',
	cj3 int comment '第三科目成绩',
	status varchar(100) comment '状态'
) comment '预约考试';

预约练车表创建语句如下:


create table t_yyxc(
	id int primary key auto_increment comment '主键',
	studentId int comment '学员',
	yyDate datetime comment '预约日期',
	cx varchar(100) comment '车型',
	remark varchar(100) comment '记录内容',
	jd int comment '进度',
	status 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_fpxy(
	id integer,
	studentId int,
	teacherId int,
	remark varchar(100)
);
--分配学员字段加注释
comment on column t_fpxy.id is '主键';
comment on column t_fpxy.studentId is '学员';
comment on column t_fpxy.teacherId is '教练';
comment on column t_fpxy.remark is '备注';
--分配学员表加注释
comment on table t_fpxy is '分配学员';

考试信息表创建语句如下:


create table t_ksxx(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--考试信息字段加注释
comment on column t_ksxx.id is '主键';
comment on column t_ksxx.title is '标题';
comment on column t_ksxx.pic is '图片';
comment on column t_ksxx.content is '内容';
comment on column t_ksxx.showDate is '日期';
--考试信息表加注释
comment on table t_ksxx is '考试信息';

普通管理员表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

学员表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	qq varchar(100),
	email varchar(100),
	pic varchar(100),
	status varchar(100)
);
--学员字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码 ';
comment on column t_student.studentName is '姓名';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.qq is 'QQ';
comment on column t_student.email is '邮箱';
comment on column t_student.pic is '头像';
comment on column t_student.status is '状态';
--学员表加注释
comment on table t_student is '学员';

教练表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	clfe varchar(100),
	status 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.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.pic is '头像';
comment on column t_teacher.clfe is '车辆分配(牌照)';
comment on column t_teacher.status is '状态';
--教练表加注释
comment on table t_teacher is '教练';

学员补考表创建语句如下:


create table t_xybk(
	id integer,
	studentId int,
	bkDate datetime,
	fee int,
	remark varchar(100)
);
--学员补考字段加注释
comment on column t_xybk.id is '主键';
comment on column t_xybk.studentId is '学员';
comment on column t_xybk.bkDate is '补考日期';
comment on column t_xybk.fee is '补考金额';
comment on column t_xybk.remark is '备注';
--学员补考表加注释
comment on table t_xybk is '学员补考';

学员报名表创建语句如下:


create table t_xybm(
	id integer,
	studentId int,
	bmrq datetime,
	fee int,
	remark varchar(100)
);
--学员报名字段加注释
comment on column t_xybm.id is '主键';
comment on column t_xybm.studentId is '学员';
comment on column t_xybm.bmrq is '报名日期';
comment on column t_xybm.fee is '金额';
comment on column t_xybm.remark is '备注';
--学员报名表加注释
comment on table t_xybm is '学员报名';

学员退学表创建语句如下:


create table t_xytx(
	id integer,
	studentId int,
	txrq datetime,
	fee int,
	remark varchar(100)
);
--学员退学字段加注释
comment on column t_xytx.id is '主键';
comment on column t_xytx.studentId is '学员';
comment on column t_xytx.txrq is '退学日期';
comment on column t_xytx.fee is '回退金额';
comment on column t_xytx.remark is '备注';
--学员退学表加注释
comment on table t_xytx is '学员退学';

员工工资表创建语句如下:


create table t_yggz(
	id integer,
	teacherId int,
	bkDate datetime,
	fee int,
	remark varchar(100)
);
--员工工资字段加注释
comment on column t_yggz.id is '主键';
comment on column t_yggz.teacherId is '教练';
comment on column t_yggz.bkDate is '工资日期';
comment on column t_yggz.fee is '工资额';
comment on column t_yggz.remark is '备注';
--员工工资表加注释
comment on table t_yggz is '员工工资';

预约考试表创建语句如下:


create table t_yyks(
	id integer,
	studentId int,
	yyDate datetime,
	kstp varchar(100),
	kswj varchar(100),
	cj1 int,
	cj2 int,
	cj3 int,
	status varchar(100)
);
--预约考试字段加注释
comment on column t_yyks.id is '主键';
comment on column t_yyks.studentId is '学员';
comment on column t_yyks.yyDate is '预约日期';
comment on column t_yyks.kstp is '考试图片';
comment on column t_yyks.kswj is '考试文件';
comment on column t_yyks.cj1 is '第一科目成绩';
comment on column t_yyks.cj2 is '第二科目成绩';
comment on column t_yyks.cj3 is '第三科目成绩';
comment on column t_yyks.status is '状态';
--预约考试表加注释
comment on table t_yyks is '预约考试';

预约练车表创建语句如下:


create table t_yyxc(
	id integer,
	studentId int,
	yyDate datetime,
	cx varchar(100),
	remark varchar(100),
	jd int,
	status varchar(100)
);
--预约练车字段加注释
comment on column t_yyxc.id is '主键';
comment on column t_yyxc.studentId is '学员';
comment on column t_yyxc.yyDate is '预约日期';
comment on column t_yyxc.cx is '车型';
comment on column t_yyxc.remark is '记录内容';
comment on column t_yyxc.jd is '进度';
comment on column t_yyxc.status is '状态';
--预约练车表加注释
comment on table t_yyxc is '预约练车';

oracle特有,对应序列如下:


create sequence s_t_fpxy;
create sequence s_t_ksxx;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_xybk;
create sequence s_t_xybm;
create sequence s_t_xytx;
create sequence s_t_yggz;
create sequence s_t_yyks;
create sequence s_t_yyxc;

驾校管理系统设计和实现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_fpxy(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学员
	teacherId int,--教练
	remark varchar(100)--备注
);

考试信息表创建语句如下:


--考试信息表注释
create table t_ksxx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate datetime--日期
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

学员表创建语句如下:


--学员表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	studentName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	qq varchar(100),--QQ
	email varchar(100),--邮箱
	pic varchar(100),--头像
	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),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	clfe varchar(100),--车辆分配(牌照)
	status varchar(100)--状态
);

学员补考表创建语句如下:


--学员补考表注释
create table t_xybk(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学员
	bkDate datetime,--补考日期
	fee int,--补考金额
	remark varchar(100)--备注
);

学员报名表创建语句如下:


--学员报名表注释
create table t_xybm(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学员
	bmrq datetime,--报名日期
	fee int,--金额
	remark varchar(100)--备注
);

学员退学表创建语句如下:


--学员退学表注释
create table t_xytx(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学员
	txrq datetime,--退学日期
	fee int,--回退金额
	remark varchar(100)--备注
);

员工工资表创建语句如下:


--员工工资表注释
create table t_yggz(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--教练
	bkDate datetime,--工资日期
	fee int,--工资额
	remark varchar(100)--备注
);

预约考试表创建语句如下:


--预约考试表注释
create table t_yyks(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学员
	yyDate datetime,--预约日期
	kstp varchar(100),--考试图片
	kswj varchar(100),--考试文件
	cj1 int,--第一科目成绩
	cj2 int,--第二科目成绩
	cj3 int,--第三科目成绩
	status varchar(100)--状态
);

预约练车表创建语句如下:


--预约练车表注释
create table t_yyxc(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学员
	yyDate datetime,--预约日期
	cx varchar(100),--车型
	remark varchar(100),--记录内容
	jd int,--进度
	status varchar(100)--状态
);

驾校管理系统设计和实现登录后主页

驾校管理系统设计和实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

分配学员javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//分配学员
@Table(name = "t_fpxy")
public class Fpxy {
//主键
@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 studentId;
//教练
private Integer teacherId;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
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_ksxx")
public class Ksxx {
//主键
@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 pic;
//内容
private String content;
//日期
private Date showDate;
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

普通管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

学员javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//学员
@Table(name = "t_student")
public class Student {
//主键
@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 studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//QQ
private String qq;
//邮箱
private String email;
//头像
private String pic;
//状态
private String status;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//车辆分配(牌照)
private String clfe;
//状态
private String status;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getClfe() {return clfe;}
public void setClfe(String clfe) {this.clfe = clfe;}
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_xybk")
public class Xybk {
//主键
@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 studentId;
//补考日期
private Date bkDate;
//补考金额
private Integer fee;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getBkDate() {return bkDate;}
public void setBkDate(Date bkDate) {this.bkDate = bkDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_xybm")
public class Xybm {
//主键
@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 studentId;
//报名日期
private Date bmrq;
//金额
private Integer fee;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getBmrq() {return bmrq;}
public void setBmrq(Date bmrq) {this.bmrq = bmrq;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_xytx")
public class Xytx {
//主键
@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 studentId;
//退学日期
private Date txrq;
//回退金额
private Integer fee;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getTxrq() {return txrq;}
public void setTxrq(Date txrq) {this.txrq = txrq;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_yggz")
public class Yggz {
//主键
@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 teacherId;
//工资日期
private Date bkDate;
//工资额
private Integer fee;
//备注
private String remark;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getBkDate() {return bkDate;}
public void setBkDate(Date bkDate) {this.bkDate = bkDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_yyks")
public class Yyks {
//主键
@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 studentId;
//预约日期
private Date yyDate;
//考试图片
private String kstp;
//考试文件
private String kswj;
//第一科目成绩
private Integer cj1;
//第二科目成绩
private Integer cj2;
//第三科目成绩
private Integer cj3;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getKstp() {return kstp;}
public void setKstp(String kstp) {this.kstp = kstp;}
public String getKswj() {return kswj;}
public void setKswj(String kswj) {this.kswj = kswj;}
public Integer getCj1() {return cj1;}
public void setCj1(Integer cj1) {this.cj1 = cj1;}
public Integer getCj2() {return cj2;}
public void setCj2(Integer cj2) {this.cj2 = cj2;}
public Integer getCj3() {return cj3;}
public void setCj3(Integer cj3) {this.cj3 = cj3;}
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_yyxc")
public class Yyxc {
//主键
@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 studentId;
//预约日期
private Date yyDate;
//车型
private String cx;
//记录内容
private String remark;
//进度
private Integer jd;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getCx() {return cx;}
public void setCx(String cx) {this.cx = cx;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getJd() {return jd;}
public void setJd(Integer jd) {this.jd = jd;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

驾校管理系统设计和实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

分配学员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//分配学员
public class Fpxy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Integer studentId;
//教练
private Integer teacherId;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
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 Ksxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

普通管理员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//普通管理员
public class Ptadmin  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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

学员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//学员
public class Student  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 studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//QQ
private String qq;
//邮箱
private String email;
//头像
private String pic;
//状态
private String status;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//车辆分配(牌照)
private String clfe;
//状态
private String status;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getClfe() {return clfe;}
public void setClfe(String clfe) {this.clfe = clfe;}
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 Xybk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Integer studentId;
//补考日期
private Date bkDate;
//补考金额
private Integer fee;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getBkDate() {return bkDate;}
public void setBkDate(Date bkDate) {this.bkDate = bkDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Xybm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Integer studentId;
//报名日期
private Date bmrq;
//金额
private Integer fee;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getBmrq() {return bmrq;}
public void setBmrq(Date bmrq) {this.bmrq = bmrq;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Xytx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Integer studentId;
//退学日期
private Date txrq;
//回退金额
private Integer fee;
//备注
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getTxrq() {return txrq;}
public void setTxrq(Date txrq) {this.txrq = txrq;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Yggz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教练
private Integer teacherId;
//工资日期
private Date bkDate;
//工资额
private Integer fee;
//备注
private String remark;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getBkDate() {return bkDate;}
public void setBkDate(Date bkDate) {this.bkDate = bkDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Yyks  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Integer studentId;
//预约日期
private Date yyDate;
//考试图片
private String kstp;
//考试文件
private String kswj;
//第一科目成绩
private Integer cj1;
//第二科目成绩
private Integer cj2;
//第三科目成绩
private Integer cj3;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getKstp() {return kstp;}
public void setKstp(String kstp) {this.kstp = kstp;}
public String getKswj() {return kswj;}
public void setKswj(String kswj) {this.kswj = kswj;}
public Integer getCj1() {return cj1;}
public void setCj1(Integer cj1) {this.cj1 = cj1;}
public Integer getCj2() {return cj2;}
public void setCj2(Integer cj2) {this.cj2 = cj2;}
public Integer getCj3() {return cj3;}
public void setCj3(Integer cj3) {this.cj3 = cj3;}
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 Yyxc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学员
private Integer studentId;
//预约日期
private Date yyDate;
//车型
private String cx;
//记录内容
private String remark;
//进度
private Integer jd;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getCx() {return cx;}
public void setCx(String cx) {this.cx = cx;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getJd() {return jd;}
public void setJd(Integer jd) {this.jd = jd;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

源代码下载点这里

评论