How to process empty fields in integer column of JTable?

Question

I have a column in a table that contains numeric values. However, some fields are empty. I want to read all fields in this column into integer variable. How should I manage empty fields?

int total = tableModel.getValueAt(currentRow, currentCol).toString().equals("") ? 0 : Integer.parseInt(tablePaxModel.getValueAt(currentRow, currentCol).toString());

how about just reading the value as String first. then check for nulls or blanks and finally parse to appropriate int. for example you can put 0 where ever you see null. also, where does this int go? can a default value for null or blank affect any other calculations? — AbtPst
– AbtPst, Commented Oct 27, 2015 at 16:15
@AbtPst: I think that my solution is what you suggest. Am I right? I just wanted to be sure that the way I'm doing it is correct. Blanks can only affect "total". — Klausos Klausos
– Klausos Klausos, Commented Oct 27, 2015 at 16:16
correct, that is the straightforward way to do it. as long as you put a default value lie 0, it should not affect any additions that you are doing. — AbtPst
– AbtPst, Commented Oct 27, 2015 at 16:18

cno · Accepted Answer · 2015-10-27 16:48:55Z

2

     try 
     {
        String valueInCell = (String)tablePaxModel.getValueAt(currentRow, currentCol);

        if(valueInCell == null || valueInCell.isEmpty())
        {
            valueInCell = "0";
        }

        int tempCellValue = Integer.parseInt(valueInCell);

        total += tempCellValue;

    } catch (Exception e) 
    {
        e.printStackTrace();  
    }

edited Oct 27, 2015 at 16:48

answered Oct 27, 2015 at 16:43

cno

1847 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AbtPst · Accepted Answer · 2015-10-27 17:59:25Z

0

something like

try {
    String val = tablePaxModel.getValueAt(currentRow, currentCol).toString();

    int temp=0;
    if(val.isEmpty() || val == null)
       temp=0;

    else
    {
    temp = Integer.parseInt(val);
    }

    total = total + temp
}

catch (Exception e) 
    {
        e.printStackTrace();  
    }

something like that. i have taken some assumptions with your code but you can modify as needed

edited Oct 27, 2015 at 17:59

answered Oct 27, 2015 at 16:21

AbtPst

8,03822 gold badges97 silver badges187 bronze badges

1 Comment

cno Over a year ago

Also, "temp" needs to be changed otherwise it will always be 0 unless you assign it. int temp has the default value of 0, so even if the value is null or empty, its always adding zero.

Collectives™ on Stack Overflow

How to process empty fields in integer column of JTable?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related