How do I receive a ResultSet from a stored procedure?

Stored procedures can return a result parameter, which can be a result set. For a discussion of standard JDBC syntax for dealing with result, IN, IN/OUT and OUT parameters, see Stored Procedures.
Category:JDBC Interview Questions