- 同城物流系统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_cd(
id int primary key auto_increment comment '主键',
title varchar(100) comment '承运商信息',
userId int comment '司机',
clxx varchar(100) comment '车辆信息',
remark text comment '备注'
) comment '车队';
订单表创建语句如下：
create table t_dd(
id int primary key auto_increment comment '主键',
ddNum varchar(100) comment '车次',
phone varchar(100) comment '电话',
lxr varchar(100) comment '联系人',
zl int comment '重量',
allfee int comment '总费用',
v1 varchar(100) comment '开始地点',
jwd1 varchar(100) comment '开始地点经纬度',
v2 varchar(100) comment '目标地点',
jwd2 varchar(100) comment '目标地点经纬度',
fee int comment '费用',
insertDate datetime comment '下单日期',
status varchar(100) comment '状态',
remark text comment '物流信息',
userId int comment '司机',
pic varchar(100) comment '签收照片',
ycstatus varchar(100) comment '',
yccontent text comment '异常',
endDate datetime comment '完成日期'
) comment '订单';
运费表创建语句如下：
create table t_yf(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '开始地点',
jwd1 varchar(100) comment '开始地点经纬度',
v2 varchar(100) comment '目标地点',
jwd2 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_cd(
id integer,
title varchar(100),
userId int,
clxx varchar(100),
remark text
);
--车队字段加注释
comment on column t_cd.id is '主键';
comment on column t_cd.title is '承运商信息';
comment on column t_cd.userId is '司机';
comment on column t_cd.clxx is '车辆信息';
comment on column t_cd.remark is '备注';
--车队表加注释
comment on table t_cd is '车队';
订单表创建语句如下：
create table t_dd(
id integer,
ddNum varchar(100),
phone varchar(100),
lxr varchar(100),
zl int,
allfee int,
v1 varchar(100),
jwd1 varchar(100),
v2 varchar(100),
jwd2 varchar(100),
fee int,
insertDate datetime,
status varchar(100),
remark text,
userId int,
pic varchar(100),
ycstatus varchar(100),
yccontent text,
endDate datetime
);
--订单字段加注释
comment on column t_dd.id is '主键';
comment on column t_dd.ddNum is '车次';
comment on column t_dd.phone is '电话';
comment on column t_dd.lxr is '联系人';
comment on column t_dd.zl is '重量';
comment on column t_dd.allfee is '总费用';
comment on column t_dd.v1 is '开始地点';
comment on column t_dd.jwd1 is '开始地点经纬度';
comment on column t_dd.v2 is '目标地点';
comment on column t_dd.jwd2 is '目标地点经纬度';
comment on column t_dd.fee is '费用';
comment on column t_dd.insertDate is '下单日期';
comment on column t_dd.status is '状态';
comment on column t_dd.remark is '物流信息';
comment on column t_dd.userId is '司机';
comment on column t_dd.pic is '签收照片';
comment on column t_dd.ycstatus is '';
comment on column t_dd.yccontent is '异常';
comment on column t_dd.endDate is '完成日期';
--订单表加注释
comment on table t_dd is '订单';
运费表创建语句如下：
create table t_yf(
id integer,
v1 varchar(100),
jwd1 varchar(100),
v2 varchar(100),
jwd2 varchar(100),
fee int
);
--运费字段加注释
comment on column t_yf.id is '主键';
comment on column t_yf.v1 is '开始地点';
comment on column t_yf.jwd1 is '开始地点经纬度';
comment on column t_yf.v2 is '目标地点';
comment on column t_yf.jwd2 is '目标地点经纬度';
comment on column t_yf.fee is '单价费用';
--运费表加注释
comment on table t_yf is '运费';
oracle特有，对应序列如下：
create sequence s_t_cd;
create sequence s_t_dd;
create sequence s_t_yf;
同城物流系统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_cd(
id int identity(1,1) primary key not null,--主键
title varchar(100),--承运商信息
userId int,--司机
clxx varchar(100),--车辆信息
remark text--备注
);
订单表创建语句如下：
--订单表注释
create table t_dd(
id int identity(1,1) primary key not null,--主键
ddNum varchar(100),--车次
phone varchar(100),--电话
lxr varchar(100),--联系人
zl int,--重量
allfee int,--总费用
v1 varchar(100),--开始地点
jwd1 varchar(100),--开始地点经纬度
v2 varchar(100),--目标地点
jwd2 varchar(100),--目标地点经纬度
fee int,--费用
insertDate datetime,--下单日期
status varchar(100),--状态
remark text,--物流信息
userId int,--司机
pic varchar(100),--签收照片
ycstatus varchar(100),--
yccontent text,--异常
endDate datetime--完成日期
);
运费表创建语句如下：
--运费表注释
create table t_yf(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--开始地点
jwd1 varchar(100),--开始地点经纬度
v2 varchar(100),--目标地点
jwd2 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_cd")
public class Cd {
//主键
@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 title;
//司机
private Long userId;
//车辆信息
private String clxx;
//备注
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getUserId() {return userId;}
public void setUserId(Long userId) {this.userId = userId;}
public String getClxx() {return clxx;}
public void setClxx(String clxx) {this.clxx = clxx;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}订单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_dd")
public class Dd {
//主键
@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 ddNum;
//电话
private String phone;
//联系人
private String lxr;
//重量
private Integer zl;
//总费用
private Integer allfee;
//开始地点
private String v1;
//开始地点经纬度
private String jwd1;
//目标地点
private String v2;
//目标地点经纬度
private String jwd2;
//费用
private Integer fee;
//下单日期
private Date insertDate;
//状态
private String status;
//物流信息
private String remark;
//司机
private Long userId;
//签收照片
private String pic;
//
private String ycstatus;
//异常
private String yccontent;
//完成日期
private Date endDate;
public String getDdNum() {return ddNum;}
public void setDdNum(String ddNum) {this.ddNum = ddNum;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public Integer getZl() {return zl;}
public void setZl(Integer zl) {this.zl = zl;}
public Integer getAllfee() {return allfee;}
public void setAllfee(Integer allfee) {this.allfee = allfee;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getJwd1() {return jwd1;}
public void setJwd1(String jwd1) {this.jwd1 = jwd1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getJwd2() {return jwd2;}
public void setJwd2(String jwd2) {this.jwd2 = jwd2;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Long getUserId() {return userId;}
public void setUserId(Long userId) {this.userId = userId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getYcstatus() {return ycstatus;}
public void setYcstatus(String ycstatus) {this.ycstatus = ycstatus;}
public String getYccontent() {return yccontent;}
public void setYccontent(String yccontent) {this.yccontent = yccontent;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}运费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_yf")
public class Yf {
//主键
@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 jwd1;
//目标地点
private String v2;
//目标地点经纬度
private String jwd2;
//单价费用
private Integer fee;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getJwd1() {return jwd1;}
public void setJwd1(String jwd1) {this.jwd1 = jwd1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getJwd2() {return jwd2;}
public void setJwd2(String jwd2) {this.jwd2 = jwd2;}
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 Cd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//承运商信息
private String title;
//司机
private Long userId;
//车辆信息
private String clxx;
//备注
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getUserId() {return userId;}
public void setUserId(Long userId) {this.userId = userId;}
public String getClxx() {return clxx;}
public void setClxx(String clxx) {this.clxx = clxx;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}订单javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//订单
public class Dd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车次
private String ddNum;
//电话
private String phone;
//联系人
private String lxr;
//重量
private Integer zl;
//总费用
private Integer allfee;
//开始地点
private String v1;
//开始地点经纬度
private String jwd1;
//目标地点
private String v2;
//目标地点经纬度
private String jwd2;
//费用
private Integer fee;
//下单日期
private Date insertDate;
//状态
private String status;
//物流信息
private String remark;
//司机
private Long userId;
//签收照片
private String pic;
//
private String ycstatus;
//异常
private String yccontent;
//完成日期
private Date endDate;
public String getDdNum() {return ddNum;}
public void setDdNum(String ddNum) {this.ddNum = ddNum;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public Integer getZl() {return zl;}
public void setZl(Integer zl) {this.zl = zl;}
public Integer getAllfee() {return allfee;}
public void setAllfee(Integer allfee) {this.allfee = allfee;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getJwd1() {return jwd1;}
public void setJwd1(String jwd1) {this.jwd1 = jwd1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getJwd2() {return jwd2;}
public void setJwd2(String jwd2) {this.jwd2 = jwd2;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Long getUserId() {return userId;}
public void setUserId(Long userId) {this.userId = userId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getYcstatus() {return ycstatus;}
public void setYcstatus(String ycstatus) {this.ycstatus = ycstatus;}
public String getYccontent() {return yccontent;}
public void setYccontent(String yccontent) {this.yccontent = yccontent;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}运费javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//运费
public class Yf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//开始地点
private String v1;
//开始地点经纬度
private String jwd1;
//目标地点
private String v2;
//目标地点经纬度
private String jwd2;
//单价费用
private Integer fee;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getJwd1() {return jwd1;}
public void setJwd1(String jwd1) {this.jwd1 = jwd1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getJwd2() {return jwd2;}
public void setJwd2(String jwd2) {this.jwd2 = jwd2;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}