Retrive image from MySql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ramola
    New Member
    • Sep 2007
    • 35

    Retrive image from MySql

    Hi,

    I have a table where in i've stored images (BLOB) , now i wanna retirve these images and display them on an html page !

    I am using JSP .

    Kind regards,
    Ramola
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Originally posted by Ramola
    Hi,

    I have a table where in i've stored images (BLOB) , now i wanna retirve these images and display them on an html page !

    I am using JSP .

    Kind regards,
    Ramola
    ... and what have you done so far?

    Comment

    • mwasif
      Recognized Expert Contributor
      • Jul 2006
      • 802

      #3
      If you already have the images in BLOB field then you need to only SELECT the data and output it to the browser. But set the proper (according to image type) content type before image data output. In JSP, the syntax will be (I am not sure about the syntax)
      [CODE=java]response.setCon tentType("image/jpeg");[/CODE]

      Comment

      Working...