JDBC简便使用

今天我才发现JDBC这么简单,压根不需要那么多步骤,注册驱动JDK会自动完成,直接连接就可以,

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

public class DatabaseConnection {
    private static final String URL = "jdbc:mysql://localhost:3306/mydatabase";
    private static final String USERNAME = "username";
    private static final String PASSWORD = "password";

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(URL, USERNAME, PASSWORD);
    }

    public static void main(String[] args) {
        try (Connection connection = DatabaseConnection.getConnection()) {
            // 连接数据库成功
            System.out.println("Connected to database!");

            // 执行查询
            String sql = "SELECT * FROM my_table";
            try (PreparedStatement statement = connection.prepareStatement(sql)) {
                ResultSet resultSet = statement.executeQuery();
                // 处理查询结果
                while (resultSet.next()) {
                    // 读取每一行的数据
                    int id = resultSet.getInt("id");
                    String name = resultSet.getString("name");
                    // 打印数据
                    System.out.println("ID: " + id + ", Name: " + name);
                }
            }
        } catch (SQLException e) {
            // 连接数据库失败
            System.err.println("Failed to connect to database: " + e.getMessage());
        }
    }
}

直接DriverManager.getConnection就可以连接返回Connection,如何connection.createStatement就可以了