jsp에서 blob 파일 미리보기

javascript

onload

var img = document.getElementById('preImg');
  img.src = '/labelImageView.htm?atchFileSn=<%= ATCH_FILE_SN[0] %>';

 

jsp

<img id="preImg" src='' />

 

 

java

Connection conn = null; 
  ResultSet rs = null;
  PreparedStatement pstmt = null;
  //Blob blob = null; // blob 데이터를 저장할 객체 생성
  ServletOutputStream sOut = response.getOutputStream(); // 이미지를 출력할 outputStream 객체 생성
  InputStream is       = null;
  
  tmpDesignVO = (LabelDesignRegManage) atchList[0];
  String atchFileSn = tmpDesignVO.ATCH_FILE_SN;

  try {
   conn = baseDAO.getJdbcTemplate(queryBuilder.getWhichConnPool()).getDataSource().getConnection();
   pstmt = conn.prepareStatement("SELECT ATCH_FILE_NM AS ATCH_FILE_NM, ATCH_FILE AS ATCH_FILE, LENGTH(ATCH_FILE) AS FILE_LENGTH, ATCH_FILE_TYPE_CODE FROM SLBL_ATCH_FILE_PCL WHERE ATCH_FILE_SN = ?");
   
   pstmt.setString(1, atchFileSn);
   //pstmt.setString(2, atchFileNm);
   rs = pstmt.executeQuery();
   
   if(rs.next())
   {
    String fileSize = "";
    String fileType = "";
    
    //blob = (BLOB) rs.getBlob(2);

    fileSize = rs.getString(3);
    fileType = rs.getString(4);
    
    tmpDesignVO.FILE_SIZE = fileSize;
    tmpDesignVO.FILE_TYPE = fileType;
    
    is = rs.getBinaryStream(2);
   }   
   
   response.setContentType("image/jpeg");
   int binaryRead;
      while ((binaryRead = is.read()) != -1)
      {
       sOut.write(binaryRead);
      }