Thread: Problem with update table after inserting new values

Hello,

I'm trying to write a small program where I have a JTable connected with Db.

Connection is working but the thing which doesnt work is when I insert new variables into Jtable I can't get it refreshed.

here is my code : Only for the Update method

protected void Update_Table() {
					// TODO Auto-generated method stub
					try{
						String update = "SELECT * FROM devices";
					//	statUp = (Statement) con.createStatement(update);
						ResultSet rest = statUp.executeQuery(update);
						table.setModel(DbUtils.resultSetToTableModel(rest));
						//DbUtils.
					}
					catch(Exception ex){
						ex.printStackTrace();
						JOptionPane.showInputDialog(null, "Couldn't create new Device");
					}
				}

The problem is in DbUtils.resultSetToTableModel(rest));
Where rest is ResultSet.

I got several errors :

Exception in thread "AWT-EventQueue-0" java.lang.Error: Unresolved compilation problem: 
	DbUtils cannot be resolved
 
	at JTable2.Update_Table(JTable2.java:213)
	at JTable2$2.actionPerformed(JTable2.java:158)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$000(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)

Thank you for your help

That error means the compiler doesn't know what DbUtils is. Did you spell it correctly? Is it properly defined somewhere? Are your imports in order?

Hey,

My imports seems fine. I found sth similar which I tried to do here you can see it. java - JTable setting model and preserve column formats (width, alignment, etc.) - Stack Overflow

heya,

thx guys for your help Friend of mine solved it. I was missing the library for dbUtils. Thx