Extract an image (blob) from database and insert it in a frame Java

Question

I have a db with a table "Images" with a field "Img" which contains image (type BLOB).

I extract an image with a query sql like this :

select img from images where id = 1

In a java swing project how can I obtain the image result of this query ?

Paul Samsotha · Accepted Answer · 2014-02-19 17:51:05Z

4

This should work

Blob blob = rs.getBlob("img");
int blobLength = (int) blob.length();  

byte[] bytes = blob.getBytes(1, blobLength);
blob.free();
BufferedImage img = ImageIO.read(new ByteArrayInputStream(bytes));

You have options with how you want to add it the the frame. You can add it an a JLabel or you can paint it on a JPanel. Just depends on your requirements and/or preferences.

To use JLabel

ImageIcon icon = new ImageIcon(bytes); // you can read straight from byte array
JLabel label = new JLabel(icon);
frame.add(label);

To paint on JPanel

@Override
protected void paintComponent(Graphics g) {
    super.paintComponent(g);
    g.drawImage(img, 0, 0, getWidth(), getHeight(), this); 
    // img is the BufferedImage in the first code.
}

edited Feb 19, 2014 at 17:51

answered Feb 19, 2014 at 17:43

Paul Samsotha

210k39 gold badges503 silver badges756 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract an image (blob) from database and insert it in a frame Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related