open static fun deleteFromTableWhere(jdbcTemplate: JdbcTemplate, tableName: String, whereClause: String, vararg args: Any): Int
Delete rows from the given table, using the provided WHERE clause.
If the provided WHERE clause contains text, it will be prefixed with " WHERE " and then appended to the generated DELETE statement. For example, if the provided table name is "person" and the provided where clause is "name = 'Bob' and age > 25", the resulting SQL statement to execute will be "DELETE FROM person WHERE name = 'Bob' and age > 25".
As an alternative to hard-coded values, the "?" placeholder can be used within the WHERE clause, binding to the given arguments.
jdbcTemplate - the JdbcTemplate with which to perform JDBC operations
tableName - the name of the table to delete rows from
whereClause - the WHERE clause to append to the query
args - arguments to bind to the query (leaving it to the PreparedStatement to guess the corresponding SQL type); may also contain SqlParameterValue objects which indicate not only the argument value but also the SQL type and optionally the scale.
Return
the number of rows deleted from the table