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

  
        
            com.vladmihalcea
            hibernate-types-52
            2.12.1
        

@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 userIds;//企业微信 要发送的人
}

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