Pessoal preciso urgente da ajuda de vcs tenho q apresentar meu projeto de final de semestre na facul amanha e falta um detalhe no meu software q nao to conseguindo fazer conseguir fazer o upload de arquivo para o banco…

Download de Arquivo por Blob URGENTE!

Exemplo de servlet usando jdbc copiado do link
http://www.roseindia.net/jdbc/display-blob-example.shtml

import java.sql.Blob;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.io.IOException;
import java.io.InputStream;
import java.sql.SQLException;
import java.sql.DriverManager;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class DisplayBlobExample extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response) 
    throws IOException,ServletException {
    Blob image = null;
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
    ServletOutputStream out = response.getOutputStream();
    try {
      Class.forName("com.mysql.jdbc.Driver");
      con = DriverManager.getConnection("jdbc:mysql://192.168.10.59:3306/
       example","root","root");
      stmt = con.createStatement();
      rs = stmt.executeQuery("select image from pictures where  id = '2'");
      if (rs.next()) {
        image = rs.getBlob(1);
      } else {
        response.setContentType("text/html");
        out.println("<html><head><title>Display Blob Example</title></head>");
        out.println("<body><h4><font color='red'>image not found for given id</font>
        </h4></body></html>");
        return;
      }
      response.setContentType("image/gif");
      InputStream in = image.getBinaryStream();
      int length = (int) image.length();
      int bufferSize = 1024;
      byte[] buffer = new byte[bufferSize];
      while ((length = in.read(buffer)) != -1) {
        out.write(buffer, 0, length);
      }
      in.close();
      out.flush();
    } catch (Exception e) {
      response.setContentType("text/html");
      out.println("<html><head><title>Unable To Display image</title></head>");
      out.println("<body><h4><font color='red'>Image Display Error=" + e.getMessage() +
       "</font></h4></body></html>");
      return;
    } finally {
      try {
        rs.close();
        stmt.close();
        con.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }
}

1 Resposta

Topicos relacionados