Java毕业设计_申通物流车辆调度系统设计与实现

申通物流车辆调度系统设计和实现

申通物流车辆调度系统设计和实现mysql数据库创建语句
申通物流车辆调度系统设计和实现oracle数据库创建语句
申通物流车辆调度系统设计和实现sqlserver数据库创建语句
申通物流车辆调度系统设计和实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
申通物流车辆调度系统设计和实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
申通物流车辆调度系统设计和实现登录注册界面
高质量编程视频：shangyepingtai.xin
申通物流车辆调度系统设计和实现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’);
SQLCopy
车辆表创建语句如下：

create table t_car(
id int primary key auto_increment comment ‘主键’,
carName varchar(100) comment ‘车辆编号’,
pic varchar(100) comment ‘图片’,
pz varchar(100) comment ‘牌照’,
bz varchar(100) comment ‘备注’,
status varchar(100) comment ‘状态’
) comment ‘车辆’;
SQLCopy
车辆申请表创建语句如下：

create table t_clsq(
id int primary key auto_increment comment ‘主键’,
carId int comment ‘车辆’,
jsyId int comment ‘驾驶员’,
title varchar(100) comment ‘标题’,
showDate datetime comment ‘日期’,
content varchar(100) comment ‘理由’
) comment ‘车辆申请’;
SQLCopy
用户表创建语句如下：

create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
customerName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
address varchar(100) comment ‘地址’
) comment ‘用户’;
SQLCopy
费用登记表创建语句如下：

create table t_fytj(
id int primary key auto_increment comment ‘主键’,
carId int comment ‘车辆’,
types varchar(100) comment ‘费用类型’,
fee int comment ‘金额’,
pic varchar(100) comment ‘发票’,
djrq datetime comment ‘日期’
) comment ‘费用登记’;
SQLCopy
回车登记表创建语句如下：

create table t_hcdj(
id int primary key auto_increment comment ‘主键’,
carId int comment ‘车辆’,
hcrq datetime comment ‘回车日期’,
content varchar(100) comment ‘备注’
) comment ‘回车登记’;
SQLCopy
驾驶员表创建语句如下：

create table t_jsy(
id int primary key auto_increment comment ‘主键’,
jsyName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
address varchar(100) comment ‘地址’
) comment ‘驾驶员’;
SQLCopy
派遣车辆表创建语句如下：

create table t_pqcl(
id int primary key auto_increment comment ‘主键’,
carId int comment ‘车辆’,
showDate datetime comment ‘日期’,
content varchar(100) comment ‘说明’,
jsyId int comment ‘驾驶员’
) comment ‘派遣车辆’;
SQLCopy
维保登记表创建语句如下：

create table t_wbdj(
id int primary key auto_increment comment ‘主键’,
carId int comment ‘车辆’,
wbnr varchar(100) comment ‘维保内容’,
wbdjrq datetime comment ‘日期’,
status varchar(100) comment ‘状态’,
content varchar(100) comment ‘结果’
) comment ‘维保登记’;
SQLCopy
申通物流车辆调度系统设计和实现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 ‘超级管理员’;
SQLCopy
车辆表创建语句如下：

create table t_car(
id integer,
carName varchar(100),
pic varchar(100),
pz varchar(100),
bz varchar(100),
status varchar(100)
);
–车辆字段加注释
comment on column t_car.id is ‘主键’;
comment on column t_car.carName is ‘车辆编号’;
comment on column t_car.pic is ‘图片’;
comment on column t_car.pz is ‘牌照’;
comment on column t_car.bz is ‘备注’;
comment on column t_car.status is ‘状态’;
–车辆表加注释
comment on table t_car is ‘车辆’;
SQLCopy
车辆申请表创建语句如下：

create table t_clsq(
id integer,
carId int,
jsyId int,
title varchar(100),
showDate datetime,
content varchar(100)
);
–车辆申请字段加注释
comment on column t_clsq.id is ‘主键’;
comment on column t_clsq.carId is ‘车辆’;
comment on column t_clsq.jsyId is ‘驾驶员’;
comment on column t_clsq.title is ‘标题’;
comment on column t_clsq.showDate is ‘日期’;
comment on column t_clsq.content is ‘理由’;
–车辆申请表加注释
comment on table t_clsq is ‘车辆申请’;
SQLCopy
用户表创建语句如下：

create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
address 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.phone is ‘电话’;
comment on column t_customer.age is ‘年龄’;
comment on column t_customer.sex is ‘性别’;
comment on column t_customer.address is ‘地址’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
费用登记表创建语句如下：

create table t_fytj(
id integer,
carId int,
types varchar(100),
fee int,
pic varchar(100),
djrq datetime
);
–费用登记字段加注释
comment on column t_fytj.id is ‘主键’;
comment on column t_fytj.carId is ‘车辆’;
comment on column t_fytj.types is ‘费用类型’;
comment on column t_fytj.fee is ‘金额’;
comment on column t_fytj.pic is ‘发票’;
comment on column t_fytj.djrq is ‘日期’;
–费用登记表加注释
comment on table t_fytj is ‘费用登记’;
SQLCopy
回车登记表创建语句如下：

create table t_hcdj(
id integer,
carId int,
hcrq datetime,
content varchar(100)
);
–回车登记字段加注释
comment on column t_hcdj.id is ‘主键’;<