add an image from Database into JTable

Question

i am trying to add an image that is in my database in a column in JTable with a number and a code special to this image the problem is i got the number and the code but the image doesn't show i don't know why here is my code

String sql="SELECT id,chiffre,image FROM symbolique WHERE id  BETWEEN 200 and 205";
try{
    st=connexion.prepareStatement(sql);
    res=st.executeQuery();
    while(res.next()){
        int j=0;
        String [] code= new String[1000];
        String [] chiffre1=new String[100];
        code [j] = res.getString("id");
        chiffre1[j] = Integer.toString(res.getInt("chiffre"));
        Blob blob = res.getBlob("image");
        is2 = new BufferedInputStream(blob.getBinaryStream());
        Image raw = ImageIO.read(is2);
        ImageIcon icon  =new ImageIcon(raw);
        Object [][] data = new Object[200][100];
        data[j][1]= code [j];
        data[j][2]= chiffre1[j];
        data[j][3]=icon;
        j++;
        String title[] = {"image", "chiffre","code"};
        DefaultTableModel model = new DefaultTableModel(data, title);
        table.setModel(model);
    }
}catch(Exception e){
   JOptionPane.showMessageDialog(null, e);}
}

score 2 · Answer 1 · answered Mar 07 '14 at 17:24

2

put Icon/ImageIcon to JTable better to the TableModel directly
you have to override getColumnClass for Icon/ImageIcon in XxxTableModel for showing this Object as image in the JTables view
for detailed informations (incl. working code examples) to read official Oracle tutorial - How to use Tables

answered Mar 07 '14 at 17:24

mKorbel

109,525
20
134
319

i didn't understand how to do this : put Icon/ImageIcon to JTable better to the TableModel directly – user3387809 Mar 07 '14 at 18:31

score 1 · Answer 2 · answered Mar 07 '14 at 19:34

This won't help solve the image problem but right now your code recreates the TableModel for every row in the ResultSet, which means you will only ever see one row of data.

Since you have looping code you need to create an empty DefaultTableModel before the loop starts.
Inside the loop you then use the addRow(...) method to add another row of data to the TableModel for every row in the ResultSet
When you finish the loop then you use the model to create the JTable.

Did you add any debug code? Did you attempt to display the width/height of the image to confirm that you are reading the image properly? Why don't you do a simple test that tries to read and display an image in a JLabel first since using a JTable is more complicated than using a JLabel. Then once you get that working you can apply the knowledge to using a JTable.

yes i tried it on JLabel and it works properly i can see my image but with JTable it doesn't work i don't know why ? i have to work with JTable because i want to get a number and a code corresponding to the image — user3387809, Mar 07 '14 at 22:07

add an image from Database into JTable

2 Answers2