mybatis plus json查询_mybatis-plus json字段查询

@TableName(value = "",autoResultMap = true)
 
@TableField(typeHandler = FileVoListTypeHandler.class)
 
public class FileVoListTypeHandler extends ListTypeHandler<FileVo> {
 
@Override
 
protected TypeReference<List<FileVo>> specificType() {
 
return new TypeReference<List<FileVo>>() {
 
};
 
}
 
}
 
 
 
@MappedJdbcTypes({JdbcType.VARBINARY})
 
@MappedTypes({List.class})
 
public abstract class ListTypeHandler<T> extends BaseTypeHandler<List<T>> {
 
public ListTypeHandler() {
 
}
 
 
 
@Override
 
public void setNonNullParameter(PreparedStatement ps, int i, List<T> parameter, JdbcType jdbcType) throws SQLException {
 
String content = CollectionUtils.isEmpty(parameter) ? null : JSON.toJSONString(parameter);
 
ps.setString(i, content);
 
}
 
@Override
 
public List<T> getNullableResult(ResultSet rs, String columnName) throws SQLException {
 
return this.getListByJsonArrayString(rs.getString(columnName));
 
}
 
@Override
 
public List<T> getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
 
return this.getListByJsonArrayString(rs.getString(columnIndex));
 
}
 
@Override
 
public List<T> getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
 
return this.getListByJsonArrayString(cs.getString(columnIndex));
 
}
 
private List<T> getListByJsonArrayString(String content) {
 
return (List)(StringUtils.isEmpty(content) ? new ArrayList() : (List)JSON.parseObject(content, this.specificType(), new Feature[0]));
 
}
 
protected abstract TypeReference<List<T>> specificType();
 
}

如果注解TableName的autoResultMap没有设置，查询时不会映射到字段上