How do I get the size of a java sql ResultSet

String querys = "SELECT COUNT(*)as count FROM

To get java resultset size reference that column from the ResultSet object into an int and do your logic from there..

PreparedStatement statements = connection.prepareStatement(querys);
statements.setString(1, item.getProductId());
ResultSet resultSet = statements.executeQuery();
while (resultSet.next()) {
    int count = resultSet.getInt("count");
    if (count >= 1) {
        System.out.println("Product ID already exists.");
    } else {
        System.out.println("New Product ID.");
    }
}

Or you can probably do rows-count.

ResultSet rs = job.getSearchedResult(stmt);
int rsCount = 0;
//but notice that you'll only get correct ResultSet size after end of the while loop
while(rs.next())
{
    //do your other per row stuff 
    rsCount = rsCount + 1;
}//end while