BLOB字段转化成字符串String

最新推荐文章于 2024-10-16 14:49:19 发布

书之岁华

最新推荐文章于 2024-10-16 14:49:19 发布

阅读量1.8w

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： BLOB Oracle

本文链接：https://blog.youkuaiyun.com/yeyiting/article/details/83374710

Oracle 专栏收录该内容

6 篇文章

订阅专栏

本文详细介绍了在MyBatis框架中如何处理Blob类型数据，包括Model层的定义、Mapper映射文件的配置以及Controller层的实现。通过具体示例展示了Blob数据的读取和转换过程，适用于需要处理大量二进制数据的场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Model

private byte[] monent;
private byte[] resule;

Mapper

<resultMap id="ResultMapWithBLOBs" type="com.hgbanner.db.jhptmodel.UploadLogWithBLOBs" extends="BaseResultMap" >
    <result column="MONENT" property="monent" jdbcType="BLOB" />
    <result column="RESULE" property="resule" jdbcType="BLOB" />
</resultMap>

Controller

@RequestMapping(value = "/InterfaceLoginfo", method = RequestMethod.GET)
@RequiresPermissions(value = PermissionSign.JKRZCX)
@SystemControllerLog(description="接口日志信息", className="InterfaceLogController", methodName="getInterfaceLoginfo")
public String getInterfaceLoginfo(String logid, Model model) throws UnsupportedEncodingException {
	UploadLogWithBLOBs uBloBs = interfaceLogService.getInterfaceLoginfo(logid);
	String monent = null;
	String resule = null;
	if (uBloBs.getMonent() != null) {
		//Blob转化为UTF-8格式字符串
		monent = new String(uBloBs.getMonent(),"UTF-8");
	}
	if (uBloBs.getResule() != null) {
		//Blob转化为UTF-8格式字符串
		resule = new String(uBloBs.getResule(),"UTF-8");
	}
	model.addAttribute("interfaceLoginfo", uBloBs);
	model.addAttribute("monent", monent);
	model.addAttribute("resule", resule);
	return "dataexchange/interfacelogdetail";
}

Jsp

<textarea class="form-control" rows="6" readonly="readonly">${monent }</textarea>
<textarea class="form-control" rows="6" readonly="readonly">${resule }</textarea>