What role does JDBC play in working with databases in Java?

JDBC (Java Database Connectivity) is a standard API in Java for interacting with databases. It provides a universal interface for executing SQL queries, managing connections, and processing results, regardless of the specific DBMS.

Main roles of JDBC:

• Establishes a connection to the database via a driver.
• Allows executing SQL queries (SELECT, INSERT, UPDATE, DELETE).
• Processes query results through ResultSet objects.
• Manages transactions and error handling.

Example of using JDBC:

Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM users");
while(rs.next()) {
    System.out.println(rs.getString("name"));
}
rs.close();
stmt.close();
conn.close();