Showing Image From Mysql (blob) to Jtable- DefaultTableModel

Question

I inserted my image with other info in my mysql DB with blob (converting it to byte), and I am able to get the image to show it in a jlable .. But Problem arrives when I try to show it in a Jtable ... I am using the DefaultTableModel, and here is my whole code for this .. can some one give me any idea? I searched around a lot and noting solved my problem :( I want to show the images in the last col...am giving only the code for this part.. ...

and if anyone wants to give the gui a try here is the full code -

private void getTableData(){

    //Connection conn=null;
    //Statement st=null;

    try{
        conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/vehicle","root","");
        st = conn.createStatement();
        String sql="SELECT * FROM user";
        ResultSet rs = st.executeQuery(sql);
        DefaultTableModel model = new DefaultTableModel(new String[]{"Name", "Gender", "Mobile Number", "Email", "Position", "User Name", "Privilege", "Photo"}, 0);
         jTableUsers.setModel(model);
        //  jTableUsers.getColumnModel().getColumn(7).setCellRenderer(jTableUsers.getDefaultRenderer(ImageIcon.class));

       // jTableUsers.getColumnModel().getColumn(7).setCellRenderer(new ImageRenderer());
        if(rs.next()){    
        byte[]imagedata= rs.getBytes("image");
            formate = new ImageIcon(imagedata);   //formate is the variable
            showimageF.setIcon(formate); 
        }
        while(rs.next())
        {
            String col1 = rs.getString("f_name");
            String col2 = rs.getString("gender");
            String col3 = rs.getString("mobile");
            String col4 = rs.getString("email");                
            String col5 = rs.getString("position");
            String col6 = rs.getString("user_name");
            String col7 = rs.getString("user_type");
            //String col18 = col18

           // mod.addRow(new Object[]{xx, rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12), rs.getString(13), rs.getString(14), rs.getString(15), rs.getString(16), rs.getString(17), rs.getString(18), rs.getString(19), rs.getString(20), rs.getString(21), rs.getString(22), rs.getString(23), newIconImage, rs.getString(25), rs.getString(26), rs.getString(27)});

            model.addRow(new Object[]{col1, col2, col3, col4,col5,col6,col7,formate,});


        }
        //jTableUsers.setModel(model);
    }catch(Exception ex){
        JOptionPane.showMessageDialog(null, ex.getMessage());
    }
}

You can take a look at this question and answers: stackoverflow.com/questions/4941372/… — Freek de Bruijn
– Freek de Bruijn, Commented Apr 17, 2015 at 18:38
yeah i saw .. but the problem is i don't get it how to do it for my code :( . am new to java and this is my 1st project ,.. can you be a bit more specific ? or maybe write the code and tell me where to put it ? :( — Soykot
– Soykot, Commented Apr 17, 2015 at 19:05

camickr · Accepted Answer · 2015-04-17 23:49:34Z

1

But Problem arrives when I try to show it in a Jtable

You need to tell the table that the column contains an Icon, then the table will use the appropriate renderer to render the Icon. You do this by overriding the getColumnClass(...) method of your DefaultTableModel

@Override
public Class getColumnClass(int column)
{

    switch (column)
    {
        case 7: return Icon.class();
        default: return Object.class;
    }
}

edited Apr 17, 2015 at 23:49

answered Apr 17, 2015 at 18:38

camickr

325k21 gold badges174 silver badges293 bronze badges

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

5 Comments

Freek de Bruijn Over a year ago

You can take a look at this question and answers: How to Insert Image into JTable Cell... ;-)

Soykot Over a year ago

yeah i got that suggestion .. but the problem is i don't get it how to do it for my code :( . am new to java and this is my 1st project ,.. can you be a bit more specific ?

camickr Over a year ago

Why are you trying to read data from a database on your first project? You should first learn the basics of Java. Overriding a method is something that is done all the time. So why don't you try overriding the DefaultTableModel with the code given above. If you have a problem then post the code. You don't learn anything if you don't try. The linked examples shows how to do this the only difference is one piece of code overrides the getColumnClass() method of a JTable and this answer if for the DefaultTableModel, but the concept is identical.

Soykot Over a year ago

Hi, Thanks for your time .. well after editing here is the part of the code now :.. but still am getting the same result as before .. am sure am doing something wrong :(

camickr Over a year ago

Did you add a System.out.pritntln(...) statement to the getColumnClass() method to verify the code is being executed and the column value is 7?

Soykot · Accepted Answer · 2015-04-17 20:33:54Z

0

Thanks for your time .. well after editing here is the part of the code now : private void getTableData(){

    //Connection conn=null;
    //Statement st=null;

    try{
        conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/vehicle","root","");
        st = conn.createStatement();
        String sql="SELECT * FROM user";
        ResultSet rs = st.executeQuery(sql);
        DefaultTableModel model = new DefaultTableModel(new String[]{"Name", "Gender", "Mobile Number", "Email", "Position", "User Name", "Privilege", "Photo"}, 0);
        JTable table=new JTable(model){
        @Override
            public Class getColumnClass(int column)
            {
               switch (column)
                        {
                            case 8: return Icon.class;
                            default: return Object.class;
                        }
                    }}; 
        jTableUsers.setModel(model);
        //  jTableUsers.getColumnModel().getColumn(7).setCellRenderer(jTableUsers.getDefaultRenderer(ImageIcon.class));

       // jTableUsers.getColumnModel().getColumn(7).setCellRenderer(new ImageRenderer());


        if(rs.next()){    
        byte[]imagedata= rs.getBytes("image");
            formate = new ImageIcon(imagedata);   //formate is the variable
            showimageF.setIcon(formate); 
        }
        while(rs.next())
        {
            String col1 = rs.getString("f_name");
            String col2 = rs.getString("gender");
            String col3 = rs.getString("mobile");
            String col4 = rs.getString("email");                
            String col5 = rs.getString("position");
            String col6 = rs.getString("user_name");
            String col7 = rs.getString("user_type");
            //String col18 = col18


            model.addRow(new Object[]{col1, col2, col3, col4,col5,col6,col7,formate,});


        }
       // jTableUsers.setModel(table);

    }catch(Exception ex){
        JOptionPane.showMessageDialog(null, ex.getMessage());
    }
}

answered Apr 17, 2015 at 20:33

Soykot

1381 silver badge10 bronze badges

5 Comments

Soykot Over a year ago

Still am getting the same result as before .. am doing something wrong but i can't figure it out yet :(

camickr Over a year ago

Well I counted columns wrong. Your table only has 8 columns, but since the column value is offset from 0, you should be using 7 in the case statement..

Soykot Over a year ago

hi, still the same .. maybe am using some code in wrong place here ?.. all I get is "javax.swing.ImageIcon@55a45f" -- this kind of codes in image column... is my this declaration okay--" jTableUsers.setModel(model);"??

camickr Over a year ago

So this tells you the data in the TableModel is an ImageIcon, which is good. So the problem must be that your code in the getColumnClass() method is NOT being executed. So this probably means that you have two instances of JTable and you are overriding the wrong instance. Based on the code provided you create the JTable, but you don't add the table to the frame.

Soykot Over a year ago

well that's the problem!! shall i share the whole code so that you might find out what am i doing wrong ?

Collectives™ on Stack Overflow

Showing Image From Mysql (blob) to Jtable- DefaultTableModel

2 Answers 2

5 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related