Форум программистов [Powered by Invision Power Board]

Код

    public void setValueAt(Object value, int row, int column)
    {
      try
        {
         String columnName = getColumnName(column);

         String query =
            "UPDATE "+tableName+
            " SET "+columnName+" = "+
             dbRepresentation(column, value)+
            " WHERE ";
        }
         catch (Exception e) {
                 String columnName = getColumnName(column); 
                 System.out.println(e);
                 e.printStackTrace();
                 String query = "INSERT INTO " +tableName+" VALUES "+dbRepresentation(column, value);
                               }


        String query;
        for(int col = 0; col < getColumnCount();col++)
        {
          String colName = getColumnName(col);
          if (colName.equals(""))
           {
            continue;
           }
          if (col != 0)
           {
            query = query + " and ";
           }
            query = query + colName +" = "+
                dbRepresentation(col, getValueAt(row, col));
        }
        
        PreparedStatement pstmt =
                               con.prepareStatement(query);
        pstmt.executeUpdate();
        Object val;
        val = dbRepresentation(column,value);
        Vector dataRow = (Vector)rows.elementAt(row);
        dataRow.setElementAt(val, column);
        }
        catch (Exception ex)
        {
           System.err.println(ex);
        }