- 智能连锁餐饮销售数据分析系统mysql数据库创建语句
- 智能连锁餐饮销售数据分析系统oracle数据库创建语句
- 智能连锁餐饮销售数据分析系统sqlserver数据库创建语句
- 智能连锁餐饮销售数据分析系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 智能连锁餐饮销售数据分析系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
智能连锁餐饮销售数据分析系统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_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 '性别',
pic varchar(100) comment '头像'
) comment '用户';
商品表创建语句如下:
create table t_shanpin(
id int primary key auto_increment comment '主键',
bh varchar(100) comment '编号',
mc varchar(100) comment '名称',
lb varchar(100) comment '类别',
dj int comment '单价',
kc int comment '库存',
sfgy varchar(100) comment '是否供应',
sfxp varchar(100) comment '是否新品',
sfzk varchar(100) comment '是否折扣',
beginDate datetime comment '打折开始日期',
endDate datetime comment '打折结束日期'
) comment '商品';
销售表创建语句如下:
create table t_xiaoshou(
id int primary key auto_increment comment '主键',
bh varchar(100) comment '编号',
mc varchar(100) comment '名称',
lb varchar(100) comment '类别',
sl int comment '数量',
dj int comment '单价',
xse int comment '销售额',
sfzk varchar(100) comment '是否折扣',
showDate datetime 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.pic is '头像';
--用户表加注释
comment on table t_customer is '用户';
商品表创建语句如下:
create table t_shanpin(
id integer,
bh varchar(100),
mc varchar(100),
lb varchar(100),
dj int,
kc int,
sfgy varchar(100),
sfxp varchar(100),
sfzk varchar(100),
beginDate datetime,
endDate datetime
);
--商品字段加注释
comment on column t_shanpin.id is '主键';
comment on column t_shanpin.bh is '编号';
comment on column t_shanpin.mc is '名称';
comment on column t_shanpin.lb is '类别';
comment on column t_shanpin.dj is '单价';
comment on column t_shanpin.kc is '库存';
comment on column t_shanpin.sfgy is '是否供应';
comment on column t_shanpin.sfxp is '是否新品';
comment on column t_shanpin.sfzk is '是否折扣';
comment on column t_shanpin.beginDate is '打折开始日期';
comment on column t_shanpin.endDate is '打折结束日期';
--商品表加注释
comment on table t_shanpin is '商品';
销售表创建语句如下:
create table t_xiaoshou(
id integer,
bh varchar(100),
mc varchar(100),
lb varchar(100),
sl int,
dj int,
xse int,
sfzk varchar(100),
showDate datetime
);
--销售字段加注释
comment on column t_xiaoshou.id is '主键';
comment on column t_xiaoshou.bh is '编号';
comment on column t_xiaoshou.mc is '名称';
comment on column t_xiaoshou.lb is '类别';
comment on column t_xiaoshou.sl is '数量';
comment on column t_xiaoshou.dj is '单价';
comment on column t_xiaoshou.xse is '销售额';
comment on column t_xiaoshou.sfzk is '是否折扣';
comment on column t_xiaoshou.showDate is '销售时间';
--销售表加注释
comment on table t_xiaoshou is '销售';
oracle特有,对应序列如下:
create sequence s_t_customer;
create sequence s_t_shanpin;
create sequence s_t_xiaoshou;
智能连锁餐饮销售数据分析系统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_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
pic varchar(100)--头像
);
商品表创建语句如下:
--商品表注释
create table t_shanpin(
id int identity(1,1) primary key not null,--主键
bh varchar(100),--编号
mc varchar(100),--名称
lb varchar(100),--类别
dj int,--单价
kc int,--库存
sfgy varchar(100),--是否供应
sfxp varchar(100),--是否新品
sfzk varchar(100),--是否折扣
beginDate datetime,--打折开始日期
endDate datetime--打折结束日期
);
销售表创建语句如下:
--销售表注释
create table t_xiaoshou(
id int identity(1,1) primary key not null,--主键
bh varchar(100),--编号
mc varchar(100),--名称
lb varchar(100),--类别
sl int,--数量
dj int,--单价
xse int,--销售额
sfzk varchar(100),--是否折扣
showDate datetime--销售时间
);
智能连锁餐饮销售数据分析系统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_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 username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}
商品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_shanpin")
public class Shanpin {
//主键
@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 bh;
//名称
private String mc;
//类别
private String lb;
//单价
private Integer dj;
//库存
private Integer kc;
//是否供应
private String sfgy;
//是否新品
private String sfxp;
//是否折扣
private String sfzk;
//打折开始日期
private Date beginDate;
//打折结束日期
private Date endDate;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getSfgy() {return sfgy;}
public void setSfgy(String sfgy) {this.sfgy = sfgy;}
public String getSfxp() {return sfxp;}
public void setSfxp(String sfxp) {this.sfxp = sfxp;}
public String getSfzk() {return sfzk;}
public void setSfzk(String sfzk) {this.sfzk = sfzk;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
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_xiaoshou")
public class Xiaoshou {
//主键
@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 bh;
//名称
private String mc;
//类别
private String lb;
//数量
private Integer sl;
//单价
private Integer dj;
//销售额
private Integer xse;
//是否折扣
private String sfzk;
//销售时间
private Date showDate;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public Integer getXse() {return xse;}
public void setXse(Integer xse) {this.xse = xse;}
public String getSfzk() {return sfzk;}
public void setSfzk(String sfzk) {this.sfzk = sfzk;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
智能连锁餐饮销售数据分析系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
用户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 username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}
商品javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//商品
public class Shanpin extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//名称
private String mc;
//类别
private String lb;
//单价
private Integer dj;
//库存
private Integer kc;
//是否供应
private String sfgy;
//是否新品
private String sfxp;
//是否折扣
private String sfzk;
//打折开始日期
private Date beginDate;
//打折结束日期
private Date endDate;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getSfgy() {return sfgy;}
public void setSfgy(String sfgy) {this.sfgy = sfgy;}
public String getSfxp() {return sfxp;}
public void setSfxp(String sfxp) {this.sfxp = sfxp;}
public String getSfzk() {return sfzk;}
public void setSfzk(String sfzk) {this.sfzk = sfzk;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
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 Xiaoshou extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//名称
private String mc;
//类别
private String lb;
//数量
private Integer sl;
//单价
private Integer dj;
//销售额
private Integer xse;
//是否折扣
private String sfzk;
//销售时间
private Date showDate;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public Integer getXse() {return xse;}
public void setXse(Integer xse) {this.xse = xse;}
public String getSfzk() {return sfzk;}
public void setSfzk(String sfzk) {this.sfzk = sfzk;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}