Image insertion into Jtable from sql database

Question

I have added rs2xml.jar in my java library in order to fetch tables from my database and display it through my Jtable. but the problem is I'm getting all other columns except the column (img) which contains all images.

 try{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        conn = DriverManager.getConnection(DB_URL, USER, PASS);
        pst = conn.createStatement();
    String sql = "select * from employee_details";
    rs = pst.executeQuery(sql);
    ed.setModel(DbUtils.resultSetToTableModel(rs));
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }

This is my code. any suggestion??

camickr · Accepted Answer · 2015-03-07 16:42:40Z

but I'm not getting any images.

Do you actually have an Image in the TableModel? Is the problem adding an Image to the TableModel or is the problem displaying the Image in the table?

A JTable uses renderers to display the data in a table column. You need to override the getColumnClass(..) method of the JTable to tell the table the type of data being stored in the table.

However, the JTable doesn't support a default renderer for images, so you will need to create a custom renderer. Read the section from the Swing tutorial on Using Custom Renderers for more information.

Or, it may be easier to replace the Image with an ImageIcon, since the JTable does support a default renderer for Icons. You would need to loop through the TableModel (before you add it to the table) and change each Image to an ImageIcon with code like:

ImageIcon icon = new ImageIcon( model.getValueAt(row, column) );
model.setValueAt(icon, row, column);

Collectives™ on Stack Overflow

Image insertion into Jtable from sql database

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