Updating Database by editing jtable

[Haris Tasawar]

Hey all,
I am new to java and i have a problem which i want to resolve. I recently saw a code which basically lists the values of a database in a jtable, so i modified it and used it in my own app. The problem which i have now come across is the updating of the database by editing the jtable. I have no idea how to do this, the only thing i know is that i have to call an event like firecellupdated but i dont know how to call it and what to call in it and also where to call it.

Can anyone help me on this issue. Any help would be appreciated.


Harry.


Note: Here is the listing code in case you guys require it

//  Connect to an MySql Database
					    String driver = "com.mysql.jdbc.Driver";
//			            String url = "jdbc:odbc:???";  // if using ODBC Data Source name
			            String url =
			                "jdbc:mysql://localhost:3306/tpos";
			            String userid = "root";
			            String password = "root";

			            Class.forName( driver );
			            Connection connection = DriverManager.getConnection( url, userid, password );

			            //  Read data from a table
			            pstat = connection.prepareStatement("Select * from supplier where SupplierId=?");
			            pstat.setString(1,search);
			            
			            //String sql = "Select * from supplier where SupplierId=?";
			            //Statement stmt = connection.createStatement();
			            ResultSet rs = pstat.executeQuery();
			            ResultSetMetaData md = rs.getMetaData();
			            int columns = md.getColumnCount();

			            //  Get column names

			            for (int i = 1; i <= columns; i++)
			            {
			                columnNames.addElement( md.getColumnName(i) );
			            }

			            //  Get row data

			            while (rs.next())
			            {
			                Vector row = new Vector(columns);

			                for (int i = 1; i <= columns; i++)
			                {
			                    row.addElement( rs.getObject(i) );
			                }

			                data.addElement( row );
			            }

			            rs.close();
			            pstat.close();
			            connection.close();
			        }
			        catch(Exception e)
			        {
			            System.out.println( e );
			        }
			        

			        //  Create table with database data

			        JTable table = new JTable(data, columnNames)
			        {
			            public Class getColumnClass(int column)
			            {
			                for (int row = 0; row < getRowCount(); row++)
			                {
			                    Object o = getValueAt(row, column);

			                    if (o != null)
			                    {
			                        return o.getClass();
			                    }
			                }

			                return Object.class;
			            }
			        };

			        
			        
			     
			        
			        
			        
			        
			        table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
			        
			        
			       
			        
			        
			        
			        JScrollPane scrollPane = new JScrollPane( table );
			        scrollPane.setBounds(10, 74, 507, 404);
			        panel.getRootPane().add(scrollPane);
			        
			      
			        
			        
			        
			        
			        table.getColumnModel().getColumn(0).setPreferredWidth(100);
			       // System.out.print(table.getColumnModel().getColumn(0));
			        table.getColumnModel().getColumn(1).setPreferredWidth(100);
			        table.getColumnModel().getColumn(2).setPreferredWidth(100);
			        table.getColumnModel().getColumn(3).setPreferredWidth(100);
			        table.getColumnModel().getColumn(4).setPreferredWidth(100);
			        table.getColumnModel().getColumn(5).setPreferredWidth(100);
			        table.getColumnModel().getColumn(6).setPreferredWidth(100);
			        table.getColumnModel().getColumn(7).setPreferredWidth(100);
			        table.getColumnModel().getColumn(8).setPreferredWidth(100);
			        table.getColumnModel().getColumn(9).setPreferredWidth(100);
			        table.getColumnModel().getColumn(10).setPreferredWidth(100);
			        table.getColumnModel().getColumn(11).setPreferredWidth(100);       

[Ulf Dittmer]

Duplicate, please continue the topic at https://coderanch.com/t/549824/GUI/java/Updating-Database-editing-jtable.