实体类:
@Data
public class Images {
/**
* 图片
*/
private byte [] picture;
}
ImagesMapper :
@Mapper
public interface ImagesMapper {
List<Images> selectImgList();
}
ImagesMapper .xml:
<select id="selectImgList" resultType="Images">
select picrure from images
</select>
service:
public interface ImagesService {
List<images> selectList();
}
serviceImpl:
public classImagesServiceImpl extends ImagesService{
@Autowired
private ImagesMapper imagesMapper;
List<images> selectList(){
List<Images> imgList = imagesMapper.selectList();
if (!imgList.isEmpty()) {
imgList.forEach(img -> {
img.setPicture("data:image/jpeg;base64,"+Base64.getEncoder().encodeToString(img.getPicture()));
});
}
}
}