How to replace Null with empty string in Java insert prepared statement

Question

I have API response which I am using Java insert prepared statement to insert values in DB table. Few column values coming in from API response is- null. I want to replace this null value with empty string in my table. Can someone help with the piece of code.

Code snippet:

PreparedStatement stmt = conn.prepareStatement(query);
stmt.setDate(1, formatDate(obj.getString("term_dt")));

Does it make sense to use "" when calling formatDate? Possibly you should call PreparedStatement's method setNull or provide appropriate default value? — Nowhere Man
– Nowhere Man, Commented Oct 7, 2020 at 15:01
Thanks Guys, I tried with if statement and it worked :if((obj.getString("term_dt"))!="null"){ stmt.setDate(1, formatDate(obj.getString("term_dt"))); } else{ stmt.setString(1,""); } — Manisha GPT
– Manisha GPT, Commented Oct 7, 2020 at 19:50

Ankit Beniwal · Accepted Answer · 2020-10-08 08:25:41Z

1

You can use the ternary operator to keep your code concise.

PreparedStatement stmt = conn.prepareStatement(query);
stmt.setDate(1, term_dt!=null ? formatDate(obj.getString("term_dt")) : "");

answered Oct 8, 2020 at 8:25

Ankit Beniwal

5298 silver badges19 bronze badges

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

Comments

magicmn · Accepted Answer · 2020-10-08 09:18:05Z

1

You can use Objects.toString(obj.getString("term_dt"), ""). It's a bit shorter than using a ternary operator.

answered Oct 8, 2020 at 9:18

magicmn

1,9149 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to replace Null with empty string in Java insert prepared statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related