Thread: [HELP] Refreshing JTable connected to database

What can be the problem with my code here? I'm trying to refresh/update the table connected to database.

 
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.event.*;
import javax.swing.table.*;
 
public class manipulatingData extends JPanel implements ActionListener
{
	private JButton btnAdd, btnEdit, btnDelete, btnSearch, btnSave, btnCancel;
	private JFrame f;
	private JPanel p,panel;
	private JDialog addData;
	private JLabel lblEnterName;
	private JTextField txtName;
 
	MyModel model = new MyModel();
	ResultSet rs;
 
	JTable table;
	JTableHeader header;
	TableColumn tc;
 
 
	String strCount;
	String name = "";
	String sql;
 
 
	private int confirm = 0;
 
	public manipulatingData()
	{
 
		model.connectDB();
 
		table = new JTable(model);
 
 
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		table.setPreferredScrollableViewportSize(new Dimension(300,150));
		table.setFillsViewportHeight(true);
		table.setRowSelectionInterval(0,0);
		table.changeSelection(0,0,false,false);
 
		table.tableChanged(new TableModelEvent (model));
 
		f = new JFrame();
		f.setTitle("Data Manipulation");
		f.setSize(527,467);
		f.setResizable(false);
		f.setLocationRelativeTo(null);
		f.setVisible(true);
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
 
		header = table.getTableHeader();
		header.setBackground(new Color(25,125,250));
		header.setReorderingAllowed(false);
		header.setResizingAllowed(false);
 
 
		btnAdd = new JButton("Add");
		btnEdit = new JButton("Edit");
		btnDelete = new JButton("Delete");
		btnSearch = new JButton("Search");
 
 
		btnAdd.addActionListener(this);
		btnEdit.addActionListener(this);
		btnDelete.addActionListener(this);
		btnSearch.addActionListener(this);
 
		JScrollPane scroll = new JScrollPane(table);
 
		scroll.setBounds(10,20,500,300);
		btnAdd.setBounds(10,350,120,30);
		btnEdit.setBounds(150,350,120,30);
		btnDelete.setBounds(10,390,120,30);
		btnSearch.setBounds(350,350,120,30);
 
 
 
		p = new JPanel();
 
		p.setLayout(null);
		p.setBackground(new Color(115,55,93));
		p.add(scroll);
		p.add(btnAdd);
		p.add(btnEdit);
		p.add(btnDelete);
		p.add(btnSearch);
 
		f.add(p);
	}
 
	public static void main (String [] args)
	{
		new manipulatingData();
 
	}
 
	public void actionPerformed (ActionEvent e)
	{
 
		rs = model.rs;
 
		if(e.getSource()==btnAdd)
		{
			//JOptionPane.showMessageDialog(null, model);
		}
 
 
		else if (e.getSource()==btnDelete)
		{
			confirm = JOptionPane.showConfirmDialog(null,"Do you want to delete this?","Confirmation",0);
 
			if(confirm == 0)
			{
				try
				{
					rs.beforeFirst();
 
					while(rs.next())
					{
						if(table.getSelectedRow() == 0 && rs.getRow() == 1)
						{
							rs.deleteRow();
						//	JOptionPane.showMessageDialog(null,"Record Deleted","Successful",1);
 
							break;
 
 
						}
 
						else if(table.getSelectedRow() == rs.getRow())
						{
 
							rs.next();
							rs.deleteRow();
 
							table.tableChanged(new TableModelEvent (model));
						//	JOptionPane.showMessageDialog(null,"Record Deleted","Successful",1);
 
 
 
							break;
 
						}
 
					}
 
 
 
				}
				catch (SQLException a)
				{
					System.err.println(a);
				}
 
 
 
			}
		}
 
 
	}
 
 
}
 
	class MyModel extends AbstractTableModel
	{
 
 
		Connection con;
		Statement s;
		ResultSet rs;
		ResultSetMetaData rsmd;
		String cDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
		Object rowData[][] = {};
		String columnNames[] = {};
 
 
 
		int count = 0;
		int recordCount = 0;
 
 
 
	    public int getColumnCount()
	    {
	       return columnNames.length;
	    }
 
	       public String getColumnName(int column)
	       {
 
	        	return columnNames[column];
	        }
 
	        public int getRowCount()
	        {
	        	return rowData.length;
	        }
 
	        public Object getValueAt(int row, int column)
	        {
	        	return rowData[row][column];
	        }
 
	        public void setValueAt(Object value, int row, int column)
	        {
	        	rowData[row][column] = value;
				fireTableCellUpdated(row, column);
 
 
 
		    }
 
	        public boolean isCellEditable(int row, int column)
	        {
	        	return false;
	        }
 
 
 
		public void connectDB()
		{
 
 
			try
			{
 
				Class.forName(cDriver);
 
				con = DriverManager.getConnection("jdbc:odbc:testDBjava3.accdb","","");
				s = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
				rs = s.executeQuery("Select * from friends");
				rsmd = rs.getMetaData();
 
				recordCount = 0;
				count = rsmd.getColumnCount();
 
	 			String fieldNames[] = new String[count];
 
	 			for(int a=1;a<=count;a++)
	 			{
	 				fieldNames[a-1] = rsmd.getColumnName(a);
	 			}
 
				while(rs.next())
				{
	 				recordCount++;
				}
 
 
 
				Object data [][]  = new Object[recordCount][count];
 
				rs.beforeFirst();
				for(int x = 0;x<recordCount;x++)
				{
					rs.next();
					for(int y = 0;y<count;y++)
					{
						data[x][y] = rs.getObject(y+1);
					}
				}
 
				columnNames = fieldNames;
				rowData = data;
 
 
 
 
 
			}
 
			catch (ClassNotFoundException exp)
			{
				System.err.println(exp);
			}
 
			catch(SQLException exp)
			{
				System.err.println(exp);
			}
		}
	}

Please help me. It's really not refreshing. Thank you so much.

The problem that I am now facing with that program is when I add/delete, the refresh/update of the JTable comes late. I need to do it two or more times for the model to apply the changes. Seems like the problem is on the database connection? This is just a test for me to make an election system. Thanks in advance....

I'm sorry. I forgot.

	model.connectDB();
 
		if(e.getSource()==btnAdd)
		{
				String name = JOptionPane.showInputDialog(null,"Enter here: ");
				sql = "Insert into friends values('"+(name)+"')";
 
				try
				{
 
					model.s.executeUpdate(sql);
 
					model.fireTableStructureChanged();
 
				//	JOptionPane.showMessageDialog(null,"Data Saved","Save Successful",1);
 
 
 
 
 
				}
				catch(SQLException exp)
				{
					System.err.println(exp);
				}
 
		}

What do you mean? It is stated in the code above in "btnDelete".

Sir, I used rs.deleteRow() to remove a row..

It works but won't take effect until I delete it again or delete some other record. I don't use any method to delete record from JTable. Just the database. Do you get me?

--- Update ---

It works but won't take effect until I delete it again or delete some other record. I don't use any method to delete record from JTable. Just the database. Do you get me?

It is exactly what I choose to delete. The record from database is what I always successfully deleted and JTable is not even responding immediately to the change..

Yeah. That's what I want. Just like in visual basic 6's adodc/datagrid. Immediate response to change with ".refresh".

I don't have any remove command in there, I just used direct deletion from database. Is that wrong? Also, I didn't use vectors. Sorry if I'm confusing you.

I thought firing events from the table model can do it alone.