PreparedStatement Execute performs INSERT success but returns false

Execution of the SQL INSERT statement using the PreparedStatement Execute method succeeds, but the return result is false.

Boolean Execute ()
Throws SqlException executes the SQL statement in this PreparedStatement object, which can be any kind of SQL statement. Some specially processed statements return multiple results, and the Execute method handles these complex statements, executequery and executeupdate simpler statements.
The Execute method returns a Boolean value to indicate the form of the first result. You must call the Getresultset or Getupdatecount method to retrieve the results, and you must call the Getmoreresults to move to any subsequent results.
Return:
Returns true if the first result is a ResultSet object, or False if the first result is an update count or no result

This means that if the query returns TRUE, it returns False if it is updated or inserted;

Therefore, the Execute INSERT or UPDATE statement should use Executeupdate.

Reference http://blog.sina.com.cn/s/blog_963fb3af01013rcs.html