How to save null value as "N/A" with Java bean class?

Question

How to save null value as "N/A" with Java bean class? Every time it gives me exception as null. How to save the null form as "N/A"? I want to save null value as "N/A".

   package javaonline;
    import java.sql.*;
    public class SavaData {


    private String uname;

    /**
     * @return the uname
     */
    public String getUname() {
        return uname;
    }

    /**
     * @param uname the uname to set
     */
    public void setUname(String uname) {
        this.uname = uname;
    }
    public int insertdate()
    { 
    int i=0;
    try{
        Class.forName("com.mysql.jdbc.Driver");  
        Connection con=DriverManager.getConnection(  
        "jdbc:mysql://localhost:3306/test","root","root");  
      PreparedStatement st=con.prepareStatement("insert into nulltest values(?)");
      if(!uname.isEmpty() || uname!=null)
      {
          st.setString(1,uname);
      }
      else{
          st.setString(1,"N/A");      
      }
      i=st.executeUpdate();
        }
    catch(Exception e)
    {
        e.getMessage();
        System.out.print(e.getMessage());
    }
        return i;
    }

    }

score 3 · Answer 1 · answered Apr 23 '18 at 20:33

3

You need to switch order of checks in your if to this

if(uname!=null && !uname.isEmpty())

So in this case in uname is null then uname.isEmpty() will not be called because && is a short-curciut operator.

answered Apr 23 '18 at 20:33

Ivan

8,508
2
19
30

Thanks, it works fine...Thanks a lot. – Debasish Ghosh Apr 26 '18 at 18:43

score 0 · Answer 2 · answered Apr 23 '18 at 20:56

You can use StringUtils.defaultIfBlank() method to do this whole logic:

public int insertdate() { 
    int i=0;
    try {
        Class.forName("com.mysql.jdbc.Driver");  
        Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
        PreparedStatement st=con.prepareStatement("insert into nulltest values(?)");

        st.setString(1, StringUtils.defaultIfBlank(uname, "N/A"));
        i=st.executeUpdate();
    } catch(Exception e) {
        e.getMessage();
        System.out.print(e.getMessage());
    }
    return i;
}

Any concern, you can double check this method documentation here.

How to save null value as "N/A" with Java bean class?

2 Answers2