简单工作流系统——实体类和数据库设计

﹏ヽ暗。殇╰゛Y 2021-07-24 15:50 381阅读 0赞

**一 E-R图**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

**二 PO**

1 Employee

package org.crazyit.hrsystem.domain;
    
    
    import java.io.Serializable;
    import java.util.*;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    import javax.persistence.*;
    
    @Entity
    @Table(name="employee_inf")
    @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
    @DiscriminatorColumn(name="emp_type"
        , discriminatorType=DiscriminatorType.INTEGER)
    @DiscriminatorValue(value="1")
    public class Employee
        implements Serializable
    {
        private static final long serialVersionUID = 48L;
        @Id @Column(name="emp_id")
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        // 标识属性
        private Integer id;
        // 员工姓名
        @Column(name="emp_name", nullable=false, length=50 , unique=true)
        private String name;
        // 员工密码
        @Column(name="emp_pass", nullable=false, length=50)
        private String pass;
        // 员工工资
        @Column(name="emp_salary", nullable=false)
        private double salary;
        // 员工对应的经理
        @ManyToOne(targetEntity=Manager.class)
        @JoinColumn(name="mgr_id")
        private Manager manager;
        // 员工对应的出勤记录
        @OneToMany(targetEntity=Attend.class, mappedBy="employee")
        private Set<Attend> attends = new HashSet<>();
        // 员工对应的工资支付记录
        @OneToMany(targetEntity=Payment.class, mappedBy="employee")
        private Set<Payment> payments = new HashSet<>();
    
    
        // 无参数的构造器
        public Employee()
        {
        }
        // 初始化全部成员变量的构造器
        public Employee(Integer id , String name , String pass ,
            double salary , Manager manager ,
            Set<Attend> attends , Set<Payment> payments)
        {
            this.id = id;
            this.name = name;
            this.pass = pass;
            this.salary = salary;
            this.manager = manager;
            this.attends = attends;
            this.payments = payments;
        }
    
    
        // id的setter和getter方法
        public void setId(Integer id)
        {
            this.id = id;
        }
        public Integer getId()
        {
            return this.id;
        }
    
    
        // name的setter和getter方法
        public void setName(String name)
        {
            this.name = name;
        }
        public String getName()
        {
            return this.name;
        }
    
    
        // pass的setter和getter方法
        public void setPass(String pass)
        {
            this.pass = pass;
        }
        public String getPass()
        {
            return this.pass;
        }
    
    
        // salary的setter和getter方法
        public void setSalary(double salary)
        {
            this.salary = salary;
        }
        public double getSalary()
        {
            return this.salary;
        }
    
    
        // manager的setter和getter方法
        public void setManager(Manager manager)
        {
            this.manager = manager;
        }
        public Manager getManager()
        {
            return this.manager;
        }
    
    
        // attends的setter和getter方法
        public void setAttends(Set<Attend> attends)
        {
            this.attends = attends;
        }
        public Set<Attend> getAttends()
        {
            return this.attends;
        }
    
    
        // payments的setter和getter方法
        public void setPayments(Set<Payment> payments)
        {
            this.payments = payments;
        }
        public Set<Payment> getPayments()
        {
            return this.payments;
        }
        // 根据name、pass来重写hashCode()方法
        @Override
        public int hashCode()
        {
            final int prime = 31;
            int result = 1;
            result = prime * result + ((name == null) ? 0 : name.hashCode());
            result = prime * result + ((pass == null) ? 0 : pass.hashCode());
            return result;
        }
        // 根据name、pass来重写equals()方法，只要name、pass相同的员工即认为相等。
        @Override
        public boolean equals(Object obj)
        {
            if (this == obj) return true;
            if (obj == null) return false;
            if (getClass() != obj.getClass()) return false;
            Employee other = (Employee) obj;
            if (name == null)
            {
                if (other.name != null) return false;
            }
            else if (!name.equals(other.name)) return false;
            if (pass == null)
            {
                if (other.pass != null) return false;
            }
            else if (!pass.equals(other.pass)) return false;
            return true;
        }
    }

2 Manager

package org.crazyit.hrsystem.domain;
    
    
    import java.io.Serializable;
    import java.util.*;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    import javax.persistence.DiscriminatorValue;
    import javax.persistence.Entity;
    import javax.persistence.*;
    
    @Entity
    @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
    @DiscriminatorValue(value="2")
    public class Manager
        extends Employee implements Serializable
    {
        private static final long serialVersionUID = 48L;
        // 该经理管理的部门
        @Column(name="dept_name", length=50)
        private String dept;
        // 该经理对应的所有员工
        @OneToMany(targetEntity=Employee.class, mappedBy="manager")
        private Set<Employee> employees = new HashSet<>();
        // 该经理签署的所有批复
        @OneToMany(targetEntity=CheckBack.class , mappedBy="manager")
        private Set<CheckBack> checks = new HashSet<>();
    
    
        // 无参数的构造器
        public Manager()
        {
        }
        // 初始化全部成员变量的构造器
        public Manager(String dept , Set<Employee> employees
            , Set<CheckBack> checks)
        {
            this.dept = dept;
            this.employees = employees;
            this.checks = checks;
        }
    
    
        // dept的setter和getter方法
        public void setDept(String dept)
        {
            this.dept = dept;
        }
        public String getDept()
        {
            return this.dept;
        }
    
    
        // employees的setter和getter方法
        public void setEmployees(Set<Employee> employees)
        {
            this.employees = employees;
        }
        public Set<Employee> getEmployees()
        {
            return this.employees;
        }
    
    
        // checks的setter和getter方法
        public void setChecks(Set<CheckBack> checks)
        {
            this.checks = checks;
        }
        public Set<CheckBack> getChecks()
        {
            return this.checks;
        }
    }

3  Attend

package org.crazyit.hrsystem.domain;
    
    
    import java.io.Serializable;
    import java.util.Date;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    import javax.persistence.*;
    
    @Entity
    @Table(name="attend_inf")
    @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
    public class Attend
        implements Serializable
    {
        private static final long serialVersionUID = 48L;
    
    
        // 代表标识属性
        @Id @Column(name="attend_id")
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        private Integer id;
        // 出勤日期
        @Column(name="duty_day", nullable=false, length=50)
        private String dutyDay;
        // 打卡时间
        @Column(name="punch_time")
        private Date punchTime;
        // 代表本次打卡是否为上班打卡
        @Column(name="is_come" , nullable=false)
        private boolean isCome;
        // 本次出勤的类型
        @ManyToOne(targetEntity=AttendType.class)
        @JoinColumn(name="type_id", nullable=false)
        private AttendType type;
        // 本次出勤关联的员工
        @ManyToOne(targetEntity=Employee.class)
        @JoinColumn(name="emp_id", nullable=false)
        private Employee employee;
    
    
        // 无参数的构造器
        public Attend()
        {
        }
        // 初始化全部成员变量的构造器
        public Attend(Integer id , String dutyDay ,
            Date punchTime , boolean isCome ,
            AttendType type , Employee employee)
        {
            this.id = id;
            this.dutyDay = dutyDay;
            this.punchTime = punchTime;
            this.isCome = isCome;
            this.type = type;
            this.employee = employee;
        }
    
    
        // id的setter和getter方法
        public void setId(Integer id)
        {
            this.id = id;
        }
        public Integer getId()
        {
            return this.id;
        }
    
    
        // dutyDay的setter和getter方法
        public void setDutyDay(String dutyDay)
        {
            this.dutyDay = dutyDay;
        }
        public String getDutyDay()
        {
            return this.dutyDay;
        }
    
    
        // punchTime的setter和getter方法
        public void setPunchTime(Date punchTime)
        {
            this.punchTime = punchTime;
        }
        public Date getPunchTime()
        {
            return this.punchTime;
        }
    
    
        // isCome的setter和getter方法
        public void setIsCome(boolean isCome)
        {
            this.isCome = isCome;
        }
        public boolean getIsCome()
        {
            return this.isCome;
        }
    
    
        // type的setter和getter方法
        public void setType(AttendType type)
        {
            this.type = type;
        }
        public AttendType getType()
        {
            return this.type;
        }
    
    
        // employee的setter和getter方法
        public void setEmployee(Employee employee)
        {
            this.employee = employee;
        }
        public Employee getEmployee()
        {
            return this.employee;
        }
    
    
        // 根据employee、isCome、dutyDay来重写hashCode()方法
        @Override
        public int hashCode()
        {
            final int prime = 31;
            int result = 1;
            result = prime * result
                + ((dutyDay == null) ? 0 : dutyDay.hashCode());
            result = prime * result
                + ((employee == null) ? 0 : employee.hashCode());
            result = prime * result + (isCome ? 1231 : 1237);
            return result;
        }
        // 根据employee、isCome、dutyDay来重写equals()方法
        @Override
        public boolean equals(Object obj)
        {
            if (this == obj) return true;
            if (obj == null) return false;
            if (getClass() != obj.getClass()) return false;
            Attend other = (Attend) obj;
            if (dutyDay == null)
            {
                if (other.dutyDay != null) return false;
            }
            else if (!dutyDay.equals(other.dutyDay)) return false;
            if (employee == null)
            {
                if (other.employee != null) return false;
            }
            else if (!employee.equals(other.employee)) return false;
            if (isCome != other.isCome) return false;
            return true;
        }
    }

4 Payment

package org.crazyit.hrsystem.domain;
    
    import java.io.Serializable;
    import java.sql.Date;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    import javax.persistence.*;
    
    
    @Entity
    @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
    @Table(name="payment_inf")
    public class Payment
        implements Serializable
    {
        private static final long serialVersionUID = 48L;
        // 标识属性
        @Id @Column(name="pay_id")
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        private Integer id;
        @Column(name="pay_month", nullable=false, length=50)
        private String payMonth;
        // 发薪的数量
        @Column(name="pay_amount", nullable=false)
        private double amount;
        // 领薪的员工
        @ManyToOne(targetEntity=Employee.class)
        @JoinColumn(name="emp_id", nullable=false)
        private Employee employee;
    
    
        // 无参数的构造器
        public Payment()
        {
        }
        // 初始化全部成员变量的构造器
        public Payment(Integer id , String payMonth ,
            double amount , Employee employee)
        {
            this.id = id;
            this.payMonth = payMonth;
            this.amount = amount;
            this.employee = employee;
        }
    
    
        // id的setter和getter方法
        public void setId(Integer id)
        {
            this.id = id;
        }
        public Integer getId()
        {
            return this.id;
        }
    
    
        // payMonth的setter和getter方法
        public void setPayMonth(String payMonth)
        {
            this.payMonth = payMonth;
        }
        public String getPayMonth()
        {
            return this.payMonth;
        }
    
    
        // amount的setter和getter方法
        public void setAmount(double amount)
        {
            this.amount = amount;
        }
        public double getAmount()
        {
            return this.amount;
        }
    
    
        // employee的setter和getter方法
        public void setEmployee(Employee employee)
        {
            this.employee = employee;
        }
        public Employee getEmployee()
        {
            return this.employee;
        }
    }

5 CheckBack

package org.crazyit.hrsystem.domain;
    
    
    import java.io.Serializable;
    import java.sql.Date;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    import javax.persistence.*;
    
    @Entity
    @Table(name="checkback_inf")
    @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
    public class CheckBack
        implements Serializable
    {
        private static final long serialVersionUID = 48L;
        // 标识属性
        @Id @Column(name="check_id")
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        private Integer id;
        // 是否同意申请
        @Column(name="check_result", nullable=false)
        private boolean result;
        // 批复理由
        @Column(name="check_reason" , length=255)
        private String reason;
    
    
        // 该批复对应的申请
        @OneToOne(targetEntity=Application.class)
        @JoinColumn(name="app_id", nullable=false , unique=true)
        private Application app;
        // 批复的经理
        @ManyToOne(targetEntity=Manager.class)
        @JoinColumn(name="mgr_id" , nullable=false)
        private Manager manager;
    
    
        // 无参数的构造器
        public CheckBack()
        {
        }
        // 初始化全部成员变量的构造器
        public CheckBack(Integer id , boolean result ,
            String reason , Application app , Manager manager)
        {
            this.id = id;
            this.result = result;
            this.reason = reason;
            this.app = app;
            this.manager = manager;
        }
    
    
        // id的setter和getter方法
        public void setId(Integer id)
        {
            this.id = id;
        }
        public Integer getId()
        {
            return this.id;
        }
    
    
        // result的setter和getter方法
        public void setResult(boolean result)
        {
            this.result = result;
        }
        public boolean getResult()
        {
            return this.result;
        }
    
    
        // reason的setter和getter方法
        public void setReason(String reason)
        {
            this.reason = reason;
        }
        public String getReason()
        {
            return this.reason;
        }
    
    
        // app的setter和getter方法
        public void setApp(Application app)
        {
            this.app = app;
        }
        public Application getApp()
        {
            return this.app;
        }
    
    
        // manager的setter和getter方法
        public void setManager(Manager manager)
        {
            this.manager = manager;
        }
        public Manager getManager()
        {
            return this.manager;
        }
    }

6 Application

package org.crazyit.hrsystem.domain;
    
    
    import java.io.Serializable;
    import java.sql.Date;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    import javax.persistence.*;
    
    
    @Entity
    @Table(name="application_inf")
    @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
    public class Application
        implements Serializable
    {
        private static final long serialVersionUID = 48L;
        // 代表标识属性
        @Id    @Column(name="app_id")
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        private Integer id;
        // 申请理由
        @Column(name="app_reason" , length=50)
        private String reason;
        // 是否处理
        @Column(name="app_result")
        private boolean result;
        // 关联的出勤记录
        @ManyToOne(targetEntity=Attend.class)
        @JoinColumn(name="attend_id" , nullable=false)
        private Attend attend;
        // 希望将指定出勤改为的type类型
        @ManyToOne(targetEntity=AttendType.class)
        @JoinColumn(name="type_id", nullable=false)
        private AttendType type;
        // 申请的结果
        @OneToOne(targetEntity=CheckBack.class, mappedBy="app")
        private CheckBack check;
    
    
        //无参数的构造器
        public Application()
        {
        }
        // 初始化全部成员变量的构造器
        public Application(Integer id , String reason ,
            boolean result , Attend attend ,
            AttendType type , CheckBack check)
        {
            this.id = id;
            this.reason = reason;
            this.result = result;
            this.attend = attend;
            this.type = type;
            this.check = check;
        }
    
    
        // id的setter和getter方法
        public void setId(Integer id)
        {
            this.id = id;
        }
        public Integer getId()
        {
            return this.id;
        }
    
    
        // reason的setter和getter方法
        public void setReason(String reason)
        {
            this.reason = reason;
        }
        public String getReason()
        {
            return this.reason;
        }
    
    
        // result的setter和getter方法
        public void setResult(boolean result)
        {
            this.result = result;
        }
        public boolean getResult()
        {
            return this.result;
        }
    
    
        // attend的setter和getter方法
        public void setAttend(Attend attend)
        {
            this.attend = attend;
        }
        public Attend getAttend()
        {
            return this.attend;
        }
    
    
        // type的setter和getter方法
        public void setType(AttendType type)
        {
            this.type = type;
        }
        public AttendType getType()
        {
            return this.type;
        }
    
    
        // check的setter和getter方法
        public void setCheck(CheckBack check)
        {
            this.check = check;
        }
        public CheckBack getCheck()
        {
            return this.check;
        }
    
    
    }

7 AttendType

package org.crazyit.hrsystem.domain;
    
    
    import java.io.Serializable;
    import javax.persistence.*;
    import org.hibernate.annotations.Cache;
    import org.hibernate.annotations.CacheConcurrencyStrategy;
    
    @Entity
    @Table(name="attend_type_inf")
    @Cache(usage=CacheConcurrencyStrategy.READ_ONLY)
    public class AttendType
        implements Serializable
    {
        private static final long serialVersionUID = 48L;
        // 标识属性
        @Id @Column(name="type_id")
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        private Integer id;
        // 出勤类型的名称
        @Column(name="type_name", nullable=false , length=50)
        private String name;
        // 此类出勤对应的罚款
        @Column(name="amerce_amount", nullable=false)
        private double amerce;
    
    
        // 无参数的构造器
        public AttendType()
        {
        }
        // 初始化全部成员变量的构造器
        public AttendType(Integer id , String name , double amerce)
        {
            this.id = id;
            this.name = name;
            this.amerce = amerce;
        }
    
    
        // id的setter和getter方法
        public void setId(Integer id)
        {
            this.id = id;
        }
        public Integer getId()
        {
            return this.id;
        }
    
    
        // name的setter和getter方法
        public void setName(String name)
        {
            this.name = name;
        }
        public String getName()
        {
            return this.name;
        }
    
    
        // amerce的setter和getter方法
        public void setAmerce(double amerce)
        {
            this.amerce = amerce;
        }
        public double getAmerce()
        {
            return this.amerce;
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/fde3f3b676c848e29ba7585a3679ec4c.png