Database Access | Cubano
There are a range of options for automating database requests:
- JDBC: will meet your needs but needs some work to get going
My personal preference would be to use either of these libraries for the flexibility they add with named parameter support and POJO mapping. They get you up and running immediately and are simpler than JDBC.
- Fluent JDBC: is a java library for operating with SQL queries conveniently
- JDBI: a SQL convenience library for Java
Other: Generally a full ORM package such as Hibernate or JPA will be overkill for your needs. jOOQ looks like an interesting alternative but is still overkill for most testing requirements in my opinion.