MyBatisPlus写入和读取mysql blob数据

实体类

autoResultMap注解必须开启

blob的对应字段，数据类型必须为byte[]，并且增加typeHandler =

@TableName(value = "pictures",autoResultMap = true)
@Data
public class Pic {
    @TableField(value = "name")
    private String name;
    @TableField(value = "pic_data",typeHandler = )
    private byte[] pic_data;
}

其他的正常写即可，读取的时候也按照byte[]即可

将byte[]写入文件

QueryWrapper<IrisPic> resultQueryWrapper = ();
("name", "");
Pic pic = (resultQueryWrapper);
ByteSink myPic= (new File(""));
(pic.getPic_data());