What is the best way to return the result of a select statement in a stored proceudre ?

For example :
I have a stored procedure called GetUsers (Group_name)

This pprocedure will get the users who belong to a given group.
Since I am using JDBC, I want to be able to access the result using java.sql.ResultSet
and traverse through it in my java program.

Thanks for your help in advance