How to connect to an Oracle database in Java?

In Java, there are two main ways to connect to an Oracle database: using JDBC driver or using third-party frameworks like MyBatis and Hibernate.

To connect to an Oracle database using a JDBC driver, you first need to download the JDBC driver provided by Oracle (ojdbc.jar) and use the following code in your Java program to establish the connection.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class OracleConnection {
    public static void main(String[] args) {
        Connection conn = null;
        String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
        String user = "username";
        String password = "password";

        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");

            conn = DriverManager.getConnection(url, user, password);
            System.out.println("Connected to Oracle database successfully!");
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

Connecting to an Oracle database using a third-party framework such as MyBatis or Hibernate provides a more convenient way to handle database operations. For example, using MyBatis requires importing dependencies into the project, configuring database connection information and SQL mapping files, and finally using MyBatis’s API to interact with the database.

The above are the basic steps for connecting to an Oracle database, and the specific operations can be adjusted according to project requirements and actual circumstances.