Oracle和MySQL等数据库使用差异：Java连接MySQL与Oracle示例

原创 Bertha 。 2024-09-10 02:18 58阅读 0赞

在Java中，我们通常使用JDBC（Java Database Connectivity）来连接Oracle和MySQL数据库。以下分别是两个例子：

**连接MySQL数据库**

```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class MySQLExample {
    private static final String MYSQL_URL = "jdbc:mysql://localhost:3306/testdb";
    private static final String MYSQL_USERNAME = "username";
    private static final String MYSQL_PASSWORD = "password";

public static void main(String[] args) {
        Connection connection = null;
        try {
            // 注册MySQL驱动
            Class.forName("com.mysql.jdbc.Driver");

// 通过URL创建连接
            connection = DriverManager.getConnection(MYSQL_URL, MYSQL_USERNAME, MYSQL_PASSWORD));

// 执行SQL语句
            String sql = "INSERT INTO employees (name, position) VALUES (?, ?)";
            PreparedStatement statement = connection.prepareStatement(sql);
            statement.setString(1, "John Doe");
            statement.setString(2, "Manager");
            int rowsInserted = statement.executeUpdate();
            if (rowsInserted > 0) {
                System.out.println("Record inserted successfully.");
            }
        } catch (Exception e) {
            System.err.println(e.getClass().getName() + ": " + e.getMessage());
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            if (connection != null) {
                connection.close();
            }
        }
    }
}
```

**连接Oracle数据库**

```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class OracleExample {
    private static final String ORACLE_URL = "jdbc:oracle:thin:@localhost:1521:orcl";
    private static final String ORACLE_USERNAME = "username";
    private static final String ORACLE_PASSWORD = "password";

public static void main(String[] args) {
        Connection connection = null;
        try {
            // 注册Oracle驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");

// 通过URL创建连接
            connection = DriverManager.getConnection(ORACLE_URL, ORACLE_USERNAME, ORACLE_PASSWORD));

以上两个示例分别展示了如何使用Java连接MySQL和Oracle数据库。请将上述代码中的URL、用户名和密码替换为实际的数据库信息。