日期:2014-05-20  浏览次数:20919 次

在线等!!!swing Jtable 单元格编辑后,数据自动保存并更新到数据库中???
使用环境如下:
首先,点击查询按钮,从数据库中提取所有记录填充到Jtable中,
然后,Jtable表格中的单元格都是可以编辑的,编辑单元格后,数据自动保存到Jtable单元格中,并同时更新到数据库中,
最后,点击查询按钮,重新从数据库中提取所有记录填充到Jtable中

 public class KpiMetadataMappingTableModel extends AbstractTableModel
  {
  private Vector<UrmKpiMetadataMappingItem> kpiMetadata = new Vector<UrmKpiMetadataMappingItem>();
  private String[] columns =
  {
  "111", "222", "333", "444", "555", "666", "777", "888", "999", "110"
  };
   

  public UrmKpiMetadataMappingItem getRow(int row)
  {
  return kpiMetadata.get(row);
  }

  @Override
  public int getRowCount()
  {
  return kpiMetadata.size();
  }

  @Override
  public int getColumnCount()
  {
  return columns.length;
  }

  public String getColumnName(int col)
  {
  return columns[col];
  }

  @Override
  public Object getValueAt(int row, int column)
  {
  UrmKpiMetadataMappingItem kpiMetadataMappingItem = kpiMetadata.get(row);

  switch (column)
  {
  case 0:
  return kpiMetadataMappingItem.getKpiId();
  case 1:
  return kpiMetadataMappingItem.getDeviceId();
  case 2:
  return kpiMetadataMappingItem.getAlarmId();
  case 3:
  return kpiMetadataMappingItem.getParameterId();
  case 4:
  return kpiMetadataMappingItem.getIsAlarm();
  case 5:
  return kpiMetadataMappingItem.getDeviceType();
  case 6:
  return kpiMetadataMappingItem.getPageIndex();
  case 7:
  return kpiMetadataMappingItem.getParameterIndex();
  case 8:
  return kpiMetadataMappingItem.getBoardName();
  case 9:
  return kpiMetadataMappingItem.getManufacture();
  }
  return "";
  }

  public boolean isCellEditable(int row,int col)
  {
  return true;
  }
   
  public void setValueAt(Object newValue,int row,int col)
  {
  // 这里边的代码如何写
  代码越详细越好
  ?????  
  }
   
  public Vector<UrmKpiMetadataMappingItem> getData()
  {
  return kpiMetadata;
  }

}

------解决方案--------------------
Java code

@Override
public void setValueAt(Object newValue,int row,int col) {
  
  UrmKpiMetadataMappingItem item = kpiMetadata.get(row);
  String val = String.valueOf(newValue);
  
  switch(column) {
    
    case 0 : 
      item.setKpiId(Integer.parseInt(val));
      break;
      
    case 1 :
      item.setDeviceId(Integer.parseInt(val));
      break;
    
    // ...
    
    case 8:
      item.setBoardName(val);
      break;
      
    // ...
    
    default :
      throw new IndexOutOfBoundsException();
  }
  
  updateRecordInDatabase(item);
  fireTableDataChanged();
}