食堂评价系统(xba43)_mysql

食堂评价系统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_cp(
	id int primary key auto_increment comment '主键',
	cpName varchar(100) comment '菜品名称',
	lx varchar(100) comment '',
	xw varchar(100) comment '',
	ld varchar(100) comment '',
	csId int comment '厨师'
) comment '菜品';

厨师表创建语句如下：


create table t_cs(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	csName varchar(100) comment '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment ''
) comment '厨师';

卖饭者表创建语句如下：


create table t_mfz(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	mfzName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment ''
) comment '卖饭者';

学生表创建语句如下：


create table t_student(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	studentName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment ''
) comment '学生';

消费表创建语句如下：


create table t_xf(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	mfzId int comment '卖饭者',
	csId int comment '厨师',
	cpId int comment '菜品',
	lx varchar(100) comment '',
	xw varchar(100) comment '',
	ld varchar(100) comment '',
	cspj varchar(100) comment '',
	mfzpj 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),
	lx varchar(100),
	xw varchar(100),
	ld varchar(100),
	csId int
);
--菜品字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.cpName is '菜品名称';
comment on column t_cp.lx is '';
comment on column t_cp.xw is '';
comment on column t_cp.ld is '';
comment on column t_cp.csId is '厨师';
--菜品表加注释
comment on table t_cp is '菜品';

厨师表创建语句如下：


create table t_cs(
	id integer,
	username varchar(100),
	password varchar(100),
	csName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--厨师字段加注释
comment on column t_cs.id is '主键';
comment on column t_cs.username is '账号';
comment on column t_cs.password is '密码';
comment on column t_cs.csName is '姓名';
comment on column t_cs.headPic is '头像';
comment on column t_cs.phone is '电话';
comment on column t_cs.age is '年龄';
comment on column t_cs.sex is '';
--厨师表加注释
comment on table t_cs is '厨师';

卖饭者表创建语句如下：


create table t_mfz(
	id integer,
	username varchar(100),
	password varchar(100),
	mfzName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--卖饭者字段加注释
comment on column t_mfz.id is '主键';
comment on column t_mfz.username is '账号';
comment on column t_mfz.password is '密码';
comment on column t_mfz.mfzName is '姓名';
comment on column t_mfz.phone is '电话';
comment on column t_mfz.age is '年龄';
comment on column t_mfz.sex is '';
--卖饭者表加注释
comment on table t_mfz is '卖饭者';

学生表创建语句如下：


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '';
--学生表加注释
comment on table t_student is '学生';

消费表创建语句如下：


create table t_xf(
	id integer,
	studentId int,
	mfzId int,
	csId int,
	cpId int,
	lx varchar(100),
	xw varchar(100),
	ld varchar(100),
	cspj varchar(100),
	mfzpj varchar(100)
);
--消费字段加注释
comment on column t_xf.id is '主键';
comment on column t_xf.studentId is '学生';
comment on column t_xf.mfzId is '卖饭者';
comment on column t_xf.csId is '厨师';
comment on column t_xf.cpId is '菜品';
comment on column t_xf.lx is '';
comment on column t_xf.xw is '';
comment on column t_xf.ld is '';
comment on column t_xf.cspj is '';
comment on column t_xf.mfzpj is '';
--消费表加注释
comment on table t_xf is '消费';

oracle特有，对应序列如下：


create sequence s_t_cp;
create sequence s_t_cs;
create sequence s_t_mfz;
create sequence s_t_student;
create sequence s_t_xf;

食堂评价系统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),--菜品名称
	lx varchar(100),--
	xw varchar(100),--
	ld varchar(100),--
	csId int--厨师
);

厨师表创建语句如下：


--厨师表注释
create table t_cs(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	csName varchar(100),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--
);

卖饭者表创建语句如下：


--卖饭者表注释
create table t_mfz(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	mfzName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--
);

学生表创建语句如下：


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--
);

消费表创建语句如下：


--消费表注释
create table t_xf(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	mfzId int,--卖饭者
	csId int,--厨师
	cpId int,--菜品
	lx varchar(100),--
	xw varchar(100),--
	ld varchar(100),--
	cspj varchar(100),--
	mfzpj varchar(100)--
);

食堂评价系统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 lx;
//
private String xw;
//
private String ld;
//厨师
private Long csId;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getLd() {return ld;}
public void setLd(String ld) {this.ld = ld;}
public Long getCsId() {return csId;}
public void setCsId(Long csId) {this.csId = csId;}
}

厨师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_cs")
public class Cs {
//主键
@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 csName;
//头像
private String headPic;
//电话
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 getCsName() {return csName;}
public void setCsName(String csName) {this.csName = csName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}

卖饭者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_mfz")
public class Mfz {
//主键
@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 mfzName;
//电话
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 getMfzName() {return mfzName;}
public void setMfzName(String mfzName) {this.mfzName = mfzName;}
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;}
}

学生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_student")
public class Student {
//主键
@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 studentName;
//电话
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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;}
}

消费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_xf")
public class Xf {
//主键
@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 studentId;
//卖饭者
private Long mfzId;
//厨师
private Long csId;
//菜品
private Long cpId;
//
private String lx;
//
private String xw;
//
private String ld;
//
private String cspj;
//
private String mfzpj;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Long getMfzId() {return mfzId;}
public void setMfzId(Long mfzId) {this.mfzId = mfzId;}
public Long getCsId() {return csId;}
public void setCsId(Long csId) {this.csId = csId;}
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getLd() {return ld;}
public void setLd(String ld) {this.ld = ld;}
public String getCspj() {return cspj;}
public void setCspj(String cspj) {this.cspj = cspj;}
public String getMfzpj() {return mfzpj;}
public void setMfzpj(String mfzpj) {this.mfzpj = mfzpj;}
}

食堂评价系统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 lx;
//
private String xw;
//
private String ld;
//厨师
private Long csId;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getLd() {return ld;}
public void setLd(String ld) {this.ld = ld;}
public Long getCsId() {return csId;}
public void setCsId(Long csId) {this.csId = csId;}
}

厨师javaBean创建语句如下：


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

//厨师
public class Cs  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 csName;
//头像
private String headPic;
//电话
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 getCsName() {return csName;}
public void setCsName(String csName) {this.csName = csName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}

卖饭者javaBean创建语句如下：


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

//卖饭者
public class Mfz  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 mfzName;
//电话
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 getMfzName() {return mfzName;}
public void setMfzName(String mfzName) {this.mfzName = mfzName;}
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;}
}

学生javaBean创建语句如下：


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

//学生
public class Student  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 studentName;
//电话
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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;}
}

消费javaBean创建语句如下：


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

//消费
public class Xf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//卖饭者
private Long mfzId;
//厨师
private Long csId;
//菜品
private Long cpId;
//
private String lx;
//
private String xw;
//
private String ld;
//
private String cspj;
//
private String mfzpj;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Long getMfzId() {return mfzId;}
public void setMfzId(Long mfzId) {this.mfzId = mfzId;}
public Long getCsId() {return csId;}
public void setCsId(Long csId) {this.csId = csId;}
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getLd() {return ld;}
public void setLd(String ld) {this.ld = ld;}
public String getCspj() {return cspj;}
public void setCspj(String cspj) {this.cspj = cspj;}
public String getMfzpj() {return mfzpj;}
public void setMfzpj(String mfzpj) {this.mfzpj = mfzpj;}
}

食堂评价系统(xba43)_mysql_oracle代码分享

食堂评价系统mysql数据库版本源码：

食堂评价系统oracle数据库版本源码：

食堂评价系统sqlserver数据库版本源码：

食堂评价系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

食堂评价系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论