Fetching row affected by a query
Hi =)
I've my execQuery method here that returns a ResultSet of results.
I would like to know the rows returned, but I cannot find a count, lenght or size method in the ResultSet class.
縃oy can i count the number of Rows affected by a query?
public ResultSet execQuery(String consulta)
{
/*
* Variables locales
*/
ResultSet coleccion =null;
Statement stmt;
/*
* Creamos statement y ejecutamos consulta
*/
try{
stmt = conn.createStatement();
coleccion = stmt.executeQuery(consulta);
}
catch(SQLException ex)
{
this.setError(ex.toString());
returnnull;
}
// Devolvemos filas afectadas
return coleccion;
}
Thx!

