- 汽车销售服务系统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_ck(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
gh varchar(100) comment '工号',
ckName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '仓库人员';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
customerName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pic varchar(100) comment '头像',
jb varchar(100) comment '级别'
) comment '用户';
财务人员表创建语句如下：
create table t_cw(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
gh varchar(100) comment '工号',
cwName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '财务人员';
供应商业务表创建语句如下：
create table t_gys(
id int primary key auto_increment comment '主键',
gysName varchar(100) comment '供应商',
qclj varchar(100) comment '汽车零件名称',
nums int comment '数量',
zj int comment '总价',
showDate datetime comment '日期'
) comment '供应商业务';
零配件出库入库记录表创建语句如下：
create table t_lpjckrk(
id int primary key auto_increment comment '主键',
ckId int comment '仓库人员',
title varchar(100) comment '配件名称',
nums varchar(100) comment '数量',
types varchar(100) comment '出库入库',
showDate datetime comment '日期'
) comment '零配件出库入库记录';
汽车出库入库记录表创建语句如下：
create table t_qcckrk(
id int primary key auto_increment comment '主键',
ckId int comment '仓库人员',
title varchar(100) comment '车型编号',
pic varchar(100) comment '图片',
types varchar(100) comment '出库入库',
showDate datetime comment '日期',
je int comment ''
) comment '汽车出库入库记录';
维修人员表创建语句如下：
create table t_wx(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
gh varchar(100) comment '工号',
wxName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '维修人员';
销售人员表创建语句如下：
create table t_xs(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
gh varchar(100) comment '工号',
xsName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '销售人员';
销售信息表创建语句如下：
create table t_xsxx(
id int primary key auto_increment comment '主键',
xsId int comment '销售人员',
title varchar(100) comment '车型编号',
pic varchar(100) comment '图片',
kh varchar(100) comment '客户名称',
lxdh varchar(100) comment '联系电话',
zfss varchar(100) comment '支付方式',
fee int comment '价格',
showDate datetime comment '日期'
) comment '销售信息';
预约维修表创建语句如下：
create table t_yywx(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '客户姓名',
v2 varchar(100) comment '电话',
v3 varchar(100) comment '车辆型号',
v4 datetime comment '维修日期',
v5 varchar(100) comment '申请零配件',
status varchar(100) comment '状态',
fee int 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_ck(
id integer,
username varchar(100),
password varchar(100),
gh varchar(100),
ckName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--仓库人员字段加注释
comment on column t_ck.id is '主键';
comment on column t_ck.username is '账号';
comment on column t_ck.password is '密码';
comment on column t_ck.gh is '工号';
comment on column t_ck.ckName is '姓名';
comment on column t_ck.age is '年龄';
comment on column t_ck.sex is '性别';
comment on column t_ck.phone is '电话';
--仓库人员表加注释
comment on table t_ck is '仓库人员';
用户表创建语句如下：
create table t_customer(
id integer,
customerName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic varchar(100),
jb varchar(100)
);
--用户字段加注释
comment on column t_customer.id 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 column t_customer.jb is '级别';
--用户表加注释
comment on table t_customer is '用户';
财务人员表创建语句如下：
create table t_cw(
id integer,
username varchar(100),
password varchar(100),
gh varchar(100),
cwName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--财务人员字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.username is '账号';
comment on column t_cw.password is '密码';
comment on column t_cw.gh is '工号';
comment on column t_cw.cwName is '姓名';
comment on column t_cw.age is '年龄';
comment on column t_cw.sex is '性别';
comment on column t_cw.phone is '电话';
--财务人员表加注释
comment on table t_cw is '财务人员';
供应商业务表创建语句如下：
create table t_gys(
id integer,
gysName varchar(100),
qclj varchar(100),
nums int,
zj int,
showDate datetime
);
--供应商业务字段加注释
comment on column t_gys.id is '主键';
comment on column t_gys.gysName is '供应商';
comment on column t_gys.qclj is '汽车零件名称';
comment on column t_gys.nums is '数量';
comment on column t_gys.zj is '总价';
comment on column t_gys.showDate is '日期';
--供应商业务表加注释
comment on table t_gys is '供应商业务';
零配件出库入库记录表创建语句如下：
create table t_lpjckrk(
id integer,
ckId int,
title varchar(100),
nums varchar(100),
types varchar(100),
showDate datetime
);
--零配件出库入库记录字段加注释
comment on column t_lpjckrk.id is '主键';
comment on column t_lpjckrk.ckId is '仓库人员';
comment on column t_lpjckrk.title is '配件名称';
comment on column t_lpjckrk.nums is '数量';
comment on column t_lpjckrk.types is '出库入库';
comment on column t_lpjckrk.showDate is '日期';
--零配件出库入库记录表加注释
comment on table t_lpjckrk is '零配件出库入库记录';
汽车出库入库记录表创建语句如下：
create table t_qcckrk(
id integer,
ckId int,
title varchar(100),
pic varchar(100),
types varchar(100),
showDate datetime,
je int
);
--汽车出库入库记录字段加注释
comment on column t_qcckrk.id is '主键';
comment on column t_qcckrk.ckId is '仓库人员';
comment on column t_qcckrk.title is '车型编号';
comment on column t_qcckrk.pic is '图片';
comment on column t_qcckrk.types is '出库入库';
comment on column t_qcckrk.showDate is '日期';
comment on column t_qcckrk.je is '';
--汽车出库入库记录表加注释
comment on table t_qcckrk is '汽车出库入库记录';
维修人员表创建语句如下：
create table t_wx(
id integer,
username varchar(100),
password varchar(100),
gh varchar(100),
wxName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--维修人员字段加注释
comment on column t_wx.id is '主键';
comment on column t_wx.username is '账号';
comment on column t_wx.password is '密码';
comment on column t_wx.gh is '工号';
comment on column t_wx.wxName is '姓名';
comment on column t_wx.age is '年龄';
comment on column t_wx.sex is '性别';
comment on column t_wx.phone is '电话';
--维修人员表加注释
comment on table t_wx is '维修人员';
销售人员表创建语句如下：
create table t_xs(
id integer,
username varchar(100),
password varchar(100),
gh varchar(100),
xsName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--销售人员字段加注释
comment on column t_xs.id is '主键';
comment on column t_xs.username is '账号';
comment on column t_xs.password is '密码';
comment on column t_xs.gh is '工号';
comment on column t_xs.xsName is '姓名';
comment on column t_xs.age is '年龄';
comment on column t_xs.sex is '性别';
comment on column t_xs.phone is '电话';
--销售人员表加注释
comment on table t_xs is '销售人员';
销售信息表创建语句如下：
create table t_xsxx(
id integer,
xsId int,
title varchar(100),
pic varchar(100),
kh varchar(100),
lxdh varchar(100),
zfss varchar(100),
fee int,
showDate datetime
);
--销售信息字段加注释
comment on column t_xsxx.id is '主键';
comment on column t_xsxx.xsId is '销售人员';
comment on column t_xsxx.title is '车型编号';
comment on column t_xsxx.pic is '图片';
comment on column t_xsxx.kh is '客户名称';
comment on column t_xsxx.lxdh is '联系电话';
comment on column t_xsxx.zfss is '支付方式';
comment on column t_xsxx.fee is '价格';
comment on column t_xsxx.showDate is '日期';
--销售信息表加注释
comment on table t_xsxx is '销售信息';
预约维修表创建语句如下：
create table t_yywx(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 datetime,
v5 varchar(100),
status varchar(100),
fee int
);
--预约维修字段加注释
comment on column t_yywx.id is '主键';
comment on column t_yywx.v1 is '客户姓名';
comment on column t_yywx.v2 is '电话';
comment on column t_yywx.v3 is '车辆型号';
comment on column t_yywx.v4 is '维修日期';
comment on column t_yywx.v5 is '申请零配件';
comment on column t_yywx.status is '状态';
comment on column t_yywx.fee is '金额';
--预约维修表加注释
comment on table t_yywx is '预约维修';
oracle特有，对应序列如下：
create sequence s_t_ck;
create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_gys;
create sequence s_t_lpjckrk;
create sequence s_t_qcckrk;
create sequence s_t_wx;
create sequence s_t_xs;
create sequence s_t_xsxx;
create sequence s_t_yywx;
汽车销售服务系统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_ck(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gh varchar(100),--工号
ckName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100)--电话
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
customerName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pic varchar(100),--头像
jb varchar(100)--级别
);
财务人员表创建语句如下：
--财务人员表注释
create table t_cw(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gh varchar(100),--工号
cwName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100)--电话
);
供应商业务表创建语句如下：
--供应商业务表注释
create table t_gys(
id int identity(1,1) primary key not null,--主键
gysName varchar(100),--供应商
qclj varchar(100),--汽车零件名称
nums int,--数量
zj int,--总价
showDate datetime--日期
);
零配件出库入库记录表创建语句如下：
--零配件出库入库记录表注释
create table t_lpjckrk(
id int identity(1,1) primary key not null,--主键
ckId int,--仓库人员
title varchar(100),--配件名称
nums varchar(100),--数量
types varchar(100),--出库入库
showDate datetime--日期
);
汽车出库入库记录表创建语句如下：
--汽车出库入库记录表注释
create table t_qcckrk(
id int identity(1,1) primary key not null,--主键
ckId int,--仓库人员
title varchar(100),--车型编号
pic varchar(100),--图片
types varchar(100),--出库入库
showDate datetime,--日期
je int--
);
维修人员表创建语句如下：
--维修人员表注释
create table t_wx(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gh varchar(100),--工号
wxName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100)--电话
);
销售人员表创建语句如下：
--销售人员表注释
create table t_xs(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gh varchar(100),--工号
xsName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100)--电话
);
销售信息表创建语句如下：
--销售信息表注释
create table t_xsxx(
id int identity(1,1) primary key not null,--主键
xsId int,--销售人员
title varchar(100),--车型编号
pic varchar(100),--图片
kh varchar(100),--客户名称
lxdh varchar(100),--联系电话
zfss varchar(100),--支付方式
fee int,--价格
showDate datetime--日期
);
预约维修表创建语句如下：
--预约维修表注释
create table t_yywx(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--客户姓名
v2 varchar(100),--电话
v3 varchar(100),--车辆型号
v4 datetime,--维修日期
v5 varchar(100),--申请零配件
status varchar(100),--状态
fee int--金额
);
登录后主页.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_ck")
public class Ck {
//主键
@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 gh;
//姓名
private String ckName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getCkName() {return ckName;}
public void setCkName(String ckName) {this.ckName = ckName;}
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_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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//级别
private String jb;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
}财务人员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_cw")
public class Cw {
//主键
@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 gh;
//姓名
private String cwName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
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_gys")
public class Gys {
//主键
@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 gysName;
//汽车零件名称
private String qclj;
//数量
private Integer nums;
//总价
private Integer zj;
//日期
private Date showDate;
public String getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
public String getQclj() {return qclj;}
public void setQclj(String qclj) {this.qclj = qclj;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
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_lpjckrk")
public class Lpjckrk {
//主键
@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 ckId;
//配件名称
private String title;
//数量
private String nums;
//出库入库
private String types;
//日期
private Date showDate;
public Integer getCkId() {return ckId;}
public void setCkId(Integer ckId) {this.ckId = ckId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getNums() {return nums;}
public void setNums(String nums) {this.nums = nums;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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_qcckrk")
public class Qcckrk {
//主键
@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 ckId;
//车型编号
private String title;
//图片
private String pic;
//出库入库
private String types;
//日期
private Date showDate;
//
private Integer je;
public Integer getCkId() {return ckId;}
public void setCkId(Integer ckId) {this.ckId = ckId;}
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 getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
}维修人员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_wx")
public class Wx {
//主键
@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 gh;
//姓名
private String wxName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getWxName() {return wxName;}
public void setWxName(String wxName) {this.wxName = wxName;}
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_xs")
public class Xs {
//主键
@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 gh;
//姓名
private String xsName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getXsName() {return xsName;}
public void setXsName(String xsName) {this.xsName = xsName;}
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_xsxx")
public class Xsxx {
//主键
@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 xsId;
//车型编号
private String title;
//图片
private String pic;
//客户名称
private String kh;
//联系电话
private String lxdh;
//支付方式
private String zfss;
//价格
private Integer fee;
//日期
private Date showDate;
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
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 getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getZfss() {return zfss;}
public void setZfss(String zfss) {this.zfss = zfss;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_yywx")
public class Yywx {
//主键
@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 v1;
//电话
private String v2;
//车辆型号
private String v3;
//维修日期
private Date v4;
//申请零配件
private String v5;
//状态
private String status;
//金额
private Integer fee;
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 Date getV4() {return v4;}
public void setV4(Date v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}汽车销售服务系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
仓库人员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//仓库人员
public class Ck 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 gh;
//姓名
private String ckName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getCkName() {return ckName;}
public void setCkName(String ckName) {this.ckName = ckName;}
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 Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//级别
private String jb;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
}财务人员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//财务人员
public class Cw 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 gh;
//姓名
private String cwName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
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 Gys extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//供应商
private String gysName;
//汽车零件名称
private String qclj;
//数量
private Integer nums;
//总价
private Integer zj;
//日期
private Date showDate;
public String getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
public String getQclj() {return qclj;}
public void setQclj(String qclj) {this.qclj = qclj;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
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 Lpjckrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//仓库人员
private Integer ckId;
//配件名称
private String title;
//数量
private String nums;
//出库入库
private String types;
//日期
private Date showDate;
public Integer getCkId() {return ckId;}
public void setCkId(Integer ckId) {this.ckId = ckId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getNums() {return nums;}
public void setNums(String nums) {this.nums = nums;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 Qcckrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//仓库人员
private Integer ckId;
//车型编号
private String title;
//图片
private String pic;
//出库入库
private String types;
//日期
private Date showDate;
//
private Integer je;
public Integer getCkId() {return ckId;}
public void setCkId(Integer ckId) {this.ckId = ckId;}
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 getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
}维修人员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//维修人员
public class Wx 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 gh;
//姓名
private String wxName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getWxName() {return wxName;}
public void setWxName(String wxName) {this.wxName = wxName;}
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 Xs 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 gh;
//姓名
private String xsName;
//年龄
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getXsName() {return xsName;}
public void setXsName(String xsName) {this.xsName = xsName;}
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 Xsxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//销售人员
private Integer xsId;
//车型编号
private String title;
//图片
private String pic;
//客户名称
private String kh;
//联系电话
private String lxdh;
//支付方式
private String zfss;
//价格
private Integer fee;
//日期
private Date showDate;
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
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 getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getZfss() {return zfss;}
public void setZfss(String zfss) {this.zfss = zfss;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Yywx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户姓名
private String v1;
//电话
private String v2;
//车辆型号
private String v3;
//维修日期
private Date v4;
//申请零配件
private String v5;
//状态
private String status;
//金额
private Integer fee;
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 Date getV4() {return v4;}
public void setV4(Date v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}