What is your experience with Java Database Connectivity (JDBC)?

Java Database Connectivity (JDBC) is an API for interacting Java applications with databases.

Experience with JDBC typically includes:

• Establishing a connection to the database using DriverManager.getConnection().
• Creating and executing SQL queries with Statement or PreparedStatement.
• Handling query results through ResultSet.
• Managing transactions (commit, rollback).
• Closing resources to prevent leaks.

An example of a simple query using JDBC:

try (Connection conn = DriverManager.getConnection(url, user, password);
     PreparedStatement ps = conn.prepareStatement("SELECT * FROM users WHERE id = ?")) {
    ps.setInt(1, 10);
    try (ResultSet rs = ps.executeQuery()) {
        while (rs.next()) {
            System.out.println(rs.getString("username"));
        }
    }
}

Experience may also include working with connection pools, exception handling, and query optimization.