public class ResourceContentDTO extends BaseDTO implements Serializable { private static final long serialVersionUID = 1L; /** 内容字段 需要用Byte数组接受 */ private byte[] fileContent; public byte[] getFileContent() { return fileContent; } public void setFileContent(byte[] fileContent) { this.fileContent = fileContent; } }
SQL
<resultMap id="resContentMap" class="resContentDTO"> <result property="fileContent" column="FILE_CONTENT" jdbcType="BLOB"/> </resultMap> <select id="getResourceXmlContentListByResourceId" resultMap="resContentMap" parameterClass="java.lang.String"> SELECT RC.FILE_CONTENT AS FILE_CONTENT FROM INF_RESOURCE_CONTENT RC WHERE RC.ONLINE_FLAG = 1 AND RC.RESOURCE_ID = #resourceId# </select>
读取:
byte[] fileContent = resourceContentDTO.getFileContent(); String fileContentStr = ""; fileContentStr = new String(fileContent, "UTF-8");