Received: from quasimodo.uol.com.br ([194.1.43.2]) by SLNWWW.degussa-huels.com.br (Lotus SMTP MTA v4.6.6 (890.1 7-16-1999)) with SMTP id 03256A0F.005ABC76; Wed, 14 Mar 2001 13:31:04 -0300 Received: from ASP16 (srv4.aspatech.com.br [200.225.92.108] (may be forged)) by quasimodo.uol.com.br (8.9.1/8.9.1) with SMTP id MAA16695 for ; Wed, 14 Mar 2001 12:33:49 -0300 (BRT) Message-ID: <015d01c0ac9c$e5ad2820$3501030a@ASPATECH.COM.BR> From: "Harrisson Ferreira Gomes" To: References: <03256A0F.004E1506.00@degussa-huels.com.br> Subject: Re: [java-list] Ajuda com imagens Date: Wed, 14 Mar 2001 12:39:00 -0300 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0159_01C0AC83.BEEBEDC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 This is a multi-part message in MIME format. ------=_NextPart_000_0159_01C0AC83.BEEBEDC0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_015A_01C0AC83.BEEBEDC0" ------=_NextPart_001_015A_01C0AC83.BEEBEDC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Cara o que eu uso eh o Oracle, creio que o SQLServer 7 tb da, estou = usando o pacote da oracle o InterMedia que me ajudou bastante, mais o = que sei para vc estar buscando e usar os campos blob ou clob ( nao sei = se o SQLServer tem).=20 Vou lhe passar uns .txt que tem alguns codigos que peguei da internet, = eles trazem imagens de banco de dados, nao usei elas mais podem lhe = ajudar. Qualquer coisa me mande msg. Harrisson ----- Original Message -----=20 From: mffigueiredo@dmc-2.com.br=20 To: harrisson.gomes@uol.com.br=20 Sent: Wednesday, March 14, 2001 10:20 AM Subject: Re: [java-list] Ajuda com imagens Harrisson, desculpe responder a sua pergunta com outra pergunta, mas estou um = passo antes de voc=EA e gostaria de saber como voc=EA fez para armazenar e trazer = as imagens do banco. =C9 que no meu caso tenho algumas imagens TIF que eu gostaria = de armazenar no SQLServer 7. =C9 poss=EDvel? Desde j=E1 agrade=E7o sua aten=E7=E3o. "Harrisson Ferreira Gomes" em 03/14/2001 = 09:15:26 AM Favor responder a java-list@soujava.org.br Para: java-list@soujava.org.br cc: jsp_brasil@yahoogroups.com, java@grupos.com.br (bcc: Marcelo Figueiredo/DSA) Assunto: [java-list] Ajuda com imagens Ola a todos, tenham um bom dia. Estou com uma pequena duvida que para muitos ser=E1 bem = simples, tenho um Servlet que traz de uma base de dados varias imagens, e tenho um = Applet que pega varias imagens passadas como par=E2metro e mostra l=E1 como um = gif animado (Pipeline), s=F3 que n=E3o consegui fazer com que o meu Servlet = interagisse com o Applet. Gostaria da opini=E3o de todos sobre o que estou tentando = fazer se e vi=E1vel ou n=E3o, tentei colocar no meu Servlet um for, mais n=E3o = ficou legal. Certo da ajuda de todos, agrade=E7o desde j=E1. Harrisson Gomes ------=_NextPart_001_015A_01C0AC83.BEEBEDC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Cara o que eu uso eh o = Oracle, creio que o=20 SQLServer 7 tb da, estou usando o pacote da oracle o InterMedia que me = ajudou=20 bastante, mais o que sei para vc estar buscando e usar os campos blob ou = clob (=20 nao sei se o SQLServer tem).

Vou lhe passar uns .txt que tem alguns = codigos que=20 peguei da internet, eles trazem imagens de banco de dados, nao usei elas = mais=20 podem lhe ajudar.

Qualquer coisa me mande = msg.

Harrisson

----- Original Message -----

From:=20 mffigueiredo@dmc-2.com.br

To: harrisson.gomes@uol.com.br =

Sent: Wednesday, March 14, 2001 = 10:20=20 AM

Subject: Re: [java-list] Ajuda = com=20 imagens

Harrisson,

desculpe responder a sua = pergunta=20 com outra pergunta, mas estou um passo antes
de voc=EA e gostaria = de saber=20 como voc=EA fez para armazenar e trazer as imagens do
banco. =C9 = que no meu=20 caso tenho algumas imagens TIF que eu gostaria de armazenar
no = SQLServer 7.=20 =C9 poss=EDvel?

Desde j=E1 agrade=E7o sua=20 aten=E7=E3o.

"Harrisson Ferreira Gomes"=20 <harrisson.gomes@uol.com.br> em 03/14/2001 = 09:15:26
AM

Favor=20 responder a java-list@soujava.org.br

Para:=20 java-list@soujava.org.br
cc:   = jsp_brasil@yahoogroups.com,=20 java@grupos.com.br (bcc: Marcelo
     =20 Figueiredo/DSA)
Assunto: [java-list] Ajuda com=20 imagens

   Ola a todos, tenham um bom=20 = dia.

          &= nbsp;=20 Estou com uma pequena duvida que para muitos ser=E1 bem simples, = tenho
um=20 Servlet que traz de uma base de dados varias imagens, e tenho um = Applet=20 que
pega varias imagens passadas como par=E2metro e mostra l=E1 = como um gif=20 animado
(Pipeline), s=F3 que n=E3o consegui fazer com que o meu = Servlet=20 interagisse com=20 = o
Applet.
         &nb= sp; =20 Gostaria da opini=E3o de todos sobre o que estou tentando fazer se = e
vi=E1vel=20 ou n=E3o, tentei colocar no meu Servlet um for, mais n=E3o ficou=20 = legal.

          = ; =20 Certo da ajuda de todos, agrade=E7o desde j=E1.

Harrisson=20 Gomes
------=_NextPart_001_015A_01C0AC83.BEEBEDC0-- ------=_NextPart_000_0159_01C0AC83.BEEBEDC0 Content-Type: text/plain; name="teste4.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="teste4.txt" dearsenthil you have asked for getting an imagefrom the database please = see this code=20 ..................>=20 import javax.servlet.*;=20 import javax.servlet.http.*;=20 import java.io.*;=20 import java.sql.*;=20 public class getblob extends HttpServlet=20 {=20 public void doGet(HttpServletRequest req, HttpServletResponse res)=20 throws ServletException, IOException {=20 res.setContentType("image/gif");=20 ServletOutputStream out =3D res.getOutputStream();=20 try=20 {=20 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");=20 Connection con =3DDriverManager.getConnection = ("jdbc:odbc:venu","scott","tiger");=20 Statement st=3Dcon.createStatement();=20 System.out.println("before satement gets executed");=20 ResultSet rs=3Dst.executeQuery("select image from images where = sno=3D101");=20 System.out.println("query executed");=20 rs.next();=20 InputStream is=3Drs.getBinaryStream(1);=20 byte[] buf =3D new byte[4 * 1024*1024];=20 int bytesRead;=20 while ((bytesRead =3D is.read(buf)) !=3D -1)=20 {=20 out.write(buf, 0, bytesRead);=20 }=20 is.close();=20 st.close();=20 con.close();=20 //System.out.println(rs.getInt(1));=20 }=20 catch (Exception e1)=20 {=20 out.println(e1.toString());=20 }=20 //fis.close();=20 }=20 }=20 ------------------------------------------------- ------=_NextPart_000_0159_01C0AC83.BEEBEDC0 Content-Type: text/plain; name="teste2.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="teste2.txt" Hi=20 I have the code to insert a blob and retrieve it.=20 insblob.java---inserts blob into database=20 import java.sql.*;=20 import java.io.*;=20 class insblob=20 {=20 public static void main (String args []) throws SQLException=20 {=20 Connection conn =3D null;=20 // Load the Oracle JDBC driver=20 try=20 {=20 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");=20 conn =3DDriverManager.getConnection("jdbc:odbc:cip","","");=20 }=20 catch (ClassNotFoundException e)=20 {=20 System.out.println(e);=20 return;=20 }=20 // Connect to the database // You must put a database name after the @ = sign in the connection URL. // You can use either the fully=20 // specified SQL*net syntax or a short cut // syntax as = ::. The example uses the short cut syntax.=20 try=20 {=20 //=3D DriverManager.getConnection = ("jdbc:oracle:oci8:@america","danko","dino");=20 File pictFile =3D new File("c:/windows/Hlpbell.gif");=20 int pictFilelen =3D (int)pictFile.length();=20 InputStream fPict =3D new FileInputStream(pictFile);=20 PreparedStatement myStmt =3D conn.prepareStatement("insert into imgblob = values(?,?)") ;=20 myStmt.setInt(1,102);=20 myStmt.setBinaryStream(2,fPict, pictFilelen);=20 int res =3D myStmt.executeUpdate();=20 System.out.println("image inserted");=20 myStmt.close();=20 conn.close();=20 }=20 catch (Exception ex)=20 {=20 System.out.println(ex);=20 System.out.println(ex.getMessage());=20 }=20 }=20 }=20 image.java--retrieves the blob=20 import java.sql.*;=20 import java.io.*;=20 import javax.servlet.*;=20 import javax.servlet.http.* ;=20 public class image extends HttpServlet=20 {=20 Connection conn=3D null;=20 Statement st =3D null ;=20 ResultSet rs =3D null;=20 public void init(ServletConfig sc) throws ServletException=20 {=20 super.init(sc);=20 try {=20 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");=20 System.out.println("driver loaded");=20 conn =3DDriverManager.getConnection("jdbc:odbc:cip","","");=20 System.out.println("connected to database");=20 }catch (Exception e){=20 System.out.println(e);=20 }=20 }=20 public void doGet(HttpServletRequest req,HttpServletResponse res)=20 throws ServletException,IOException=20 {=20 res.setContentType ("image/gif");=20 ServletOutputStream outstream =3D res.getOutputStream();=20 try {=20 st =3D conn.createStatement ();=20 rs =3D st.executeQuery ("select * from imgblob ");=20 while (rs.next())=20 {=20 InputStream instream =3D rs.getBinaryStream("img");=20 // Create temporary buffer for read=20 byte[] buffer =3D new byte[5*1024];=20 // length of bytes read=20 int length =3D 0;=20 // Fetch data=20 while ((length =3D instream.read(buffer)) !=3D -1)=20 {=20 outstream.write (buffer, 0, length);=20 }=20 //buffer=3Dnull;=20 }=20 } catch(SQLException e){=20 System.out.println("hooo"+e);=20 }=20 }=20 }=20 i hope this serves ur request=20 bye=20 pramod ------=_NextPart_000_0159_01C0AC83.BEEBEDC0 Content-Type: text/plain; name="teste3.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="teste3.txt" Re: Session Variables=20 posted by: venugopal reply Thursday, Nov 9, 12:43 AM =20 iam giving a login code and after login seesion validation please = compare and see it may work for you=20 ------->=20 //import packages=20 import java.io.*;=20 import javax.servlet.*;=20 import javax.servlet.http.*;=20 import java.util.*;=20 import java.sql.*;=20 public class Memberlogin extends HttpServlet=20 {=20 private BENConnectionPool pool;=20 public void init(ServletConfig config) throws ServletException=20 {=20 super.init(config);=20 try=20 {=20 System.out.println("before connection opened");=20 pool=3Dnew = BENConnectionPool("jdbc:odbc:banner","banner","banner","sun.jdbc.odbc.Jdb= cOdbcDriver",1,1);=20 System.out.println("after connection opened");=20 }=20 catch(Exception e)=20 {=20 System.out.println(e);=20 }=20 }=20 public void doPost(HttpServletRequest req,HttpServletResponse res) = throws ServletException,IOException=20 {=20 res.setContentType("text/html");=20 PrintWriter out=3Dres.getWriter();=20 Connection con=3Dnull;=20 PreparedStatement pst=3Dnull;=20 Statement st=3Dnull;=20 ResultSet rs=3Dnull;=20 boolean CorrectUser=3Dfalse;=20 boolean Received=3Dfalse;=20 String m_strMemberid =3Dreq.getParameter("Username");=20 System.out.println("Name:"+m_strMemberid);=20 String m_strPassword =3Dreq.getParameter("Password");=20 System.out.println("Pass:"+m_strPassword);=20 System.out.println("This iis for data base checking");=20 try=20 {=20 con=3Dpool.getConnection();=20 String checkingUserid=3D"select memberid,password from bendetails where = memberid=3D? and password=3D?";=20 pst=3Dcon.prepareCall(checkingUserid);=20 pst.setString(1,m_strMemberid);=20 pst.setString(2,m_strPassword);=20 rs=3Dpst.executeQuery();=20 System.out.println("After RS");=20 if(rs.next())=20 {=20 out.println ("User id &password are correect go ahead");=20 HttpSession session=3Dreq.getSession(true);=20 session.putValue("username",m_strMemberid);=20 session.putValue("password",m_strPassword);=20 CorrectUser=3Dtrue;=20 //res.sendRedirect("http://client0187:8080/URLList.html");=20 }=20 else=20 {=20 out.println ("User id &password are incorrect ");=20 res.sendRedirect("http://client0187:8080/Invalidlogin.html");=20 }=20 String ReceivedAnyCredits=3D"select idreceived,transfer_result_flag from = bentransferdetails where idreceived=3D'"+m_strMemberid+"' and = transfer_result_flag=3D'F'";=20 if(CorrectUser)=20 {=20 System.out.println("valid user");=20 st=3Dcon.createStatement();=20 rs=3Dst.executeQuery(ReceivedAnyCredits);=20 while(rs.next())=20 {=20 Received=3Dtrue;=20 System.out.println("he received");=20 }=20 res.sendRedirect("http://client0187:8080/URLList.html");=20 }=20 }=20 catch(Exception e)=20 {=20 System.out.println(e);=20 }=20 finally=20 {=20 try=20 {=20 if(rs!=3Dnull)=20 {=20 rs.close();=20 }=20 if(pst!=3Dnull)=20 {=20 pst.close();=20 }=20 }=20 catch(Exception e)=20 {=20 System.out.println(e);=20 }=20 if(con!=3Dnull)=20 {=20 pool.returnConnection(con);=20 }=20 }=20 }=20 }=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 after login please see this=20 /*click banner*/=20 import javax.servlet.*;=20 import javax.servlet.http.*;=20 import java.io.*;=20 import java.sql.*;=20 public class ClickBanner extends HttpServlet=20 {=20 private BENConnectionPool pool;=20 public void init(ServletConfig sc)throws ServletException=20 {=20 super.init(sc);=20 try=20 {=20 pool=3Dnew = BENConnectionPool("jdbc:odbc:banner","banner","banner","sun.jdbc.odbc.Jdb= cOdbcDriver",1,1);=20 }=20 catch(Exception e)=20 {=20 System.out.println(e);=20 }=20 }=20 public void doGet(HttpServletRequest req, HttpServletResponse res)throws = ServletException, IOException=20 {=20 res.setContentType("image/gif");=20 res.setHeader("Pragma","no-cache");=20 ServletOutputStream out =3D res.getOutputStream();=20 Connection con=3Dnull;=20 ResultSet rs=3Dnull;=20 Statement st=3Dnull;=20 boolean flag=3Dfalse;=20 String urlstring=3D"";=20 try=20 {=20 int r_urlid=3DInteger.parseInt(req.getParameter("banner"));=20 con=3Dpool.getConnection();=20 st=3Dcon.createStatement();=20 HttpSession bannersession=3Dreq.getSession(false);=20 Integer s_urlid=3D(Integer)bannersession.getValue("DisplayBannerURLID"); = int clickbannerurlid=3D s_urlid.intValue();=20 bannersession.invalidate();=20 System.out.println("End of the click Banner 1 ");=20 String query1=3D"select url from bensitedetails where = urlid=3D"+clickbannerurlid;=20 rs=3Dst.executeQuery(query1);=20 System.out.println("End of the click Banner 2 ");=20 // HttpSession downlinesession =3D req.getSession(true);=20 // downlinesession.putValue("DownlineURLID",new Integer(r_urlid));=20 while(rs.next())=20 {=20 urlstring=3Drs.getString(1);=20 flag=3Dtrue;=20 }=20 if(flag)=20 {=20 res.sendRedirect(urlstring);=20 String query6=3D " update benstatistics set = clickthrusjoin=3Dclickthrusjoin+1,clickthrusreset=3Dclickthrusreset+1 = where urlid=3D"+clickbannerurlid;=20 st.executeUpdate(query6);=20 con.commit();=20 }=20 System.out.println("End of the click Banner class");=20 }=20 catch(Exception e)=20 {=20 System.out.println(e);=20 }=20 }=20 }=20 ------=_NextPart_000_0159_01C0AC83.BEEBEDC0 Content-Type: text/plain; name="teste1.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="teste1.txt" Hi=20 i tried to display an image from database using servlets/jdbc but i = getting an exception "no resultset produced".the following is the code = which i used.i will be glad if someone can help me in this regard.=20 thanks in advance=20 pramod=20 import java.sql.*;=20 import java.io.*;=20 import javax.servlet.*;=20 import javax.servlet.http.* ;=20 public class getblob extends HttpServlet=20 {=20 Connection con =3D null;=20 public void init(ServletConfig sc) throws ServletException=20 {=20 super.init(sc);=20 // Load the Oracle JDBC driver=20 try {=20 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");=20 System.out.println("driver loaded");=20 con =3DDriverManager.getConnection("jdbc:odbc:test","scott","tiger");=20 System.out.println("connected to database");=20 }catch (Exception e){=20 System.out.println(e);=20 }=20 }=20 public void doGet(HttpServletRequest req , HttpServletResponse res)=20 throws ServletException , IOException {=20 try{=20 res.setContentType("image/gif");=20 ServletOutputStream out =3D res.getOutputStream() ;=20 Statement st =3D con.createStatement() ;=20 ResultSet rs =3D st.executeQuery("select image from imgblob where = sno=3D101");=20 System.out.println("test");=20 while (rs.next())=20 {=20 System.out.println("hi");=20 BufferedInputStream gif =3D new = BufferedInputStream(rs.getBinaryStream("image"));=20 byte[] buf =3D new byte[3*1024];=20 int len ;=20 while ((len=3Dgif.read(buf,0,buf.length))!=3D-1)=20 {=20 out.write(buf,0,len);=20 }=20 }=20 }catch(Exception e){=20 System.out.println(e);=20 }=20 }=20 }=20 --------------------------------------------- Hi,=20 The following is the code I used to show image on the screen. This code = would be helpful, if you are storing images in the Oracle database.=20 If you are using other database like DB2, mySQL. you don't need to go = that difficult.=20 public void returnImageFile (String query) throws IOException, = SQLException=20 {=20 boolean headOnly;=20 if (getRequest().getMethod().equalsIgnoreCase ("get"))=20 headOnly =3D false;=20 else if (!getRequest().getMethod().equalsIgnoreCase( "head"))=20 headOnly =3D true;=20 else=20 {=20 getResponse().sendError( HttpServletResponse.SC_NOT_IMPLEMENTED );=20 return;=20 }=20 Statement statement =3D null;=20 ResultSet rs =3D null;=20 try=20 {=20 statement =3D getConnection().createStatement ();=20 rs =3D statement.executeQuery (query);=20 if (rs.next())=20 {=20 Blob blob =3D rs.getBlob (1);=20 String image_mime =3D rs.getString (2);=20 getResponse().setContentType (image_mime);=20 ServletOutputStream outstream =3D getResponse().getOutputStream();=20 if (!headOnly)=20 {=20 // Get binary output stream to retrieve blob data=20 InputStream instream =3D blob.getBinaryStream();=20 // Create temporary buffer for read=20 byte[] buffer =3D new byte[10];=20 // length of bytes read=20 int length =3D 0;=20 // Fetch data=20 while ((length =3D instream.read(buffer)) !=3D -1)=20 {=20 outstream.write (buffer, 0, length);=20 }=20 // Close input stream=20 instream.close();=20 }=20 outstream.flush();=20 outstream.close();=20 }=20 }=20 catch (SQLException ex)=20 {=20 getResponse().sendError (HttpServletResponse.SC_NOT_FOUND);=20 return;=20 } ------=_NextPart_000_0159_01C0AC83.BEEBEDC0--