Commons Fileupload http://jakarta.apache.org/commons/fileupload/
[]'s Rodrigo Lopes -----Mensagem original----- De: CMilfont [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 14 de mar�o de 2005 16:47 Para: Elias Sales Assunto: 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]
