Imprecise jtable float values from view

[antonio espinosa]

hello dear friends i have this issue i'm working with a jtable and queried results from a sql server database and the table shows 0.0 a float value after that i evaluate the cell and it says it's value is 0.03
what is wrong ? my sql query says its 0 not 0.03, how to match the jtable values and my queried results?.

thank you very much fellows

 String value= String.valueOf(TaReadyPay.getModel().getValueAt(row, 10));
System.out.println(value);

[Tony Docherty]

What do you mean by you evaluate the cell?
Are you doing some computation on the cell value?
What CellRender are you using?

Try printing out the value returned from the DB, the value you are actually adding to the JTable (is it a float value or String) and then immediately get the value back from the JTable and print that out too. Are they all 0.0?

[antonio espinosa]

What do you mean by you evaluate the cell? well i mean to show the value of the cell.
Are you doing some computation on the cell value? any
What CellRender are you using? a modified version of this model My model


i saw the values wich i got from the database (the cost was 0) and it was as i expected, then i read the populated values of the model and it was ok.

finally i discovered this:

            Float Cost=   modeljtable1.getValueAt(row,7 ).toString();
         
            System.out.println(  modelojtable1.getValueAt(0, 7).toString());//output:0.0
            System.out.println( " ");
            System.out.print(Cost);//output 0.03

HOWever the jtable view shows 0.0

thank you very much Tony.


if it helps i'l show you my process to create the jtablemodel

public void setUp2() {
        try {
            resultseet = CConexion.ConsultarSet(CConexion.Conexion, Consulta);
            InicioCobro.ModeloDeCobroInicial1(resultseet, Nombredecolumnas, CConexion.elnumeroderesultados);
            modelojtable1 = new ModeloPaCobrar(data, Nombredecolumnas);


            TaReadyPay.setModel(modelojtable1);
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));//this is because i want to remove some data from the view (hidden columns)
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
            TaReadyPay.removeColumn(TaReadyPay.getColumnModel().getColumn(10));
          System.out.println(  modelojtable1.getValueAt(0, 7));


        } catch (SQLException ex) {
            Logger.getLogger(InicioCobro.class.getName()).log(Level.SEVERE, null, ex);
            new ErrorConexion(this, true);
            System.exit(0);
        }
    }



public static void ModeloDeCobroInicial1(java.sql.ResultSet DatosdeModelo, String Nombredecolumnas[], int numerodresultados) {
        String col[] = new String[Nombredecolumnas.length];
        columnNames = new String[Nombredecolumnas.length];//reservo la cantidad de memoria para el arreglo pero no es necesario
        //mejor se lo asigno directamente columNamas=String;
        System.arraycopy(Nombredecolumnas, 0,
                InicioCobro.columnNames, 0, Nombredecolumnas.length);
        InicioCobro.data = new String[numerodresultados][Nombredecolumnas.length];


        try {


            int i = 0;
            while (DatosdeModelo.next()) {
                for (int j = 0; j <= Nombredecolumnas.length - 1; j++) {
                    col[j] = DatosdeModelo.getString(InicioCobro.columnNames[j]);

                    InicioCobro.data[i][j] = col[j];
                }
                i++;
            }
            DatosdeModelo.close();
        } catch (SQLException e) {
            System.out.println(e);
        }


    }


//and this is my model

  class ModeloPaCobrar extends AbstractTableModel {

        private String[] columnNames;
        private Object[][] data;

        ModeloPaCobrar(Object[][] DATOS, String[] x) {
            data = DATOS;


            columnNames = x;
        }

        public void setDatosyColumnas(Object[][] datos, String[] columnas) {
            data = datos;
            columnNames = columnas;
        }
        private boolean DEBUG;

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

        @Override
        public int getRowCount() {
            return data.length;
        }

        @Override
        public String getColumnName(int col) {
            return columnNames[col];
        }

        @Override
        public Object getValueAt(int row, int col) {
            return data[row][col];
        }

        /*
         * JTable uses this method to determine the default renderer/ editor for
         * each cell. If we didn't implement this method, then the last column
         * would contain text ("true"/"false"), rather than a check box.
         */
        @Override
        public Class getColumnClass(int column) {
//            Object value = this.getValueAt(0, column);
//            return (value == null ? Object.class : value.getClass());
             return getValueAt(0, column).getClass();
        }

        /*
         * Don't need to implement this method unless your table's editable.
         */
        @Override
        public boolean isCellEditable(int row, int col) {
            //Note that the data/cell address is constant,
            //no matter where the cell appears onscreen.
//            if (col < 2) {
//                return false;
//            } else {
//                return true;
//            }
            return false;
        }

        /*
         * Don't need to implement this method unless your table's data can
         * change.
         */
        @Override
        public void setValueAt(Object value, int row, int col) {
            if (DEBUG) {
                System.out.println("Setting value at " + row + "," + col
                        + " to " + value
                        + " (an instance of "
                        + value.getClass() + ")");
            }

            data[row][col] = value;
            fireTableCellUpdated(row, col);

            if (DEBUG) {
                System.out.println("New value of data:");
                printDebugData();
            }
        }

        private void printDebugData() {
            int numRows = getRowCount();
            int numCols = getColumnCount();

            for (int i = 0; i < numRows; i++) {
                System.out.print("    row " + i + ":");
                for (int j = 0; j < numCols; j++) {
                    System.out.print("  " + data[i][j]);
                }
                System.out.println();
            }
            System.out.println("--------------------------");
        }
    }

[Tony Docherty]

   Float Cost=   modeljtable1.getValueAt(row,7 ).toString(); 

That won't compile, you can't assign a String to a variable of type Float.

[antonio espinosa]

Tony Docherty wrote:

   Float Cost=   modeljtable1.getValueAt(row,7 ).toString(); 

That won't compile, you can't assign a String to a variable of type Float.

ok right at some point i commited an error typing it at java ranch this is the real code sorry it was a dumb error of mine

 String a =   modelojtable1.getValueAt(row,7 ).toString() ;

[Tony Docherty]

Ok so where do you set a value into your Cost variable (which then prints out 0.03).

[antonio espinosa]

oh my good! this fixed on its own i cant believe it... thank you very much for your time really the output was 0.03... now i want to ask you an advice

      Double CantidadPorpagar= Double.valueOf(String.valueOf(TaReadyPay.getModel().getValueAt(fila, 7)));
/* the problem was at this line don't know why! */

i do too much conversions wich would be the best way to get the value from de model.

Integer anint = Integer.parseInt(String.valueOf(TaReadyPay.getModel().getValueAt(row, 19)));

i hope you are not mad about this.

[Tony Docherty]

Why not just store the data in your model in their natural class types (ie as Integers and/or Doubles) then you won't have to convert to and from strings.
It is not unusual for JTables to have models which have different data types in different columns.

[antonio espinosa]

i'll look for this. i'm very pleased because you are very kind

[Tony Docherty]

My pleasure.
Check out the Java tutorial http://docs.oracle.com/javase/tutorial/uiswing/components/table.html