1,首先导入要用到的包(特别注意版本,3.1以下不支持)

  1. <dependency>
  2. <groupId>com.baomidou</groupId>
  3. <artifactId>mybatis-plus-boot-starter</artifactId>
  4. <version>3.4.3.1</version>
  5. </dependency>

2,实体注解配置,@TableName @TableField

  1. import com.baomidou.mybatisplus.annotation.IdType;
  2. import com.baomidou.mybatisplus.annotation.TableField;
  3. import com.baomidou.mybatisplus.annotation.TableId;
  4. import com.baomidou.mybatisplus.annotation.TableName;
  5. import com.baomidou.mybatisplus.extension.handlers.FastjsonTypeHandler;
  6. import com.zh.wisdom.bo.OssFileBo;
  7. import lombok.Data;
  8. import java.util.List;
  9. /**
  10. * @Author YMG
  11. * @Date 2021/7/28 10:18
  12. * @Description :
  13. */
  14. @Data
  15. @TableName(value = "rui",autoResultMap = true)
  16. public class Rui {
  17. @TableId(type = IdType.AUTO)
  18. private Integer id;
  19. @TableField(typeHandler = FastjsonTypeHandler.class)
  20. private List<OssFileBo> ossFiles;
  21. private String rui;
  22. }

3,mapper.xml配置

  1. <result column="oss_files" jdbcType="VARCHAR" property="ossFiles" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" />

4,存库效果及查询效果展示

image.png
image.png