Refresh JComboBox

[Sandeep Swaminathan]

There's a combo box which displays items from the database and I delete it. I want to REFRESH it then and there.

I tried
jcbCombo.updateUI();
jcbCombo.repaint();
jcbCombo.revalidate();

Didnt work! What to do?

[Maneesh Godbole]

How are you deleting the data? Can you post your relevant code?

[Rob Spoor]

JComboBox (and JList, JTree and JTable) works with a model that contains the actual data. You'll need to remove from that and add again.

[Sandeep Swaminathan]

The code below is used to display the names of XSMeter in a combobox from the back-end.

private void delFiles()
{
	lblDeleteName = new JLabel("Name: ");
        Vector v = new Vector();
        jcbDeleteName = new JComboBox(v);
        jcbDeleteName.setMaximumRowCount(5);
        
        try
        {
                Statement statement = connection.createStatement();
                ResultSet rs = statement.executeQuery("select distinct " +
                               "FileName from XSMeter where FileName is not null");
                
                while(rs.next())
                {
                    jcbDeleteName.addItem(rs.getString("FileName"));
                }
                
                rs.close();
        }
        
        catch(SQLException ee)
        {
            displaySQLErrors(ee);
        }
}

After deletion I want to refresh the combobox so that the deleted file is removed from the combobox. Commented lines are what I thought would work but didnt! I have no clue how to go about!

jbDelete.addActionListener(new ActionListener()
{
	public void actionPerformed(ActionEvent e)
        {
        	int i = JOptionPane.showConfirmDialog(null, 
                "Are you sure you want to delete?", 
                "Confirm Delete", JOptionPane.YES_NO_OPTION, 
                JOptionPane.QUESTION_MESSAGE);
                    
                if(i == 0)
                {
                	try
                        {
                        	Statement statement = connection.createStatement();
                            	int j = statement.executeUpdate("delete " +
                                "from XSMeter where FileName=" + "'" + 
                                jcbDeleteName.getSelectedItem() + "'");
                            	JOptionPane.showMessageDialog(null, "Deleted");
                            	//jcbDeleteName.updateUI();
                            	//jcbDeleteName.repaint();
                            	//jcbDeleteName.revalidate();
                         }
                        
                        catch(SQLException e)
                        {
                            displaySQLErrors(e);
                        }
                        
                }
        }
});

[Maneesh Godbole]

Your code just fires the delete query on the DB, but does not delete from JComboBox

[Sandeep Swaminathan]

Oh oh! Tat was silly of me! Gotcha! Thanks for the info! I didn't notice it at all :p

[Maneesh Godbole]

You are welcome.
Don't worry about it. Happens to everyone