How to deal with null value in table column in java?

Question

I am getting null pointer exception again and again while getting value from database table.....why its giving me null pointer exception?

Here is my code :

private HashSet getPlayerList() {
        HashSet hs = new HashSet();
        String soccername = "";
        try {
            conn = ConnectionProvider.getConnection();
            rs = null;
            pstmt = null;
            String sql = "Select * from Players where deleted = false";

            if (conn != null) {
                pstmt = conn.prepareStatement(sql);
                rs = pstmt.executeQuery();

                while (rs.next()) {
                    soccername = rs.getString("soccername").trim();// this line giving exception
                    if (soccername == null || soccername.isEmpty()) {
                        soccername = rs.getString("name").trim();
                    }
                    hs.add(soccername);
                }
            }
        } catch (NamingException ex) {
            System.out.println(ex);
        } catch (SQLException ex) {
            System.out.println(ex);
        } finally {
            try {
                pstmt.close();
                rs.close();
                conn.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        }
        return hs;
   }

possible duplicate of [What is a Null Pointer Exception, and how do I fix it?](http://stackoverflow.com/questions/218384/what-is-a-null-pointer-exception-and-how-do-i-fix-it) — Deltharis, Nov 17 '14 at 11:41

nano_nano · Accepted Answer · 2014-11-17T11:41:39.657

0

that is wrong:

soccername = rs.getString("soccername").trim();// this line giving exception
if (soccername == null || soccername.isEmpty()) {

if rs.getString("soccername") returns null it must leads to a NPE because it is followed by the function trim().

better is:

soccername = rs.getString("soccername");
if (soccername == null || soccername.trim().isEmpty()) {

edited Nov 17 '14 at 11:41

answered Nov 17 '14 at 11:36

nano_nano

12,351
8
55
83

score 0 · Answer 2 · answered Nov 17 '14 at 11:37

0

It should be:

soccername = rs.getString("soccername");
if (soccername == null || soccername.isEmpty()) {
    soccername = rs.getString("name").trim();
} else {
    //now you are sure that soccername is not null
    soccername = soccername.trim();
}

answered Nov 17 '14 at 11:37

BackSlash

21,927
22
96
136

How to deal with null value in table column in java?

2 Answers2