Set NULL values in PreparedStatement

In some cases, you need to set the null value in the PreparedStatement, this time if you also use to set the specific type of method, such as Setint (1,null), the program will mercilessly report the null pointer exception, so you need to do is to use SetNull (index, Type) method to replace your original method.

For example:

Stmt.setnull (1,types.integer);

The second parameter is the specific type value in Java.sql.Types, and you can find the specific type you need by types. In this way, you can complete the null value set in PreparedStatement, assuming that your database field allows null values.