- 基于WEB的连锁类饭店物流配送mysql数据库创建语句
- 基于WEB的连锁类饭店物流配送oracle数据库创建语句
- 基于WEB的连锁类饭店物流配送sqlserver数据库创建语句
- 基于WEB的连锁类饭店物流配送spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于WEB的连锁类饭店物流配送spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于WEB的连锁类饭店物流配送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_clgz(
id int primary key auto_increment comment '主键',
clgzName varchar(100) comment '车辆编号',
v2 varchar(100) comment '出车地点',
v3 varchar(100) comment '随车人',
v4 varchar(100) comment '出车时间',
v5 varchar(100) comment '车辆归队时间'
) comment '车辆跟踪';
辅料表创建语句如下：
create table t_fl(
id int primary key auto_increment comment '主键',
name varchar(100) comment '辅料',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
num int comment '库存数量'
) comment '辅料';
建议表创建语句如下：
create table t_jy(
id int primary key auto_increment comment '主键',
userId int comment '用户',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
status varchar(100) comment '状态',
answer varchar(100) comment ''
) comment '建议';
秘制调料表创建语句如下：
create table t_mztl(
id int primary key auto_increment comment '主键',
name varchar(100) comment '秘制调料',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
num int comment '数量'
) comment '秘制调料';
辅料配送表创建语句如下：
create table t_ps_fl(
id int primary key auto_increment comment '主键',
userId int comment '用户',
flId int comment '辅料',
insertDate datetime comment '日期',
num int comment '数量',
status varchar(100) comment '状态',
totalNum int comment '分店总数量'
) comment '辅料配送';
秘制调料配送表创建语句如下：
create table t_ps_mztl(
id int primary key auto_increment comment '主键',
userId int comment '用户',
mztlId int comment '秘制调料',
insertDate datetime comment '日期',
num int comment '数量',
status varchar(100) comment '状态',
totalNum int comment '分店总数量'
) comment '秘制调料配送';
食材配送表创建语句如下：
create table t_ps_sc(
id int primary key auto_increment comment '主键',
userId int comment '用户',
scId int comment '产品',
insertDate datetime comment '日期',
num int comment '数量',
status varchar(100) comment '状态',
totalNum int comment '分店总数量'
) comment '食材配送';
食材表创建语句如下：
create table t_sc(
id int primary key auto_increment comment '主键',
name varchar(100) comment '食材',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
num int comment '库存数量'
) comment '食材';
普通用户(分店)表创建语句如下：
create table t_user(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账户',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
phone varchar(100) comment '手机',
address varchar(100) comment '地址',
idcard varchar(100) comment '身份证',
insertDate datetime comment '入库时间'
) comment '普通用户(分店)';
物流配送表创建语句如下：
create table t_wlps(
id int primary key auto_increment comment '主键',
psr varchar(100) comment '配送人',
psaddress varchar(100) comment '配送地址',
psrphone varchar(100) comment '配送电话',
psd varchar(100) comment '配送日期',
psck varchar(100) comment '配送仓库',
psjg varchar(100) comment '配送结果'
) comment '物流配送';
基于WEB的连锁类饭店物流配送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_clgz(
id integer,
clgzName varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--车辆跟踪字段加注释
comment on column t_clgz.id is '主键';
comment on column t_clgz.clgzName is '车辆编号';
comment on column t_clgz.v2 is '出车地点';
comment on column t_clgz.v3 is '随车人';
comment on column t_clgz.v4 is '出车时间';
comment on column t_clgz.v5 is '车辆归队时间';
--车辆跟踪表加注释
comment on table t_clgz is '车辆跟踪';
辅料表创建语句如下：
create table t_fl(
id integer,
name varchar(100),
pic varchar(100),
content varchar(100),
num int
);
--辅料字段加注释
comment on column t_fl.id is '主键';
comment on column t_fl.name is '辅料';
comment on column t_fl.pic is '图片';
comment on column t_fl.content is '内容';
comment on column t_fl.num is '库存数量';
--辅料表加注释
comment on table t_fl is '辅料';
建议表创建语句如下：
create table t_jy(
id integer,
userId int,
title varchar(100),
content varchar(100),
status varchar(100),
answer varchar(100)
);
--建议字段加注释
comment on column t_jy.id is '主键';
comment on column t_jy.userId is '用户';
comment on column t_jy.title is '标题';
comment on column t_jy.content is '内容';
comment on column t_jy.status is '状态';
comment on column t_jy.answer is '';
--建议表加注释
comment on table t_jy is '建议';
秘制调料表创建语句如下：
create table t_mztl(
id integer,
name varchar(100),
pic varchar(100),
content varchar(100),
num int
);
--秘制调料字段加注释
comment on column t_mztl.id is '主键';
comment on column t_mztl.name is '秘制调料';
comment on column t_mztl.pic is '图片';
comment on column t_mztl.content is '内容';
comment on column t_mztl.num is '数量';
--秘制调料表加注释
comment on table t_mztl is '秘制调料';
辅料配送表创建语句如下：
create table t_ps_fl(
id integer,
userId int,
flId int,
insertDate datetime,
num int,
status varchar(100),
totalNum int
);
--辅料配送字段加注释
comment on column t_ps_fl.id is '主键';
comment on column t_ps_fl.userId is '用户';
comment on column t_ps_fl.flId is '辅料';
comment on column t_ps_fl.insertDate is '日期';
comment on column t_ps_fl.num is '数量';
comment on column t_ps_fl.status is '状态';
comment on column t_ps_fl.totalNum is '分店总数量';
--辅料配送表加注释
comment on table t_ps_fl is '辅料配送';
秘制调料配送表创建语句如下：
create table t_ps_mztl(
id integer,
userId int,
mztlId int,
insertDate datetime,
num int,
status varchar(100),
totalNum int
);
--秘制调料配送字段加注释
comment on column t_ps_mztl.id is '主键';
comment on column t_ps_mztl.userId is '用户';
comment on column t_ps_mztl.mztlId is '秘制调料';
comment on column t_ps_mztl.insertDate is '日期';
comment on column t_ps_mztl.num is '数量';
comment on column t_ps_mztl.status is '状态';
comment on column t_ps_mztl.totalNum is '分店总数量';
--秘制调料配送表加注释
comment on table t_ps_mztl is '秘制调料配送';
食材配送表创建语句如下：
create table t_ps_sc(
id integer,
userId int,
scId int,
insertDate datetime,
num int,
status varchar(100),
totalNum int
);
--食材配送字段加注释
comment on column t_ps_sc.id is '主键';
comment on column t_ps_sc.userId is '用户';
comment on column t_ps_sc.scId is '产品';
comment on column t_ps_sc.insertDate is '日期';
comment on column t_ps_sc.num is '数量';
comment on column t_ps_sc.status is '状态';
comment on column t_ps_sc.totalNum is '分店总数量';
--食材配送表加注释
comment on table t_ps_sc is '食材配送';
食材表创建语句如下：
create table t_sc(
id integer,
name varchar(100),
pic varchar(100),
content varchar(100),
num int
);
--食材字段加注释
comment on column t_sc.id is '主键';
comment on column t_sc.name is '食材';
comment on column t_sc.pic is '图片';
comment on column t_sc.content is '内容';
comment on column t_sc.num is '库存数量';
--食材表加注释
comment on table t_sc is '食材';
普通用户(分店)表创建语句如下：
create table t_user(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
phone varchar(100),
address varchar(100),
idcard varchar(100),
insertDate datetime
);
--普通用户(分店)字段加注释
comment on column t_user.id is '主键';
comment on column t_user.username is '账户';
comment on column t_user.password is '密码';
comment on column t_user.name is '姓名';
comment on column t_user.phone is '手机';
comment on column t_user.address is '地址';
comment on column t_user.idcard is '身份证';
comment on column t_user.insertDate is '入库时间';
--普通用户(分店)表加注释
comment on table t_user is '普通用户(分店)';
物流配送表创建语句如下：
create table t_wlps(
id integer,
psr varchar(100),
psaddress varchar(100),
psrphone varchar(100),
psd varchar(100),
psck varchar(100),
psjg varchar(100)
);
--物流配送字段加注释
comment on column t_wlps.id is '主键';
comment on column t_wlps.psr is '配送人';
comment on column t_wlps.psaddress is '配送地址';
comment on column t_wlps.psrphone is '配送电话';
comment on column t_wlps.psd is '配送日期';
comment on column t_wlps.psck is '配送仓库';
comment on column t_wlps.psjg is '配送结果';
--物流配送表加注释
comment on table t_wlps is '物流配送';
oracle特有，对应序列如下：
create sequence s_t_clgz;
create sequence s_t_fl;
create sequence s_t_jy;
create sequence s_t_mztl;
create sequence s_t_ps_fl;
create sequence s_t_ps_mztl;
create sequence s_t_ps_sc;
create sequence s_t_sc;
create sequence s_t_user;
create sequence s_t_wlps;
基于WEB的连锁类饭店物流配送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_clgz(
id int identity(1,1) primary key not null,--主键
clgzName varchar(100),--车辆编号
v2 varchar(100),--出车地点
v3 varchar(100),--随车人
v4 varchar(100),--出车时间
v5 varchar(100)--车辆归队时间
);
辅料表创建语句如下：
--辅料表注释
create table t_fl(
id int identity(1,1) primary key not null,--主键
name varchar(100),--辅料
pic varchar(100),--图片
content varchar(100),--内容
num int--库存数量
);
建议表创建语句如下：
--建议表注释
create table t_jy(
id int identity(1,1) primary key not null,--主键
userId int,--用户
title varchar(100),--标题
content varchar(100),--内容
status varchar(100),--状态
answer varchar(100)--
);
秘制调料表创建语句如下：
--秘制调料表注释
create table t_mztl(
id int identity(1,1) primary key not null,--主键
name varchar(100),--秘制调料
pic varchar(100),--图片
content varchar(100),--内容
num int--数量
);
辅料配送表创建语句如下：
--辅料配送表注释
create table t_ps_fl(
id int identity(1,1) primary key not null,--主键
userId int,--用户
flId int,--辅料
insertDate datetime,--日期
num int,--数量
status varchar(100),--状态
totalNum int--分店总数量
);
秘制调料配送表创建语句如下：
--秘制调料配送表注释
create table t_ps_mztl(
id int identity(1,1) primary key not null,--主键
userId int,--用户
mztlId int,--秘制调料
insertDate datetime,--日期
num int,--数量
status varchar(100),--状态
totalNum int--分店总数量
);
食材配送表创建语句如下：
--食材配送表注释
create table t_ps_sc(
id int identity(1,1) primary key not null,--主键
userId int,--用户
scId int,--产品
insertDate datetime,--日期
num int,--数量
status varchar(100),--状态
totalNum int--分店总数量
);
食材表创建语句如下：
--食材表注释
create table t_sc(
id int identity(1,1) primary key not null,--主键
name varchar(100),--食材
pic varchar(100),--图片
content varchar(100),--内容
num int--库存数量
);
普通用户(分店)表创建语句如下：
--普通用户(分店)表注释
create table t_user(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账户
password varchar(100),--密码
name varchar(100),--姓名
phone varchar(100),--手机
address varchar(100),--地址
idcard varchar(100),--身份证
insertDate datetime--入库时间
);
物流配送表创建语句如下：
--物流配送表注释
create table t_wlps(
id int identity(1,1) primary key not null,--主键
psr varchar(100),--配送人
psaddress varchar(100),--配送地址
psrphone varchar(100),--配送电话
psd varchar(100),--配送日期
psck varchar(100),--配送仓库
psjg varchar(100)--配送结果
);
登录后主页.jpg?x-oss-process=style/00001)
基于WEB的连锁类饭店物流配送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_clgz")
public class Clgz {
//主键
@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 clgzName;
//出车地点
private String v2;
//随车人
private String v3;
//出车时间
private String v4;
//车辆归队时间
private String v5;
public String getClgzName() {return clgzName;}
public void setClgzName(String clgzName) {this.clgzName = clgzName;}
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 String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}辅料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_fl")
public class Fl {
//主键
@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 name;
//图片
private String pic;
//内容
private String content;
//库存数量
private Integer num;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}建议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_jy")
public class Jy {
//主键
@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 userId;
//标题
private String title;
//内容
private String content;
//状态
private String status;
//
private String answer;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
}秘制调料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_mztl")
public class Mztl {
//主键
@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 name;
//图片
private String pic;
//内容
private String content;
//数量
private Integer num;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}辅料配送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_ps_fl")
public class Ps_fl {
//主键
@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 userId;
//辅料
private Integer flId;
//日期
private Date insertDate;
//数量
private Integer num;
//状态
private String status;
//分店总数量
private Integer totalNum;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTotalNum() {return totalNum;}
public void setTotalNum(Integer totalNum) {this.totalNum = totalNum;}
}秘制调料配送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_ps_mztl")
public class Ps_mztl {
//主键
@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 userId;
//秘制调料
private Integer mztlId;
//日期
private Date insertDate;
//数量
private Integer num;
//状态
private String status;
//分店总数量
private Integer totalNum;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getMztlId() {return mztlId;}
public void setMztlId(Integer mztlId) {this.mztlId = mztlId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTotalNum() {return totalNum;}
public void setTotalNum(Integer totalNum) {this.totalNum = totalNum;}
}食材配送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_ps_sc")
public class Ps_sc {
//主键
@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 userId;
//产品
private Integer scId;
//日期
private Date insertDate;
//数量
private Integer num;
//状态
private String status;
//分店总数量
private Integer totalNum;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getScId() {return scId;}
public void setScId(Integer scId) {this.scId = scId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTotalNum() {return totalNum;}
public void setTotalNum(Integer totalNum) {this.totalNum = totalNum;}
}食材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_sc")
public class Sc {
//主键
@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 name;
//图片
private String pic;
//内容
private String content;
//库存数量
private Integer num;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}普通用户(分店)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_user")
public class User {
//主键
@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 name;
//手机
private String phone;
//地址
private String address;
//身份证
private String idcard;
//入库时间
private Date insertDate;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
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_wlps")
public class Wlps {
//主键
@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 psr;
//配送地址
private String psaddress;
//配送电话
private String psrphone;
//配送日期
private String psd;
//配送仓库
private String psck;
//配送结果
private String psjg;
public String getPsr() {return psr;}
public void setPsr(String psr) {this.psr = psr;}
public String getPsaddress() {return psaddress;}
public void setPsaddress(String psaddress) {this.psaddress = psaddress;}
public String getPsrphone() {return psrphone;}
public void setPsrphone(String psrphone) {this.psrphone = psrphone;}
public String getPsd() {return psd;}
public void setPsd(String psd) {this.psd = psd;}
public String getPsck() {return psck;}
public void setPsck(String psck) {this.psck = psck;}
public String getPsjg() {return psjg;}
public void setPsjg(String psjg) {this.psjg = psjg;}
}基于WEB的连锁类饭店物流配送spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
车辆跟踪javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车辆跟踪
public class Clgz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车辆编号
private String clgzName;
//出车地点
private String v2;
//随车人
private String v3;
//出车时间
private String v4;
//车辆归队时间
private String v5;
public String getClgzName() {return clgzName;}
public void setClgzName(String clgzName) {this.clgzName = clgzName;}
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 String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}辅料javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//辅料
public class Fl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//辅料
private String name;
//图片
private String pic;
//内容
private String content;
//库存数量
private Integer num;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}建议javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//建议
public class Jy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer userId;
//标题
private String title;
//内容
private String content;
//状态
private String status;
//
private String answer;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
}秘制调料javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//秘制调料
public class Mztl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//秘制调料
private String name;
//图片
private String pic;
//内容
private String content;
//数量
private Integer num;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}辅料配送javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//辅料配送
public class Ps_fl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer userId;
//辅料
private Integer flId;
//日期
private Date insertDate;
//数量
private Integer num;
//状态
private String status;
//分店总数量
private Integer totalNum;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTotalNum() {return totalNum;}
public void setTotalNum(Integer totalNum) {this.totalNum = totalNum;}
}秘制调料配送javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//秘制调料配送
public class Ps_mztl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer userId;
//秘制调料
private Integer mztlId;
//日期
private Date insertDate;
//数量
private Integer num;
//状态
private String status;
//分店总数量
private Integer totalNum;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getMztlId() {return mztlId;}
public void setMztlId(Integer mztlId) {this.mztlId = mztlId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTotalNum() {return totalNum;}
public void setTotalNum(Integer totalNum) {this.totalNum = totalNum;}
}食材配送javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//食材配送
public class Ps_sc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer userId;
//产品
private Integer scId;
//日期
private Date insertDate;
//数量
private Integer num;
//状态
private String status;
//分店总数量
private Integer totalNum;
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getScId() {return scId;}
public void setScId(Integer scId) {this.scId = scId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTotalNum() {return totalNum;}
public void setTotalNum(Integer totalNum) {this.totalNum = totalNum;}
}食材javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//食材
public class Sc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//食材
private String name;
//图片
private String pic;
//内容
private String content;
//库存数量
private Integer num;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}普通用户(分店)javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通用户(分店)
public class User 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 name;
//手机
private String phone;
//地址
private String address;
//身份证
private String idcard;
//入库时间
private Date insertDate;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
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 Wlps extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//配送人
private String psr;
//配送地址
private String psaddress;
//配送电话
private String psrphone;
//配送日期
private String psd;
//配送仓库
private String psck;
//配送结果
private String psjg;
public String getPsr() {return psr;}
public void setPsr(String psr) {this.psr = psr;}
public String getPsaddress() {return psaddress;}
public void setPsaddress(String psaddress) {this.psaddress = psaddress;}
public String getPsrphone() {return psrphone;}
public void setPsrphone(String psrphone) {this.psrphone = psrphone;}
public String getPsd() {return psd;}
public void setPsd(String psd) {this.psd = psd;}
public String getPsck() {return psck;}
public void setPsck(String psck) {this.psck = psck;}
public String getPsjg() {return psjg;}
public void setPsjg(String psjg) {this.psjg = psjg;}
}