构建用户实体类
用户实体类
package com.cao.frs.entities;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;
import javax.persistence.*;
import java.util.Date;
@Data //lombok实体类
@AllArgsConstructor //有参构造
@NoArgsConstructor //无参构造
@DynamicInsert // DynamicInsert与@DynamicUpdate优化数据库更新,动态修改
@DynamicUpdate
@ApiModel("用户实体类")
@Entity //JPA实体类
@Table(name = "users") //当实体类名与数据库表类型不一样的添加注解
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@ApiModelProperty("主键id")
private Integer id;
@ApiModelProperty("城市")
private String city;
@ApiModelProperty("生日")
private Date birthday;
@ApiModelProperty("邮箱")
private String email;
@ApiModelProperty("是否为管理员")
private Integer isAdmin;
@ApiModelProperty("昵称/职位")
private String nickname;
@ApiModelProperty("密码")
private String password;
@ApiModelProperty("电话")
private String telephone;
@ApiModelProperty("用户名")
private String username;
@ApiModelProperty("报销金额上限")
private Integer limit;
}
报销申请记录表
package com.cao.frs.entities;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;
import javax.persistence.*;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
@DynamicUpdate
@DynamicInsert
@Entity
@Table(name = "invoice")
@ApiModel("报销申请表")
public class Invoice {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@ApiModelProperty("主键id")
private Integer id;
@ApiModelProperty("报销申请人名字")
private String name;
@ApiModelProperty("报销类型")
private String type;
@ApiModelProperty("报销金额")
private Integer money;
@ApiModelProperty("是否有发票")
private Integer has_bill;
@ApiModelProperty("发票日期")
private Date bill_date;
@ApiModelProperty("增值税号")
private String vat;
@ApiModelProperty("发票抬头")
private String title;
}
报销记录表
package com.cao.frs.entities;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;
import javax.persistence.*;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
@DynamicInsert
@DynamicUpdate
@Entity
@Table(name = "remiburse")
@ApiModel("报销记录表")
public class Reimburse {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@ApiModelProperty("主键id")
private Integer id;
@ApiModelProperty("用户id")
private Integer user_id;
@ApiModelProperty("报销申请时间")
private Date create_time;
@ApiModelProperty("报销结束时间")
private Date end_time;
@ApiModelProperty("操作人id")
private Integer operate_id;
@ApiModelProperty("报销金额")
private Integer money;
}