Differences between statement and preparedStatement [in jdbc]
① Syntax difference: · Statement is the parent class of PreparedStatement [developer generally uses the latter]
· Different SQL statement locations:
The usage of statement is as follows:
Stmt = conn. CreateStatement ();
ResultSet rs1_stmt.exe cuteQuery (SQL );
======================================
The usage of PrepareStatement is as follows:
Ptmt = conn. PreparedStatement (SQL );
ResultSet rs1_ptmt.exe cuteQuery ();
② Code readability and maintainability:
· // Statement:
Stmt.exe cuteUpdate ("insert into tb_name (col1, col2, col2, col4) values
('"+ Var1 +"', '"+ var2 +"', "+ var3 +", '"+ var4 + "')");
· // PrepareStatement updates data
Perstmt = con. prepareStatement ("insert into tb_name (col1, col2, col2, col4) values (?,?,?,?) ");
Perstmt. setString (1, var1 );
Perstmt. setString (2, var2 );
Perstmt. setString (3, var3 );
Perstmt. setString (4, var4 );
Perstmt.exe cuteUpdate ();
This article permanently updates the link address: