Forum:

Swing / AWT / SWT

JTable AbstractTableModel Edit Date Problem

Ranch Hand

Posts: 121

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

This si the code for my previous post. I can edit string and Integr value cells; but cannot edit date cell. Must date cell be set to editable with another kind of code?

Thank you,

Giuseppa

allRows = new Vector();
            while(rs.next()){
                newRow = new Vector();
                for(int j = 1; j <= columns; j++){
                    switch(md.getColumnType(j)){
                        case Types.CHAR:
                        case Types.VARCHAR:
                        case Types.LONGVARCHAR:
                            String s = rs.getString(j);
                            if(rs.wasNull()){
                                newRow.add(null);
                            }
                            else{
                                newRow.addElement(s);
                            }

break;

case Types.INTEGER:
                            int in = rs.getInt(j);
                            if(rs.wasNull()){
                            newRow.addElement(null);
                            }
                            else {
                                newRow.addElement(new Integer(in));
                            }

break;
                    
                        case Types.FLOAT:
                        case Types.DOUBLE:
                            double d = rs.getDouble(j);
                            if(rs.wasNull()){
                                newRow.addElement(null);
                            }
                            else {
                                newRow.addElement(new Double(d));
                            }
                            
                            break;
                         case Types.DATE:
                             java.sql.Date date = rs.getDate(j);
                             if(rs.wasNull()){
                                 newRow.addElement(null);
                             }
                             else{
                                  newRow.addElement(date);
                             }

break;
                    }
                   // newRow.addElement(rs.getObject(j));
                }
                allRows.addElement(newRow);
            }

public Class getColumnClass(int col){

try{
                switch(md.getColumnType(col + 1)){
                    case Types.CHAR:
                    case Types.VARCHAR:
                    case Types.LONGVARCHAR:
                        return String.class;

case Types.INTEGER:
                        return Integer.class;
         
                    case Types.FLOAT:
                    case Types.DOUBLE:
                        return Double.class;

case Types.DATE:
                        return java.sql.Date.class;

default:
                        return  Object.class;

}
            }catch(SQLException e){
                 e.getMessage();
                 return Object.class;

}
             //getValueAt(0, col).getClass();
        }
    
        public boolean isCellEditable(int row, int col){

if(rowNew){

return true;
            }

if(col == 0){

return false;
            }else{

return true;
            }

}

public String getColumnName(int col){

return tableColNames[col];
        }

public int getColumnCount(){

return columns;
        }

public int getRowCount()
        {

return allRows.size();
        }

public Object getValueAt(int arow, int col){

row = (Vector)allRows.elementAt(arow);
           System.out.println(row.elementAt(col));
      
           return row.elementAt(col);
        }

public void setValueAt(Object aValue, int aRow, int aCol){

try{
            Object oldValue = getValueAt(aRow, aCol);
                   
            if(oldValue == null && aValue == null){
                  
                return;
            }

if(oldValue != null){
                if(oldValue.equals(aValue)){
                   
                    return;
                }

}

updateResultSet(rs, aValue, aRow, aCol);
       
            fireTableCellUpdated(aRow, aCol);
            }catch(SQLException e){

e.getMessage();
            }catch(Exception ex){
                ex.getMessage();
            }
             Vector dataRow = (Vector)allRows.elementAt(aRow);
             dataRow.setElementAt(aValue, aCol);
             fireTableCellUpdated(aRow, aCol);
        }

private void updateResultSet(ResultSet rs, Object aValue, int aRow, int aCol)
        throws Exception{

if(aValue == null || aValue.toString().trim().length() == 0){

rs.updateNull(aCol);
                return;
            }

switch(md.getColumnType(aCol+1)){

case Types.CHAR:
                case Types.VARCHAR:
                case Types.LONGVARCHAR:
                    rs.updateString(aCol+1, ((String)aValue));
                    
                    return;

case Types.INTEGER:
                    rs.updateInt(aCol+1, ((Integer)aValue).intValue());
                   
                    return;
               
                case Types.FLOAT:
                case Types.DOUBLE:
                    rs.updateDouble(aCol+1, ((Double)aValue).doubleValue());

return;
                case Types.DATE:
                    rs.updateDate(aCol+1, (java.sql.Date)aValue);
                
                    return;

default:

rs.updateObject(aCol+1, aValue);
                    return;

}
            
        }

Rob Spoor

Sheriff