mysql-JPA对数据库中JSON类型数据的支持

mysql

一、引入依赖

  <!--JPA对数据库中JSON类型数据的支持-->
        <dependency>
            <groupId>com.vladmihalcea</groupId>
            <artifactId>hibernate-types-52</artifactId>
            <version>2.12.1</version>
        </dependency>

二、实体类

@Entity
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@DynamicInsert
@DynamicUpdate
@Table(name = "test_predict")
@TypeDef(name = "json", typeClass = JsonStringType.class)
public class TestPredict {
    @Id
    @Column(name="testId")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer testId;
    private Integer stationId ; // '风电场id' ,
    private String  projectId ; //项目id
    private String  stationName ; // '风电场' ,
    private String  longitude ; // '经度' ,
    private String  latitude ; // '纬度' ,
    private String  relaMan ; // '联系人' ,
    private String  dataSource ; // '数据源:EC,九天' ,
    private String  dataType ; // '数据类型:吊装,样机测试' ,
    private String  taskStatus ; // '任务状态' ,
    private Date lastSendDate ; //'最后发送时间' ,
    private Boolean delFlag; //删除标记
    @Type(type = "json")
    @Column(name = "userIds",columnDefinition = "json")
    private List<WxUserDTO> userIds;//企业微信 要发送的人
}

postresql

    @Type(type = "json")
    @Column(name = "instance_types", columnDefinition = "json")
    private List<AliInstanceType> instanceTypes;