Java ResultSet how to check if there are any results

To check if a ResultSet object contains any results in Java, you can use the next method of the ResultSet class.

The next method moves the cursor to the next row in the ResultSet and returns true if the cursor is positioned on a valid row, or false if there are no more rows in the ResultSet.

Here's an example of how you can use the next method to check if a ResultSet contains any results:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) {
    Connection connection = // get connection
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
    if (resultSet.next()) {
      // resultSet contains at least one row
    } else {
      // resultSet is empty
    }
  }
}

This code creates a Statement object and uses it to execute a SELECT query on the users table. It then creates a ResultSet object to store the query results and uses the next method to check if the ResultSet contains any rows. If the ResultSet contains at least one row, the code will execute the first block of code; otherwise, it will execute the second block of code.

I hope this helps! Let me know if you have any questions.