- 网咖管理系统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_cp(
id int primary key auto_increment comment '主键',
cpName varchar(100) comment '电脑编号',
pz text comment '配置说明',
dj int comment '每小时单价',
status varchar(100) comment ''
) comment '电脑';
电脑上机记录表创建语句如下：
create table t_cplist(
id int primary key auto_increment comment '主键',
cpId int comment '电脑',
customerId int comment '用户',
beinDate datetime comment '开始日期',
endDate datetime comment '结束日期',
fee int comment '金额',
remark text comment '备注'
) comment '电脑上机记录';
用户表创建语句如下：
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 '',
sfz varchar(100) comment '身份证',
fee int comment '用户余额'
) comment '用户';
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '公告';
商品库存表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
spId int comment '商品',
sl int comment '库存添加数量',
showDate datetime comment '添加日期'
) comment '商品库存';
订单表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
spId int comment '商品',
sl int comment '数量',
zj int comment '总价',
insertDate datetime comment '发起日期',
jw varchar(100) comment '机器位置',
status varchar(100) comment '状态',
back text comment '回复'
) comment '订单';
商品表创建语句如下：
create table t_sp(
id int primary key auto_increment comment '主键',
spName varchar(100) comment '商品名称编号',
pic varchar(100) comment '图片',
fee int comment '价格',
nums int comment '数量'
) comment '商品';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '内容',
insertDate datetime comment '发起日期'
) comment '通知';
网咖管理员表创建语句如下：
create table t_wkadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
wkadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) 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_cp(
id integer,
cpName varchar(100),
pz text,
dj int,
status varchar(100)
);
--电脑字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.cpName is '电脑编号';
comment on column t_cp.pz is '配置说明';
comment on column t_cp.dj is '每小时单价';
comment on column t_cp.status is '';
--电脑表加注释
comment on table t_cp is '电脑';
电脑上机记录表创建语句如下：
create table t_cplist(
id integer,
cpId int,
customerId int,
beinDate datetime,
endDate datetime,
fee int,
remark text
);
--电脑上机记录字段加注释
comment on column t_cplist.id is '主键';
comment on column t_cplist.cpId is '电脑';
comment on column t_cplist.customerId is '用户';
comment on column t_cplist.beinDate is '开始日期';
comment on column t_cplist.endDate is '结束日期';
comment on column t_cplist.fee is '金额';
comment on column t_cplist.remark is '备注';
--电脑上机记录表加注释
comment on table t_cplist 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),
sfz varchar(100),
fee int
);
--用户字段加注释
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.sfz is '身份证';
comment on column t_customer.fee is '用户余额';
--用户表加注释
comment on table t_customer is '用户';
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';
商品库存表创建语句如下：
create table t_kc(
id integer,
spId int,
sl int,
showDate datetime
);
--商品库存字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.spId is '商品';
comment on column t_kc.sl is '库存添加数量';
comment on column t_kc.showDate is '添加日期';
--商品库存表加注释
comment on table t_kc is '商品库存';
订单表创建语句如下：
create table t_order(
id integer,
customerId int,
spId int,
sl int,
zj int,
insertDate datetime,
jw varchar(100),
status varchar(100),
back text
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.spId is '商品';
comment on column t_order.sl is '数量';
comment on column t_order.zj is '总价';
comment on column t_order.insertDate is '发起日期';
comment on column t_order.jw is '机器位置';
comment on column t_order.status is '状态';
comment on column t_order.back is '回复';
--订单表加注释
comment on table t_order is '订单';
商品表创建语句如下：
create table t_sp(
id integer,
spName varchar(100),
pic varchar(100),
fee int,
nums int
);
--商品字段加注释
comment on column t_sp.id is '主键';
comment on column t_sp.spName is '商品名称编号';
comment on column t_sp.pic is '图片';
comment on column t_sp.fee is '价格';
comment on column t_sp.nums is '数量';
--商品表加注释
comment on table t_sp is '商品';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
title varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';
网咖管理员表创建语句如下：
create table t_wkadmin(
id integer,
username varchar(100),
password varchar(100),
wkadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--网咖管理员字段加注释
comment on column t_wkadmin.id is '主键';
comment on column t_wkadmin.username is '账号';
comment on column t_wkadmin.password is '密码';
comment on column t_wkadmin.wkadminName is '姓名';
comment on column t_wkadmin.phone is '电话';
comment on column t_wkadmin.age is '年龄';
comment on column t_wkadmin.sex is '';
--网咖管理员表加注释
comment on table t_wkadmin is '网咖管理员';
oracle特有，对应序列如下：
create sequence s_t_cp;
create sequence s_t_cplist;
create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_kc;
create sequence s_t_order;
create sequence s_t_sp;
create sequence s_t_tongzhi;
create sequence s_t_wkadmin;
网咖管理系统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_cp(
id int identity(1,1) primary key not null,--主键
cpName varchar(100),--电脑编号
pz text,--配置说明
dj int,--每小时单价
status varchar(100)--
);
电脑上机记录表创建语句如下：
--电脑上机记录表注释
create table t_cplist(
id int identity(1,1) primary key not null,--主键
cpId int,--电脑
customerId int,--用户
beinDate datetime,--开始日期
endDate datetime,--结束日期
fee int,--金额
remark text--备注
);
用户表创建语句如下：
--用户表注释
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),--
sfz varchar(100),--身份证
fee int--用户余额
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
商品库存表创建语句如下：
--商品库存表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
spId int,--商品
sl int,--库存添加数量
showDate datetime--添加日期
);
订单表创建语句如下：
--订单表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
spId int,--商品
sl int,--数量
zj int,--总价
insertDate datetime,--发起日期
jw varchar(100),--机器位置
status varchar(100),--状态
back text--回复
);
商品表创建语句如下：
--商品表注释
create table t_sp(
id int identity(1,1) primary key not null,--主键
spName varchar(100),--商品名称编号
pic varchar(100),--图片
fee int,--价格
nums int--数量
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--内容
insertDate datetime--发起日期
);
网咖管理员表创建语句如下：
--网咖管理员表注释
create table t_wkadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
wkadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--
);
登录后主页.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_cp")
public class Cp {
//主键
@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 cpName;
//配置说明
private String pz;
//每小时单价
private Integer dj;
//
private String status;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}电脑上机记录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_cplist")
public class Cplist {
//主键
@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 Long cpId;
//用户
private Long customerId;
//开始日期
private Date beinDate;
//结束日期
private Date endDate;
//金额
private Integer fee;
//备注
private String remark;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Date getBeinDate() {return beinDate;}
public void setBeinDate(Date beinDate) {this.beinDate = beinDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_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 sfz;
//用户余额
private Integer fee;
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}公告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_gonggao")
public class Gonggao {
//主键
@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 String content;
//发起日期
private Date insertDate;
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 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_kc")
public class Kc {
//主键
@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 Long spId;
//库存添加数量
private Integer sl;
//添加日期
private Date showDate;
public Long getSpId() {return spId;}
public void setSpId(Long spId) {this.spId = spId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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_order")
public class Order {
//主键
@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 Long customerId;
//商品
private Long spId;
//数量
private Integer sl;
//总价
private Integer zj;
//发起日期
private Date insertDate;
//机器位置
private String jw;
//状态
private String status;
//回复
private String back;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getSpId() {return spId;}
public void setSpId(Long spId) {this.spId = spId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getJw() {return jw;}
public void setJw(String jw) {this.jw = jw;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}商品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_sp")
public class Sp {
//主键
@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 spName;
//图片
private String pic;
//价格
private Integer fee;
//数量
private Integer nums;
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_wkadmin")
public class Wkadmin {
//主键
@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 wkadminName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
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 getWkadminName() {return wkadminName;}
public void setWkadminName(String wkadminName) {this.wkadminName = wkadminName;}
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;}
}网咖管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
电脑javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//电脑
public class Cp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//电脑编号
private String cpName;
//配置说明
private String pz;
//每小时单价
private Integer dj;
//
private String status;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}电脑上机记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//电脑上机记录
public class Cplist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//电脑
private Long cpId;
//用户
private Long customerId;
//开始日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date beinDate;
//结束日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date endDate;
//金额
private Integer fee;
//备注
private String remark;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Date getBeinDate() {return beinDate;}
public void setBeinDate(Date beinDate) {this.beinDate = beinDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 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 sfz;
//用户余额
private Integer fee;
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
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 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 Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品
private Long spId;
//库存添加数量
private Integer sl;
//添加日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getSpId() {return spId;}
public void setSpId(Long spId) {this.spId = spId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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 Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//商品
private Long spId;
//数量
private Integer sl;
//总价
private Integer zj;
//发起日期
private Date insertDate;
//机器位置
private String jw;
//状态
private String status;
//回复
private String back;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getSpId() {return spId;}
public void setSpId(Long spId) {this.spId = spId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getJw() {return jw;}
public void setJw(String jw) {this.jw = jw;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}商品javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//商品
public class Sp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称编号
private String spName;
//图片
private String pic;
//价格
private Integer fee;
//数量
private Integer nums;
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
}通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Wkadmin 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 wkadminName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
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 getWkadminName() {return wkadminName;}
public void setWkadminName(String wkadminName) {this.wkadminName = wkadminName;}
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;}
}