open static fun countRowsInTableWhere(jdbcTemplate: JdbcTemplate, tableName: String, whereClause: String): Int
Count the rows in 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 SELECT 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 "SELECT COUNT(0) FROM person WHERE name = 'Bob' and age > 25".
jdbcTemplate - the JdbcTemplate with which to perform JDBC operations
tableName - the name of the table to count rows in
whereClause - the WHERE clause to append to the query
Return
the number of rows in the table that match the provided WHERE clause