问题:Mybatis: JdbcType解析BLOB报No typehandler found for property,添加属性typeHandler解决了
问题:Java接收blob,返回字段数据为null
通过对象接收方式:
Mybatis配置文件xml中配置
<resultMap type="com.dangj.member.vo.DjUserVo" id="DjUserResult">
<result property="photo" column="photo" jdbcType="BLOB" typeHandler="org.apache.ibatis.type.BlobTypeHandler"/>
</resultMap>
java接收对象
@Data
@NoArgsConstructor
@Accessors(chain = true)
public class DjUserVo implements Serializable {
private static final long serialVersionUID=1L;
//头像照片
private Object photo;
}
vue前端加载显示(图片路径为base64文件)
<el-table-column
prop="photo"
label="照片">
<template slot-scope="scope">
<!-- <img :src="'data:image/png;base64,'+scope.row.photo" alt="" width='75' height="90"/>-->
<el-popover
placement="right"
title=""
trigger="hover">
<img :src="'data:image/png;base64,'+scope.row.photo"/>
<img slot="reference" :src="'data:image/png;base64,'+scope.row.photo" :alt="scope.row.photo" style="max-height: 80px;max-width: 70px">
</el-popover>
</template>
</el-table-column>
1、原创文章,作者:诺米,如若转载,请注明出处:https://www.http3w.com/archives/523
2、本站内容若有雷同从属巧合,若侵犯了您的权益,请联系本站删除,E-mail: wtao219@qq.com