基于web的游乐园员工管理系统

基于web的游乐园员工管理系统登录注册界面

基于web的游乐园员工管理系统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 '主键',
	deptId int comment '部门',
	zwId int comment '职位',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	headPic varchar(100) comment '头像'
) comment '员工';

部门表创建语句如下:


create table t_dept(
	id int primary key auto_increment comment '主键',
	deptName varchar(100) comment '部门名称'
) comment '部门';

工资表创建语句如下:


create table t_gongzi(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	yf varchar(100) comment '月份',
	jbf int comment '加班费',
	qjf int comment '请假费',
	jbgz int comment '基本工资',
	total int comment '到手工资'
) comment '工资';

考勤表创建语句如下:


create table t_kaoqin(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	ampm varchar(100) comment '上班还是下班',
	status varchar(100) comment '状态',
	beginDate datetime comment '上班打卡时间',
	endDate datetime comment '下班打卡时间'
) comment '考勤';

游乐场项目表创建语句如下:


create table t_xiangmu(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '项目名称',
	fee int comment '定价',
	lb varchar(100) comment '类别',
	pic varchar(100) comment '图片',
	fzr varchar(100) comment '负责人'
) comment '游乐场项目';

职位表创建语句如下:


create table t_zw(
	id int primary key auto_increment comment '主键',
	zwName varchar(100) comment '职位名称'
) comment '职位';

基于web的游乐园员工管理系统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,
	deptId int,
	zwId int,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	headPic varchar(100)
);
--员工字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.deptId is '部门';
comment on column t_customer.zwId 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.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.headPic is '头像';
--员工表加注释
comment on table t_customer is '员工';

部门表创建语句如下:


create table t_dept(
	id integer,
	deptName varchar(100)
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门名称';
--部门表加注释
comment on table t_dept is '部门';

工资表创建语句如下:


create table t_gongzi(
	id integer,
	customerId int,
	yf varchar(100),
	jbf int,
	qjf int,
	jbgz int,
	total int
);
--工资字段加注释
comment on column t_gongzi.id is '主键';
comment on column t_gongzi.customerId is '员工';
comment on column t_gongzi.yf is '月份';
comment on column t_gongzi.jbf is '加班费';
comment on column t_gongzi.qjf is '请假费';
comment on column t_gongzi.jbgz is '基本工资';
comment on column t_gongzi.total is '到手工资';
--工资表加注释
comment on table t_gongzi is '工资';

考勤表创建语句如下:


create table t_kaoqin(
	id integer,
	customerId int,
	ampm varchar(100),
	status varchar(100),
	beginDate datetime,
	endDate datetime
);
--考勤字段加注释
comment on column t_kaoqin.id is '主键';
comment on column t_kaoqin.customerId is '员工';
comment on column t_kaoqin.ampm is '上班还是下班';
comment on column t_kaoqin.status is '状态';
comment on column t_kaoqin.beginDate is '上班打卡时间';
comment on column t_kaoqin.endDate is '下班打卡时间';
--考勤表加注释
comment on table t_kaoqin is '考勤';

游乐场项目表创建语句如下:


create table t_xiangmu(
	id integer,
	title varchar(100),
	fee int,
	lb varchar(100),
	pic varchar(100),
	fzr varchar(100)
);
--游乐场项目字段加注释
comment on column t_xiangmu.id is '主键';
comment on column t_xiangmu.title is '项目名称';
comment on column t_xiangmu.fee is '定价';
comment on column t_xiangmu.lb is '类别';
comment on column t_xiangmu.pic is '图片';
comment on column t_xiangmu.fzr is '负责人';
--游乐场项目表加注释
comment on table t_xiangmu is '游乐场项目';

职位表创建语句如下:


create table t_zw(
	id integer,
	zwName varchar(100)
);
--职位字段加注释
comment on column t_zw.id is '主键';
comment on column t_zw.zwName is '职位名称';
--职位表加注释
comment on table t_zw is '职位';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_dept;
create sequence s_t_gongzi;
create sequence s_t_kaoqin;
create sequence s_t_xiangmu;
create sequence s_t_zw;

基于web的游乐园员工管理系统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,--主键
	deptId int,--部门
	zwId int,--职位
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	headPic varchar(100)--头像
);

部门表创建语句如下:


--部门表注释
create table t_dept(
	id int identity(1,1) primary key not null,--主键
	deptName varchar(100)--部门名称
);

工资表创建语句如下:


--工资表注释
create table t_gongzi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	yf varchar(100),--月份
	jbf int,--加班费
	qjf int,--请假费
	jbgz int,--基本工资
	total int--到手工资
);

考勤表创建语句如下:


--考勤表注释
create table t_kaoqin(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	ampm varchar(100),--上班还是下班
	status varchar(100),--状态
	beginDate datetime,--上班打卡时间
	endDate datetime--下班打卡时间
);

游乐场项目表创建语句如下:


--游乐场项目表注释
create table t_xiangmu(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--项目名称
	fee int,--定价
	lb varchar(100),--类别
	pic varchar(100),--图片
	fzr varchar(100)--负责人
);

职位表创建语句如下:


--职位表注释
create table t_zw(
	id int identity(1,1) primary key not null,--主键
	zwName varchar(100)--职位名称
);

基于web的游乐园员工管理系统登录后主页

基于web的游乐园员工管理系统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 Integer deptId;
//职位
private Integer zwId;
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String headPic;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public Integer getZwId() {return zwId;}
public void setZwId(Integer zwId) {this.zwId = zwId;}
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 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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

部门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_dept")
public class Dept {
//主键
@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 deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}

工资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_gongzi")
public class Gongzi {
//主键
@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 Integer customerId;
//月份
private String yf;
//加班费
private Integer jbf;
//请假费
private Integer qjf;
//基本工资
private Integer jbgz;
//到手工资
private Integer total;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Integer getJbf() {return jbf;}
public void setJbf(Integer jbf) {this.jbf = jbf;}
public Integer getQjf() {return qjf;}
public void setQjf(Integer qjf) {this.qjf = qjf;}
public Integer getJbgz() {return jbgz;}
public void setJbgz(Integer jbgz) {this.jbgz = jbgz;}
public Integer getTotal() {return total;}
public void setTotal(Integer total) {this.total = total;}
}

考勤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_kaoqin")
public class Kaoqin {
//主键
@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 Integer customerId;
//上班还是下班
private String ampm;
//状态
private String status;
//上班打卡时间
private Date beginDate;
//下班打卡时间
private Date endDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getAmpm() {return ampm;}
public void setAmpm(String ampm) {this.ampm = ampm;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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_xiangmu")
public class Xiangmu {
//主键
@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 Integer fee;
//类别
private String lb;
//图片
private String pic;
//负责人
private String fzr;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}

职位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_zw")
public class Zw {
//主键
@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 zwName;
public String getZwName() {return zwName;}
public void setZwName(String zwName) {this.zwName = zwName;}
}

基于web的游乐园员工管理系统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 Integer deptId;
//职位
private Integer zwId;
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String headPic;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public Integer getZwId() {return zwId;}
public void setZwId(Integer zwId) {this.zwId = zwId;}
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 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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

部门javaBean创建语句如下:


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

//部门
public class Dept  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门名称
private String deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}

工资javaBean创建语句如下:


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

//工资
public class Gongzi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//月份
private String yf;
//加班费
private Integer jbf;
//请假费
private Integer qjf;
//基本工资
private Integer jbgz;
//到手工资
private Integer total;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Integer getJbf() {return jbf;}
public void setJbf(Integer jbf) {this.jbf = jbf;}
public Integer getQjf() {return qjf;}
public void setQjf(Integer qjf) {this.qjf = qjf;}
public Integer getJbgz() {return jbgz;}
public void setJbgz(Integer jbgz) {this.jbgz = jbgz;}
public Integer getTotal() {return total;}
public void setTotal(Integer total) {this.total = total;}
}

考勤javaBean创建语句如下:


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

//考勤
public class Kaoqin  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//上班还是下班
private String ampm;
//状态
private String status;
//上班打卡时间
private Date beginDate;
//下班打卡时间
private Date endDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getAmpm() {return ampm;}
public void setAmpm(String ampm) {this.ampm = ampm;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 Xiangmu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目名称
private String title;
//定价
private Integer fee;
//类别
private String lb;
//图片
private String pic;
//负责人
private String fzr;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}

职位javaBean创建语句如下:


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

//职位
public class Zw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//职位名称
private String zwName;
public String getZwName() {return zwName;}
public void setZwName(String zwName) {this.zwName = zwName;}
}

评论