Java & MySQL – Transactions If your JDBC Connection is in auto-commit mode, which it is by default, then every SQL statement is committed to the database upon its completion. That may be fine for simple applications, but there are three reasons why you may want to turn off the auto-commit and manage your own […]

Java & MySQL – Viewing a ResultSet The ResultSet interface contains dozens of methods for getting the data of the current row. There is a get method for each of the possible data types, and each get method has two versions − One that takes in a column name. One that takes in a column […]

Java & MySQL – Updating a ResultSet The ResultSet interface contains a collection of update methods for updating the data of a result set. As with the get methods, there are two update methods for each data type − One that takes in a column name. One that takes in a column index. For example, […]