hibernate中注解方式添加索引

hibernate实体里面建立索引

第一种对多个字段分别建立索引,源代码以及mysql中的显示数据如下图

package com.test.entity;
import javax.persistence.*;

@Entity
@Table(name = "T_S_USER",indexes={@Index(name="name_idIndex",columnList="name"),@Index(name="age_idIndex",columnList="age")})
public class test {
    @Id
    @Column(name = "id",columnDefinition = "bigint(32) comment 'id'")
    private Long id;

    @Column(nullable = false,name = "name",columnDefinition = "varchar(8) comment ''")
    private String name;

    @Column(nullable = false,name = "age",columnDefinition = "varchar(8) comment ''")
    private String age;

    @Column(nullable = false,name = "sex",columnDefinition = "varchar(8) comment ''")
    private String sex;
}