- 在线家政管理系统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_employee(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
employeeName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '公司雇员（普通管理员）';
工资表创建语句如下：
create table t_gz(
id int primary key auto_increment comment '主键',
ygId int comment '员工',
v1 int comment '工资',
v2 varchar(100) comment '发放日期',
v3 varchar(100) comment '发钱方式'
) comment '工资';
表创建语句如下：
create table t_ht(
id int primary key auto_increment comment '主键',
ygId int comment '员工',
v1 varchar(100) comment '住址',
v2 varchar(100) comment '需要照顾的人群',
v3 varchar(100) comment '意向的家政员要求',
v4 int comment '价格',
v5 varchar(100) comment '时间',
v6 varchar(100) comment '开始时间',
v7 varchar(100) comment '结束时间',
status varchar(100) comment '状态'
) comment '';
员工记录表创建语句如下：
create table t_jl(
id int primary key auto_increment comment '主键',
ygId int comment '员工',
v1 varchar(100) comment '几天',
v2 varchar(100) comment '什么工作',
v3 int comment '多少钱',
v4 varchar(100) comment '是否被辞退',
v5 varchar(100) comment '备注',
insertDate datetime comment '',
jlDate varchar(100) comment ''
) comment '员工记录';
员工表创建语句如下：
create table t_yg(
id int primary key auto_increment comment '主键',
gh varchar(100) comment '工号',
employeeName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
wx varchar(100) comment '微信',
v1 varchar(100) comment '想要什么工作',
v2 varchar(100) comment '半天还是全天',
v3 varchar(100) comment '培训成绩',
v4 varchar(100) comment '是否会普通话',
v5 varchar(100) comment '农村还是城市',
v6 varchar(100) comment '是否本地人',
v7 varchar(100) comment '有何习惯',
v8 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_employee(
id integer,
username varchar(100),
password varchar(100),
employeeName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--公司雇员（普通管理员）字段加注释
comment on column t_employee.id is '主键';
comment on column t_employee.username is '账号';
comment on column t_employee.password is '密码';
comment on column t_employee.employeeName is '姓名';
comment on column t_employee.age is '年龄';
comment on column t_employee.sex is '性别';
comment on column t_employee.phone is '电话';
--公司雇员（普通管理员）表加注释
comment on table t_employee is '公司雇员（普通管理员）';
工资表创建语句如下：
create table t_gz(
id integer,
ygId int,
v1 int,
v2 varchar(100),
v3 varchar(100)
);
--工资字段加注释
comment on column t_gz.id is '主键';
comment on column t_gz.ygId is '员工';
comment on column t_gz.v1 is '工资';
comment on column t_gz.v2 is '发放日期';
comment on column t_gz.v3 is '发钱方式';
--工资表加注释
comment on table t_gz is '工资';
表创建语句如下：
create table t_ht(
id integer,
ygId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 int,
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
status varchar(100)
);
--字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.ygId is '员工';
comment on column t_ht.v1 is '住址';
comment on column t_ht.v2 is '需要照顾的人群';
comment on column t_ht.v3 is '意向的家政员要求';
comment on column t_ht.v4 is '价格';
comment on column t_ht.v5 is '时间';
comment on column t_ht.v6 is '开始时间';
comment on column t_ht.v7 is '结束时间';
comment on column t_ht.status is '状态';
--表加注释
comment on table t_ht is '';
员工记录表创建语句如下：
create table t_jl(
id integer,
ygId int,
v1 varchar(100),
v2 varchar(100),
v3 int,
v4 varchar(100),
v5 varchar(100),
insertDate datetime,
jlDate varchar(100)
);
--员工记录字段加注释
comment on column t_jl.id is '主键';
comment on column t_jl.ygId is '员工';
comment on column t_jl.v1 is '几天';
comment on column t_jl.v2 is '什么工作';
comment on column t_jl.v3 is '多少钱';
comment on column t_jl.v4 is '是否被辞退';
comment on column t_jl.v5 is '备注';
comment on column t_jl.insertDate is '';
comment on column t_jl.jlDate is '';
--员工记录表加注释
comment on table t_jl is '员工记录';
员工表创建语句如下：
create table t_yg(
id integer,
gh varchar(100),
employeeName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
wx varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
v8 varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.gh is '工号';
comment on column t_yg.employeeName 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.wx 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 column t_yg.v6 is '是否本地人';
comment on column t_yg.v7 is '有何习惯';
comment on column t_yg.v8 is '所在城市';
--员工表加注释
comment on table t_yg is '员工';
oracle特有，对应序列如下：
create sequence s_t_employee;
create sequence s_t_gz;
create sequence s_t_ht;
create sequence s_t_jl;
create sequence s_t_yg;
在线家政管理系统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_employee(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
employeeName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100)--电话
);
工资表创建语句如下：
--工资表注释
create table t_gz(
id int identity(1,1) primary key not null,--主键
ygId int,--员工
v1 int,--工资
v2 varchar(100),--发放日期
v3 varchar(100)--发钱方式
);
表创建语句如下：
--表注释
create table t_ht(
id int identity(1,1) primary key not null,--主键
ygId int,--员工
v1 varchar(100),--住址
v2 varchar(100),--需要照顾的人群
v3 varchar(100),--意向的家政员要求
v4 int,--价格
v5 varchar(100),--时间
v6 varchar(100),--开始时间
v7 varchar(100),--结束时间
status varchar(100)--状态
);
员工记录表创建语句如下：
--员工记录表注释
create table t_jl(
id int identity(1,1) primary key not null,--主键
ygId int,--员工
v1 varchar(100),--几天
v2 varchar(100),--什么工作
v3 int,--多少钱
v4 varchar(100),--是否被辞退
v5 varchar(100),--备注
insertDate datetime,--
jlDate varchar(100)--
);
员工表创建语句如下：
--员工表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
gh varchar(100),--工号
employeeName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
wx varchar(100),--微信
v1 varchar(100),--想要什么工作
v2 varchar(100),--半天还是全天
v3 varchar(100),--培训成绩
v4 varchar(100),--是否会普通话
v5 varchar(100),--农村还是城市
v6 varchar(100),--是否本地人
v7 varchar(100),--有何习惯
v8 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_employee")
public class Employee {
//主键
@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 employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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;}
}工资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_gz")
public class Gz {
//主键
@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 ygId;
//工资
private Integer v1;
//发放日期
private String v2;
//发钱方式
private String v3;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public Integer getV1() {return v1;}
public void setV1(Integer 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;}
}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_ht")
public class Ht {
//主键
@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 ygId;
//住址
private String v1;
//需要照顾的人群
private String v2;
//意向的家政员要求
private String v3;
//价格
private Integer v4;
//时间
private String v5;
//开始时间
private String v6;
//结束时间
private String v7;
//状态
private String status;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
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_jl")
public class Jl {
//主键
@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 ygId;
//几天
private String v1;
//什么工作
private String v2;
//多少钱
private Integer v3;
//是否被辞退
private String v4;
//备注
private String v5;
//
private Date insertDate;
//
private String jlDate;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 Integer getV3() {return v3;}
public void setV3(Integer 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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getJlDate() {return jlDate;}
public void setJlDate(String jlDate) {this.jlDate = jlDate;}
}员工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 gh;
//姓名
private String employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//微信
private String wx;
//想要什么工作
private String v1;
//半天还是全天
private String v2;
//培训成绩
private String v3;
//是否会普通话
private String v4;
//农村还是城市
private String v5;
//是否本地人
private String v6;
//有何习惯
private String v7;
//所在城市
private String v8;
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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 getWx() {return wx;}
public void setWx(String wx) {this.wx = wx;}
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;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
}在线家政管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
公司雇员（普通管理员）javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公司雇员（普通管理员）
public class Employee 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 employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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;}
}工资javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//工资
public class Gz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer ygId;
//工资
private Integer v1;
//发放日期
private String v2;
//发钱方式
private String v3;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public Integer getV1() {return v1;}
public void setV1(Integer 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;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Ht extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer ygId;
//住址
private String v1;
//需要照顾的人群
private String v2;
//意向的家政员要求
private String v3;
//价格
private Integer v4;
//时间
private String v5;
//开始时间
private String v6;
//结束时间
private String v7;
//状态
private String status;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
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 Jl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer ygId;
//几天
private String v1;
//什么工作
private String v2;
//多少钱
private Integer v3;
//是否被辞退
private String v4;
//备注
private String v5;
//
private Date insertDate;
//
private String jlDate;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 Integer getV3() {return v3;}
public void setV3(Integer 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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getJlDate() {return jlDate;}
public void setJlDate(String jlDate) {this.jlDate = jlDate;}
}员工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 gh;
//姓名
private String employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//微信
private String wx;
//想要什么工作
private String v1;
//半天还是全天
private String v2;
//培训成绩
private String v3;
//是否会普通话
private String v4;
//农村还是城市
private String v5;
//是否本地人
private String v6;
//有何习惯
private String v7;
//所在城市
private String v8;
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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 getWx() {return wx;}
public void setWx(String wx) {this.wx = wx;}
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;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
}