PreparredStatement MySQL server version for the right syntax

String SQL = "insert into tablename (a, B, c) values (?,?,?) "; PreparedStatement pstmt = conn. prepareStatement (SQL); // execute the query pstmt.exe cuteQuery (SQL); // execute the update pstmt.exe cuteUpdate (SQL );

Cause: the PreparedStatement has cached the SQL statement at the time of creation so that the parameters can be set later. Therefore, you can append the SQL statement when executing a query or update, such as pstmt.exe cuteQuery (SQLWill not set parameters, resulting in an error! Corresponding to the pstmt.exe cuteQuery ().

This article is from the "love IT" blog, please be sure to keep this source http://5563447.blog.51cto.com/5553447/1294836