executeQuery() - return resultset

Question

I am getting this error in return resultset. cannot convert results from Resultset to double.

Isn't it possible to return a double? What should i do?

public double getBalance( String name )
{
    ResultSet resultSet = null;

   try 
   {
       selectBalance.setString( 1, name ); // specify last name

      // executeQuery returns ResultSet containing matching entries
      resultSet = selectBalance.executeQuery(); 


      while ( resultSet.next() )
      {
         resultSet.getDouble("balance");

      } // end while
   } // end try
   catch ( SQLException sqlException )
   {
      sqlException.printStackTrace();
   } // end catch

   return resultSet;
}

Thx in advance!

What is the query? What is the table? We need more info – Cristian Meneses Apr 07 '15 at 19:34 — Cristian Meneses, Apr 07 '15 at 19:34

score 1 · Answer 1 · answered Apr 07 '15 at 19:34

You should return a double if that's what you need :

public double getBalance( String name )
{
    double result = 0.0;
    ResultSet resultSet = null;

   try 
   {
       selectBalance.setString( 1, name ); // specify last name

      // executeQuery returns ResultSet containing matching entries
      resultSet = selectBalance.executeQuery(); 


      while ( resultSet.next() )
      {
         result = resultSet.getDouble("balance");

      } // end while
   } // end try
   catch ( SQLException sqlException )
   {
      sqlException.printStackTrace();
   } // end catch

   return result;
}

Note that this would only return the value read from the last row of the result set, so if you expect multiple rows to be returned, consider returning a List<Double>.

executeQuery() - return resultset

1 Answers1