Member Avatar for Nidhi S.

i want to retrieve images from access database and display in grid layout.
i have displayed 1 image successfully but how can i do this for all images together.i have stored images as BLOB

Edited by Nidhi S. because: n/a
  • 2 Contributors
  • 2 Replies
  • 104 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by Nidhi S.

Dani AI

Generated

gave the right direction and confirmed one image renders. For the jump from one image to many, the usual gaps are: doing database reads on the Swing Event Dispatch Thread (freezes UI), creating or reusing the same component instead of a fresh JLabel per image, and not scaling images (huge memory use). The pattern below is safe and practical: read each BLOB into a BufferedImage, create a thumbnail, add a new JLabel(new ImageIcon(...)) for each image into a JPanel with GridLayout, then put that panel in a JScrollPane.

Example pattern (keep DB work off the EDT and make thumbnails):

// pseudo-example: run in background (SwingWorker or a background thread)
while (rs.next()) {
  try (InputStream in = rs.getBinaryStream("photo_blob")) {
    BufferedImage img = ImageIO.read(in);
    BufferedImage thumb = createThumbnail(img, 120, 90); // scale with Graphics2D
    publish(new JLabel(new ImageIcon(thumb))); // SwingWorker.publish/process
  }
}

Use new GridLayout(0, cols, hgap, vgap) so columns are fixed and rows grow. Add the grid panel to a JScrollPane. Implement createThumbnail with Graphics2D and a rendering-hint for decent quality rather than getScaledInstance.

Quick troubleshooting checklist:

  • Ensure each image gets its own JLabel and is added before revalidate/repaint (call them on the EDT).
  • Move DB+image decoding to a background thread (SwingWorker) and only update the panel on the EDT.
  • If only one image appears, check your loop logic and that you aren’t reassigning the same component reference.
  • If memory spikes, generate and store small thumbnails (or paginate/lazy-load results).
  • If images come out corrupt, write the BLOB to disk and inspect the file to confirm the stored bytes are valid.

For many large images, consider storing files on disk and keeping paths in the DB (Access can be slow with many large BLOBs).

Recommended Answers

All 2 Replies

Member Avatar for peter_budo

The default answer would be : the same way as you did it for one image. Retrieve collection of image objects from database and use loop to get it in grid layout. If you posted code somebody could already helped you

Member Avatar for Nidhi S.

The default answer would be : the same way as you did it for one image. Retrieve collection of image objects from database and use loop to get it in grid layout. If you posted code somebody could already helped you

i did that.
thanx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.