public void select() {
Statement statement = connection.createStatement();
statement.executeUpdate("INSERT INTO persons(id, name) VALUES(2, 'John DOE')"); // Noncompliant
}Use PreparedStatement instead of Statement, because SQL will only commit the query once, whereas if you used only one statement, it would commit the query every time and thus induce unnecessary calculations by the CPU and therefore superfluous energy consumption.
Using Statement instead of PreparedStatement causes the database to parse and compile the SQL query on every execution.
This leads to unnecessary CPU overhead and energy consumption.
PreparedStatement precompiles the query, reducing resource usage for repeated executions.
public void select() {
Statement statement = connection.createStatement();
statement.executeUpdate("INSERT INTO persons(id, name) VALUES(2, 'John DOE')"); // Noncompliant
}public void select() {
PreparedStatement statement = connection.prepareStatement("INSERT INTO persons(id, name) VALUES(?, ?)");
statement.setInt(1, 2);
statement.setString(2, "John DOE");
statement.executeUpdate();
}