Which method is used to commit a transaction in JDBC?

The commit() method in JDBC is used to commit a transaction, making all the changes made during the transaction permanent. When auto-commit is disabled, multiple SQL statements can be executed as part of a single transaction. The commit() method is then called to save all changes to the database, ensuring that they are consistent and durable.

Using the commit() method allows developers to control when and how changes are applied to the database, providing the flexibility to roll back the transaction if an error occurs. This is particularly important in scenarios where multiple operations must be completed successfully as a unit, such as in financial applications where atomicity is crucial.

Proper use of the commit() method is essential for managing transactions in JDBC. It ensures that data changes are handled correctly and that the database remains in a consistent state, even in the event of errors or failures.