ResultSet in Interface

ResultSet interface represents the result set of a database query by using SQL.

• When we use PreparedStatement for performing SQL query statements, it will return the PreparedStatement object.
• Then we call the executeQuery() by using the PreparedStatement object and this result is assigned to the ResultSet object.
• This ResultSet object contains the result of the SQL query.

Now we will explore this concept to understand this concept in a better way. In this article, we learn about ResultSet in JDBC and Its functionality and how to retrieve data from a ResultSet in JDBC.

Syntax:

The below statements is representing the syntax of ResultSet with PreparedStatement object.

PreparedStatement preparedStatement = connection.prepareStatement(sql_query);
ResultSet resultSet = preparedStatement.executeQuery();

We can observe syntax of ResultSet, which gets the ResultSet by using preparedStatement. This preparedStatement is used for executing the SQL queries.

In Java database connectivity, the ResultSet is an interface, and it has a lot of built-in methods for handling the results of SQL queries. In this article, we will learn to retrieve data from a ResultSet in JDBC.