What is used to form requests to the database?

Database queries in Java are formed using:

1. JDBC (Java Database Connectivity): A standard API for connecting to various databases and executing queries. It provides basic classes and interfaces for working with connections, statements, and query results.

   // Example of using JDBC
   try (Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "user", "password");
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable")) {
        while (resultSet.next()) {
            // Process results
        }
   } catch (SQLException e) {
       e.printStackTrace();
   }
   

2. ORM frameworks (Object-Relational Mapping), such as Hibernate and JPA (Java Persistence API): Allow mapping Java objects to database tables, simplifying query writing and data handling. ORM frameworks generate SQL queries automatically based on the object model.

   • JPA: A specification defining an API for managing data persistence.
   • Hibernate: A popular implementation of JPA.

   // Example of using JPA/Hibernate
   EntityManager em = emf.createEntityManager();
   try {
       // JPQL (Java Persistence Query Language) - object-oriented query language
       TypedQuery<MyEntity> query = em.createQuery("SELECT e FROM MyEntity e WHERE e.name = :name", MyEntity.class);
       query.setParameter("name", "someName");
       List<MyEntity> results = query.getResultList();
       // Process results
   } finally {
       em.close();
   }
   

3. DSL (Domain-Specific Language) for queries: Some frameworks provide specialized languages or APIs for building queries more expressively than pure SQL or JPQL. Example - QueryDSL.

   // Example of using QueryDSL
   // QMyEntity - generated class
   QMyEntity myEntity = QMyEntity.myEntity;
   JPAQueryFactory queryFactory = new JPAQueryFactory(em);
   
   List<MyEntity> results = queryFactory.selectFrom(myEntity)
                                        .where(myEntity.name.eq("someName"))
                                        .fetch();
   

4. Specialized libraries: Some databases or technologies provide their own libraries for forming queries, for example, for working with NoSQL databases (MongoDB, Cassandra) or graph databases (Neo4j).

The choice of tool depends on the project's complexity, performance requirements, the need to use an object model, and developer preferences. Most modern Java applications use ORM frameworks (Hibernate/JPA) for convenience and abstraction from the specific database, while JDBC remains the basic level for direct database interaction when necessary.