What libraries or tools have you used for database interaction in your projects?

In Java projects, I often used the following libraries and tools for working with databases:

• JDBC — the standard API for interacting with relational databases.
• Hibernate — an ORM framework that simplifies working with the database by allowing you to work with objects instead of SQL queries.
• Spring Data JPA — a wrapper over JPA/Hibernate that simplifies creating repositories and queries.
• MyBatis — a framework for mapping SQL queries to Java objects, providing more precise control over SQL.

Example of using Spring Data JPA:

public interface UserRepository extends JpaRepository<User, Long> {
    List<User> findByLastName(String lastName);
}

This approach allows for quickly creating queries without writing SQL.