How to replace from null value empty string in java? [closed]

Question

I'm getting the null values from DB, but I need to display the empty string "" instead.

For example, I have to append four values to display in the single cell of a Excel sheet like below:

sheet.addCell(new Label(4, currentRow, a.getPar()+" "+a.getO()+" "+a.getPar()));

How to achieve the expected result (the replacement) in Java?

Answer 1

If I understand correctly, you can use the ternary opperator:

System.out.println("My string is: " + ((string == null) ? "" : string));

In case you are not familiar with it, it reads "Is string null? If it is, then 'return' en empty string, else 'return' string". I say 'return' because you can consider ((string == null) ? "" : string) as a function that returns a String.

You can replace the empty string with any other String of course.

Answer 2

If I understand correctly, you need this

public static String replaceNull(String input) {
  return input == null ? "" : input;
}

and the use it where ever you need it like

sheet.addCell(new Label(4,currentRow, replaceNull(a.getParan())+" "+replaceNull(a.getO())+" "+replaceNull(a.getParan())));

Hope this helps