交通事故学习系统

交通事故学习系统登录注册界面

交通事故学习系统mysql数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

用户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	cp varchar(100) comment '车牌号',
	jsz varchar(100) comment '驾驶证号',
	headPic varchar(100) comment '头像',
	address varchar(100) comment '住址',
	email varchar(100) comment '邮箱'
) comment '用户';

违法类型表创建语句如下:


create table t_types(
	id int primary key auto_increment comment '主键',
	typesName varchar(100) comment '类型名称'
) comment '违法类型';

违法行为表创建语句如下:


create table t_wfxw(
	id int primary key auto_increment comment '主键',
	typesId int comment '类型',
	customerId int comment '用户',
	mc varchar(100) comment '违法说明',
	picOne varchar(100) comment '违法图片一',
	picTwo varchar(100) comment '违法图片二',
	picThree varchar(100) comment '违法图片三',
	wfDate varchar(100) comment '违法日期',
	wfAddress varchar(100) comment '违法地址'
) comment '违法行为';

学习情况表创建语句如下:


create table t_xxqk(
	id int primary key auto_increment comment '主键',
	spId int comment '视频',
	customerId int comment '用户',
	insertDate datetime comment '日期'
) comment '学习情况';

学习视频表创建语句如下:


create table t_xxsp(
	id int primary key auto_increment comment '主键',
	typesId int comment '类型',
	spName varchar(100) comment '视频名称',
	url varchar(100) comment '地址',
	content varchar(100) comment '内容'
) comment '学习视频';

交通事故学习系统oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	idcard varchar(100),
	cp varchar(100),
	jsz varchar(100),
	headPic varchar(100),
	address varchar(100),
	email 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.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.phone is '电话';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.cp is '车牌号';
comment on column t_customer.jsz is '驾驶证号';
comment on column t_customer.headPic is '头像';
comment on column t_customer.address is '住址';
comment on column t_customer.email is '邮箱';
--用户表加注释
comment on table t_customer is '用户';

违法类型表创建语句如下:


create table t_types(
	id integer,
	typesName varchar(100)
);
--违法类型字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '类型名称';
--违法类型表加注释
comment on table t_types is '违法类型';

违法行为表创建语句如下:


create table t_wfxw(
	id integer,
	typesId int,
	customerId int,
	mc varchar(100),
	picOne varchar(100),
	picTwo varchar(100),
	picThree varchar(100),
	wfDate varchar(100),
	wfAddress varchar(100)
);
--违法行为字段加注释
comment on column t_wfxw.id is '主键';
comment on column t_wfxw.typesId is '类型';
comment on column t_wfxw.customerId is '用户';
comment on column t_wfxw.mc is '违法说明';
comment on column t_wfxw.picOne is '违法图片一';
comment on column t_wfxw.picTwo is '违法图片二';
comment on column t_wfxw.picThree is '违法图片三';
comment on column t_wfxw.wfDate is '违法日期';
comment on column t_wfxw.wfAddress is '违法地址';
--违法行为表加注释
comment on table t_wfxw is '违法行为';

学习情况表创建语句如下:


create table t_xxqk(
	id integer,
	spId int,
	customerId int,
	insertDate datetime
);
--学习情况字段加注释
comment on column t_xxqk.id is '主键';
comment on column t_xxqk.spId is '视频';
comment on column t_xxqk.customerId is '用户';
comment on column t_xxqk.insertDate is '日期';
--学习情况表加注释
comment on table t_xxqk is '学习情况';

学习视频表创建语句如下:


create table t_xxsp(
	id integer,
	typesId int,
	spName varchar(100),
	url varchar(100),
	content varchar(100)
);
--学习视频字段加注释
comment on column t_xxsp.id is '主键';
comment on column t_xxsp.typesId is '类型';
comment on column t_xxsp.spName is '视频名称';
comment on column t_xxsp.url is '地址';
comment on column t_xxsp.content is '内容';
--学习视频表加注释
comment on table t_xxsp is '学习视频';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_types;
create sequence s_t_wfxw;
create sequence s_t_xxqk;
create sequence s_t_xxsp;

交通事故学习系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

用户表创建语句如下:


--用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	cp varchar(100),--车牌号
	jsz varchar(100),--驾驶证号
	headPic varchar(100),--头像
	address varchar(100),--住址
	email varchar(100)--邮箱
);

违法类型表创建语句如下:


--违法类型表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName varchar(100)--类型名称
);

违法行为表创建语句如下:


--违法行为表注释
create table t_wfxw(
	id int identity(1,1) primary key not null,--主键
	typesId int,--类型
	customerId int,--用户
	mc varchar(100),--违法说明
	picOne varchar(100),--违法图片一
	picTwo varchar(100),--违法图片二
	picThree varchar(100),--违法图片三
	wfDate varchar(100),--违法日期
	wfAddress varchar(100)--违法地址
);

学习情况表创建语句如下:


--学习情况表注释
create table t_xxqk(
	id int identity(1,1) primary key not null,--主键
	spId int,--视频
	customerId int,--用户
	insertDate datetime--日期
);

学习视频表创建语句如下:


--学习视频表注释
create table t_xxsp(
	id int identity(1,1) primary key not null,--主键
	typesId int,--类型
	spName varchar(100),--视频名称
	url varchar(100),--地址
	content 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_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 sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
//车牌号
private String cp;
//驾驶证号
private String jsz;
//头像
private String headPic;
//住址
private String address;
//邮箱
private String email;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public String getJsz() {return jsz;}
public void setJsz(String jsz) {this.jsz = jsz;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
}

违法类型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_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

违法行为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_wfxw")
public class Wfxw {
//主键
@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 typesId;
//用户
private Integer customerId;
//违法说明
private String mc;
//违法图片一
private String picOne;
//违法图片二
private String picTwo;
//违法图片三
private String picThree;
//违法日期
private String wfDate;
//违法地址
private String wfAddress;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getPicOne() {return picOne;}
public void setPicOne(String picOne) {this.picOne = picOne;}
public String getPicTwo() {return picTwo;}
public void setPicTwo(String picTwo) {this.picTwo = picTwo;}
public String getPicThree() {return picThree;}
public void setPicThree(String picThree) {this.picThree = picThree;}
public String getWfDate() {return wfDate;}
public void setWfDate(String wfDate) {this.wfDate = wfDate;}
public String getWfAddress() {return wfAddress;}
public void setWfAddress(String wfAddress) {this.wfAddress = wfAddress;}
}

学习情况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_xxqk")
public class Xxqk {
//主键
@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 spId;
//用户
private Integer customerId;
//日期
private Date insertDate;
public Integer getSpId() {return spId;}
public void setSpId(Integer spId) {this.spId = spId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

学习视频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_xxsp")
public class Xxsp {
//主键
@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 typesId;
//视频名称
private String spName;
//地址
private String url;
//内容
private String content;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

交通事故学习系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

用户javaBean创建语句如下:


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

//用户
public class Customer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
//车牌号
private String cp;
//驾驶证号
private String jsz;
//头像
private String headPic;
//住址
private String address;
//邮箱
private String email;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public String getJsz() {return jsz;}
public void setJsz(String jsz) {this.jsz = jsz;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
}

违法类型javaBean创建语句如下:


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

//违法类型
public class Types  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

违法行为javaBean创建语句如下:


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

//违法行为
public class Wfxw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private Integer typesId;
//用户
private Integer customerId;
//违法说明
private String mc;
//违法图片一
private String picOne;
//违法图片二
private String picTwo;
//违法图片三
private String picThree;
//违法日期
private String wfDate;
//违法地址
private String wfAddress;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getPicOne() {return picOne;}
public void setPicOne(String picOne) {this.picOne = picOne;}
public String getPicTwo() {return picTwo;}
public void setPicTwo(String picTwo) {this.picTwo = picTwo;}
public String getPicThree() {return picThree;}
public void setPicThree(String picThree) {this.picThree = picThree;}
public String getWfDate() {return wfDate;}
public void setWfDate(String wfDate) {this.wfDate = wfDate;}
public String getWfAddress() {return wfAddress;}
public void setWfAddress(String wfAddress) {this.wfAddress = wfAddress;}
}

学习情况javaBean创建语句如下:


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

//学习情况
public class Xxqk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//视频
private Integer spId;
//用户
private Integer customerId;
//日期
private Date insertDate;
public Integer getSpId() {return spId;}
public void setSpId(Integer spId) {this.spId = spId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

学习视频javaBean创建语句如下:


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

//学习视频
public class Xxsp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private Integer typesId;
//视频名称
private String spName;
//地址
private String url;
//内容
private String content;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

源代码下载点这里

评论