基于java的音乐餐厅管理系统的设计与实现,java程序毕业设计

基于java的音乐餐厅管理系统的设计与实现登录注册界面

基于java的音乐餐厅管理系统的设计与实现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 '主键',
	cdName varchar(100) comment '菜单编号名称',
	pic1 varchar(100) comment '图片一',
	pic2 varchar(100) comment '图片二',
	pic3 varchar(100) comment '图片三',
	content varchar(100) comment '具体说明',
	fee int comment '金额',
	status varchar(100) comment '状态'
) comment '菜单';

预定表创建语句如下:


create table t_yd(
	id int primary key auto_increment comment '主键',
	phone varchar(100) comment '电话',
	name varchar(100) comment '姓名',
	cdId varchar(100) comment '菜单',
	rs int comment '人数',
	fee int comment '预定金额',
	ydDate varchar(100) comment '预定日期',
	remark varchar(100) comment '备注'
) comment '预定';

管理人员表创建语句如下:


create table t_yg(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ygName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	js varchar(100) comment '角色',
	v1 varchar(100) comment '厨师长权限',
	v2 varchar(100) comment '人事经理权限',
	v3 varchar(100) comment '餐厅领班权限',
	v4 varchar(100) comment '酒店领班权限',
	v5 varchar(100) comment '财务权限'
) comment '管理人员';

人事管理表创建语句如下:


create table t_yuangong(
	id int primary key auto_increment comment '主键',
	name varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	address varchar(100) comment '地址',
	tx varchar(100) comment '头像',
	status varchar(100) comment '状态',
	inDate varchar(100) comment '入职日期'
) comment '人事管理';

营业表创建语句如下:


create table t_yy(
	id int primary key auto_increment comment '主键',
	name varchar(100) comment '桌位编号',
	num int comment '人数',
	cdId int comment '菜单',
	phone varchar(100) comment '联系方式',
	jcsj varchar(100) comment '就餐时间',
	fee int comment '消费金额',
	remark varchar(100) comment '备注',
	insertDate datetime comment ''
) comment '营业';

基于java的音乐餐厅管理系统的设计与实现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,
	cdName varchar(100),
	pic1 varchar(100),
	pic2 varchar(100),
	pic3 varchar(100),
	content varchar(100),
	fee int,
	status varchar(100)
);
--菜单字段加注释
comment on column t_cd.id is '主键';
comment on column t_cd.cdName is '菜单编号名称';
comment on column t_cd.pic1 is '图片一';
comment on column t_cd.pic2 is '图片二';
comment on column t_cd.pic3 is '图片三';
comment on column t_cd.content is '具体说明';
comment on column t_cd.fee is '金额';
comment on column t_cd.status is '状态';
--菜单表加注释
comment on table t_cd is '菜单';

预定表创建语句如下:


create table t_yd(
	id integer,
	phone varchar(100),
	name varchar(100),
	cdId varchar(100),
	rs int,
	fee int,
	ydDate varchar(100),
	remark varchar(100)
);
--预定字段加注释
comment on column t_yd.id is '主键';
comment on column t_yd.phone is '电话';
comment on column t_yd.name is '姓名';
comment on column t_yd.cdId is '菜单';
comment on column t_yd.rs is '人数';
comment on column t_yd.fee is '预定金额';
comment on column t_yd.ydDate is '预定日期';
comment on column t_yd.remark is '备注';
--预定表加注释
comment on table t_yd is '预定';

管理人员表创建语句如下:


create table t_yg(
	id integer,
	username varchar(100),
	password varchar(100),
	ygName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	js varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100)
);
--管理人员字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.phone is '电话';
comment on column t_yg.js is '角色';
comment on column t_yg.v1 is '厨师长权限';
comment on column t_yg.v2 is '人事经理权限';
comment on column t_yg.v3 is '餐厅领班权限';
comment on column t_yg.v4 is '酒店领班权限';
comment on column t_yg.v5 is '财务权限';
--管理人员表加注释
comment on table t_yg is '管理人员';

人事管理表创建语句如下:


create table t_yuangong(
	id integer,
	name varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	address varchar(100),
	tx varchar(100),
	status varchar(100),
	inDate varchar(100)
);
--人事管理字段加注释
comment on column t_yuangong.id is '主键';
comment on column t_yuangong.name is '姓名';
comment on column t_yuangong.age is '年龄';
comment on column t_yuangong.sex is '性别';
comment on column t_yuangong.phone is '电话';
comment on column t_yuangong.address is '地址';
comment on column t_yuangong.tx is '头像';
comment on column t_yuangong.status is '状态';
comment on column t_yuangong.inDate is '入职日期';
--人事管理表加注释
comment on table t_yuangong is '人事管理';

营业表创建语句如下:


create table t_yy(
	id integer,
	name varchar(100),
	num int,
	cdId int,
	phone varchar(100),
	jcsj varchar(100),
	fee int,
	remark varchar(100),
	insertDate datetime
);
--营业字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.name is '桌位编号';
comment on column t_yy.num is '人数';
comment on column t_yy.cdId is '菜单';
comment on column t_yy.phone is '联系方式';
comment on column t_yy.jcsj is '就餐时间';
comment on column t_yy.fee is '消费金额';
comment on column t_yy.remark is '备注';
comment on column t_yy.insertDate is '';
--营业表加注释
comment on table t_yy is '营业';

oracle特有,对应序列如下:


create sequence s_t_cd;
create sequence s_t_yd;
create sequence s_t_yg;
create sequence s_t_yuangong;
create sequence s_t_yy;

基于java的音乐餐厅管理系统的设计与实现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,--主键
	cdName varchar(100),--菜单编号名称
	pic1 varchar(100),--图片一
	pic2 varchar(100),--图片二
	pic3 varchar(100),--图片三
	content varchar(100),--具体说明
	fee int,--金额
	status varchar(100)--状态
);

预定表创建语句如下:


--预定表注释
create table t_yd(
	id int identity(1,1) primary key not null,--主键
	phone varchar(100),--电话
	name varchar(100),--姓名
	cdId varchar(100),--菜单
	rs int,--人数
	fee int,--预定金额
	ydDate varchar(100),--预定日期
	remark varchar(100)--备注
);

管理人员表创建语句如下:


--管理人员表注释
create table t_yg(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ygName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	js varchar(100),--角色
	v1 varchar(100),--厨师长权限
	v2 varchar(100),--人事经理权限
	v3 varchar(100),--餐厅领班权限
	v4 varchar(100),--酒店领班权限
	v5 varchar(100)--财务权限
);

人事管理表创建语句如下:


--人事管理表注释
create table t_yuangong(
	id int identity(1,1) primary key not null,--主键
	name varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	address varchar(100),--地址
	tx varchar(100),--头像
	status varchar(100),--状态
	inDate varchar(100)--入职日期
);

营业表创建语句如下:


--营业表注释
create table t_yy(
	id int identity(1,1) primary key not null,--主键
	name varchar(100),--桌位编号
	num int,--人数
	cdId int,--菜单
	phone varchar(100),--联系方式
	jcsj varchar(100),--就餐时间
	fee int,--消费金额
	remark varchar(100),--备注
	insertDate datetime--
);

基于java的音乐餐厅管理系统的设计与实现登录后主页

基于java的音乐餐厅管理系统的设计与实现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 cdName;
//图片一
private String pic1;
//图片二
private String pic2;
//图片三
private String pic3;
//具体说明
private String content;
//金额
private Integer fee;
//状态
private String status;
public String getCdName() {return cdName;}
public void setCdName(String cdName) {this.cdName = cdName;}
public String getPic1() {return pic1;}
public void setPic1(String pic1) {this.pic1 = pic1;}
public String getPic2() {return pic2;}
public void setPic2(String pic2) {this.pic2 = pic2;}
public String getPic3() {return pic3;}
public void setPic3(String pic3) {this.pic3 = pic3;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_yd")
public class Yd {
//主键
@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 phone;
//姓名
private String name;
//菜单
private String cdId;
//人数
private Integer rs;
//预定金额
private Integer fee;
//预定日期
private String ydDate;
//备注
private String remark;
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getCdId() {return cdId;}
public void setCdId(String cdId) {this.cdId = cdId;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getYdDate() {return ydDate;}
public void setYdDate(String ydDate) {this.ydDate = ydDate;}
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_yg")
public class Yg {
//主键
@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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//角色
private String js;
//厨师长权限
private String v1;
//人事经理权限
private String v2;
//餐厅领班权限
private String v3;
//酒店领班权限
private String v4;
//财务权限
private String v5;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getJs() {return js;}
public void setJs(String js) {this.js = js;}
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 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_yuangong")
public class Yuangong {
//主键
@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 age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
//头像
private String tx;
//状态
private String status;
//入职日期
private String inDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getInDate() {return inDate;}
public void setInDate(String inDate) {this.inDate = inDate;}
}

营业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_yy")
public class Yy {
//主键
@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 Integer num;
//菜单
private Integer cdId;
//联系方式
private String phone;
//就餐时间
private String jcsj;
//消费金额
private Integer fee;
//备注
private String remark;
//
private Date insertDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCdId() {return cdId;}
public void setCdId(Integer cdId) {this.cdId = cdId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getJcsj() {return jcsj;}
public void setJcsj(String jcsj) {this.jcsj = jcsj;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

基于java的音乐餐厅管理系统的设计与实现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 cdName;
//图片一
private String pic1;
//图片二
private String pic2;
//图片三
private String pic3;
//具体说明
private String content;
//金额
private Integer fee;
//状态
private String status;
public String getCdName() {return cdName;}
public void setCdName(String cdName) {this.cdName = cdName;}
public String getPic1() {return pic1;}
public void setPic1(String pic1) {this.pic1 = pic1;}
public String getPic2() {return pic2;}
public void setPic2(String pic2) {this.pic2 = pic2;}
public String getPic3() {return pic3;}
public void setPic3(String pic3) {this.pic3 = pic3;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Yd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//电话
private String phone;
//姓名
private String name;
//菜单
private String cdId;
//人数
private Integer rs;
//预定金额
private Integer fee;
//预定日期
private String ydDate;
//备注
private String remark;
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getCdId() {return cdId;}
public void setCdId(String cdId) {this.cdId = cdId;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getYdDate() {return ydDate;}
public void setYdDate(String ydDate) {this.ydDate = ydDate;}
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 Yg  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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//角色
private String js;
//厨师长权限
private String v1;
//人事经理权限
private String v2;
//餐厅领班权限
private String v3;
//酒店领班权限
private String v4;
//财务权限
private String v5;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getJs() {return js;}
public void setJs(String js) {this.js = js;}
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 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 Yuangong  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
//头像
private String tx;
//状态
private String status;
//入职日期
private String inDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getInDate() {return inDate;}
public void setInDate(String inDate) {this.inDate = inDate;}
}

营业javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//营业
public class Yy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//桌位编号
private String name;
//人数
private Integer num;
//菜单
private Integer cdId;
//联系方式
private String phone;
//就餐时间
private String jcsj;
//消费金额
private Integer fee;
//备注
private String remark;
//
private Date insertDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCdId() {return cdId;}
public void setCdId(Integer cdId) {this.cdId = cdId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getJcsj() {return jcsj;}
public void setJcsj(String jcsj) {this.jcsj = jcsj;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

评论