Java hide null values retrieved from a database

Question

I use the code below to get all results from the database.

while(rs1.next()) {
    for(int i = 1; i < columnsNumber; i++)
        System.out.printf(rs1.getString(i)+"    ");
    System.out.println();
}

They come in form of:

1       google      com     null        
2       facebook    com     null        
3       youtube     com     null
4       bbc         com     uk

I want to not display the null value. Although still display rest of the record. Thank you!

Don't print in the case: if(rs1 == null), or add if(rs1 != null) System.out.printf(rs1.getString(i)+" ");. You may want to factor out the spaces in that case though. — Spencer Wieczorek
– Spencer Wieczorek, Commented Jan 7, 2018 at 16:54
You can replace null with empty string. String cell = Optional.ofNullable(rs1.getString(i)).orElse(""); System.out.printf(cell +" "); — Nikolai Shevchenko
– Nikolai Shevchenko, Commented Jan 7, 2018 at 16:55
If you don't want to print the NULL, what do you want to print instead??? — MatBailie
– MatBailie, Commented Jan 7, 2018 at 16:58

Todd · Accepted Answer · 2018-01-07 16:56:17Z

1

You can check for nulls with a ternary...

for(int i = 1; i < columnsNumber; i++) {
    String printMe = rs1.getString(i)
    System.out.printf(printMe == null ? "" : printMe + "\t"); 
}

In this case, if printMe (your column value) is null, it just prints an empty string. I've substituted spaces for a tab, but you can print however you like.

answered Jan 7, 2018 at 16:56

Todd

31.9k11 gold badges91 silver badges93 bronze badges

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

1 Comment

Prophet ICEN Over a year ago

Yes, that's exactly what I was looking for! Thank you!

Scott C Wilson · Accepted Answer · 2018-01-07 19:00:22Z

0

You could do a check prior to the print:

for(int i = 1; i < columnsNumber; i++) {
    String s = rs1.getString(i)
    if (s != null) { 
       System.out.printf(s + "    "); 
    }
}
System.out.println();

answered Jan 7, 2018 at 19:00

Scott C Wilson

19.7k11 gold badges64 silver badges88 bronze badges

Comments

Ritesh Tiwari · Accepted Answer · 2018-01-07 19:09:18Z

0

Just do a simple null check before printing the column cell element.

while(rs1.next()) {
    for(int i = 1; i < columnsNumber; i++)
        System.out.printf(rs1.getString(i) == null ? "" : rs1.getString(i) + "\t");
    System.out.println();
}

answered Jan 7, 2018 at 19:09

Ritesh Tiwari

305 bronze badges

Collectives™ on Stack Overflow

Java hide null values retrieved from a database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related