项目执行难题：Java与MySQL数据交互示例-蒲公英云

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

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

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

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

public class DatabaseConnection {
private static final String DB_URL = “jdbc//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();
                }
            }
        }
    }
}