项目执行难题：Java与MySQL数据交互示例

原创柔光的暖阳◎ 2024-10-06 15:18 79阅读 0赞

在项目执行中，Java与MySQL的数据交互是一个常见的挑战。以下提供一个简单的示例来说明这个问题：

1. **Java连接MySQL**：
```java
import java.sql.Connection;
import java.sql.DriverManager;

public class DatabaseConnection {
    private static final String DB_URL = "jdbc:mysql://localhost:3306/mydatabase";
    private static final String USER = "username";
    private static final String PASS = "password";

public static Connection getConnection() {
        try {
            return DriverManager.getConnection(DB_URL, USER, PASS));
        } catch (Exception e) {
            System.out.println("Error while connecting to the database: " + e.getMessage());
            e.printStackTrace();
        }
        return null;
    }
}
```

2. **Java操作MySQL**（例如查询数据）：
```java
import java.sql.ResultSet;
import java.sql.Statement;

public class DatabaseUsage {
    public static void main(String[] args) {
        Connection connection = DatabaseConnection.getConnection();

try (Statement stmt = connection.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT * FROM my_table")) {

// Iterate over the results
            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");

System.out.println("ID: " + id + ", Name: " + name);
            }
        } catch (Exception e) {
            System.out.println("Error while operating with the database: " + e.getMessage());
            e.printStackTrace();
        } finally {
            if (connection != null) {
                try {
                    connection.close();
                } catch (Exception e) {
                    System.out.println("Error closing database connection: " + e.getMessage());
                    e.printStackTrace();
                }
            }
        }
    }
}
```
上述示例展示了如何使用Java连接MySQL数据库，并进行数据查询操作。在实际项目中，可能需要处理更复杂的数据交互和事务管理。