Spring data jpa使用枚举

枚举的优越性不用多说。在实体中使用,上代码

实体类:

复制代码

@Entity
@Table(name = "cache_user")
public class User {
    /**
     * 用户类型
     */
    public static enum AccountType {
        TEACHER,//老师
        STUDENT;//学生
    }

    @Id
    @GenericGenerator(name = "uuid", strategy = "uuid2")
    @GeneratedValue(generator = "uuid")
    private String id;

    private String name;

    private int age;

    /**
     * EnumType:  ORDINAL 枚举序数  默认选项(int)。eg:TEACHER 数据库存储的是 0
     *            STRING:枚举名称       (String)。eg:TEACHER 数据库存储的是 "TEACHER"
     */
    @Enumerated(EnumType.STRING)  
    private AccountType accountType = AccountType.TEACHER;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public User() {
        super();
    }

    public AccountType getAccountType() {
        return accountType;
    }

    public void setAccountType(AccountType accountType) {
        this.accountType = accountType;
    }

复制代码

查询时:

    @Query("from User u  where u.accountType = :type ")
    User findByType(@Param("type") AccountType type);

eg : 

        User u3 = userRepository.findByType(AccountType.TEACHER);
        System.out.println("第二次查询:" + u3.getAge());

生成的sql:

INFO  [main] jdbc.sqlonly.sqlOccured:226 - select user0_.id as id1_0_, user0_.account_type as account_2_0_, user0_.age as age3_0_, user0_.name 
as name4_0_ from cache_user user0_ where user0_.account_type='KEEPER' 

如果注解是:

    @Enumerated(EnumType.ORDINAL)  
    private AccountType accountType = AccountType.TEACHER;

或者无注解:

  private AccountType accountType = AccountType.TEACHER;

生成的sql:

[main] jdbc.sqltiming.sqlTimingOccured:370 - select user0_.id as id1_0_, user0_.account_type as account_2_0_, user0_.age as age3_0_, user0_.name
as name4_0_ from cache_user user0_ where user0_.account_type=0

 

评论 2 您还未登录,请先 登录 后发表或查看评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值