Hi friend,


Please implement like the follows code.


I am going to post the working code for displaying a MySQL table in an updatable JTable

You would create the table as follows:

conn = getConnection();
stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stat.executeQuery("SELECT * FROM register");
ResultSetTableModel model = new ResultSetTableModel(rs);
table = new JTable(model);
table.setColumnSelectionAllowed(true);
table.setRowSelectionAllowed(true);
scrollPane = new JScrollPane(table);
pane.add(scrollPane, BorderLayout.CENTER);
validate();

And here is the working table model I use:

class ResultSetTableModel extends AbstractTableModel {

public ResultSetTableModel(ResultSet aResultSet) {
rs = aResultSet;

try {
rsmd = rs.getMetaData();
}
catch(SQLException e) {
e.printStackTrace();
}
}


public String getColumnName(int c){
try{
return rsmd.getColumnName(c + 1);
}
catch(SQLException e){
e.printStackTrace();
return "";
}
}

public boolean isCellEditable(int row, int col){
return true;
}

public int getColumnCount() {
try{
return rsmd.getColumnCount();
}
catch (SQLException e){
e.printStackTrace();
return 0;
}
}

public Object getValueAt(int r, int c) {
try {
rs.absolute(r + 1);
return rs.getObject(c + 1);
}
catch(SQLException e)
{
e.printStackTrace();
return null;
}
}

public void setValueAt(Object aValue, int rowIndex, int columnIndex){
try
{
rs.absolute(rowIndex + 1);
System.out.println("I got here... row: "+ rowIndex + ", " + columnIndex);
rs.updateString(columnIndex+1, (String)aValue);
rs.updateRow();
}
catch(SQLException e)
{
e.printStackTrace();
}
}

public int getRowCount() {
try {
rs.last();
return rs.getRow();
}
catch(SQLException e) {
e.printStackTrace();
return 0;
}
}

private ResultSetMetaData rsmd;
}
----------------------------------------------
Read for more information.

http://www.roseindia.net/java/example/java/swing/
Thanks.