How to display image retrieved from mysql on JFrame

Question

I am having a problem displaying an image retrieved from a database in a JFrame. Here is what I will use .........

     try
               {
               Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/studio","root","");  
            Statement st=con.createStatement();   
            ResultSet rs = st.executeQuery( "select  image  from photo_instn where cust_id='2'") ;
            while(rs.next()) 
            {
            byte[] imagedata = rs.getBytes("image") ;
            Image img = Toolkit.getDefaultToolkit().createImage(imagedata);
            ImageIcon icon =new ImageIcon(img);
            JLabel lPhoto = new JLabel(icon) ;
            setLayout(null);                              // BYTES TO IMAGE                                                                      
            System.out.println("Inside");
            System.out.println(lPhoto);
            this.add(lPhoto) ;
            lPhoto.setBounds(200,20,300,400); 
  }
}

---

This code has no problems. but the image does not appear in the frame ... Please help me solve this problem ....

Answer 1

try adding this.setVisible(true)to your code after

this.add (lPhoto);

Answer 2

import java.awt.*;
import java.sql.*;

import javax.swing.*;

public class DisplayImage extends JFrame {

Connection connection = null;
PreparedStatement statement = null;

ResultSet result;

public DisplayImage() {
    super("Image Display");
    setSize(600, 600);
    connection = getConnection();
    try { // table name:image and second image is field name
        statement = connection
                .prepareStatement("select image from  image where id = 1");
        result = statement.executeQuery();

        byte[] image = null;
        while (result.next()) {
            image = result.getBytes("image");

        }
        Image img = Toolkit.getDefaultToolkit().createImage(image);
        ImageIcon icon = new ImageIcon(img);
        JLabel lPhoto = new JLabel();
        lPhoto.setIcon(icon);
        add(lPhoto);

    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    setVisible(true);
}

public Connection getConnection() {
    Connection connection = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection(
                // user name:root and password:blank
                "jdbc:mysql://localhost:3306/insertRetriveImages", "root",
                "");

    } catch (Exception e) {
        System.out.println("Error Occured While Getting the Connection: - "
                + e);
    }
    return connection;
}

public static void main(String[] args) {
    new DisplayImage();
}
}

Answer 3

 Class.forName("com.mysql.jdbc.Driver");
            Connection  con= DriverManager.getConnection("jdbc:mysql://localhost:3306/vodafonecare","root","root");
            PreparedStatement ps=con.prepareStatement("select * from photo");
            ResultSet rs=ps.executeQuery();
            if(rs.next()){
                rs.next();
                 rs.next();
            Blob b=rs.getBlob(3);
            byte bt[]=b.getBytes(1,(int)b.length());
             Image img = Toolkit.getDefaultToolkit().createImage(bt);
             photoL.setIcon(new ImageIcon(img));

Answer 4

1 Extract byte[]from the database as it was in your code, then

InputStream in = new ByteArrayInputStream(imageInByte);
BufferedImage bImageFromConvert = ImageIO.read(in);

2 Submit this image on a JFrame

boolean Graphics.drawImage(Image img, 
                           int x, int y,
                           ImageObserver observer);

Also see

• Drawing image

Answer 5

We do not know the context for using this code.

As a rule, after adding / removing a component from the GUI, you need to use:

panel.revalidate();
panel.repaint();