In JDBC there are two scrollable ResultSets namely, scrollable sensitive and, scrollable insensitive.In the TYPE_SCROLL_INSENSITIVE ResultSet the cursor moves in forward or backward directions. This type of ResultSet is insensitive to the changes that are made in the database i.e. the modifications done in the database are not reflected in the ResultSet.Which means if we have established a connection with a database using JDBC program and retrieved a ResultSet holding all the records in a table named SampleTable. Meanwhile if we have added some more records to the table (after retrieving getting the ResultSet), these recent changes will not be reflected ... Read More

Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries(in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the first row from the current position, using the first() method of the ResultSet interface.rs.first()This method returns a boolean value specifying whether the cursor has been moved to the first row successfully.If there are no rows in the current ResultSet object this method returns false, else it ... Read More

Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries (in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the last row from the current position, using the last() method of the ResultSet interface.rs.last()This method returns a boolean value specifying whether the cursor has been moved to the last row successfully.If there are no rows in the current ResultSet object this method returns false, else ... Read More

Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries(in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the previous row from the current position, using the previous() method of the ResultSet interface.rs.previous()This method returns a boolean value specifying whether the ResultSet object contains more rows. If there are no rows before its current position this method returns false, else it returns true.Let us ... Read More

Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries(in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the next row from the current position, using the next() method of the ResultSet interface.rs.next()This method returns a boolean value specifying whether the ResultSet object contains more rows.If there are no rows next to its current position this method returns false, else it returns true.Let us create ... Read More

ResultSet objectCertain SQL queries (especially SELECT) returns tabular data, In JDBC the object of the java.sql.ResultSet interface holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).ResultSet Cursor/pointerThe ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.There are two types of result sets namely, forward only and, bidirectional. By default the ResultSet we get by the executeQuery() method is of the type forward only. Using this you can traverse/move the cursor only forward direction.Bidirectional ResultSetA bi-directional ResultSet ... Read More

When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The isClosed() method of the ResultSet interface is used to determine whether the current ResultSet object is closed.rs.isclosed()CLOSE_CURSORS_AT_COMMITIf the holdability of the ResultSet object is set to this value. Whenever you commit/save ... Read More

When we execute certain SQL queries (SELECT query in general) they return tabular data. The java.sql.ResultSet interface represents such tabular data returned by the SQL statements i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which requires the database (executeQuery() method of the Statement interface in general). The ResultSet object has a cursor/pointer which points to the current row. Initially, this cursor is positioned before the first row. Java ResultSet isLast() Method The isLast() method of the ResultSet interface is used to determine whether the cursor is on the last row of the ... Read More

When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The isBeforeFirst() method of the ResultSet interface is used to determine whether the cursor is at the default position of the ResultSet.rs.isBeforeFirst();This method returns an boolean this value is true, if the cursor is ... Read More

The ResultSet interface in Java is used to retrieve data from a database in a tabular form. The isAfterLast() method is one of the navigation methods in the ResultSet that helps in checking the position of the cursor. Specifically, isAfterLast() checks whether the cursor is positioned after the last row of the result set. Method Definition The isAfterLast() method of the ResultSet interface is used to determine whether the cursor is after the end of the ResultSet.This method returns a boolean this value is true, if the cursor is after the end of the ResultSet else, it returns false. ... Read More