JDBC Testing Support
JdbcTestUtils
The org.springframework.test.jdbc
package contains JdbcTestUtils
, which is a
collection of JDBC-related utility functions intended to simplify standard database
testing scenarios. Specifically, JdbcTestUtils
provides the following static utility
methods.
-
countRowsInTable(..)
: Counts the number of rows in the given table. -
countRowsInTableWhere(..)
: Counts the number of rows in the given table by using the providedWHERE
clause. -
deleteFromTables(..)
: Deletes all rows from the specified tables. -
deleteFromTableWhere(..)
: Deletes rows from the given table by using the providedWHERE
clause. -
dropTables(..)
: Drops the specified tables.
|
Embedded Databases
The spring-jdbc
module provides support for configuring and launching an embedded
database, which you can use in integration tests that interact with a database.
For details, see Embedded Database Support
and Testing Data Access
Logic with an Embedded Database.