Prevent Null from appearing?

[dhanush karma]

How can I prevent the word "null" from appearing in my HTML input text fields when I populate them with a resultset that has null values?
[ March 23, 2007: Message edited by: Bear Bibeault ]

[Jan Cumps]

You can use java.sql.ResultSet.wasNull().
This method reports whether the last column read had a value of SQL NULL.

Call it after you have retrieved a column value.
Only print the value you returned when wasNull() returns false.

pseudocode:

String eight = rs.getString(8);
if (rs.wasNull()) {
    out.print("the value I want to show when the column was null");
} else {
    out.print(eight);
}

Regards, Jan
[ March 23, 2007: Message edited by: Jan Cumps ]

[Chengwei Lee]

Hi Dhanush,

How are you displaying your values at the JSP? Are you using JSTL? If you use <c:out>, I believe it handles NULl values for you gracefully. Alternatively, if you're using scriptlets to display the values, you could check for null before printing.

You should follow the MVC pattern. Handling the display of null values belongs to the presentation layer.

Cheers!