que tipo de arquivo eh Elias? aquele exempo que postei eu conseguia ler jpeg, qual o erro que acontece?
Elias, Escreveu em Tuesday, March 15, 2005, 8:25:58 AM: ES> Galera conseguir gravar no banco de dados, mas o exemplo de como l� o ES> arquivo n�o deu certo, alguem tem um exemplo de como recuperar arquivos em ES> campo blob? ES> ----- Original Message ----- ES> From: "CMilfont" <[EMAIL PROTECTED]> ES> To: "Elias Sales" <[email protected]> ES> Sent: Monday, March 14, 2005 4:46 PM ES> 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 � ES> uma >> >> >pr�tica muito boa colocar tanto c�digo Java, pois fica muito mais ES> 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 ES> 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) ES> fi.getSize(); >> >> >>> byte [] imagem = new >> ES> byte[size]; >> >> >>> imagem = fi.get(); >> >> >>> >> >> >>> //upload.read(imagem, 0, ES> size); >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>Class.forName("com.mysql.jdbc.Driver"); >> >> >> >> >> >> >> >> >>> Connection con = >> >> >>> >> >> >>> >> >> >> >>>DriverManager.getConnection("jdbc:mysql://localhost:3306/sistema?user=root ES> & >> ES> p >> >> > >> >> > >> >> >>assword="); >> >> >> >> >> >> >> >> >>> PreparedStatement pstm = >> >> >>> >> >> >>> >> >> >>con.prepareStatement("INSERT INTO tb_fotos (nome, foto) VALUES (?, ES> ?)"); >> >> >> >> >> >> >> >> >>> 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> & >> 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 ES> 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 >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >> >>>>------------------------------------------------------------------------- ES> - >> >> >>----------------- >> >> >> >> >> >> >> >> >>>Ceara' Java User Group >> >> >>> >> >> >>> Para cancelar sua assinatura, envie um e-mail para: >> >> >>> >> >> >>> >> >> >>[EMAIL PROTECTED] >> >> >> >> >> >> >> >> >>> Para mais informacoes, mande um e-mail para: ES> [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: >> >> >> >> >> >> >> >> >[EMAIL PROTECTED] >> >> > >> >> > >> >> >> Para mais informacoes, mande um e-mail para: ES> [EMAIL PROTECTED] >> >> >> Falar com o administrador? e-mail para: [EMAIL PROTECTED] >> >> >> >> >> >> >> >> >> >> >> > >> >> > >> >> >> >>>-------------------------------------------------------------------------- ES> - >> 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: ES> [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> - >> 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> ------------------- >> 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: ES> [EMAIL PROTECTED] >> ES> Falar com o administrador? e-mail para: [EMAIL PROTECTED] >> >> >> >> >> -- >> Atenciosamente, >> CMilfont >> [EMAIL PROTECTED] >> >> -- >> Curtindo: Winamp stopped >> >> >> >> -------------------------------------------------------------------------- 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]
