How can I connect Java Application with Oracle database in java?

Connecting to an Oracle database from a Java application typically involves using the JDBC (Java Database Connectivity) API. The following provides a concise step-by-step guide on establishing such a connection:

Step 1: Adding the JDBC Driver

First, ensure that your Java project includes the Oracle JDBC driver. Oracle provides various types of drivers, with ojdbc8.jar (for Java 8) being commonly used. You can add the dependency using Maven or Gradle, or directly add the JAR file to the project's classpath.

If using Maven, add the following dependency to your pom.xml file:

xml
<dependency>
    <groupId>com.oracle.database.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>19.3.0.0</version>
</dependency>

Step 2: Registering the JDBC Driver

In your Java code, you need to register the Oracle JDBC driver. Starting from Java 6, this step is typically unnecessary as JDBC 4.0 and later versions support automatic driver loading. However, if needed, you can manually register the driver:

java
Class.forName("oracle.jdbc.driver.OracleDriver");

Step 3: Establishing the Connection

Use the DriverManager.getConnection() method to establish a connection to the Oracle database. You need to provide the database URL, username, and password:

java
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String username = "your_username";
String password = "your_password";
Connection conn = DriverManager.getConnection(url, username, password);

Here, jdbc:oracle:thin specifies the JDBC driver type, and @localhost:1521:orcl specifies the host, port, and database instance name.

Step 4: Executing SQL Queries

Once the connection is established, you can create a Statement or PreparedStatement to execute SQL queries:

java
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");
while (rs.next()) {
    System.out.println(rs.getString("column_name"));
}

Step 5: Closing the Connection

After completing database operations, ensure to close ResultSet, Statement, and Connection to release database resources and prevent memory leaks:

java
rs.close();
stmt.close();
conn.close();

Example

The following is a complete example code demonstrating how to connect to an Oracle database and query data:

java
import java.sql.*;

public class OracleJdbcExample {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        String username = "your_username";
        String password = "your_password";
        try {
            // Optional: Register JDBC driver
            // Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection conn = DriverManager.getConnection(url, username, password);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");
            while (rs.next()) {
                System.out.println(rs.getString("column_name"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (SQLException e) {
            System.out.println("Database connection failed");
            e.printStackTrace();
        }
    }
}

Using this method, you can successfully connect your Java application to an Oracle database and perform the required database operations.