Galera conseguir gravar no banco de dados, mas o exemplo de como l� o arquivo n�o deu certo, alguem tem um exemplo de como recuperar arquivos em campo blob?
----- Original Message ----- From: "CMilfont" <[EMAIL PROTECTED]> To: "Elias Sales" <[email protected]> Sent: Monday, March 14, 2005 4:46 PM Subject: Re[2]: [cejug-discussao] Tratamento de dados em blob > eh do grupo apache, acho que vem no tomcat 5, se nao entra no projeto > jakarta e procura la que vc acha.... > > Elias, > Escreveu em Monday, March 14, 2005, 3:54:11 PM: > > ES> <%@ page import="org.apache.commons.fileupload.*" %> > > ES> Qual api tem esse pacote? > > > ES> ----- Original Message ----- > ES> From: "David Barbosa Feitosa" <[EMAIL PROTECTED]> > ES> To: <[email protected]> > ES> Sent: Monday, March 14, 2005 3:44 PM > ES> Subject: Re: [cejug-discussao] Tratamento de dados em blob > > > >> O Netbeans debuga > >> eh s� colocar os break points no JSP > >> e acompanhar na Aba de debug. > >> flws! > >> > >> ldaniel wrote: > >> > >> >Oi, pessoal. > >> > > >> >S� um coment�rio: > >> > > >> >A menos que voc� conhe�a uma forma eficiente de debugar o JSP, n�o � uma > >> >pr�tica muito boa colocar tanto c�digo Java, pois fica muito mais dif�cil > >> >encontrar problemas. Quanto ao debug do JSP, estou procurando um jeito > ES> (sei > >> >que tem gente que faz), mas n�o conhe�o ainda. Ent�o, se algu�m souber e > >> >quiser compartilhar, eu ficaria grato. > >> > > >> >[]s. > >> > > >> >----- Original Message ----- > >> >From: "Elias Sales" <[EMAIL PROTECTED]> > >> >To: <[email protected]>; "CMilfont" <[EMAIL PROTECTED]> > >> >Sent: Wednesday, March 02, 2005 18:59 > >> >Subject: Re: [cejug-discussao] Tratamento de dados em blob > >> > > >> > > >> > > >> > > >> >>Valeu cara vou testar... > >> >> > >> >>----- Original Message ----- > >> >>From: "CMilfont" <[EMAIL PROTECTED]> > >> >>To: "Elias Sales" <[email protected]> > >> >>Sent: Wednesday, March 02, 2005 10:04 AM > >> >>Subject: Re: [cejug-discussao] Tratamento de dados em blob > >> >> > >> >> > >> >> > >> >> > >> >>>ve se esses codigos te ajudam... > >> >>> > >> >>>jsp com um exemplo de insercao: > >> >>> > >> >>><%@ page import="java.util.*" %> > >> >>><%@ page import="java.text.*" %> > >> >>><%@ page import="java.sql.*" %> > >> >>><%@ page import="org.apache.commons.fileupload.*" %> > >> >>> > >> >>><% > >> >>>if (FileUpload.isMultipartContent(request)) { > >> >>> DiskFileUpload fu = new DiskFileUpload(); > >> >>> fu.setSizeMax(800000); > >> >>> try { > >> >>> List items = fu.parseRequest(request); > >> >>> Iterator i = items.iterator(); > >> >>> FileItem fi; > >> >>> String cmt=null; > >> >>> > >> >>> while (i.hasNext()) { > >> >>> fi = (FileItem)i.next(); > >> >>> if (fi.isFormField()) { > >> >>> cmt = fi.getString(); > >> >>> } else{ > >> >>> > >> >>> int size = (int) fi.getSize(); > >> >>> byte [] imagem = new > ES> byte[size]; > >> >>> imagem = fi.get(); > >> >>> > >> >>> //upload.read(imagem, 0, size); > >> >>> > >> >>> > >> >>> > >> >>> > >> >>Class.forName("com.mysql.jdbc.Driver"); > >> >> > >> >> > >> >>> Connection con = > >> >>> > >> >>> > >> > >>DriverManager.getConnection("jdbc:mysql://localhost:3306/sistema?user=root & > ES> p > >> > > >> > > >> >>assword="); > >> >> > >> >> > >> >>> PreparedStatement pstm = > >> >>> > >> >>> > >> >>con.prepareStatement("INSERT INTO tb_fotos (nome, foto) VALUES (?, ?)"); > >> >> > >> >> > >> >>> pstm.setString(1, cmt); > >> >>> pstm.setBytes(2, imagem); > >> >>> pstm.executeUpdate(); > >> >>> con.close(); > >> >>> } > >> >>> } > >> >>> } catch (FileUploadException e) { > >> >>> out.print("Erro no upload do arquivo"); > >> >>> } catch (SQLException e) { > >> >>> out.print("Erro na consulta com o banco de > >> >>> > >> >>> > >> >>dados"); > >> >> > >> >> > >> >>> } catch (Exception e) { > >> >>> out.print(e.getMessage()); > >> >>> } > >> >>>}else { > >> >>> out.print("O Formulario nao possui dados bin�rios"); > >> >>>} > >> >>> > >> >>>%> > >> >>> > >> >>><html> > >> >>><body bgcolor="#FFFFFF"> > >> >>><h2>Fonto inserida com sucesso no banco de dados!</h2> > >> >>></body> > >> >>></html> > >> >>> > >> >>>/************************************ > >> >>>exemplo de leitura: > >> >>> > >> >>><%@ page language="java" %> > >> >>><%@ page import="java.util.*" %> > >> >>><%@ page import="java.text.*" %> > >> >>><%@ page import="java.io.*" %> > >> >>><%@ page import="java.lang.*" %> > >> >>><%@ page import="java.sql.*" %> > >> >>><%@ page import="java.awt.*" %> > >> >>> > >> >>><%! > >> >>>byte [] image; > >> >>>%> > >> >>> > >> >>><% > >> >>>try { > >> >>> // criando a conexao com o banco de dados > >> >>> > >> >>> Class.forName("com.mysql.jdbc.Driver"); > >> >>> Connection con = > >> >>> > >> >>> > >> > >>DriverManager.getConnection("jdbc:mysql://localhost:3306/sistema?user=root & > ES> p > >> > > >> > > >> >>assword="); > >> >> > >> >> > >> >>> //PreparedStatement pstm = > >> con.prepareStatement("INSERT INTO > >> >>> > >> >>> > >> >>tb_fotos (nome, foto) VALUES (?, ?)"); > >> >> > >> >> > >> >>> Statement stm = con.createStatement(); > >> >>> > >> >>> int codigo; > >> >>> // pegando o codigo da foto a ser exibida > >> >>> if (request.getParameter("numero") == null){codigo = 1; } > >> >>> else{codigo = > ES> Integer.parseInt(request.getParameter("numero"));} > >> >>> > >> >>> ResultSet rs = stm.executeQuery("SELECT * FROM tb_fotos WHERE > ES> id > >> >>> > >> >>> > >> >= > >> > > >> > > >> >>"+codigo); > >> >> > >> >> > >> >>> if (rs.next()) { > >> >>> > >> >>> Blob blob = rs.getBlob("foto"); > >> >>> > >> >>> > >> //JPEGManager.encodeJPG(response.getOutputStream(), > >> >>> > >> >>> > >> >>blob.getBytes(1, (int) blob.length())); > >> >> > >> >> > >> >>> image = blob.getBytes(1, (int) blob.length()); > >> >>> int BUFFER = image.length; > >> >>> InputStream fs = new ByteArrayInputStream(image); > >> >>> JPEGImageDecoder decoder = > >> >>> > >> >>> > >> >>JPEGCodec.createJPEGDecoder(fs); > >> >> > >> >> > >> >>> BufferedImage bImage = > >> decoder.decodeAsBufferedImage(); > >> >>> JPEGImageEncoder encoder = > >> >>> > >> >>> > >> >>JPEGCodec.createJPEGEncoder(out); > >> >> > >> >> > >> >>> encoder.encode(bImage); > >> >>> fs.close(); > >> >>> fs = null; > >> >>> encoder = null; > >> >>> bImage = null; > >> >>> > >> >>> } > >> >>> con.close(); > >> >>>}catch (Exception e){ > >> >>> // erro > >> >>> %>Erro encontrado<% > >> >>>} > >> >>>%> > >> >>> > >> >>> > >> >>>Elias, > >> >>>Escreveu em Tuesday, March 1, 2005, 7:03:19 PM: > >> >>> > >> >>>ES> alguem tem algum exemplo de gravar e ler campos em > >> >>>ES> blob usando mysql? > >> >>>-- > >> >>>Atenciosamente, > >> >>> CMilfont > >> >>> [EMAIL PROTECTED] > >> >>> > >> >>>-- > >> >>>Curtindo: Pitty Festival de Ver�o 2005 - 01 > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> > >>>------------------------------------------------------------------------- - > >> >>----------------- > >> >> > >> >> > >> >>>Ceara' Java User Group > >> >>> > >> >>> Para cancelar sua assinatura, envie um e-mail para: > >> >>> > >> >>> > >> >>[EMAIL PROTECTED] > >> >> > >> >> > >> >>> Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] > >> >>> Falar com o administrador? e-mail para: [EMAIL PROTECTED] > >> >>> > >> >>> > >> >>> > >> > >>>------------------------------------------------------------------------- - > >> >> > >> >> > >> >----------------- > >> > > >> > > >> >>Ceara' Java User Group > >> >> > >> >> Para cancelar sua assinatura, envie um e-mail para: > >> >> > >> >> > >> >[EMAIL PROTECTED] > >> > > >> > > >> >> Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] > >> >> Falar com o administrador? e-mail para: [EMAIL PROTECTED] > >> >> > >> >> > >> >> > >> > > >> > > >> > >>-------------------------------------------------------------------------- - > ES> ---------------- > >> > > >> >Ceara' Java User Group > >> > > >> > > >> > > >> > Para cancelar sua assinatura, envie um e-mail para: > ES> [EMAIL PROTECTED] > >> > > >> > Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] > >> > > >> > Falar com o administrador? e-mail para: [EMAIL PROTECTED] > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > >> -- > >> David Barbosa Feitosa > >> Engenheiro de Sistemas > >> > >> Tel.: 55 (81) 3425-5729 > >> Cel.: 55 (81) 8887-7064 > >> MSN : [EMAIL PROTECTED] > >> ICQ : 159135932 > >> > >> C.E.S.A.R. - Centro de Estudos e Sistemas Avan�ados do Recife > >> > >> > >> ------------------------------------------------------------------------- - > ES> ----------------- > >> Ceara' Java User Group > >> > >> Para cancelar sua assinatura, envie um e-mail para: > ES> [EMAIL PROTECTED] > >> Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] > >> Falar com o administrador? e-mail para: [EMAIL PROTECTED] > >> > > > ES> ------------------------------------------------------------------------ ------------------- > ES> Ceara' Java User Group > > ES> Para cancelar sua assinatura, envie um e-mail para: > ES> [EMAIL PROTECTED] > ES> Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] > ES> Falar com o administrador? e-mail para: [EMAIL PROTECTED] > > > > > -- > Atenciosamente, > CMilfont > [EMAIL PROTECTED] > > -- > Curtindo: Winamp stopped > > > > -------------------------------------------------------------------------- ----------------- > Ceara' Java User Group > > Para cancelar sua assinatura, envie um e-mail para: [EMAIL PROTECTED] > Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] > Falar com o administrador? e-mail para: [EMAIL PROTECTED] > ------------------------------------------------------------------------------------------- Ceara' Java User Group Para cancelar sua assinatura, envie um e-mail para: [EMAIL PROTECTED] Para mais informacoes, mande um e-mail para: [EMAIL PROTECTED] Falar com o administrador? e-mail para: [EMAIL PROTECTED]
