Checking for a null int value from a Java ResultSet

by

The default for ResultSet.getInt when the field value is NULL is to return 0, which is also the default value for your iVal declaration. In which case your test is completely redundant.

If you actually want to do something different if the field value is NULL, I suggest:

int iVal = 0;
ResultSet rs = magicallyAppearingStmt.executeQuery(query);
if (rs.next()) {
    iVal = rs.getInt("ID_PARENT");
    if (rs.wasNull()) {
        // handle NULL field value
    }
}

(Edited as @martin comments below; the OP code as written would not compile because iVal is not initialised)

More Related Contents:

  1. MySQL query to get Records in Result set
  2. Method Overloading for null argument
  3. Which @NotNull Java annotation should I use?
  4. Should a retrieval method return ‘null’ or throw an exception when it can’t produce the return value? [closed]
  5. Difference between null and empty (“”) Java String
  6. How do I get the size of a java.sql.ResultSet?
  7. Fastest way to write huge data in text file Java
  8. How come invoking a (static) method on a null reference doesn’t throw NullPointerException?
  9. object==null or null==object?
  10. Null check chain vs catching NullPointerException
  11. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  12. Why can’t primitive data types be “null” in Java?
  13. Why does String.valueOf(null) throw a NullPointerException?
  14. Filter values only if not null using lambda in Java8
  15. What is the point of the class Option[T]?
  16. Uninitialized Object vs Object Initialized to NULL
  17. Java “?” Operator for checking null – What is it? (Not Ternary!)
  18. Which is more effective: if (null == variable) or if (variable == null)? [duplicate]
  19. Java method dispatch with null argument
  20. Execute anonymous pl/sql block and get resultset in java
  21. ResultSet: Retrieving column values by index versus retrieving by label
  22. How to simplify a null-safe compareTo() implementation?
  23. Comparable and Comparator contract with regards to null
  24. How to check a string against null in java?
  25. Why null cast a parameter? [duplicate]
  26. How to get the number of columns from a JDBC ResultSet?
  27. Hibernate: How to set NULL query-parameter value with HQL?
  28. Spring data JPA and parameters that can be null
  29. clearing or set null to objects in java
  30. How do I avoid checking for nulls in Java?

Leave a Comment