Java & MySQL – Navigating a ResultSet There are several methods in the ResultSet interface that involve moving the cursor, including − S.N. Methods & Description 1 public void beforeFirst() throws SQLException Moves the cursor just before the first row. 2 public void afterLast() throws SQLException Moves the cursor just after the last row. 3 […]
Category Archives: java Mysql
Java & MySQL – WHERE Clause Example This chapter provides an example on how to select records from a table using JDBC application. This would add additional conditions using WHERE clause while selecting records from the table. Before executing the following example, make sure you have the following in place − To execute the following […]
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, […]