Java Database Connectivity (JDBC)

We are in the process of migrating oracle to Mysql.

we have a function in oracle called

Procedure get_customer(o_c OUT refcursor)
BEGIN

open o_c for select customer_id,cust_name
from customer;

END;

I am interested only to have this in stored procedure in mysql.

i do not want to do this in java it self ...
like
Statement stmnt = "select cusotmer_id,cust_name"


Thanks in advance