生成实体类,大家都是一样的操作了,推荐使用GsonFormat。
@Entity
public class DataEntity {
private String deptName;
@Id
private String empId;
private String empName;
private String loginName;
private String mCarNo;
private String photo;
private String postName;
@Convert(converter = EmpPointListConvert.class, columnType = String.class)
private List<EmpPointListEntity> empPointList;
此处省略一万行自动生成的代码
EmpPointListConvert代码如下,记得添加fastjson:
public class EmpPointListConvert implements PropertyConverter<List<EmpPointListEntity>, String> {
@Override
public List<EmpPointListEntity> convertToEntityProperty(String databaseValue) {
return JSON.parseArray(databaseValue, EmpPointListEntity.class);
}
@Override
public String convertToDatabaseValue(List<EmpPointListEntity> entityProperty) {
return JSON.toJSONString(entityProperty);
}
}
再来一组比较:
@Entity
public class DataSingleEntity {
private String deptName;
@Id
private String empId;
private String empName;
private String loginName;
private String mCarNo;
private String photo;
private String postName;
@Convert(converter = EmpPointConvert.class, columnType = String.class)
private EmpPointListEntity empPointList;
此处省略一万行自动生成的代码
}
EmpPointConvert代码如下:
public class EmpPointConvert implements PropertyConverter<EmpPointListEntity, String> {
@Override
public EmpPointListEntity convertToEntityProperty(String databaseValue) {
return JSON.parseObject(databaseValue, EmpPointListEntity.class);
}
@Override
public String convertToDatabaseValue(EmpPointListEntity entityProperty) {
return JSON.toJSONString(entityProperty);
}
}
下面点个锤子吧
贴一张保存后的数据库吧: