How to use : Java GUI JTable - Update Data When Cell Change Value

table.getModel().addTableModelListener(new TableModelListener() {
public void tableChanged(TableModelEvent e) {
  if(e.getType()==(TableModelEvent.UPDATE))
   {   
	  int intColumn = e.getColumn();
	  int intRows = e.getFirstRow();
	  UpdateData(intRows,intColumn); // Update
   }
}
});	

private void UpdateData(int intRows,int intColumn)
{	
	String CustomerID = table.getValueAt(intRows, 0).toString();
	String Name = table.getValueAt(intRows, 1).toString();
	String Email = table.getValueAt(intRows, 2).toString();
	String CountryCode = table.getValueAt(intRows, 3).toString();
	String Budget = table.getValueAt(intRows, 4).toString();
	String Used = table.getValueAt(intRows, 5).toString();

	String sql = "UPDATE customer " +
			"SET Name = '" + Name + "' " +
			", Email = '" + Email + "' " +
			", CountryCode = '" + CountryCode + "' " +
			", Budget = '" + Budget + "' " +
			", Used = '" + Used + "' " +
			" WHERE CustomerID = '"+CustomerID+"' ";
	s.execute(sql);	
}

CREATE TABLE `customer` (
  `CustomerID` varchar(4) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `CountryCode` varchar(2) NOT NULL,
  `Budget` double NOT NULL,
  `Used` double NOT NULL,
  PRIMARY KEY  (`CustomerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- dump ตาราง `customer`
-- 

INSERT INTO `customer` VALUES ('C001', 'Win Weerachai', '[email protected]', 'TH', 1000000, 600000);
INSERT INTO `customer` VALUES ('C002', 'John  Smith', '[email protected]', 'UK', 2000000, 800000);
INSERT INTO `customer` VALUES ('C003', 'Jame Born', '[email protected]', 'US', 3000000, 600000);
INSERT INTO `customer` VALUES ('C004', 'Chalee Angel', '[email protected]', 'US', 4000000, 100000);

package com.java.myapp;

import java.awt.Color;
import java.awt.Component;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;

public class MyForm extends JFrame {

	private JTable table;
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				MyForm frame = new MyForm();
				frame.setVisible(true);
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public MyForm() {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 580, 242);
		setTitle("ThaiCreate.Com Java GUI Tutorial");
		getContentPane().setLayout(null);
		
		// ScrollPane
		JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(64, 44, 440, 89);
		getContentPane().add(scrollPane);
		
		// Table
		table = new JTable(){
		    public boolean isCellEditable(int rowIndex, int colIndex) {
		    	if(colIndex==0) {
		    		return false; // Disallow Column 0
		    	} else {
		    		return true;   // Allow the editing 
		    	}
		    }
		    
            @Override
            public Component prepareRenderer(TableCellRenderer renderer, int row, int column) {
                Component comp = super.prepareRenderer(renderer, row, column);
                if (column==0) {
                    comp.setBackground(Color.lightGray);
                } else {
                	comp.setBackground(Color.white);
                }
                return comp;
            }
            
            
		};
	    
	    scrollPane.setViewportView(table);
		
		
		// Windows Loaded
		addWindowListener(new WindowAdapter() {
			@Override
			public void windowOpened(WindowEvent e) {
				PopulateData(); // PopulateData
			}
		});
		
	}
	
	// Connection
	private Connection ConnectDB() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			return  DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
					"?user=root&password=root");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	// PopulateData 
	private void PopulateData()
	{
		
		// Clear Table
		table.setModel(new DefaultTableModel());
		
		// Model for Table
		DefaultTableModel model = (DefaultTableModel)table.getModel();
		model.addColumn("CustomerID");
		model.addColumn("Name");
		model.addColumn("Email");
		model.addColumn("CountryCode");
		model.addColumn("Budget");
		model.addColumn("Used");		
		
		Connection connect =  ConnectDB();
		Statement s = null;
		
		try {

			s = connect.createStatement();
			
			String sql = "SELECT * FROM  customer ORDER BY CustomerID ASC";
			
			ResultSet rec = s.executeQuery(sql);
			int row = 0;
			while((rec!=null) && (rec.next()))
            {			
				model.addRow(new Object[0]);
				model.setValueAt(rec.getString("CustomerID"), row, 0);
				model.setValueAt(rec.getString("Name"), row, 1);
				model.setValueAt(rec.getString("Email"), row, 2);
				model.setValueAt(rec.getString("CountryCode"), row, 3);
				model.setValueAt(rec.getFloat("Budget"), row, 4);
				model.setValueAt(rec.getFloat("Used"), row, 5);
				row++;
            }

			rec.close();
			
			// Cell Edit Change
			
		    table.getModel().addTableModelListener(new TableModelListener() {
		        public void tableChanged(TableModelEvent e) {
	        	  if(e.getType()==(TableModelEvent.UPDATE))
	        	   {   
	        		  int intColumn = e.getColumn();
	        		  int intRows = e.getFirstRow();
	        		  UpdateData(intRows,intColumn); // Update
	        	   }
		        }
		      });	
		
	        
             
		} catch (Exception e) {
			// TODO Auto-generated catch block
			JOptionPane.showMessageDialog(null, e.getMessage());
			e.printStackTrace();
		}
		
		try {
			if(s != null) {
				s.close();
				connect.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	// UpdateData
		private void UpdateData(int intRows,int intColumn)
		{
			
			Connection connect =  ConnectDB();
			Statement s = null;
			
			try {
				
				s = connect.createStatement();
				
				String CustomerID = table.getValueAt(intRows, 0).toString();
				String Name = table.getValueAt(intRows, 1).toString();
				String Email = table.getValueAt(intRows, 2).toString();
				String CountryCode = table.getValueAt(intRows, 3).toString();
				String Budget = table.getValueAt(intRows, 4).toString();
				String Used = table.getValueAt(intRows, 5).toString();
				
				String sql = "UPDATE customer " +
						"SET Name = '" + Name + "' " +
						", Email = '" + Email + "' " +
						", CountryCode = '" + CountryCode + "' " +
						", Budget = '" + Budget + "' " +
						", Used = '" + Used + "' " +
						" WHERE CustomerID = '"+CustomerID+"' ";
	             s.execute(sql);

	             
			} catch (Exception e) {
				// TODO Auto-generated catch block
				JOptionPane.showMessageDialog(null, e.getMessage());
				e.printStackTrace();
			}
			
			try {
				if(s != null) {
					s.close();
					connect.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				System.out.println(e.getMessage());
				e.printStackTrace();
			}
			
		}
}