Todos os tipos! Tenho q apresentar uma lista e disponibilizar como um download.
Tipo: Arquivos Anexos procedimento.doc equipamentos.xls regras.pdf ----- Original Message ----- From: "CMilfont" <[EMAIL PROTECTED]> To: "Elias Sales" <[email protected]> Sent: Tuesday, March 15, 2005 9:11 AM Subject: Re: [cejug-discussao] recuperar arquivos em campo blob > 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=roo t > 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=roo t > 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] > ------------------------------------------------------------------------------------------- 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]
