Thread: Display icon/image in a JTable when reading in from MySQL

I am making a database search GUI for a CCG. I have a large GUI with JTextFields, JComboBoxes, JButtons, etc. When the user presses search, the program queries the MySQL database based on input from the user and displays the results in a JTable. The search is working great and returning the correct information. However, the final column of the database is a String that contains the file name of an image (png) for each record. I am having trouble getting the table to display the last column as an Image.

try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + dbName, dbUsername, dbPassword);
            Statement sqlState = conn.createStatement();
            String selectStuff = "SELECT * FROM ...";
            rs = sqlState.executeQuery(selectStuff);
 
            Object[] tempRow;
 
 
// --------------------------------------------------------------
//             ImageIcon testIcon = new ImageIcon("test.png");
// --------------------------------------------------------------
 
            while(rs.next()){
                tempRow = new Object[] {rs.getString(3), rs.getString(4), rs.getString(10), rs.getString(6),
                    rs.getString(5), rs.getString(7), rs.getString(8), rs.getString(9), 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(42) };
                dTableModel.addRow(tempRow);
 
            }
}

The final column "rs.getString(42)" is the String that I want to turn into an ImageIcon.

Even when I try to manually set the value as an Icon by adding...

ImageIcon testIcon = new ImageIcon("test.png");

...and changing...

rs.getString(42)
 
to
 
testIcon

...I still can't get it to work. The last column of the table just spits out "test.png".

I've searched all over the internet and tried overriding the getColumnClass, but I had no luck there either.

I'm able to read in the String of the filename from MySQL. How do I get Java to recognize/convert this to an ImageIcon?

Thanks for the quick response andmin...

I was trying that and made some progress, but still can't figure out how to get the image to show. I think I finally have it recognizing the column as an ImageIcon, but am having trouble getting an image to display still.

Right now I'm trying to get it to display any image. I stripped almost everything out of the code and the table is still displaying the data correctly except for that image.

public class temp {
 
    static String dbUsername = "...";
    static String dbPassword = "...";
    static String dbName = "...";
 
    static Object[][] databaseInfo;
    static Object[] columns = {"Type", "Homeland", "Cost", "Set"};
    static ResultSet rs;
    static ResultSetMetaData metaData;
 
    static DefaultTableModel dTableModel = new DefaultTableModel(databaseInfo, columns) {
        public Class getColumnClass(int column) {
            Class returnValue = String.class;
 
            if (column == 3) {
                returnValue = ImageIcon.class; }
 
            return returnValue;
          }
        };
 
    public static void main(String[] args){
        JFrame frame = new JFrame();
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        Connection conn = null;
 
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + dbName, dbUsername, dbPassword);
            Statement sqlState = conn.createStatement();
            String selectStuff = "SELECT * FROM swdbtest.spiritdatabase2 WHERE ActivationCost > 10";
            rs = sqlState.executeQuery(selectStuff);
 
            Object[] tempRow;
 
            ImageIcon testIcon = new ImageIcon("AgeOfAlchemy.png");
 
            while(rs.next()){
                tempRow = new Object[] {rs.getString(3), rs.getString(4), rs.getString(42), testIcon };
                dTableModel.addRow(tempRow);
            }
        }
        catch (SQLException ex) {
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("VendorError: " + ex.getErrorCode());
        }
        catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
 
        JTable table = new JTable(dTableModel);
 
        JScrollPane scrollPane = new JScrollPane(table);
        frame.add(scrollPane, BorderLayout.CENTER);
        frame.setSize(1200, 700);
        frame.setVisible(true);
    }
 
}

Originally Posted by andbin

This is a specification on the local file-system and it's a relative specification, relative to the "current" directory. Which is your current directory? I can't know. It depends on how/from where you launch the application.

I suspect this is not what you want!

I have it in the same directory as my code. I just have a couple images there for testing purposes, which has worked so far for all my coding. After I get this working, I'm going to have to Photoshop about 25 images, so I didn't bother putting it in another folder and using a url. Photoshoping will be the easy part.

--- Update ---

I just saw you're in Italy. I love Italy and have been there twice.