0 Replies Latest reply on Jun 8, 2016 7:25 PM by cbce2b6a-00ba-4120-8bc6-d7700859065a

    Blob image in Jsp

    cbce2b6a-00ba-4120-8bc6-d7700859065a

      I have a profile page in my project.Which will dispaly person's imformation and image in this page. But When i visit my profile page, only retrieved image is showing in the profile  page.....why???There is also another properties which is not showing.

       

       

       

      here is the code

       

       

       

       

      <%@page import="javax.imageio.ImageIO"%>

      <%@page import="ServletHolder.Database"%>

      <%@page import="java.sql.*"%>

      <%@page import="java.io.*"%>

       

       

       

       

       

       

      <%

       

       

          Connection con=Database.getConnection();

          PreparedStatement pst;

          ResultSet rs;

          String c="aaaaaaa@gmail.com";

          String ah="";

          Blob img;

          byte[] imgdata=null;

          try{

       

       

          String al="select * from `uploadpic` where `email`='"+c+"'";

          pst=con.prepareStatement(al);

          rs=pst.executeQuery();

       

       

          if(rs.next()){

              ah=rs.getString("email");

              img=rs.getBlob("pic");

              imgdata=img.getBytes(1, (int)img.length());

          }

       

       

          }catch(Exception e){

              ah=e.toString();

          }

       

       

       

       

             response.setContentType("image/gif");

       

         

            //response.getOutputStream().write(imgdata);

            //  response.getOutputStream().close();

           //  OutputStream o = response.getOutputStream();

           //  o.write(imgdata);

            // o.flush();

            // o.close();

       

       

       

       

      %>

       

       

       

       

       

       

      <%@page contentType="text/html" pageEncoding="UTF-8"%>

      <!DOCTYPE html>

      <html>

          <head>

              <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

              <title>JSP Page</title>

       

       

          </head>

          <body>

              <h1>Profile</h1>

       

       

       

       

       

                      <p><strong> Hello User Welcome!!!</strong></p>

       

       

       

       

                      <img src="<%response.getOutputStream().write(imgdata);%>" alt="Mountain View" style="width:200px;"><br>

       

                      <img src="<%response.getOutputStream().write(imgdata);%>" alt="Profile Picture" width="100" title="Profile Picture">

       

       

       

                      <p><strong> Advertisement</strong></p>

       

       

       

              <a href="Editprofile.jsp"> Edit Profile</a><br>

              <form action="Logout" method="post">

                  <input type="submit" value="Logout">

                  </form>

       

       

       

          </body>

      </html>

       

      ***Moderator action (Timo): removed the email address. User please don't post mail addresses here.***