Java毕业设计_基于spring的一汽大众4s店汽车销售系统的设计与实现

基于spring的一汽大众4s店汽车销售系统的设计与实现

基于spring的一汽大众4s店汽车销售系统的设计与实现mysql数据库创建语句
基于spring的一汽大众4s店汽车销售系统的设计与实现oracle数据库创建语句
基于spring的一汽大众4s店汽车销售系统的设计与实现sqlserver数据库创建语句
基于spring的一汽大众4s店汽车销售系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于spring的一汽大众4s店汽车销售系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频：shangyepingtai.xin
基于spring的一汽大众4s店汽车销售系统的设计与实现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_ck(
id int primary key auto_increment comment ‘主键’,
pp varchar(100) comment ‘品牌’,
cx varchar(100) comment ‘车型’,
bxdh varchar(100) comment ‘保修单号’,
fwdh varchar(100) comment ‘服务单号’,
showDate datetime comment ‘出库时间’,
clbh varchar(100) comment ‘车辆编号’,
czr 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 ‘姓名’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’,
pic varchar(100) comment ‘头像’
) comment ‘客户’;
SQLCopy
员工表创建语句如下：

create table t_employeename(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment '密码 ',
employeeName varchar(100) comment ‘姓名’,
gh varchar(100) comment ‘工号’,
zw varchar(100) comment ‘职务’,
xl varchar(100) comment ‘学历’,
rzsj datetime comment ‘入职时间’,
lzsj datetime comment ‘离职时间’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’
) comment ‘员工’;
SQLCopy
名品汽车库存表创建语句如下：

create table t_kc(
id int primary key auto_increment comment ‘主键’,
pp varchar(100) comment ‘品牌’,
cx varchar(100) comment ‘车型’,
kcsl int comment ‘库存数量’,
pz varchar(100) comment ‘车辆编号’
) comment ‘名品汽车库存’;
SQLCopy
客户购买信息表创建语句如下：

create table t_khgc(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘客户’,
pp varchar(100) comment ‘品牌’,
cx varchar(100) comment ‘车型’,
fee int comment ‘购买金额’,
gmsj datetime comment ‘购买时间’,
phone varchar(100) comment ‘电话’,
pic varchar(100) comment ‘图片’,
fk varchar(100) comment ‘客户反馈内容’,
fkcode int comment ‘客户反馈分数’,
employeeId int comment ‘’
) comment ‘客户购买信息’;
SQLCopy
入库表创建语句如下：

create table t_rk(
id int primary key auto_increment comment ‘主键’,
pp varchar(100) comment ‘品牌’,
cx varchar(100) comment ‘车型’,
bxdh varchar(100) comment ‘入库单号’,
showDate datetime comment ‘入库时间’,
clbh varchar(100) comment ‘车辆编号’,
czr varchar(100) comment ‘操作人’
) comment ‘入库’;
SQLCopy
售后服务表创建语句如下：

create table t_shfw(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘客户’,
pp varchar(100) comment ‘品牌’,
cx varchar(100) comment ‘车型’,
v1 varchar(100) comment ‘维修记录’,
v2 varchar(100) comment ‘保修单号’,
v3 varchar(100) comment ‘服务编号’,
showDate datetime comment ‘服务时间’,
phone varchar(100) comment ‘电话’,
status varchar(100) comment ‘状态’
) comment ‘售后服务’;
SQLCopy
客户试驾信息表创建语句如下：

create table t_yysj(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘客户’,
pp varchar(100) comment ‘品牌’,
cx varchar(100) comment ‘车型’,
sjDate datetime comment ‘试驾时间’,
phone varchar(100) comment ‘电话’,
status varchar(100) comment ‘状态’
) comment ‘客户试驾信息’;
SQLCopy
基于spring的一汽大众4s店汽车销售系统的设计与实现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_ck(
id integer,
pp varchar(100),
cx varchar(100),
bxdh varchar(100),
fwdh varchar(100),
showDate datetime,
clbh varchar(100),
czr varchar(100)
);
–出库字段加注释
comment on column t_ck.id is ‘主键’;
comment on column t_ck.pp is ‘品牌’;
comment on column t_ck.cx is ‘车型’;
comment on column t_ck.bxdh is ‘保修单号’;
comment on column t_ck.fwdh is ‘服务单号’;
comment on column t_ck.showDate is ‘出库时间’;
comment on column t_ck.clbh is ‘车辆编号’;
comment on column t_ck.czr is ‘操作人’;
–出库表加注释
comment on table t_ck is ‘出库’;
SQLCopy
客户表创建语句如下：

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

create table t_employeename(
id integer,
username varchar(100),
password varchar(100),
employeeName varchar(100),
gh varchar(100),
zw varchar(100),
xl varchar(100),
rzsj datetime,
lzsj datetime,
age varchar(100),
sex varchar(100),
phone varchar(100)
);
–员工字段加注释
comment on column t_employeename.id is ‘主键’;
comment on column t_employeename.username is ‘账号’;
comment on column t_employeename.password is '密码 ';
comment on column t_employeename.employeeName is ‘姓名’;
comment on column t_employeename.gh is ‘工号’;
comment on column t_employeename.zw is ‘职务’;
comment on column t_employeename.xl is ‘学历’;
comment on column t_employeename.rzsj is ‘入职时间’;
comment on column t_employeename.lzsj is ‘离职时间’;
comment on column t_employeename.age is ‘年龄’;
comment on column t_employeename.sex is ‘性别’;
comment on column t_employeename.phone is ‘电话’;
–员工表加注释
comment on table t_employeename is ‘员工’;
SQLCopy
名品汽车库存表创建语句如下：

create table t_kc(
id integer,
pp varchar(100),
cx varchar(100),
kcsl int,
pz varchar(100)
);
–名品汽车库存字段加注释
comment on column t_kc.id is ‘主键’;
comment on column t_kc.pp is ‘品牌’;
comment on column t_kc.cx is ‘车型’;
comment on column t_kc.kcsl is ‘库存数量’;
comment on column t_kc.pz is ‘车辆编号’;
–名品汽车库存表加注释
comment on table t_kc is ‘名品汽车库存’;
SQLCopy
客户购买信息表创建语句如下：

create table t_khgc(
id integer,
customerId int,
pp varchar(100),
cx varchar(100),
fee int,
gmsj datetime,
phone varchar(100),
pic varchar(100),
fk varchar(100),
fkcode int,
employeeId int
);
–客户购买信息字段加注释
comment on column t_khgc.id is ‘主键’;
comment on column t_khgc.customerId is ‘客户’;
comment on column t_khgc.pp is ‘品牌’;
comment on column t_khgc.cx is ‘