实体定义:
/** * 序列sql blob写入byte[] */ private byte[] serialSql; /** * 序列sql字符串 读取blob字符串 */ @TableField(exist = false,typeHandler = org.apache.ibatis.type.BlobTypeHandler.class) private String serialSqlStr;
mapper注解配置
@Results({ @Result(id = true,column = "system_serial_number_id",property = "systemSerialNumberId"), @Result(column = "serial_sql",property = "serialSqlStr") })
插入blob数据:
String serialSqlStr = systemSerialNumber.getSerialSqlStr(); if (serialSqlStr != null){ systemSerialNumber.setSerialSql(serialSqlStr.getBytes(StandardCharsets.UTF_8)); }
查询结果 实体byte[] 不能查出数据
谢谢你的来访,希望能对你有所帮助!