Inserting null to an Integer column using JDBC
Try using.
pst.setNull(4, java.sql.Types.INTEGER); //pst is prepared statement instance.
Interface PreparedStatement.setNull API
Mapping of java.sql.Types to SQL types
P.S. : Edited to reflect Java 8 updates.
In addition to Smit's answer:
If you want to insert an Integer
-object into a database that may be null
, you can use
statement.setObject(4, yourObject, java.sql.Types.INTEGER);
instead of
if (yourObject == null) {
statement.setNull(4, java.sql.Types.INTEGER);
else {
statement.setInt(4, yourObject);
}